Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8247/BugTracker/Tests
Modified Files:
explain.SF-1739353.stable.out.Five
full_join_crash.SF-1841754.sql
full_join_crash.SF-1841754.stable.out
groupby_orderby_nonselected.SF-1723863.stable.err
subquery_orderby.SF-1688915.stable.err
subquery_orderby.SF-1688915.stable.out
Removed Files:
subquery_orderby.SF-1688915.stable.out.Five
Log Message:
output changes because of recent changes
full_join_crash because we now only return the 'joined' columns once
for 'naturel' join and join ... USING
--- subquery_orderby.SF-1688915.stable.out.Five DELETED ---
Index: full_join_crash.SF-1841754.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/full_join_crash.SF-1841754.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- full_join_crash.SF-1841754.sql 3 Dec 2007 08:51:24 -0000 1.2
+++ full_join_crash.SF-1841754.sql 27 Jan 2008 15:06:19 -0000 1.3
@@ -14,6 +14,9 @@
SELECT * FROM t1 FULL JOIN t2 USING (name);
SELECT * FROM t1 FULL JOIN t2 USING (name) FULL JOIN t3 USING (name);
+SELECT * FROM t1 natural FULL JOIN t2 ;
+SELECT * FROM t1 natural FULL JOIN t2 natural FULL JOIN t3;
+
drop table t1;
drop table t2;
drop table t3;
Index: explain.SF-1739353.stable.out.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/explain.SF-1739353.stable.out.Five,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- explain.SF-1739353.stable.out.Five 9 Dec 2007 16:22:36 -0000 1.10
+++ explain.SF-1739353.stable.out.Five 27 Jan 2008 15:06:19 -0000 1.11
@@ -43,12 +43,12 @@
| _6:bat[:oid,:oid]{rows=1:lng} := nil;
|
| _9{rows=1:lng} := algebra.kdifference(_1,_8);
|
| _8{rows=1:lng} := nil;
|
-| _11{rows=1:lng} := algebra.markT(_9,[EMAIL PROTECTED]);
|
+| _11{rows=1:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} :=
algebra.markT(_9,[EMAIL PROTECTED]); |
| _9{rows=1:lng} := nil;
|
-| _12{rows=1:lng} := bat.reverse(_11);
|
-| _11{rows=1:lng} := nil;
|
+| _12{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.reverse(_11); |
+| _11{rows=1:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} :=
nil; |
| _13:bat[:oid,:sht]{rows=1:lng,notnil} :=
sql.bind("tmp","_tables","type",0); |
-| _15{rows=1:lng} := algebra.join(_12,_13);
|
+| _15{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_12,_13); |
| _13:bat[:oid,:sht]{rows=1:lng,notnil} := nil;
|
| _16:bat[:oid,:int]{rows=107:lng,notnil} :=
sql.bind("sys","_tables","id",0); |
| _18:bat[:oid,:int]{rows=1:lng,notnil} :=
sql.bind("sys","_tables","id",1); |
@@ -66,10 +66,10 @@
| _24:bat[:oid,:oid]{rows=1:lng} := nil;
|
| _26{rows=109:lng} := algebra.kdifference(_23,_25);
|
| _25{rows=1:lng} := nil;
|
-| _27{rows=109:lng} := algebra.markT(_26,[EMAIL PROTECTED]);
|
+| _27{rows=109:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} :=
algebra.markT(_26,[EMAIL PROTECTED]); |
| _26{rows=109:lng} := nil;
|
-| _28{rows=109:lng} := bat.reverse(_27);
|
-| _27{rows=109:lng} := nil;
|
+| _28{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.reverse(_27); |
+| _27{rows=109:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} :=
nil; |
| _29:bat[:oid,:sht]{rows=107:lng,notnil} :=
sql.bind("sys","_tables","type",0); |
| _30:bat[:oid,:sht]{rows=1:lng,notnil} :=
sql.bind("sys","_tables","type",1); |
| _31{rows=108:lng} := algebra.kunion(_29,_30);
|
@@ -81,35 +81,35 @@
| _34{rows=109:lng} := algebra.kunion(_33,_32);
|
| _33{rows=108:lng} := nil;
|
| _32:bat[:oid,:sht]{rows=1:lng,notnil} := nil;
|
-| _35{rows=109:lng} := algebra.join(_28,_34);
|
+| _35{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_28,_34); |
| _34{rows=109:lng} := nil;
|
-| _36{rows=111:lng} := bat.setWriteMode(_35);
|
-| _35{rows=109:lng} := nil;
|
+| _36{rows=111:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.setWriteMode(_35); |
+| _35{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
| bat.append(_36,_15,true);
|
-| _15{rows=1:lng} := nil;
|
-| _40{rows=56:lng} := algebra.uselect(_36,nil:sht,2,false,false);
|
-| _36{rows=111:lng} := nil;
|
-| _43{rows=56:lng} := algebra.markT(_40,[EMAIL PROTECTED]);
|
-| _40{rows=56:lng} := nil;
|
-| _44{rows=56:lng} := bat.reverse(_43);
|
-| _43{rows=56:lng} := nil;
|
-| _45{rows=1:lng} := algebra.join(_12,_1);
|
+| _15{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _40{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.uselect(_36,nil:sht,2,false,false); |
+| _36{rows=111:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _43{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL
PROTECTED]:oid,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} :=
algebra.markT(_40,[EMAIL PROTECTED]); |
+| _40{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _44{rows=56:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL
PROTECTED]:oid,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.reverse(_43); |
+| _43{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL
PROTECTED]:oid,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} := nil; |
+| _45{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_12,_1); |
| _1:bat[:oid,:int]{rows=1:lng,notnil} := nil;
|
-| _46{rows=109:lng} := algebra.join(_28,_23);
|
+| _46{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_28,_23); |
| _23{rows=109:lng} := nil;
|
-| _47{rows=111:lng} := bat.setWriteMode(_46);
|
-| _46{rows=109:lng} := nil;
|
+| _47{rows=111:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.setWriteMode(_46); |
+| _46{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
| bat.append(_47,_45,true);
|
-| _45{rows=1:lng} := nil;
|
-| _49{rows=56:lng} := algebra.join(_44,_47);
|
-| _47{rows=111:lng} := nil;
|
-| _50{rows=56:lng} := algebra.markT(_49,[EMAIL PROTECTED]);
|
-| _49{rows=56:lng} := nil;
|
-| _51{rows=56:lng} := bat.reverse(_50);
|
-| _50{rows=56:lng} := nil;
|
+| _45{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _49{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_44,_47); |
+| _47{rows=111:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _50{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL
PROTECTED]:oid,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} :=
algebra.markT(_49,[EMAIL PROTECTED]); |
+| _49{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _51{rows=56:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL
PROTECTED]:oid,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.reverse(_50); |
+| _50{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL
PROTECTED]:oid,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} := nil; |
| _52:bat[:oid,:str]{rows=1:lng,notnil} :=
sql.bind("tmp","_tables","name",0); |
-| _54{rows=1:lng} := algebra.join(_12,_52);
|
-| _12{rows=1:lng} := nil;
|
+| _54{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_12,_52); |
+| _12{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
| _52:bat[:oid,:str]{rows=1:lng,notnil} := nil;
|
| _55:bat[:oid,:str]{rows=107:lng,notnil} :=
sql.bind("sys","_tables","name",0); |
| _56:bat[:oid,:str]{rows=1:lng,notnil} :=
sql.bind("sys","_tables","name",1); |
@@ -122,24 +122,26 @@
| _60{rows=109:lng} := algebra.kunion(_59,_58);
|
| _59{rows=108:lng} := nil;
|
| _58:bat[:oid,:str]{rows=1:lng,notnil} := nil;
|
-| _61{rows=109:lng} := algebra.join(_28,_60);
|
-| _28{rows=109:lng} := nil;
|
+| _61{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_28,_60); |
+| _28{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
| _60{rows=109:lng} := nil;
|
-| _62{rows=111:lng} := bat.setWriteMode(_61);
|
-| _61{rows=109:lng} := nil;
|
+| _62{rows=111:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
bat.setWriteMode(_61); |
+| _61{rows=109:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
| bat.append(_62,_54,true);
|
-| _54{rows=1:lng} := nil;
|
-| _64{rows=56:lng} := algebra.joinPath(_51,_44,_62);
|
-| _51{rows=56:lng} := nil;
|
-| _44{rows=56:lng} := nil;
|
-| _62{rows=111:lng} := nil;
|
-| _65 := sql.resultSet(1,1,_64);
|
-| sql.rsColumn(_65,"sys.tables","name","varchar",1024,0,_64);
|
-| _64{rows=56:lng} := nil;
|
-| sql.exportResult(_65,"");
|
+| _54{rows=1:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _64{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_44,_62); |
+| _44{rows=56:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL
PROTECTED]:oid,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} := nil; |
+| _62{rows=111:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _65{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
algebra.join(_51,_64); |
+| _51{rows=56:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL
PROTECTED]:oid,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} := nil; |
+| _64{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| _66 := sql.resultSet(1,1,_65);
|
+| sql.rsColumn(_66,"sys.tables","name","varchar",1024,0,_65);
|
+| _65{rows=56:lng,hlb>[EMAIL PROTECTED]:oid,hub<[EMAIL PROTECTED]:oid} :=
nil; |
+| sql.exportResult(_66,"");
|
| end s1_1;
|
+------------------------------------------------------------------------------+
-102 rows
+104 rows
# 13:06:44 >
Index: full_join_crash.SF-1841754.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/full_join_crash.SF-1841754.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- full_join_crash.SF-1841754.stable.out 3 Dec 2007 08:51:26 -0000
1.2
+++ full_join_crash.SF-1841754.stable.out 27 Jan 2008 15:06:19 -0000
1.3
@@ -1,21 +1,22 @@
stdout of test 'full_join_crash.SF-1841754` in directory 'src/test/BugTracker`
itself:
-# 10:32:46 >
-# 10:32:46 > Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30150 --set
xrpc_port=44978 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" "--dbinit= module(sql_server);" ; echo ;
echo Over..
-# 10:32:46 >
-
-# MonetDB Server v4.20.1
-# based on GDK v1.20.1
-# Copyright (c) 1993-2007, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
-# MonetDB/SQL module v2.20.3 loaded
+# 15:12:40 >
+# 15:12:40 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=36556 --set
xrpc_port=42728 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 15:12:40 >
-printf("\nReady.\n");
+# MonetDB server v5.3.0, based on kernel v1.21.0
+# Serving database 'mTests_src_test_BugTracker'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:36556/
+# MonetDB/SQL module v2.21.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -30,24 +31,42 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.t1, sys.t1, sys.t2, sys.t2 # table_name
-% name, n, name, n # name
-% clob, int, clob, int # type
+% sys., sys.t1, sys.t2 # table_name
+% name, n, n # name
+% clob, int, int # type
+% 2, 2, 2 # length
+[ "aa", 11, 12 ]
+[ "bb", NULL, 22 ]
+[ "dd", NULL, 42 ]
+% sys., sys.t1, sys.t2, sys.t3 # table_name
+% name, n, n, n # name
+% clob, int, int, int # type
% 2, 2, 2, 2 # length
-[ "aa", 11, "aa", 12 ]
-[ NULL, NULL, "bb", 22 ]
-[ NULL, NULL, "dd", 42 ]
-% sys.t1, sys.t1, sys.t2, sys.t2, sys.t3, sys.t3 # table_name
-% name, n, name, n, name, n # name
-% clob, int, clob, int, clob, int # type
-% 2, 2, 2, 2, 2, 2 # length
-[ "aa", 11, "aa", 12, "aa", 13 ]
-[ NULL, NULL, "bb", 22, NULL, NULL ]
-[ NULL, NULL, "dd", 42, NULL, NULL ]
-[ NULL, NULL, NULL, NULL, "bb", 23 ]
-[ NULL, NULL, NULL, NULL, "cc", 33 ]
+[ "aa", 11, 12, 13 ]
+[ "bb", NULL, 22, 23 ]
+[ "dd", NULL, 42, NULL ]
+[ "cc", NULL, NULL, 33 ]
+% sys., sys. # table_name
+% name, n # name
+% clob, int # type
+% 2, 2 # length
+[ "aa", 11 ]
+[ "aa", 12 ]
+[ "bb", 22 ]
+[ "dd", 42 ]
+% sys., sys. # table_name
+% name, n # name
+% clob, int # type
+% 2, 2 # length
+[ "aa", 11 ]
+[ "aa", 12 ]
+[ "bb", 22 ]
+[ "dd", 42 ]
+[ "aa", 13 ]
+[ "bb", 23 ]
+[ "cc", 33 ]
-# 10:32:46 >
-# 10:32:46 > Done.
-# 10:32:46 >
+# 15:12:40 >
+# 15:12:40 > Done.
+# 15:12:40 >
Index: subquery_orderby.SF-1688915.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/subquery_orderby.SF-1688915.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- subquery_orderby.SF-1688915.stable.out 5 Sep 2007 08:27:25 -0000
1.4
+++ subquery_orderby.SF-1688915.stable.out 27 Jan 2008 15:06:19 -0000
1.5
@@ -1,59 +1,31 @@
stdout of test 'subquery_orderby.SF-1688915` in directory
'src/test/BugTracker` itself:
-# 10:11:41 >
-# 10:11:41 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=35778 --set xrpc_port=45704 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
-# 10:11:41 >
-
-# Monet Database Server V4.16.3
-# Copyright (c) 1993-2007, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 12:35:21 >
+# 12:35:21 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31630 --set
xrpc_port=49305 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 12:35:21 >
-printf("\nReady.\n");
+# MonetDB server v5.3.0, based on kernel v1.21.0
+# Serving database 'mTests_src_test_BugTracker'
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:31630/
+# MonetDB/SQL module v2.21.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
-# 10:11:41 >
-# 10:11:41 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35778
-# 10:11:41 >
+# 12:35:21 >
+# 12:35:21 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=31630
+# 12:35:21 >
-% .x # table_name
-% name # name
-% varchar # type
-% 12 # length
-[ "schemas" ]
-[ "types" ]
-[ "functions" ]
-[ "args" ]
-[ "sequences" ]
-[ "dependencies" ]
-[ "connections" ]
-[ "_tables" ]
-[ "_columns" ]
-[ "keys" ]
-[ "idxs" ]
-[ "triggers" ]
-[ "keycolumns" ]
-[ "_tables" ]
-[ "_columns" ]
-[ "keys" ]
-[ "idxs" ]
-[ "triggers" ]
-[ "keycolumns" ]
-[ "tables" ]
-[ "columns" ]
-[ "db_users" ]
-[ "users" ]
-[ "user_role" ]
-[ "auths" ]
-[ "privileges" ]
-[ "profile" ]
-# 14:16:47 >
-# 14:16:47 > Done.
-# 14:16:47 >
+# 12:35:21 >
+# 12:35:21 > Done.
+# 12:35:21 >
Index: groupby_orderby_nonselected.SF-1723863.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/groupby_orderby_nonselected.SF-1723863.stable.err,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- groupby_orderby_nonselected.SF-1723863.stable.err 23 May 2007 22:08:12
-0000 1.1
+++ groupby_orderby_nonselected.SF-1723863.stable.err 27 Jan 2008 15:06:19
-0000 1.2
@@ -10,9 +10,14 @@
# 23:24:26 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35962
# 23:24:26 >
-MAPI = [EMAIL PROTECTED]:35962
+MAPI = [EMAIL PROTECTED]:31630
QUERY = select count(*)
-ERROR = !ORDER BY: no such column 'col1'
+ERROR = !syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or
UNION or ')' in: "select count(*)
+ !from (
+ !select col2, count(*) as row_count
+ !from data_1to10
+ !group by col2
+ !order"
# 23:24:26 >
# 23:24:26 > Done.
Index: subquery_orderby.SF-1688915.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/subquery_orderby.SF-1688915.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- subquery_orderby.SF-1688915.stable.err 26 Jan 2008 13:39:15 -0000
1.3
+++ subquery_orderby.SF-1688915.stable.err 27 Jan 2008 15:06:19 -0000
1.4
@@ -10,6 +10,9 @@
# 10:11:41 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35778
# 10:11:41 >
+MAPI = [EMAIL PROTECTED]:31630
+QUERY = select name from (select name, id from tables order by id) as x;
+ERROR = !syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or
UNION or ')' in: "select name from (select name, id from tables order"
# 10:11:41 >
# 10:11:41 > Done.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
