Skip to content
New issue

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

casting a type without alias results in program contains errors #3626

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

casting a type without alias results in program contains errors #3626

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

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.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants