Fixed at https://www.sqlite.org/src/timeline?c=b043a54c3de54b28
On 5/1/19, Manuel Rigger 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
ume.
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of Manuel Rigger
> >Sent: Wednesday, 1 May, 2019 15:31
> >To: SQLite mailing list
> >Subject: Re: [sqlite] COLLATE NOCASE index on REAL column
> >
n Behalf Of Manuel Rigger
>Sent: Wednesday, 1 May, 2019 15:31
>To: SQLite mailing list
>Subject: Re: [sqlite] COLLATE NOCASE index on REAL column
>malfunctions
>
>I'm very sorry, after finding the issue using the latest stable Linux
>version, I accidentally used an outdated versio
On May 1, 2019, at 3:31 PM, Manuel Rigger 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 '+/‘);
That behavior *does* reproduce here.
Making the final query’s predicate “c0 =
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);
On May 1, 2019, at 1:18 PM, Richard Hipp 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
On 5/1/19, Manuel Rigger 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
Hi everyone,
Consider the example below:
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. If the
statement for the creation of the
8 matches
Mail list logo