Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12834/src/test/BugTracker/Tests
Modified Files:
Tag: GDK-2
cardinality_violation.SF-1240701.stable.err.Five
connect_crash.SF-1436626.py explain.SF-1739353.stable.out.Five
subquery_orderby.SF-1688915.stable.out
subquery_orderby.SF-1688915.stable.out.Five
Log Message:
propagated changes of Monday Sep 03 2007 - Thursday Sep 06 2007
from the development trunk to the GDK-2 branch
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.2.2.1
retrieving revision 1.2.2.2
diff -u -d -r1.2.2.1 -r1.2.2.2
--- explain.SF-1739353.stable.out.Five 24 Aug 2007 09:40:28 -0000 1.2.2.1
+++ explain.SF-1739353.stable.out.Five 6 Sep 2007 13:52:10 -0000 1.2.2.2
@@ -37,76 +37,76 @@
| mal
|
+==============================================================================+
| function user.s1_1():void;
|
-| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12861} :=
sql.bind("tmp","_tables","id",0); |
+| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=15399} :=
sql.bind("tmp","_tables","id",0); |
| constraints.emptySet(_1);
|
-| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=12865} :=
sql.bind("tmp","_tables","type",0); |
-| _13:bat[:oid,:int]{notnil=true,rows=127:lng,bid=848} :=
sql.bind("sys","_tables","id",0); |
-| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12711} :=
sql.bind("sys","_tables","id",1); |
+| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=15403} :=
sql.bind("tmp","_tables","type",0); |
+| _13:bat[:oid,:int]{notnil=true,rows=136:lng,bid=758} :=
sql.bind("sys","_tables","id",0); |
+| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=15277} :=
sql.bind("sys","_tables","id",1); |
| constraints.emptySet(_15);
|
-| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12711} := nil;
|
-| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12712} :=
sql.bind("sys","_tables","id",2); |
+| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=15277} := nil;
|
+| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=15278} :=
sql.bind("sys","_tables","id",2); |
| constraints.emptySet(_16);
|
-| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12712} := nil;
|
-| _18:bat[:oid,:oid]{rows=94:lng,bid=12710} :=
sql.bind_dbat("sys","_tables",1); |
-| _23:bat[:oid,:sht]{notnil=true,rows=127:lng,bid=854} :=
sql.bind("sys","_tables","type",0); |
-| _41:bat[:oid,:str]{notnil=true,rows=0:lng,bid=12862} :=
sql.bind("tmp","_tables","name",0); |
-| _44:bat[:oid,:str]{notnil=true,rows=127:lng,bid=850} :=
sql.bind("sys","_tables","name",0); |
+| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=15278} := nil;
|
+| _18:bat[:oid,:oid]{rows=104:lng,bid=15276} :=
sql.bind_dbat("sys","_tables",1); |
+| _23:bat[:oid,:sht]{notnil=true,rows=136:lng,bid=764} :=
sql.bind("sys","_tables","type",0); |
+| _41:bat[:oid,:str]{notnil=true,rows=0:lng,bid=15400} :=
sql.bind("tmp","_tables","name",0); |
+| _44:bat[:oid,:str]{notnil=true,rows=136:lng,bid=760} :=
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=12865} := nil;
|
-| _19{rows=94:lng} := bat.reverse(_18);
|
-| _18:bat[:oid,:oid]{rows=94:lng,bid=12710} := nil;
|
-| _20{rows=34:lng} := algebra.kdifference(_13,_19);
|
-| _19{rows=94:lng} := nil;
|
-| _21{rows=34:lng} := algebra.markT(_20,[EMAIL PROTECTED]);
|
-| _20{rows=34:lng} := nil;
|
-| _22{rows=34:lng} := bat.reverse(_21);
|
-| _21{rows=34:lng} := nil;
|
-| _24{rows=34:lng} := algebra.join(_22,_23);
|
-| _23:bat[:oid,:sht]{notnil=true,rows=127:lng,bid=854} := nil;
|
-| _25{rows=35:lng} := bat.setWriteMode(_24);
|
-| _24{rows=34:lng} := nil;
|
+| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=15403} := nil;
|
+| _19{rows=104:lng} := bat.reverse(_18);
|
+| _18:bat[:oid,:oid]{rows=104:lng,bid=15276} := nil;
|
+| _20{rows=33:lng} := algebra.kdifference(_13,_19);
|
+| _19{rows=104:lng} := nil;
|
+| _21{rows=33:lng} := algebra.markT(_20,[EMAIL PROTECTED]);
|
+| _20{rows=33:lng} := nil;
|
+| _22{rows=33:lng} := bat.reverse(_21);
|
+| _21{rows=33:lng} := nil;
|
+| _24{rows=33:lng} := algebra.join(_22,_23);
|
+| _23:bat[:oid,:sht]{notnil=true,rows=136:lng,bid=764} := nil;
|
+| _25{rows=34:lng} := bat.setWriteMode(_24);
|
+| _24{rows=33:lng} := nil;
|
| bat.append(_25,_12,true);
|
| _12{rows=0:lng} := nil;
|
-| _29{rows=35:lng} := algebra.uselect(_25,nil:sht,2,false,false);
|
-| _25{rows=35:lng} := nil;
|
-| _32{rows=35:lng} := algebra.markT(_29,[EMAIL PROTECTED]);
|
-| _29{rows=35:lng} := nil;
|
-| _33{rows=35:lng} := bat.reverse(_32);
|
-| _32{rows=35:lng} := nil;
|
+| _29{rows=34:lng} := algebra.uselect(_25,nil:sht,2,false,false);
|
+| _25{rows=34:lng} := nil;
|
+| _32{rows=34:lng} := algebra.markT(_29,[EMAIL PROTECTED]);
|
+| _29{rows=34:lng} := nil;
|
+| _33{rows=34:lng} := bat.reverse(_32);
|
+| _32{rows=34:lng} := nil;
|
| _34{rows=0:lng} := algebra.join(_9,_1);
|
-| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12861} := nil;
|
-| _35{rows=34:lng} := algebra.join(_22,_13);
|
-| _13:bat[:oid,:int]{notnil=true,rows=127:lng,bid=848} := nil;
|
-| _36{rows=35:lng} := bat.setWriteMode(_35);
|
-| _35{rows=34:lng} := nil;
|
+| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=15399} := nil;
|
+| _35{rows=33:lng} := algebra.join(_22,_13);
|
+| _13:bat[:oid,:int]{notnil=true,rows=136:lng,bid=758} := nil;
|
+| _36{rows=34:lng} := bat.setWriteMode(_35);
|
+| _35{rows=33:lng} := nil;
|
| bat.append(_36,_34,true);
|
| _34{rows=0:lng} := nil;
|
-| _38{rows=35:lng} := algebra.join(_33,_36);
|
-| _36{rows=35:lng} := nil;
|
-| _39{rows=35:lng} := algebra.markT(_38,[EMAIL PROTECTED]);
|
-| _38{rows=35:lng} := nil;
|
-| _40{rows=35:lng} := bat.reverse(_39);
|
-| _39{rows=35:lng} := nil;
|
+| _38{rows=34:lng} := algebra.join(_33,_36);
|
+| _36{rows=34:lng} := nil;
|
+| _39{rows=34:lng} := algebra.markT(_38,[EMAIL PROTECTED]);
|
+| _38{rows=34:lng} := nil;
|
+| _40{rows=34:lng} := bat.reverse(_39);
|
+| _39{rows=34:lng} := nil;
|
| _43{rows=0:lng} := algebra.join(_9,_41);
|
| _9{rows=0:lng} := nil;
|
-| _41:bat[:oid,:str]{notnil=true,rows=0:lng,bid=12862} := nil;
|
-| _45{rows=34:lng} := algebra.join(_22,_44);
|
-| _22{rows=34:lng} := nil;
|
-| _44:bat[:oid,:str]{notnil=true,rows=127:lng,bid=850} := nil;
|
-| _46{rows=35:lng} := bat.setWriteMode(_45);
|
-| _45{rows=34:lng} := nil;
|
+| _41:bat[:oid,:str]{notnil=true,rows=0:lng,bid=15400} := nil;
|
+| _45{rows=33:lng} := algebra.join(_22,_44);
|
+| _22{rows=33:lng} := nil;
|
+| _44:bat[:oid,:str]{notnil=true,rows=136:lng,bid=760} := nil;
|
+| _46{rows=34:lng} := bat.setWriteMode(_45);
|
+| _45{rows=33:lng} := nil;
|
| bat.append(_46,_43,true);
|
| _43{rows=0:lng} := nil;
|
-| _48{rows=35:lng} := algebra.joinPath(_40,_33,_46);
|
-| _40{rows=35:lng} := nil;
|
-| _33{rows=35:lng} := nil;
|
-| _46{rows=35:lng} := nil;
|
+| _48{rows=34:lng} := algebra.joinPath(_40,_33,_46);
|
+| _40{rows=34:lng} := nil;
|
+| _33{rows=34:lng} := nil;
|
+| _46{rows=34:lng} := nil;
|
| _49 := sql.resultSet(1,1,_48);
|
| sql.rsColumn(_49,"sys.tables","name","varchar",1024,0,_48);
|
-| _48{rows=35:lng} := nil;
|
+| _48{rows=34:lng} := nil;
|
| sql.exportResult(_49,"");
|
| end s1_1;
|
+------------------------------------------------------------------------------+
Index: connect_crash.SF-1436626.py
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/connect_crash.SF-1436626.py,v
retrieving revision 1.3
retrieving revision 1.3.6.1
diff -u -d -r1.3 -r1.3.6.1
--- connect_crash.SF-1436626.py 9 Nov 2006 22:41:17 -0000 1.3
+++ connect_crash.SF-1436626.py 6 Sep 2007 13:52:10 -0000 1.3.6.1
@@ -1,7 +1,7 @@
import os, time
def main():
- srvcmd = '%s --dbname "%s" --dbinit "module(sql_server);
mapi_register(sql_frontend()); mil_start();"' %
(os.getenv('MSERVER'),os.getenv('TSTDB'))
+ srvcmd = '%s --dbname "%s" --dbinit "module(sql_server); mil_start();"' %
(os.getenv('MSERVER'),os.getenv('TSTDB'))
srv = os.popen(srvcmd, 'w')
time.sleep(10) # give server time to start
cltcmd = os.getenv('SQL_CLIENT')
Index: subquery_orderby.SF-1688915.stable.out.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/subquery_orderby.SF-1688915.stable.out.Five,v
retrieving revision 1.3
retrieving revision 1.3.4.1
diff -u -d -r1.3 -r1.3.4.1
--- subquery_orderby.SF-1688915.stable.out.Five 10 May 2007 10:53:00 -0000
1.3
+++ subquery_orderby.SF-1688915.stable.out.Five 6 Sep 2007 13:52:10 -0000
1.3.4.1
@@ -28,14 +28,14 @@
[ "functions" ]
[ "args" ]
[ "sequences" ]
+[ "dependencies" ]
+[ "connections" ]
[ "_tables" ]
[ "_columns" ]
[ "keys" ]
[ "idxs" ]
[ "triggers" ]
[ "keycolumns" ]
-[ "dependencies" ]
-[ "connections" ]
[ "_tables" ]
[ "_columns" ]
[ "keys" ]
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.3
retrieving revision 1.3.4.1
diff -u -d -r1.3 -r1.3.4.1
--- subquery_orderby.SF-1688915.stable.out 10 May 2007 12:20:59 -0000
1.3
+++ subquery_orderby.SF-1688915.stable.out 6 Sep 2007 13:52:10 -0000
1.3.4.1
@@ -30,14 +30,14 @@
[ "functions" ]
[ "args" ]
[ "sequences" ]
+[ "dependencies" ]
+[ "connections" ]
[ "_tables" ]
[ "_columns" ]
[ "keys" ]
[ "idxs" ]
[ "triggers" ]
[ "keycolumns" ]
-[ "dependencies" ]
-[ "connections" ]
[ "_tables" ]
[ "_columns" ]
[ "keys" ]
Index: cardinality_violation.SF-1240701.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err.Five,v
retrieving revision 1.13
retrieving revision 1.13.2.1
diff -u -d -r1.13 -r1.13.2.1
--- cardinality_violation.SF-1240701.stable.err.Five 11 Aug 2007 07:58:11
-0000 1.13
+++ cardinality_violation.SF-1240701.stable.err.Five 6 Sep 2007 13:52:10
-0000 1.13.2.1
@@ -14,7 +14,7 @@
MAPI = [EMAIL PROTECTED]:36535
QUERY = select * from env() as env where name = ( select 'prefix' from env()
as env );
-ERROR = !SQLException:zero_or_one:cardinality violation (45>1)
+ERROR = !SQLException:zero_or_one:cardinality violation (46>1)
MAPI = [EMAIL PROTECTED]:36535
QUERY = select * from columns where name = (select columns.name from _tables,
columns where _tables.id = columns.table_id);
ERROR = !SQLException:zero_or_one:cardinality violation (171>1)
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
