
|
If you were logged in you would be able to see more operations.
|
|
|
Farrago
Created: 06/May/09 02:45 AM
Updated: 06/May/09 02:45 AM
|
|
| Component/s: |
Statement Processing
|
| Affects Version/s: |
0.9.0
|
| Fix Version/s: |
None
|
|
|
The expression VALUES ('cd' SIMILAR TO '[a-e^c]d') returns TRUE. It should return FALSE.
SQL:2008 spec has a general rule for SIMILAR predicates:
l) L( <left bracket> <character enumeration include> <circumflex> <character enumeration exclude>
<right bracket> )
is the set of all strings of length 1 (one) taken from the set of characters in the <character enumeration
include>s, except for those strings of length 1 (one) taken from the set of characters in the <character
enumeration exclude>.
|
|
Description
|
The expression VALUES ('cd' SIMILAR TO '[a-e^c]d') returns TRUE. It should return FALSE.
SQL:2008 spec has a general rule for SIMILAR predicates:
l) L( <left bracket> <character enumeration include> <circumflex> <character enumeration exclude>
<right bracket> )
is the set of all strings of length 1 (one) taken from the set of characters in the <character enumeration
include>s, except for those strings of length 1 (one) taken from the set of characters in the <character
enumeration exclude>. |
Show » |
| There are no comments yet on this issue.
|
|