"Cannot find column type" error in temporary tables in functions

[monetdb-team]

Date: 2013-11-04 15:52:32 +0100
From: @arjenderijke
To: SQL devs <>
Version: 11.15.17 (Feb2013-SP5)
CC: @njnes

Last updated: 2013-12-03 13:59:36 +0100

Comment 19320

Date: 2013-11-04 15:52:32 +0100
From: @arjenderijke

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0
Build Identifier:

If you define a temporary table within a function, you cannot used special columntypes. If you select the function, you get an errormessage: Cannot find column type.

This does not happen if you use the standard columntypes like integer, float

Reproducible: Always

Comment 19321

Date: 2013-11-04 16:13:44 +0100
From: MonetDB Mercurial Repository <>

Changeset 9ee5aecf7b01 made by Arjen de Rijke arjen.de.rijke@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=9ee5aecf7b01

Changeset description:

add test for bug #3394

Comment 19328

Date: 2013-11-11 22:20:44 +0100
From: @njnes

now we also handle created types in declared tables

Comment 19380

Date: 2013-12-03 13:59:36 +0100
From: @sjoerdmullender

Feb2013-SP6 has been released.