Date: 2015-07-15 23:58:42 +0200
From: @yzchang
To: SQL devs <>
Version: 11.19.15 (Oct2014-SP4)
CC: @njnes

Last updated: 2015-08-28 13:41:39 +0200

Comment 21010

Date: 2015-07-15 23:58:42 +0200
From: @yzchang

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

When create a TEMP TABLE using "LIKE" to define its columns gives no result, neither an error nor "operation successful"

Reproducible: Always

Steps to Reproduce:

1. Run the following queries:

sql>create table t1 (i int);
operation successful (25.500ms)
sql>create temp table tmp (like t1);
sql>select * from tmp;
SELECT: no such table 'tmp'

Actual Results:

nothing at all

Expected Results:

Either an error, or "operation successful"

Comment 21011

Date: 2015-07-16 00:04:59 +0200
From: MonetDB Mercurial Repository <>

Changeset db6edcd1218a made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Added (and enabled :)) test for bug #3767

Comment 21043

Date: 2015-07-22 16:20:47 +0200
From: @njnes

with in the tmp schema, the table t1 isn't know, ie the create statement should have failed. Which it now does..

Comment 21181

Date: 2015-08-28 13:41:39 +0200
From: @sjoerdmullender

Jul2015 has been released.