On 5/3/19, Manuel Rigger <rigger.man...@gmail.com> wrote:
> I found another similar example with GLOB:
>
> CREATE TABLE test (c0 REAL);
> CREATE UNIQUE INDEX index_0 ON test(('0' GLOB -c0));
> INSERT INTO test(c0) VALUES (1.0), (0.0);
> REINDEX;
>
> Is the issue related to the implementation of the unary minus operator
> (i.e., do both examples trigger the same bug)?That seems likely. Did you try this using the int-real branch (https://www.sqlite.org/src/timeline?r=int-real)? That was my latest effort to address this corner case. We are working on some more pressing concerns right this moment. I will return to that branch, finish testing it, and perhaps merge it to trunk, when I get a chance. -- 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
