We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Date: 2020-06-23 16:36:55 +0200 From: @PedroTadim To: SQL devs <> Version: 11.37.7 (Jun2020)
Last updated: 2020-07-27 09:30:12 +0200
Date: 2020-06-23 16:36:55 +0200 From: @PedroTadim
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36 Build Identifier:
Run the statments bellow.
Reproducible: Always
CREATE TABLE "sys"."t0" ("c0" BOOLEAN,"c1" DOUBLE PRECISION NOT NULL); COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'; false 0.2059926383949241 NULL 1.89755202e+09 NULL 0.8514002985569765 NULL 0.8565135463082767
SELECT ALL t0.c0 FROM t0 WHERE (((0.654013919354451) BETWEEN SYMMETRIC (t0.c1) AND ("length"(upper(''))))OR(t0.c0));
empty
3 null values.
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Date: 2020-06-23 16:36:55 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)
Last updated: 2020-07-27 09:30:12 +0200
Comment 27873
Date: 2020-06-23 16:36:55 +0200
From: @PedroTadim
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36
Build Identifier:
Run the statments bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE "sys"."t0" ("c0" BOOLEAN,"c1" DOUBLE PRECISION NOT NULL);
COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
false 0.2059926383949241
NULL 1.89755202e+09
NULL 0.8514002985569765
NULL 0.8565135463082767
SELECT ALL t0.c0 FROM t0 WHERE (((0.654013919354451) BETWEEN SYMMETRIC (t0.c1) AND ("length"(upper(''))))OR(t0.c0));
Actual Results:
empty
Expected Results:
3 null values.
The text was updated successfully, but these errors were encountered: