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

Creating a table with a full outer join query gives type with wrong digits on the joined key. #6776

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


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2019-10-21 15:42:28 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development

Last updated: 2019-11-28 10:00:06 +0100

Comment 27370

Date: 2019-10-21 15:42:28 +0200
From: @PedroTadim

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

Do the steps bellow.

Reproducible: Always

Steps to Reproduce:

create table dummy4("key" varchar(32), val int);
insert into dummy4 values('AAAAAAAA',1),('BBBBBBBBB',2);
create table dummy5("key" varchar(32), val int);
insert into dummy5 values('CCCCCCCC',3),('DDDDDDDD',4);
create table dummy6 as select "key", dummy4.val as "val4", dummy5.val as "val5" from dummy4 full outer join dummy5 using ("key");

select as "table_name", as "column_name", c.type, c.type_digits
from sys.tables t join sys.columns c on c.table_id = where = 'dummy6';

Actual Results:

Column "key" has 0 digits.

Expected Results:

Column "key" has 32 digits.

I already fixed this. Going to push in a few minutes.

Comment 27371

Date: 2019-10-21 15:45:47 +0200
From: MonetDB Mercurial Repository <>

Changeset 22d7b71a8c6b made by Pedro Ferreira in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=22d7b71a8c6b

Changeset description:

Added test and fixes for bug #6776, ie consider outer join like relations while compiling an USING token

Comment 27375

Date: 2019-10-22 09:40:41 +0200
From: MonetDB Mercurial Repository <>

Changeset 2cbfdbb1e382 made by Pedro Ferreira in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=2cbfdbb1e382

Changeset description:

Reverted changes from [0e5d3a5b40c6](;node=0e5d3a5b40c6)  and use alternative way for bug #6776.

I found out there's an ugly hack to set the type of 'ifthenelse' expression.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant