On 5/1/19, Manuel Rigger <[email protected]> wrote: > > CREATE TABLE test (c0 REAL); > CREATE INDEX index_0 ON test(c0 COLLATE NOCASE); > INSERT INTO test(c0) VALUES ('/'); > SELECT * FROM test WHERE (c0 LIKE '/'); > > Unexpectedly, the SELECT statement does not return a result.
I am unable to reproduce the observed behavior. What version of SQLite are you testing with? Are you compiling it yourself? If so, what compile-time options do you use? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
