Date: 2020-06-23 18:21:26 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:14 +0200

Comment 27875

Date: 2020-06-23 18:21:26 +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:

Do this

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "sys"."t0" ("c0" DECIMAL(18,3) NOT NULL);
COPY 41 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
0.388
0.371
0.939
0.790
0.493
0.148
0.841
0.034
0.189
0.087
0.048
0.227
0.759
0.446
0.622
0.579
0.453
0.819
0.768
0.027
0.839
0.506
0.560
0.362
0.453
0.728
0.078
0.364
0.559
0.829
0.061
0.854
0.920
0.440
0.627
0.838
0.113
0.501
0.283
0.722
0.819

SELECT ALL ((- (- (VAR_POP(ALL ((CAST(CAST(abs(709845242) AS INT) AS INT))%(abs(CAST((931144491) NOT IN (-587881807) AS INT))))))))^(- (+ (- (char_length(r'>])')))))), 0.5186927954967299, CAST("locate"(lower(r'[]'), rtrim(r'..ۄUH*6鉡q'), ((((-233289450)&(-476676450)))-(- (236876413)))) AS INT)
FROM t0 WHERE FALSE GROUP BY 1.2807753E7 HAVING MAX(ALL ((t0.c0)>=(NULL)));

Actual Results:

'calc.bit' undefined

Expected Results:

Somthing

Comment 27887

Date: 2020-06-30 16:23:14 +0200
From: MonetDB Mercurial Repository <>

Changeset 890beb553c41 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=890beb553c41

Changeset description:

Fix for bug #6911, ie never call exp_convert on any expression without knowing if it will be compatible with the output type.
Removed the superfluous exp_convert calls and moved rel_check_type to rel_exp.h and renamed it to exp_check_type to make it more widely available.