[ http://issues.apache.org/jira/browse/DERBY-1262?page=all ]
Håvard Mork updated DERBY-1262:
-------------------------------
Attachment: 1262_3.diff
New patch:
Removed duplicate greaterThan/lessThan methods, and now relying on the upgrade
mechanism to upgrade the stored preparedstatements (SPS).
The patch addresses both greaterThan and lessThan, and adds null padding on the
right side so the comparisons will correctly respond to control characters.
Changing lessThan was necessary to make 'asdf%' not include 'asdg\t' (\t is tab
char).
All derbylang still passes.
> 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, 1262_3.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
