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; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.6 Safari/537.36
Build Identifier:
Casting a column to a different type without aliasing it to the same name results in program contains errors;
create table test2 (i int, b bool);
insert into test2 values (1, true);
select cast(b as smallint), (i > 0 and b) from test2;
TypeException:user.s33_1[22]:'calc.and' undefined in: _69:any := calc.and(_65:bit, 67:sht)
select cast(b as smallint) as b, (i > 0 and b) from test2;
+------+---------+
| b | and>_i |
+======+=========+
| 1 | true |
+------+---------+
1 tuple (1.751ms)
my original problem was, but it is difficult to reproduce;
TypeException:user.s32_1[928]:'bat.insert' undefined in: _2267:any := bat.insert(_2257:bat[:oid,:bit], _2265:oid, _2264:sht)
Reproducible: Always
MonetDB 5 server v11.19.4 (64-bit, 64-bit oids)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 31.4GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.33 2013-05-28 (compiled with 8.33)
openssl: OpenSSL 1.0.1h 5 Jun 2014 (compiled with OpenSSL 1.0.1h 5 Jun 2014)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: skinkie@bigdata.openebs.nl (x86_64-unknown-linux-gnu)
Compilation: gcc -g -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code
Linking : /usr/x86_64-pc-linux-gnu/bin/ld -m elf_x86_64
Date: 2014-11-23 13:34:51 +0100
From: @skinkie
To: SQL devs <>
Version: 11.19.3 (Oct2014)
CC: @njnes
Last updated: 2015-01-29 14:07:36 +0100
Comment 20454
Date: 2014-11-23 13:34:51 +0100
From: @skinkie
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.6 Safari/537.36
Build Identifier:
Casting a column to a different type without aliasing it to the same name results in program contains errors;
create table test2 (i int, b bool);
insert into test2 values (1, true);
select cast(b as smallint), (i > 0 and b) from test2;
TypeException:user.s33_1[22]:'calc.and' undefined in: _69:any := calc.and(_65:bit, 67:sht)
select cast(b as smallint) as b, (i > 0 and b) from test2;
+------+---------+
| b | and>_i |
+======+=========+
| 1 | true |
+------+---------+
1 tuple (1.751ms)
my original problem was, but it is difficult to reproduce;
TypeException:user.s32_1[928]:'bat.insert' undefined in: _2267:any := bat.insert(_2257:bat[:oid,:bit], _2265:oid, _2264:sht)
Reproducible: Always
MonetDB 5 server v11.19.4 (64-bit, 64-bit oids)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 31.4GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.33 2013-05-28 (compiled with 8.33)
openssl: OpenSSL 1.0.1h 5 Jun 2014 (compiled with OpenSSL 1.0.1h 5 Jun 2014)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: skinkie@bigdata.openebs.nl (x86_64-unknown-linux-gnu)
Compilation: gcc -g -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code
Linking : /usr/x86_64-pc-linux-gnu/bin/ld -m elf_x86_64
Comment 20496
Date: 2014-12-01 09:17:35 +0100
From: MonetDB Mercurial Repository <>
Changeset d54e3de83771 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=d54e3de83771
Changeset description:
Comment 20497
Date: 2014-12-01 09:20:21 +0100
From: @njnes
fixed by adding an extra label/alias
Comment 20603
Date: 2015-01-29 14:07:36 +0100
From: @sjoerdmullender
Oct2014-SP2 has been released.
The text was updated successfully, but these errors were encountered: