For instance, a fulltext search involving the word "and" will lead to an error with the following message, on Oracle side
java.sql.SQLException: ORA-29902: erreur d'exécution de la routine ODCIIndexStart() ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 11
For a NXQL query like
SELECT * FROM Document WHERE ecm:fulltext = 'test and test'
VCS will build a SQL query like
SELECT ... FROM ... WHERE ... AND (CONTAINS("FULLTEXT"."FULLTEXT_TITLE", '(test AND and AND test)', 1) > 0)
Keywords to escape may be part of http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqoper.htm
- is required by
-
NXP-17693 Don't escape stemming prefix in Oracle full-text searches
- Resolved