casting a type without alias results in program contains errors

[monetdb-team]

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:

fixed bug #3626 by adding an extra alias to cast expressions

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.