Date: 2014-08-11 21:29:53 +0200
From: @skinkie
To: SQL devs <>
Version: 11.17.21 (Jan2014-SP3)
CC: @njnes

Last updated: 2014-10-31 14:14:29 +0100

Comment 20028

Date: 2014-08-11 21:29:53 +0200
From: @skinkie

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.58 Safari/537.36
Build Identifier:

create table test_a (a integer);
create table test_b (a smallint);

select * from test_a join test_b using (a);
TypeException:user.s9_1[28]:'calc.ifthenelse' undefined in: _68:any := calc.ifthenelse(_62:bit, _64:sht, _66:int)
program contains errors

"ON" works:
sql>select * from test_b join test_a on (test_a.a = test_b.a);
+---+---+
| a | a |
+===+===+
+---+---+
0 tuples (2.390ms)

Reproducible: Always

MonetDB 5 server v11.17.22 (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 20032

Date: 2014-08-12 11:48:04 +0200
From: MonetDB Mercurial Repository <>

Changeset b567ef55eac7 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=b567ef55eac7

Changeset description:

fixed bug #3536, ie handle different types in using and outer joins

Comment 20033

Date: 2014-08-12 11:49:00 +0200
From: @njnes

fixed

1. the natural join doesn't need the ifthen at all
2. in case of outer joins we need to convert types first

Comment 20373

Date: 2014-10-31 14:14:29 +0100
From: @sjoerdmullender

Oct2014 has been released.