Changeset: 7899f7abf279 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7899f7abf279
Modified Files:
sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql
sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
Branch: Jun2010
Log Message:
disable parallelism (mitosis & dataflow) to avoid ambiguous explain output
diffs (169 lines):
diff -r f6757ebce84e -r 7899f7abf279
sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql
--- a/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql Sat Jul
17 21:15:56 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql Sun Jul
18 11:02:44 2010 +0200
@@ -1,3 +1,5 @@
debug select count(*) from tables;
plan select count(*) from tables;
+-- disable parallelism (mitosis & dataflow) to avoid ambiguous results
+set
optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,history,multiplex,garbageCollector';
explain select count(*) from tables;
diff -r f6757ebce84e -r 7899f7abf279
sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
--- a/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out Sat Jul
17 21:15:56 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out Sun Jul
18 11:02:44 2010 +0200
@@ -30,100 +30,56 @@
# 13:30:19 > Mtimeout -timeout 60 java nl.cwi.monetdb.client.JdbcClient -h
rig -p 39462 -d mTests_src_test_BugTracker -f
"../../../../../source/sql/src/test/BugTracker/Tests/jdbc_no_debug.SF-1739356-data.sql"
# 13:30:19 >
-+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++-----------------------------------------------------------------------------------------------------------------+
| rel
|
-+===========================================================================================================================================================================================================================================================================================================+
++=================================================================================================================+
| project (
|
| | group by (
|
| | | project (
|
| | | | union (
|
| | | | | project (
|
| | | | | | select (
|
-| | | | | | | table(sys._tables) [ _tables.id as p.id, _tables.name as p.name,
_tables.schema_id as p.schema_id, _tables.query as p.query, _tables.type as
p.type, _tables.system as p.system, _tables.commit_action as p.commit_action,
_tables.readonly as p.readonly, _tables.%TID% NOT NULL as p.%TID% ] |
+| | | | | | | table(sys._tables) [ _tables.id as p.id, _tables.type as p.type,
_tables.%TID% NOT NULL as p.%TID% ] |
| | | | | | ) [ p.type < convert(2) ]
|
-| | | | | ) [ p.id, p.name, p.schema_id, p.query, p.type, p.system,
p.commit_action, p.readonly, 0 as temporary ],
|
+| | | | | ) [ p.id, p.type ],
|
| | | | | project (
|
| | | | | | select (
|
-| | | | | | | table(tmp._tables) [ _tables.id as t.id, _tables.name as t.name,
_tables.schema_id as t.schema_id, _tables.query as t.query, _tables.type as
t.type, _tables.system as t.system, _tables.commit_action as t.commit_action,
_tables.readonly as t.readonly, _tables.%TID% NOT NULL as t.%TID% ] |
+| | | | | | | table(tmp._tables) [ _tables.id as t.id, _tables.type as t.type,
_tables.%TID% NOT NULL as t.%TID% ] |
| | | | | | ) [ t.type < convert(2) ]
|
-| | | | | ) [ t.id, t.name, t.schema_id, t.query, t.type, t.system,
t.commit_action, t.readonly, 1 as temporary ]
|
-| | | | ) [ id as tables.id, name as tables.name, schema_id as
tables.schema_id, query as tables.query, type as tables.type, system as
tables.system, commit_action as tables.commit_action, readonly as
tables.readonly, temporary as tables.temporary ]
|
+| | | | | ) [ t.id, t.type ]
|
+| | | | ) [ id as tables.id, type as tables.type ]
|
| | | ) [ tables.id ]
|
| | ) [ ] [ count NOT NULL as L1 ]
|
| ) [ L1 NOT NULL ]
|
-+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++-----------------------------------------------------------------------------------------------------------------+
18 rows
+--------+
| mal |
+========+
-| function user.s2_1{autoCommit=true}():void; |
+| function user.s3_1{autoCommit=true}():void; |
| _2 := sql.mvc(); |
-| barrier _143 := language.dataflow(); |
-| _23:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",1); |
-| _24 := algebra.thetauselect(_23,2:sht,"<"); |
-| _25:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","_tables",1); |
-| _27 := bat.reverse(_25); |
-| _97 := algebra.kdifference(_24,_27); |
-| _110 := algebra.markT(_97,5,4); |
-| _117 := bat.reverse(_110); |
-| _30:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",1); |
-| _142 := algebra.leftjoin(_117,_30); |
-| _64:bat[:oid,:sht] :=
sql.bind(_2,"sys","_tables","type",0,8...@0,nil:oid); |
-| _72 := algebra.thetauselect(_64,2:sht,"<"); |
-| _20:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",2); |
-| _76 := algebra.kdifference(_72,_20); |
-| _22 := algebra.thetauselect(_20,2:sht,"<"); |
-| _80 := algebra.semijoin(_22,_64); |
-| _85 := algebra.kunion(_76,_80); |
-| _96 := algebra.kdifference(_85,_27); |
-| _107 := algebra.markT(_96,5,3); |
-| _116 := bat.reverse(_107); |
-| _68:bat[:oid,:int] :=
sql.bind(_2,"sys","_tables","id",0,8...@0,nil:oid); |
-| _29:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",2); |
-| _122 := algebra.kdifference(_68,_29); |
-| _129 := algebra.semijoin(_29,_68); |
-| _133 := algebra.kunion(_122,_129); |
-| _140 := algebra.leftjoin(_116,_133); |
-| _62:bat[:oid,:sht] :=
sql.bind(_2,"sys","_tables","type",0,5...@0,8...@0); |
-| _71 := algebra.thetauselect(_62,2:sht,"<"); |
-| _75 := algebra.kdifference(_71,_20); |
-| _79 := algebra.semijoin(_22,_62); |
-| _84 := algebra.kunion(_75,_79); |
-| _94 := algebra.kdifference(_84,_27); |
-| _104 := algebra.markT(_94,5,2); |
-| _115 := bat.reverse(_104); |
-| _67:bat[:oid,:int] :=
sql.bind(_2,"sys","_tables","id",0,5...@0,8...@0); |
-| _121 := algebra.kdifference(_67,_29); |
-| _127 := algebra.semijoin(_29,_67); |
-| _132 := algebra.kunion(_121,_127); |
-| _138 := algebra.leftjoin(_115,_132); |
-| _60:bat[:oid,:sht] :=
sql.bind(_2,"sys","_tables","type",0,2...@0,5...@0); |
-| _70 := algebra.thetauselect(_60,2:sht,"<"); |
-| _74 := algebra.kdifference(_70,_20); |
-| _78 := algebra.semijoin(_22,_60); |
-| _83 := algebra.kunion(_74,_78); |
-| _92 := algebra.kdifference(_83,_27); |
-| _101 := algebra.markT(_92,5,1); |
-| _114 := bat.reverse(_101); |
-| _66:bat[:oid,:int] :=
sql.bind(_2,"sys","_tables","id",0,2...@0,5...@0); |
-| _120 := algebra.kdifference(_66,_29); |
-| _125 := algebra.semijoin(_29,_66); |
-| _131 := algebra.kunion(_120,_125); |
-| _136 := algebra.leftjoin(_114,_131); |
-| _58:bat[:oid,:sht] :=
sql.bind(_2,"sys","_tables","type",0,0...@0,2...@0); |
-| _69 := algebra.thetauselect(_58,2:sht,"<"); |
-| _73 := algebra.kdifference(_69,_20); |
-| _77 := algebra.semijoin(_22,_58); |
-| _81 := algebra.kunion(_73,_77); |
-| _90 := algebra.kdifference(_81,_27); |
-| _98 := algebra.markT(_90,5,0); |
-| _113 := bat.reverse(_98); |
-| _65:bat[:oid,:int] :=
sql.bind(_2,"sys","_tables","id",0,0...@0,2...@0); |
-| _118 := algebra.kdifference(_65,_29); |
-| _123 := algebra.semijoin(_29,_65); |
-| _130 := algebra.kunion(_118,_123); |
-| _134 := algebra.leftjoin(_113,_130); |
+| _19:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",0); |
+| _21 := algebra.thetauselect(_19,2:sht,"<"); |
+| _22:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",2); |
+| _24 := algebra.kdifference(_21,_22); |
+| _25 := algebra.thetauselect(_22,2:sht,"<"); |
+| _26 := algebra.kunion(_24,_25); |
+| _27:bat[:oid,:sht] := sql.bind(_2,"sys","_tables","type",1); |
+| _28 := algebra.thetauselect(_27,2:sht,"<"); |
+| _29 := algebra.kunion(_26,_28); |
+| _30:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","_tables",1); |
+| _32 := bat.reverse(_30); |
+| _33 := algebra.kdifference(_29,_32); |
+| _34 := algebra.markT(_33,0...@0); |
+| _35 := bat.reverse(_34); |
+| _36:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",0); |
+| _38:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",2); |
+| _39 := algebra.kdifference(_36,_38); |
+| _40 := algebra.kunion(_39,_38); |
+| _41:bat[:oid,:int] := sql.bind(_2,"sys","_tables","id",1); |
+| _43 := algebra.kunion(_40,_41); |
+| _44 := algebra.leftjoin(_35,_43); |
| _3:bat[:oid,:sht] := sql.bind(_2,"tmp","_tables","type",0); |
| _8 := algebra.thetauselect(_3,2:sht,"<"); |
| _10:bat[:oid,:oid] := sql.bind_dbat(_2,"tmp","_tables",1); |
@@ -133,18 +89,14 @@
| _15 := bat.reverse(_14); |
| _16:bat[:oid,:int] := sql.bind(_2,"tmp","_tables","id",0); |
| _18 := algebra.leftjoin(_15,_16); |
-| exit _143; |
-| _33:bat[:oid,:int] := bat.new(nil:oid,nil:int); |
-| barrier _146 := language.dataflow(); |
-| _32 := mat.pack(_134,_136,_138,_140,_142); |
-| _36 := bat.append(_33,_32,true); |
-| _38 := bat.append(_36,_18,true); |
-| _39 := aggr.count(_38); |
-| exit _146; |
-| sql.exportValue(1,".tables","L2","wrd",64,0,6,_39,""); |
-| end s2_1; |
+| _45:bat[:oid,:int] := bat.new(nil:oid,nil:int); |
+| _48 := bat.append(_45,_44,true); |
+| _50 := bat.append(_48,_18,true); |
+| _51 := aggr.count(_50); |
+| sql.exportValue(1,".tables","L2","wrd",64,0,6,_51,""); |
+| end s3_1; |
+--------+
-86 rows
+38 rows
# 13:30:20 >
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
