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.106 Safari/537.36
Build Identifier:
Run the statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t0("c0" DOUBLE NOT NULL);
COPY 11 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
0
0.9440456550171384
0.3985168253176739
0.9033732171086648
0.969477015070214
-4798112
0.6321209051017095
0.7740272412444077
0.7778437505533593
0.34293653568934335
0.1228907839970418
SELECT AVG(ALL ((((CAST(((+ (-266455613))/(sql_min(-384923592, -684635832))) AS INT))+(abs(((1380859174)(1039801791))))))(((((greatest(1447838997, -1100245247))/(((((849535137)||(-1532296761)))/(CAST(t0.c0 AS INT))))))(- (+ (((-291947972)(626914646))))))))), 0.77785585904529674916574322196538560092449188232421875 FROM t0 WHERE (0.06276420221300283) NOT BETWEEN ASYMMETRIC (t0.c0) AND (t0.c0)
GROUP BY 0.135845384683200176567652306403033435344696044921875, 0.86688447, 0.3299475775341662586725988148828037083148956298828125, + (+ (- (length(r'q')))), greatest(upper(upper(r'623865997')), trim(replace(r'vAd(Lup}Z', r'-1774953973', r'0.4235712099498189'), substr(r'', -1963236744)));
Major change. According to the SQL standard addition and subtraction between intervals and other number types is not allowed. The same applies for casting. This fixes bug #6910
The text was updated successfully, but these errors were encountered:
Date: 2020-06-23 18:06:30 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)
Last updated: 2020-10-19 11:06:20 +0200
Comment 27874
Date: 2020-06-23 18:06:30 +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 statements bellow.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t0("c0" DOUBLE NOT NULL);
COPY 11 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
0
0.9440456550171384
0.3985168253176739
0.9033732171086648
0.969477015070214
-4798112
0.6321209051017095
0.7740272412444077
0.7778437505533593
0.34293653568934335
0.1228907839970418
SELECT AVG(ALL ((((CAST(((+ (-266455613))/(sql_min(-384923592, -684635832))) AS INT))+(abs(((1380859174)(1039801791))))))(((((greatest(1447838997, -1100245247))/(((((849535137)||(-1532296761)))/(CAST(t0.c0 AS INT))))))(- (+ (((-291947972)(626914646))))))))), 0.77785585904529674916574322196538560092449188232421875 FROM t0 WHERE (0.06276420221300283) NOT BETWEEN ASYMMETRIC (t0.c0) AND (t0.c0)
GROUP BY 0.135845384683200176567652306403033435344696044921875, 0.86688447, 0.3299475775341662586725988148828037083148956298828125, + (+ (- (length(r'q')))), greatest(upper(upper(r'623865997')), trim(replace(r'vAd(Lup}Z', r'-1774953973', r'0.4235712099498189'), substr(r'', -1963236744)));
Actual Results:
Something
Expected Results:
MAL undefined error.
Comment 27876
Date: 2020-06-29 20:12:03 +0200
From: MonetDB Mercurial Repository <>
Changeset 20f3bf441d1a made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=20f3bf441d1a
Changeset description:
The text was updated successfully, but these errors were encountered: