Fixed at https://www.sqlite.org/src/timeline?c=b043a54c3de54b28
On 5/1/19, Manuel Rigger <rigger.man...@gmail.com> wrote:
> I'm very sorry, after finding the issue using the latest stable Linux
> version, I accidentally used an outdated version (3.24.0) to produce a
> minimal failing case. Here is a reduced example that triggers the bug on
> the latest stable [1] and snapshot [2] versions:
>
> 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 '+/');
>
> Best,
> Manuel
>
>
> [1] 3.28.0 2019-04-16 19:49:53
> 884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50
> [2] 3.29.0 2019-04-27 20:30:19
> 50fe48458942fa7a6bcc76316c6321f95b23dc34f2f8e0a483826483b2fb16f6
>
> On Wed, May 1, 2019 at 9:55 PM Warren Young <war...@etr-usa.com> wrote:
>
>> On May 1, 2019, at 1:18 PM, Richard Hipp <d...@sqlite.org> wrote:
>> >
>> > I am unable to reproduce the observed behavior.
>>
>> Nor I, on 3.28.0 release with our custom build.
>>
>> Thank you for providing a simple test case, Manuel: it helps greatly!
>>
>> > What version of
>> > SQLite are you testing with? Are you compiling it yourself? If so,
>> > what compile-time options do you use?
>>
>> Also, what is your locale setting? The fact that COLLATE NOCASE affects
>> it makes this smell like a locale/i18n issue, to me.
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
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
