SQLite

View Ticket
Login
Ticket Hash: 0f0428096f17252a932169ce017328e24e0c4114
Title: GLOB unexpectedly does not match
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-09-16 18:20:06
Version Found In: 3.29.0
User Comments:
mrigger added on 2019-09-03 18:23:00:

In the following test case, a row is unexpectedly not fetched:

CREATE TABLE t0(c0 UNIQUE);
INSERT INTO t0 VALUES (-1);
SELECT * FROM t0 WHERE t0.c0 GLOB '-*'; -- unexpected: row is not fetched

The expression should evaluate to TRUE:

SELECT t0.c0 GLOB '-*' FROM t0; -- TRUE