[ http://issues.apache.org/jira/browse/DERBY-1262?page=comments#action_12415186 ]
Kathey Marsden commented on DERBY-1262: --------------------------------------- Army said: |I think there's a *regression* after this patch was checked in. The following |query returns 2 rows before svn revision 411174 and NO rows after. As I read it, the fix for this issue created a bug that is a wrong Results regression that is in the 10.1 maintenance branch. I think instead of reopening this bug there should be a new bug marked regression and we should not release 10.1.3 while it exists. > 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 > Fix For: 10.2.0.0, 10.1.3.0, 10.1.2.5 > Attachments: 1262.diff, 1262_3.diff, 1262_4.diff, 1262_5.diff, 1262_6.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
