bug on context index and xmltype column

Track changes to Oracle schemas in your existing version control system.

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

bug on context index and xmltype column

Postby errr3 » Wed Feb 12, 2014 7:23 am

Refresh after commit changes show incorrect changes with context index on xmltype column.

For example:
create table t1(col xmltype);

create index idx_test on t1(col)
indextype is ctxsys.context
parameters ('datastore ctxsys.default_datastore
filter ctxsys.null_filter
section group ctxsys.auto_section_group
sync (on commit) memory 16m');
errr3
 
Posts: 3
Joined: Wed Feb 12, 2014 7:21 am

Postby Brian Donahue » Thu Feb 13, 2014 5:53 pm

I am thinking that Source Control for Oracle does not support the CONTEXT index type. When the program attempts to create a DDL script for this, it ends up like
CREATE INDEX idx_test ON t1(SYS_MAKEXML(0,"SYS_NC00002$"));


I'll see if I can get some confirmation about this.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby errr3 » Wed Aug 06, 2014 12:26 pm

Bug still exists in Source Control for Oracle 2.0.3.489. Customers who use xml index cannot use you product normally, developpers don't want to migrate to your poduct while this bug exist.
errr3
 
Posts: 3
Joined: Wed Feb 12, 2014 7:21 am

Postby Brian Donahue » Wed Aug 06, 2014 3:02 pm

Sorry for the lack of response. This syntax seems to be working now in Source Control for Oracle 2.0.3.489, which just came out today on Red Gate Check for Updates.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests