[sqlite] LIKE does not fetch row when used on INT UNIQUE COLLATE NOCASE column

[Manuel Rigger]

Hi,

I found an issue where a row is not fetched when using a LIKE operator on
an INT UNIQUE COLLATE NOCASE column:

CREATE TABLE t0(c0 INT UNIQUE COLLATE NOCASE);
INSERT INTO t0(c0) VALUES ('./');
SELECT * FROM t0 WHERE t0.c0 LIKE './'; -- fetches no rows

The following query returns TRUE:

SELECT t0.c0 LIKE './' FROM t0; -- returns 1

Best,
Manuel
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users