"View/Create Table": index not displayed

[Wiswesser]

Hello, everybody.

May be I've found a bug in the "View/Create Table" window (PL/SQL Developer, Version 7.0.3.1123): a table index using an object type attribute is not displayed.

test case

(1) object type

create or replace type t_someobj as object(
  somekey    varchar2(6)
, somedate   date
, member function isempty return boolean
)

(2) table and index

create table sometab(
  someid          number not null
, somecode        varchar2(4) not null
, someobj         t_someobj
)

create index sometab_ix on sometab
( someid
, somecode
, someobj.somedate
)

(3) "View Table"
Display the table and it's indexes using the "View Table" window (object browser, table "sometab" -> context menu -> view -> tab "Indexes"), the index "sometab_ix" is missing. As well, the sql script (button "View SQL) does not mention the index.

(4) browser and user dictionary
But the index does exist. You find it in the object browser and in the user dictionary:

select index_name, table_name, column_name, column_position
  from user_ind_columns where index_name = 'SOMETAB_IX'

displays the index and it's three columns:

SOMETAB_IX	SOMETAB	SOMEID	1
SOMETAB_IX	SOMETAB	SOMECODE	2
SOMETAB_IX	SOMETAB	"SOMEOBJ"."SOMEDATE"	3

Kind regards
Ww

 

[Marco Kalter]

This could indeed be displayed properly. We'll fix it.