[ http://issues.apache.org/jira/browse/DERBY-1262?page=all ] A B reopened DERBY-1262: ------------------------
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. I admit I haven't looked closely enough to figure out which behavior is correct, but some more investigation is definitely required (at the very least, a release note is needed if the new behavior is correct). This change went into the 10.1 codeline as well, and I have verified that it returned 2 rows with the snapshot 405564 but no rows with the latest 10.1 codeline. So I'm reopening this issue. Note: it's currently marked as "Unassigned", so anyone who is inclined to pick it up should certainly feel free... > 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
