dynamobi/dynamobi — Issue #436: [FRG-375] The expression VALUES ('cd' SIMILAR TO '[a-e^c]d') returns TRUE. It should return FALSE.
Author: dynamobi-build
Created: 2011-12-30 03:13:47+00:00
State: open
Labels: FRG, Statement Processing

[reporter="sunil", created="Wed, 6 May 2009 02:45:33 -0500 (GMT-05:00)"]
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(

)

is the set of all strings of length 1 (one) taken from the set of characters in the
include>s, except for those strings of length 1 (one) taken from the set of characters in the
enumeration exclude>.