On 5/1/19, Manuel Rigger <rigger.man...@gmail.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
