Thanks for the feedback! I just tried the examples on the int-real branch,
and it seems that they do not cause any errors.
So I guess these two examples can be considered to be duplicate bug reports
of my "Index on REAL column malfunctions when multiplying with a string"
email.
Best,
Manuel
On Fri, May 3, 2019 at 1:49 PM Richard Hipp <d...@sqlite.org> wrote:
> 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
