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 t.name as "table_name", c.name as "column_name", c.type, c.type_digits
from sys.tables t join sys.columns c on c.table_id = t.id where t.name = '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 pedro.ferreira@monetdbsolutions.com 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 pedro.ferreira@monetdbsolutions.com 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](https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0e5d3a5b40c6)  and use alternative way for bug #6776.

I found out there's an ugly hack to set the type of 'ifthenelse' expression.