|
If you were logged in you would be able to see more operations.
|
|
|
|
SQL92's LIKE predicate also has an optional ESCAPE argument. So, in regards to CMIS SQL, what are the like string escaping rules? As there is no way to specify an escape character in the grammar, is it simply not allowed (as in SQL92 without the ESCAPE clause)? Or is there some default escape character? What does it escape (i.e. just % and _, or does it escape quotes (which will modify the entire BNF, I think)?
|
|
Description
|
SQL92's LIKE predicate also has an optional ESCAPE argument. So, in regards to CMIS SQL, what are the like string escaping rules? As there is no way to specify an escape character in the grammar, is it simply not allowed (as in SQL92 without the ESCAPE clause)? Or is there some default escape character? What does it escape (i.e. just % and _, or does it escape quotes (which will modify the entire BNF, I think)? |
Show » |
|
Bug
Closed
Critical
Clarify query escape behavior.
I would therefore propose to use the complete SQL92 rules:
<like predicate> ::= <match value> [ NOT ] LIKE <pattern> [ ESCAPE <escape character> ]
<match value> ::= <character value expression>
<pattern> ::= <character value expression>
<escape character> ::= <character value expression>
with <escape character> of length 1 and the <pattern> following the SQL92 rules for its well-formedness.