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