dynamobi/dynamobi — Issue #440: [FRG-373] SIMILAR TO is not SQL 2003 conformant
Author: dynamobi-build
Created: 2011-12-30 03:13:50+00:00
State: open
Labels: FRG, Runtime

[reporter="rchen", created="Wed, 15 Apr 2009 19:47:47 -0500 (GMT-05:00)"]
SQL 2003 does not interprete ?i as the case insensitive marker used in java.util.regex.Pattern. However, this statement does get a match in sales.emps table.

select * from emps where name similar to '(?i)joh%';

This is likely a bug when converting string literals to Java Pattern which is used by the Java implementation of SIMILAR TO operator.

Also, this conversion doesn't need to be done at runtime. Same for LIKE operator.