History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FRG-375
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: John V. Sichi
Reporter: Sunil Mujumdar
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Farrago

The expression VALUES ('cd' SIMILAR TO '[a-e^c]d') returns TRUE. It should return FALSE.

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


 Description  « Hide
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>.

 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.