[ http://issues.apache.org/jira/browse/DERBY-1262?page=comments#action_12413100 ]
Øystein Grøvlen commented on DERBY-1262: ---------------------------------------- Patch looks good, but I am not expert on this code. I would very much like this to be fixed in 10.1.3 so it would be nice if someone with more experience with this code could look at it. One minor comment: - Why are the old versions of greaterEqualStringFromParameter() and greaterEqualStringFromParameterWithEsc() kept? Do you need them anymore? Seems like they are only called from one location. > Like-predicates: % does not match tab character > ----------------------------------------------- > > Key: DERBY-1262 > URL: http://issues.apache.org/jira/browse/DERBY-1262 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.0 > Environment: Embedded, Solaris 10 x86 > Reporter: Øystein Grøvlen > Attachments: 1262.diff > > % in like predicates does not seem to match tab character. In the following > example all whitespace in character literals is the tab character: > ij> create table t4(i integer primary key, j integer, c varchar(10)); > 0 rows inserted/updated/deleted > ij> insert into t4 values (1, 1, 'abc def'); > 1 row inserted/updated/deleted > ij> select * from t4 where c like 'abc%'; > I |J |C > ---------------------------------- > 0 rows selected > ij> select * from t4 where c like 'abc %'; > I |J |C > ---------------------------------- > 1 |1 |abc def > 1 row selected -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
