You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:
Runs the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64));
INSERT INTO "t0" VALUES (0.10155454782177964, 'FALSE'), (594212101, NULL), (0.5981662672233894, NULL);
SELECT t0.c0 FROM t0 WHERE CAST((0.3101399424332040855034620108199305832386016845703125) NOT IN (0.6446234112932121007588648353703320026397705078125) AS BOOLEAN);
Actual Results:
Empty.
Expected Results:
3 rows.
The text was updated successfully, but these errors were encountered:
Date: 2020-06-15 16:07:10 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)
Last updated: 2020-07-27 09:30:12 +0200
Comment 27850
Date: 2020-06-15 16:07:10 +0200
From: @PedroTadim
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:
Runs the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64));
INSERT INTO "t0" VALUES (0.10155454782177964, 'FALSE'), (594212101, NULL), (0.5981662672233894, NULL);
SELECT t0.c0 FROM t0 WHERE CAST((0.3101399424332040855034620108199305832386016845703125) NOT IN (0.6446234112932121007588648353703320026397705078125) AS BOOLEAN);
Actual Results:
Empty.
Expected Results:
3 rows.
The text was updated successfully, but these errors were encountered: