Date: 2014-02-04 20:34:29 +0100
From: @mlkersten
To: SQL devs <>
Version: 11.15.11 (Feb2013-SP3)
CC: @njnes

Last updated: 2014-02-20 15:02:59 +0100

Comment 19528

Date: 2014-02-04 20:34:29 +0100
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:26.0) Gecko/20100101 Firefox/26.0
Build Identifier:

sql>create schema tempo ;
operation successful (85.215ms)

a typo creates a wrong error message
sql>create temporary table temp.dummy(i int);
CREATE TABLE: no such schema 'temporary'

In Postgresql, temporary tables can only be assigned
to a specific schema;
sql>create temporary table tempo.dummy(i int);
operation successful (28.985ms)
I had expected a proper error message

sql>select * from tempo.dummy;
SELECT: no such table 'dummy'
sql>select * from tmp.dummy;
+---+
| i |
+===+
+---+

Reproducible: Always

Steps to Reproduce:

Test file has been added

Comment 19529

Date: 2014-02-04 20:38:13 +0100
From: MonetDB Mercurial Repository <>

Changeset 8278337135e7 made by Martin Kersten mk@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Add test file temporary.Bug-3430

Comment 19541

Date: 2014-02-05 11:48:18 +0100
From: @njnes

local temp tables are indeed stored in the tmp schema, ie the schema part should not be given, and if given should give an error when not equal to tmp. For global temporary tables this is not the case.

The first create has one more side effect, ie temp gets expanded to temporary.

Comment 19542

Date: 2014-02-05 12:09:24 +0100
From: @njnes

check for local temporary tables with incorrect schema's (!= tmp) added.

Comment 19546

Date: 2014-02-05 13:00:19 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

approved output for bug #3427 (also use auto commit mode)
fixed bug #3430, ie check if local temporary tables are stored in the 'tmp' schema
fixed bug #3428, don't overwrite the statement number, but use a temporary structure to store the
NotNil select statements. Solves the problem that the sum(a), sub(a*b) uses the a after nil
removal in the a*b.

fixed bug #3425, correctly add the timezone with the proper type (ie second interval (ie with scale 3))

Comment 19615

Date: 2014-02-20 15:02:59 +0100
From: @sjoerdmullender

Jan2014 has been released.