Issue Details (XML | Word | Printable)

Key: DERBY-1231
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Bernt M. Johnsen
Reporter: Dyre Tjeldvoll
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

LIKE does not match empty strings when used with a prepared statement

Created: 20/Apr/06 06:02 PM   Updated: 13/Dec/07 09:04 AM
Return to search
Component/s: JDBC, SQL
Affects Version/s: 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.3.1.4
Fix Version/s: 10.2.2.0, 10.3.1.4

Time Tracking:
Not Specified

File Attachments:
  Size
File Licensed for inclusion in ASF works DERBY-1231-v2.diff 2006-12-06 08:13 AM Bernt M. Johnsen 2 kB
File Licensed for inclusion in ASF works DERBY-1231-v3.diff 2006-12-06 09:25 AM Bernt M. Johnsen 2 kB
File Licensed for inclusion in ASF works DERBY-1231.diff 2006-12-05 07:50 AM Bernt M. Johnsen 1 kB
Java Source File Licensed for inclusion in ASF works vti.java 2006-04-20 06:06 PM Dyre Tjeldvoll 2 kB
Issue Links:
Blocker
 
Incorporates
 
Reference
 

Urgency: Normal
Resolution Date: 06/Dec/06 11:46 AM


 Description  « Hide
LIKE should give true for two 0-length strings. See SQL 2003 Ch. 8.5
General Rules 3)c)i)

The query SELECT * FROM t WHERE v like ''

appears to give me all rows where v is an empty
string, as expected.

But a prepared statement

SELECT * FROM t WHERE v like ?, with setString(1, "")

always returns an empty result set. See attached repro for the full example.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dyre Tjeldvoll made changes - 20/Apr/06 06:06 PM
Field Original Value New Value
Attachment vti.java [ 12325608 ]
Rick Hillegas made changes - 27/Jul/06 09:51 PM
Urgency Normal
Rick Hillegas made changes - 19/Sep/06 02:58 PM
Fix Version/s 10.2.1.0 [ 11187 ]
Fix Version/s 10.2.2.0 [ 12312027 ]
Daniel John Debrunner made changes - 02/Nov/06 10:45 PM
Link This issue is part of DERBY-2034 [ DERBY-2034 ]
Bernt M. Johnsen made changes - 05/Dec/06 07:25 AM
Assignee Bernt M. Johnsen [ bernt ]
Bernt M. Johnsen made changes - 05/Dec/06 07:50 AM
Attachment DERBY-1231.diff [ 12346400 ]
Bernt M. Johnsen made changes - 05/Dec/06 07:51 AM
Derby Info [Patch Available]
Bernt M. Johnsen made changes - 05/Dec/06 08:51 AM
Link This issue is related to DERBY-1386 [ DERBY-1386 ]
Bernt M. Johnsen made changes - 05/Dec/06 08:52 AM
Link This issue blocks DERBY-1262 [ DERBY-1262 ]
Bernt M. Johnsen made changes - 05/Dec/06 08:55 AM
Link This issue blocks DERBY-1262 [ DERBY-1262 ]
Bernt M. Johnsen made changes - 05/Dec/06 10:12 AM
Link This issue blocks DERBY-2145 [ DERBY-2145 ]
Bernt M. Johnsen made changes - 05/Dec/06 11:54 AM
Status Open [ 1 ] In Progress [ 3 ]
Bernt M. Johnsen made changes - 06/Dec/06 08:13 AM
Attachment DERBY-1231-v2.diff [ 12346524 ]
Bernt M. Johnsen made changes - 06/Dec/06 09:25 AM
Attachment DERBY-1231-v3.diff [ 12346534 ]
Bernt M. Johnsen made changes - 06/Dec/06 09:29 AM
Fix Version/s 10.3.0.0 [ 12310800 ]
Derby Info [Patch Available]
Resolution Fixed [ 1 ]
Status In Progress [ 3 ] Resolved [ 5 ]
Bernt M. Johnsen made changes - 06/Dec/06 09:29 AM
Resolution Fixed [ 1 ]
Status Resolved [ 5 ] Reopened [ 4 ]
Bernt M. Johnsen made changes - 06/Dec/06 11:46 AM
Resolution Fixed [ 1 ]
Status Reopened [ 4 ] Resolved [ 5 ]
Andrew McIntyre made changes - 13/Dec/07 09:04 AM
Status Resolved [ 5 ] Closed [ 6 ]