[#SES-675] MySql REGEX fails for null value

Issue Details [XML]

Key:	SES-675
Type:	Bug
Status:	Open
Priority:	Minor
Assignee:	Unassigned
Reporter:	James Leigh
Votes:	0
Watchers:	0

Operations

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

Sesame

MySql REGEX fails for null value

Created: 20/Jul/09 02:50 PM Updated: 20/Jul/09 02:50 PM

Component/s:

RDBMS Sail

Affects Version/s:

2.2.4

Fix Version/s:

None

Description

http://www.openrdf.org/forum/mvnforum/viewthread?thread=2173

An unknown predicate causes a regex to compare with a null value, this should be optimized away and is invalid SQL.

SELECT r0.subj,
NULL ,
r0.obj,
NULL
FROM TRIPLES_14774 r0
WHERE NULL COLLATE utf8_general_ci REGEXP ?

All

Comments

Change History

Sort Order:

There are no comments yet on this issue.