Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv11652
Modified Files:
Tag: Feb2010
explain_gives_crash.SF-2741829.sql
explain_gives_crash.SF-2741829.stable.out
Log Message:
solve dynamic output
Index: explain_gives_crash.SF-2741829.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -u -d -r1.3 -r1.3.2.1
--- explain_gives_crash.SF-2741829.stable.out 10 Jan 2010 15:33:37 -0000
1.3
+++ explain_gives_crash.SF-2741829.stable.out 26 Jan 2010 20:17:52 -0000
1.3.2.1
@@ -21,106 +21,98 @@
Over..
-# 11:37:27 >
-# 11:37:27 > mclient -lsql -i --host=localhost --port=39621
-# 11:37:27 >
+# 21:13:40 >
+# 21:13:40 > mclient -lsql -i --host=alf --port=39638
+# 21:13:40 >
-% .explain # table_name
-% mal # name
-% clob # type
-% 0 # length
-function user.s0_1{autoCommit=true}():void;
- sql.catalog(28,"sys",3008394056,0);
+#~BeginVariableOutput~#
+function user.s1_1{autoCommit=true}():void;
+" sql.catalog(28\,\"sys\"\,140219811293400\,0);"
barrier _46 := language.dataflow();
- _6:bat[:oid,:int] := sql.bind("sys","blabla","id",0);
+" _6:bat[:oid\,:int] := sql.bind(\"sys\"\,\"blabla\"\,\"id\"\,0);"
_9 := algebra.selectNotNil(_6);
- _6:bat[:oid,:int] := nil:BAT;
- _10:bat[:oid,:oid] := sql.bind_dbat("sys","blabla",1);
+" _6:bat[:oid\,:int] := nil:BAT;"
+" _10:bat[:oid\,:oid] := sql.bind_dbat(\"sys\"\,\"blabla\"\,1);"
_12 := bat.reverse(_10);
- _10:bat[:oid,:oid] := nil:BAT;
- _13 := algebra.kdifference(_9,_12);
+" _10:bat[:oid\,:oid] := nil:BAT;"
+" _13 := algebra.kdifference(_9\,_12);"
_9 := nil:BAT;
_12 := nil:BAT;
- (ext20,grp18) := group.new(_13);
+" (ext20\,grp18) := group.new(_13);"
_13 := nil:BAT;
_16 := bat.mirror(ext20);
ext20 := nil:BAT;
- _17:bat[:oid,:wrd] := aggr.count(grp18,grp18,_16);
+" _17:bat[:oid\,:wrd] := aggr.count(grp18\,grp18\,_16);"
grp18 := nil:BAT;
_16 := nil:BAT;
_18 := aggr.count(_17);
_19:wrd := aggr.sum(_17);
- _17:bat[:oid,:wrd] := nil:BAT;
+" _17:bat[:oid\,:wrd] := nil:BAT;"
_20 := calc.isnil(_19);
- _22 := calc.ifthenelse(_20,0:wrd,_19);
- _23 := calc.!=(_18,_22);
+" _22 := calc.ifthenelse(_20\,0:wrd\,_19);"
+" _23 := calc.!=(_18\,_22);"
exit _46;
- sql.assert(_23,"UPDATE: UNIQUE constraint 'blabla.dada' violated");
-end s0_1;
-% .explain # table_name
-% mal # name
-% clob # type
-% 0 # length
-function user.s1_1{autoCommit=true}():void;
- sql.catalog(28,"sys",3009062784,0);
+" sql.assert(_23\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s1_1;
+function user.s2_1{autoCommit=true}():void;
+" sql.catalog(28\,\"sys\"\,140219811563080\,0);"
barrier _46 := language.dataflow();
- _6:bat[:oid,:int] := sql.bind("sys","blabla","id",0);
+" _6:bat[:oid\,:int] := sql.bind(\"sys\"\,\"blabla\"\,\"id\"\,0);"
_9 := algebra.selectNotNil(_6);
- _6:bat[:oid,:int] := nil:BAT;
- _10:bat[:oid,:oid] := sql.bind_dbat("sys","blabla",1);
+" _6:bat[:oid\,:int] := nil:BAT;"
+" _10:bat[:oid\,:oid] := sql.bind_dbat(\"sys\"\,\"blabla\"\,1);"
_12 := bat.reverse(_10);
- _10:bat[:oid,:oid] := nil:BAT;
- _13 := algebra.kdifference(_9,_12);
+" _10:bat[:oid\,:oid] := nil:BAT;"
+" _13 := algebra.kdifference(_9\,_12);"
_9 := nil:BAT;
_12 := nil:BAT;
- (ext20,grp18) := group.new(_13);
+" (ext20\,grp18) := group.new(_13);"
_13 := nil:BAT;
_16 := bat.mirror(ext20);
ext20 := nil:BAT;
- _17:bat[:oid,:wrd] := aggr.count(grp18,grp18,_16);
+" _17:bat[:oid\,:wrd] := aggr.count(grp18\,grp18\,_16);"
grp18 := nil:BAT;
_16 := nil:BAT;
_18 := aggr.count(_17);
_19:wrd := aggr.sum(_17);
- _17:bat[:oid,:wrd] := nil:BAT;
+" _17:bat[:oid\,:wrd] := nil:BAT;"
_20 := calc.isnil(_19);
- _22 := calc.ifthenelse(_20,0:wrd,_19);
- _23 := calc.!=(_18,_22);
+" _22 := calc.ifthenelse(_20\,0:wrd\,_19);"
+" _23 := calc.!=(_18\,_22);"
exit _46;
- sql.assert(_23,"UPDATE: UNIQUE constraint 'blabla.dada' violated");
-end s1_1;
-% .explain # table_name
-% mal # name
-% clob # type
-% 0 # length
-function user.s0_1{autoCommit=true}():void;
- sql.catalog(28,"sys",3006267824,0);
+" sql.assert(_23\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s2_1;
+#~EndVariableOutput~#
+#~BeginVariableOutput~#
+function user.s1_1{autoCommit=true}():void;
+" sql.catalog(28\,\"sys\"\,140219810609496\,0);"
barrier _46 := language.dataflow();
- _6:bat[:oid,:int] := sql.bind("sys","blabla","id",0);
+" _6:bat[:oid\,:int] := sql.bind(\"sys\"\,\"blabla\"\,\"id\"\,0);"
_9 := algebra.selectNotNil(_6);
- _6:bat[:oid,:int] := nil:BAT;
- _10:bat[:oid,:oid] := sql.bind_dbat("sys","blabla",1);
+" _6:bat[:oid\,:int] := nil:BAT;"
+" _10:bat[:oid\,:oid] := sql.bind_dbat(\"sys\"\,\"blabla\"\,1);"
_12 := bat.reverse(_10);
- _10:bat[:oid,:oid] := nil:BAT;
- _13 := algebra.kdifference(_9,_12);
+" _10:bat[:oid\,:oid] := nil:BAT;"
+" _13 := algebra.kdifference(_9\,_12);"
_9 := nil:BAT;
_12 := nil:BAT;
- (ext20,grp18) := group.new(_13);
+" (ext20\,grp18) := group.new(_13);"
_13 := nil:BAT;
_16 := bat.mirror(ext20);
ext20 := nil:BAT;
- _17:bat[:oid,:wrd] := aggr.count(grp18,grp18,_16);
+" _17:bat[:oid\,:wrd] := aggr.count(grp18\,grp18\,_16);"
grp18 := nil:BAT;
_16 := nil:BAT;
_18 := aggr.count(_17);
_19:wrd := aggr.sum(_17);
- _17:bat[:oid,:wrd] := nil:BAT;
+" _17:bat[:oid\,:wrd] := nil:BAT;"
_20 := calc.isnil(_19);
- _22 := calc.ifthenelse(_20,0:wrd,_19);
- _23 := calc.!=(_18,_22);
+" _22 := calc.ifthenelse(_20\,0:wrd\,_19);"
+" _23 := calc.!=(_18\,_22);"
exit _46;
- sql.assert(_23,"UPDATE: UNIQUE constraint 'blabla.dada' violated");
-end s0_1;
+" sql.assert(_23\,\"UPDATE: UNIQUE constraint 'blabla.dada' violated\");"
+end s1_1;
+#~EndVariableOutput~#
# 11:37:28 >
# 11:37:28 > Done.
Index: explain_gives_crash.SF-2741829.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.sql,v
retrieving revision 1.3
retrieving revision 1.3.4.1
diff -u -d -r1.3 -r1.3.4.1
--- explain_gives_crash.SF-2741829.sql 14 Aug 2009 12:51:03 -0000 1.3
+++ explain_gives_crash.SF-2741829.sql 26 Jan 2010 20:17:50 -0000 1.3.4.1
@@ -1,5 +1,10 @@
+\f csv
create table blabla(id integer);
+select '#~BeginVariableOutput~#';
explain alter table blabla add constraint dada unique (id);
explain alter table blabla add constraint dada unique (id);
+select '#~EndVariableOutput~#';
alter table blabla drop constraint dada;
+select '#~BeginVariableOutput~#';
explain alter table blabla add constraint dada unique (id);
+select '#~EndVariableOutput~#';
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
