Re: [sqlite] Unique index that uses GLOB does not detect duplicate due to REAL conversion

2019-04-30 Thread Keith Medcalf
edle or the haystack are numeric storage class. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of

[sqlite] Unique index that uses GLOB does not detect duplicate due to REAL conversion

2019-04-30 Thread Manuel Rigger
Hi everyone, It think that I found a bug where I could circumvent a UNIQUE check of an index. Consider the example below, which causes "Error: UNIQUE constraint failed" when invoking REINDEX: CREATE TABLE test (c0, c1 REAL); CREATE UNIQUE INDEX index_1 ON test(c0 GLOB c1); INSERT INTO test(c0, c