Red Gate forums :: View topic - bug on context index and xmltype column
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

bug on context index and xmltype column

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
errr3



Joined: 12 Feb 2014
Posts: 2

PostPosted: Wed Feb 12, 2014 7:23 am    Post subject: bug on context index and xmltype column Reply with quote

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');
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Thu Feb 13, 2014 5:53 pm    Post subject: Reply with quote

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
Quote:
CREATE INDEX idx_test ON t1(SYS_MAKEXML(0,"SYS_NC00002$"));


I'll see if I can get some confirmation about this.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group