Home » Server Options » Text & interMedia » ORACLE SQL POSSIBE BUG (11G)
ORACLE SQL POSSIBE BUG [message #679253] Wed, 19 February 2020 02:53 Go to next message
andreas18121989
Messages: 2
Registered: February 2020
Junior Member
when query my database table with word "NOR" with CONTAINS command i didn't get result(example:contains(tt_transvalue,'{'||'NOR'||'}') >0 ), the NOR is not a keyword and the escape character not work in my case.
Re: ORACLE SQL POSSIBE BUG [message #679254 is a reply to message #679253] Wed, 19 February 2020 03:19 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
It would help if you posted a test case - create table and insert statements for the data so we can replicate it, along with the exact select statement you are running.

Your complete oracle version (11g has a lot of sub-versions) would also be useful.
Re: ORACLE SQL POSSIBE BUG [message #679255 is a reply to message #679253] Wed, 19 February 2020 03:40 Go to previous messageGo to next message
John Watson
Messages: 8201
Registered: January 2010
Location: Global Village
Senior Member
No errors for me:
orclz> create index ename_ctx on emp(ename) indextype is ctxsys.context;

Index created.

orclz>
orclz> select * from emp where contains(ename,'{'||'NOR'||'}') >0 ;

no rows selected

orclz>
--edit:
And, to do the Moderator bit:
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

[Updated on: Wed, 19 February 2020 03:43]

Report message to a moderator

Re: ORACLE SQL POSSIBE BUG [message #679256 is a reply to message #679255] Wed, 19 February 2020 03:43 Go to previous messageGo to next message
andreas18121989
Messages: 2
Registered: February 2020
Junior Member
The problem is that i don't get any results instead that i have at least one record with NOR value.
Re: ORACLE SQL POSSIBE BUG [message #679257 is a reply to message #679256] Wed, 19 February 2020 03:45 Go to previous message
John Watson
Messages: 8201
Registered: January 2010
Location: Global Village
Senior Member
Quote:
It would help if you posted a test case - create table and insert statements for the data so we can replicate it, along with the exact select statement you are running.

Your complete oracle version (11g has a lot of sub-versions) would also be useful.
Previous Topic: pixel (rgb) values extraction function
Next Topic: 19c Orace Text Index(CTXSYS.CONTEXT ) - String search anomaly
Goto Forum:
  


Current Time: Sun Mar 29 08:32:43 CDT 2020