Hi all,
As shown below, despite CREATE TABLE WITH DATA works fine,
CREATE TEMPORARY TABLE WITH DATA is not able to create a temp table
with data.
---------------------------------------------------------
$ mclient mydb
Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014-SP3)
Database: MonetDB v11.17.21 (Jan2014-SP3),
'mapi:monetdb://localhost.localdomain:50000/mydb'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>CREATE TABLE t2 AS SELECT 1 WITH DATA;
operation successful (1.143ms)
sql>SELECT * FROM t2;
+------+
| v |
+======+
| 1 |
+------+
1 tuple (0.453ms)
sql>CREATE TEMPORARY TABLE t AS SELECT 1 WITH DATA;
operation successful (0.985ms)
sql>SELECT * FROM t;
+---+
| v |
+===+
+---+
0 tuples (0.439ms)
sql>
---------------------------------------------------------
Is this a bug? or something I misunderstand?
Regards,
--
NAGAYASU Satoshi