Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30583
Modified Files:
All
Added Files:
explain.SF-1739353-data.sql explain.SF-1739353.SQL
explain.SF-1739353.stable.err
explain.SF-1739353.stable.err.Five
explain.SF-1739353.stable.out
explain.SF-1739353.stable.out.Five
Log Message:
Add test for bug #1739353
A simple explain query. Since the MAL code differs quite a lot from the
MIL code, I added a M5 specific output.
--- NEW FILE: explain.SF-1739353-data.sql ---
EXPLAIN SELECT "name" FROM "tables";
--- NEW FILE: explain.SF-1739353.stable.out.Five ---
stdout of test 'explain.SF-1739353` in directory 'src/test/BugTracker` itself:
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 420 mserver5
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/sqllog"
--set
"xquery_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/xquerylog"
--set mapi_open=true --set mapi_port=31876 --set xrpc_port=48015 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include
sql;' ; echo ; echo Over..
# 13:06:43 >
# MonetDB server v5.1.0, based on kernel v1.19.0
# Serving database 'mTests_src_test_BugTracker'
# Compiled for x86_64-pc-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://pegasus.ins.cwi.nl:31876/
# MonetDB/SQL module v2.19.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 300 ./explain.SF-1739353.SQL explain.SF-1739353
# 13:06:43 >
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -f
../../../../../../../../../scratch1/fabian/monetdb/current/sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql
# 13:06:43 >
+------------------------------------------------------------------------------+
| mal |
+==============================================================================+
| function user.s1_1():void; |
| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=174} :=
sql.bind("tmp","_tables","id",0); |
| constraints.emptySet(_1); |
| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=178} :=
sql.bind("tmp","_tables","type",0); |
| _13:bat[:oid,:int]{notnil=true,rows=30:lng,bid=88} :=
sql.bind("sys","_tables","id",0); |
| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=387} :=
sql.bind("sys","_tables","id",1); |
| constraints.emptySet(_15); |
| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=387} := nil; |
| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=389} :=
sql.bind("sys","_tables","id",2); |
| constraints.emptySet(_16); |
| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=389} := nil; |
| _20:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=92} :=
sql.bind("sys","_tables","type",0); |
| _38:bat[:oid,:str]{notnil=true,rows=0:lng,bid=175} :=
sql.bind("tmp","_tables","name",0); |
| _41:bat[:oid,:str]{notnil=true,rows=30:lng,bid=89} :=
sql.bind("sys","_tables","name",0); |
| _8{rows=0:lng} := algebra.markT(_1,[EMAIL PROTECTED]);
|
| _9{rows=0:lng} := bat.reverse(_8); |
| _8{rows=0:lng} := nil; |
| _12{rows=0:lng} := algebra.join(_9,_10); |
| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=178} := nil; |
| _18{rows=30:lng} := algebra.markT(_13,[EMAIL PROTECTED]);
|
| _19{rows=30:lng} := bat.reverse(_18); |
| _18{rows=30:lng} := nil; |
| _21{rows=30:lng} := algebra.join(_19,_20); |
| _20:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=92} := nil; |
| _22{rows=31:lng} := bat.setWriteMode(_21); |
| _21{rows=30:lng} := nil; |
| bat.append(_22,_12,true); |
| _12{rows=0:lng} := nil; |
| _26{rows=31:lng} := algebra.uselect(_22,nil:sht,2,false,false); |
| _22{rows=31:lng} := nil; |
| _29{rows=31:lng} := algebra.markT(_26,[EMAIL PROTECTED]);
|
| _26{rows=31:lng} := nil; |
| _30{rows=31:lng} := bat.reverse(_29); |
| _29{rows=31:lng} := nil; |
| _31{rows=0:lng} := algebra.join(_9,_1); |
| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=174} := nil; |
| _32{rows=30:lng} := algebra.join(_19,_13); |
| _13:bat[:oid,:int]{notnil=true,rows=30:lng,bid=88} := nil; |
| _33{rows=31:lng} := bat.setWriteMode(_32); |
| _32{rows=30:lng} := nil; |
| bat.append(_33,_31,true); |
| _31{rows=0:lng} := nil; |
| _35{rows=31:lng} := algebra.join(_30,_33); |
| _33{rows=31:lng} := nil; |
| _36{rows=31:lng} := algebra.markT(_35,[EMAIL PROTECTED]);
|
| _35{rows=31:lng} := nil; |
| _37{rows=31:lng} := bat.reverse(_36); |
| _36{rows=31:lng} := nil; |
| _40{rows=0:lng} := algebra.join(_9,_38); |
| _9{rows=0:lng} := nil; |
| _38:bat[:oid,:str]{notnil=true,rows=0:lng,bid=175} := nil; |
| _42{rows=30:lng} := algebra.join(_19,_41); |
| _19{rows=30:lng} := nil; |
| _41:bat[:oid,:str]{notnil=true,rows=30:lng,bid=89} := nil; |
| _43{rows=31:lng} := bat.setWriteMode(_42); |
| _42{rows=30:lng} := nil; |
| bat.append(_43,_40,true); |
| _40{rows=0:lng} := nil; |
| _45{rows=31:lng} := algebra.joinPath(_37,_30,_43); |
| _37{rows=31:lng} := nil; |
| _30{rows=31:lng} := nil; |
| _43{rows=31:lng} := nil; |
| _46 := sql.resultSet(1,1,_45); |
| sql.rsColumn(_46,"sys.tables","name","varchar",1024,0,_45); |
| _45{rows=31:lng} := nil; |
| sql.exportResult(_46,""); |
| end s1_1; |
+------------------------------------------------------------------------------+
67 rows
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -q
# 13:06:43 >
# 13:06:44 >
# 13:06:44 > Done.
# 13:06:44 >
--- NEW FILE: explain.SF-1739353.stable.err.Five ---
stderr of test 'explain.SF-1739353` in directory 'src/test/BugTracker` itself:
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 420 mserver5
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/sqllog"
--set
"xquery_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/xquerylog"
--set mapi_open=true --set mapi_port=31876 --set xrpc_port=48015 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include
sql;' ; echo ; echo Over..
# 13:06:43 >
#warning: please don't forget to set your vault key!
#(see /ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf)
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 300 ./explain.SF-1739353.SQL explain.SF-1739353
# 13:06:43 >
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -f
../../../../../../../../../scratch1/fabian/monetdb/current/sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql
# 13:06:43 >
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -q
# 13:06:43 >
Database connect failed: InvalidCredentialsException:checkCredentials:Invalid
credentials for user 'voc'
# 13:06:44 >
# 13:06:44 > Done.
# 13:06:44 >
--- NEW FILE: explain.SF-1739353.SQL ---
#!/bin/bash
cat << EOF > .monetdb
user=monetdb
password=monetdb
EOF
LANG="en_US.UTF-8"
export LANG
Mlog "$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -f
$RELSRCDIR/explain.SF-1739353-data.sql"
$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -f
$RELSRCDIR/explain.SF-1739353-data.sql
cat << EOF > .monetdb
user=voc
password=voc
EOF
Mlog "$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -q"
$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -q
rm -f .monetdb
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.61
retrieving revision 1.62
diff -u -d -r1.61 -r1.62
--- All 22 Jun 2007 07:09:13 -0000 1.61
+++ All 17 Jul 2007 11:13:07 -0000 1.62
@@ -76,3 +76,4 @@
alter_table_add_fkey.SF-1737668
select_id_not_in_another_select.SF-1737777
crash_on_concurrent_use.SF-1411926
+HAVE_JAVA?explain.SF-1739353
--- NEW FILE: explain.SF-1739353.stable.out ---
stdout of test 'explain.SF-1739353` in directory 'src/test/BugTracker` itself:
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 420 mserver5
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/sqllog"
--set
"xquery_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/xquerylog"
--set mapi_open=true --set mapi_port=31876 --set xrpc_port=48015 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include
sql;' ; echo ; echo Over..
# 13:06:43 >
# MonetDB server v5.1.0, based on kernel v1.19.0
# Serving database 'mTests_src_test_BugTracker'
# Compiled for x86_64-pc-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://pegasus.ins.cwi.nl:31876/
# MonetDB/SQL module v2.19.0 loaded
printf("\nReady.\n");
Ready.
quit();
Over..
# 13:09:50 >
# 13:09:50 > Mtimeout -timeout 300 ./explain.SF-1739353.SQL explain.SF-1739353
# 13:09:50 >
# 13:09:50 >
# 13:09:50 > Mtimeout -timeout 60 mjclient -h pegasus -p 36830 -d
mTests_src_test_BugTracker -f
../../../../../../../../../scratch1/fabian/monetdb/current/sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql
# 13:09:50 >
+-----------------------------------------------------------------------+
| statement |
+=======================================================================+
| var s21 := mvc_bind(myc, "tmp", "_tables", "id", 0); |
| var s23 := mvc_bind_dbat(myc, "tmp", "_tables", 1); |
| var s22 := s23.reverse(); |
| s23 := nil; |
| var s20 := kdiff(s21, s22); |
| s22 := nil; |
| var s24 := oid("[EMAIL PROTECTED]");
|
| var s19 := mark(s20, s24); |
| s24 := nil; |
| var s18 := s19.reverse(); |
| var s25 := mvc_bind(myc, "tmp", "_tables", "type", 0); |
| var s17 := s18.join(s25); |
| s25 := nil; |
| var s34 := mvc_bind(myc, "sys", "_tables", "id", 0); |
| var s35 := mvc_bind(myc, "sys", "_tables", "id", 1); |
| var s33 := kunion(s34, s35); |
| s34 := nil; |
| s35 := nil; |
| var s36 := mvc_bind(myc, "sys", "_tables", "id", 2); |
| var s32 := kdiff(s33, s36); |
| s33 := nil; |
| var s31 := kunion(s32, s36); |
| s32 := nil; |
| s36 := nil; |
| var s38 := mvc_bind_dbat(myc, "sys", "_tables", 1); |
| var s37 := s38.reverse(); |
| s38 := nil; |
| var s30 := kdiff(s31, s37); |
| s37 := nil; |
| var s39 := oid("[EMAIL PROTECTED]");
|
| var s29 := mark(s30, s39); |
| s39 := nil; |
| var s28 := s29.reverse(); |
| var s43 := mvc_bind(myc, "sys", "_tables", "type", 0); |
| var s44 := mvc_bind(myc, "sys", "_tables", "type", 1); |
| var s42 := kunion(s43, s44); |
| s43 := nil; |
| s44 := nil; |
| var s45 := mvc_bind(myc, "sys", "_tables", "type", 2); |
| var s41 := kdiff(s42, s45); |
| s42 := nil; |
| var s40 := kunion(s41, s45); |
| s41 := nil; |
| s45 := nil; |
| var s27 := s28.join(s40); |
| s40 := nil; |
| var s15 := append(s27.access(BAT_WRITE),s17); |
| s27 := nil; |
| s17 := nil; |
| var s14 := s15; |
| var s12 := s14; |
| var s47 := bte("2"); |
| var s46 := sht(s47); |
| s47 := nil; |
| var s11 := s12.uselect(sht(nil), s46, FALSE, FALSE); |
| s46 := nil; |
| var s48 := oid("[EMAIL PROTECTED]");
|
| var s10 := mark(s11, s48); |
| s48 := nil; |
| var s9 := s10.reverse(); |
| var s54 := s18.join(s21); |
| s21 := nil; |
| var s56 := s28.join(s31); |
| s31 := nil; |
| var s52 := append(s56.access(BAT_WRITE),s54); |
| s56 := nil; |
| s54 := nil; |
| var s51 := s52; |
| var s49 := s51; |
| var s8 := s9.join(s49); |
| s49 := nil; |
| var s7 := s8; |
| var s57 := oid("[EMAIL PROTECTED]");
|
| var s5 := mark(s7, s57); |
| s57 := nil; |
| var s4 := s5.reverse(); |
| var s67 := mvc_bind(myc, "tmp", "_tables", "name", 0); |
| var s66 := s18.join(s67); |
| s67 := nil; |
| var s73 := mvc_bind(myc, "sys", "_tables", "name", 0); |
| var s74 := mvc_bind(myc, "sys", "_tables", "name", 1); |
| var s72 := kunion(s73, s74); |
| s73 := nil; |
| s74 := nil; |
| var s75 := mvc_bind(myc, "sys", "_tables", "name", 2); |
| var s71 := kdiff(s72, s75); |
| s72 := nil; |
| var s70 := kunion(s71, s75); |
| s71 := nil; |
| s75 := nil; |
| var s69 := s28.join(s70); |
| s70 := nil; |
| var s64 := append(s69.access(BAT_WRITE),s66); |
| s69 := nil; |
| s66 := nil; |
| var s63 := s64; |
| var s61 := s63; |
| var s60 := s9.join(s61); |
| s61 := nil; |
| var s59 := s60; |
| var s3 := s4.join(s59); |
| s59 := nil; |
| var s1 := mvc_result_table(myc, 1, 1, s3); |
| mvc_result_column(myc, "sys.tables", "name", "varchar", 1024, 0, s3); |
| mvc_export_result(myc, Output, s1, ""); |
+-----------------------------------------------------------------------+
105 rows
# 13:09:51 >
# 13:09:51 > Mtimeout -timeout 60 mjclient -h pegasus -p 36830 -d
mTests_src_test_BugTracker -q
# 13:09:51 >
# 13:09:51 >
# 13:09:51 > Done.
# 13:09:51 >
--- NEW FILE: explain.SF-1739353.stable.err ---
stderr of test 'explain.SF-1739353` in directory 'src/test/BugTracker` itself:
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 420 mserver5
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/lib:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/sqllog"
--set
"xquery_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-pegasus.ins.cwi.nl/sql/xquerylog"
--set mapi_open=true --set mapi_port=31876 --set xrpc_port=48015 --set
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include
sql;' ; echo ; echo Over..
# 13:06:43 >
#warning: please don't forget to set your vault key!
#(see /ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf)
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 300 ./explain.SF-1739353.SQL explain.SF-1739353
# 13:06:43 >
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -f
../../../../../../../../../scratch1/fabian/monetdb/current/sql/src/test/BugTracker/Tests/explain.SF-1739353-data.sql
# 13:06:43 >
# 13:06:43 >
# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -q
# 13:06:43 >
Database connect failed: schema authorization error
# 13:06:44 >
# 13:06:44 > Done.
# 13:06:44 >
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
