Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv8306/src/test/BugTracker/Tests
Modified Files:
explain.SF-1739353.stable.out
Log Message:
propagated changes of Wednesday Feb 03 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/02/03 - stmane:
src/test/BugTracker/Tests/explain.SF-1739353.stable.out,1.5.2.1
approved new MAL plan as revealed by `EXPLAIN ...`
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: explain.SF-1739353.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/explain.SF-1739353.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- explain.SF-1739353.stable.out 11 Nov 2009 09:32:05 -0000 1.5
+++ explain.SF-1739353.stable.out 3 Feb 2010 10:37:42 -0000 1.6
@@ -35,81 +35,169 @@
| mal |
+========+
| function user.s1_1{autoCommit=true}():void; |
-| barrier _101 := language.dataflow(); |
+| barrier _222 := language.dataflow(); |
+| _22:bat[:oid,:sht] := sql.bind("sys","_tables","type",1); |
+| _23 := algebra.thetauselect(_22,2:sht,"<"); |
+| _22:bat[:oid,:sht] := nil:BAT; |
+| _24:bat[:oid,:oid] := sql.bind_dbat("sys","_tables",1); |
+| _26 := bat.reverse(_24); |
+| _24:bat[:oid,:oid] := nil:BAT; |
+| _96 := algebra.kdifference(_23,_26); |
+| _23 := nil:BAT; |
+| _109 := algebra.markT(_96,5,4); |
+| _96 := nil:BAT; |
+| _116 := bat.reverse(_109); |
+| _109 := nil:BAT; |
+| _29:bat[:oid,:str] := sql.bind("sys","_tables","name",1); |
+| _141 := algebra.leftjoin(_116,_29); |
+| _116 := nil:BAT; |
+| _29:bat[:oid,:str] := nil:BAT; |
+| _63:bat[:oid,:sht] :=
sql.bind("sys","_tables","type",0,7...@0,nil:oid); |
+| _71 := algebra.thetauselect(_63,2:sht,"<"); |
+| _19:bat[:oid,:sht] := sql.bind("sys","_tables","type",2); |
+| _75 := algebra.kdifference(_71,_19); |
+| _71 := nil:BAT; |
+| _21 := algebra.thetauselect(_19,2:sht,"<"); |
+| _79 := algebra.semijoin(_21,_63); |
+| _63:bat[:oid,:sht] := nil:BAT; |
+| _84 := algebra.kunion(_75,_79); |
+| _75 := nil:BAT; |
+| _79 := nil:BAT; |
+| _95 := algebra.kdifference(_84,_26); |
+| _84 := nil:BAT; |
+| _106 := algebra.markT(_95,5,3); |
+| _95 := nil:BAT; |
+| _115 := bat.reverse(_106); |
+| _106 := nil:BAT; |
+| _67:bat[:oid,:str] :=
sql.bind("sys","_tables","name",0,7...@0,nil:oid); |
+| _28:bat[:oid,:str] := sql.bind("sys","_tables","name",2); |
+| _121 := algebra.kdifference(_67,_28); |
+| _128 := algebra.semijoin(_28,_67); |
+| _67:bat[:oid,:str] := nil:BAT; |
+| _132 := algebra.kunion(_121,_128); |
+| _121 := nil:BAT; |
+| _128 := nil:BAT; |
+| _139 := algebra.leftjoin(_115,_132); |
+| _115 := nil:BAT; |
+| _132 := nil:BAT; |
+| _61:bat[:oid,:sht] := sql.bind("sys","_tables","type",0,5...@0,7...@0);
|
+| _70 := algebra.thetauselect(_61,2:sht,"<"); |
+| _74 := algebra.kdifference(_70,_19); |
+| _70 := nil:BAT; |
+| _78 := algebra.semijoin(_21,_61); |
+| _61:bat[:oid,:sht] := nil:BAT; |
+| _83 := algebra.kunion(_74,_78); |
+| _74 := nil:BAT; |
+| _78 := nil:BAT; |
+| _93 := algebra.kdifference(_83,_26); |
+| _83 := nil:BAT; |
+| _103 := algebra.markT(_93,5,2); |
+| _93 := nil:BAT; |
+| _114 := bat.reverse(_103); |
+| _103 := nil:BAT; |
+| _66:bat[:oid,:str] := sql.bind("sys","_tables","name",0,5...@0,7...@0);
|
+| _120 := algebra.kdifference(_66,_28); |
+| _126 := algebra.semijoin(_28,_66); |
+| _66:bat[:oid,:str] := nil:BAT; |
+| _131 := algebra.kunion(_120,_126); |
+| _120 := nil:BAT; |
+| _126 := nil:BAT; |
+| _137 := algebra.leftjoin(_114,_131); |
+| _114 := nil:BAT; |
+| _131 := nil:BAT; |
+| _59:bat[:oid,:sht] := sql.bind("sys","_tables","type",0,2...@0,5...@0);
|
+| _69 := algebra.thetauselect(_59,2:sht,"<"); |
+| _73 := algebra.kdifference(_69,_19); |
+| _69 := nil:BAT; |
+| _77 := algebra.semijoin(_21,_59); |
+| _59:bat[:oid,:sht] := nil:BAT; |
+| _82 := algebra.kunion(_73,_77); |
+| _73 := nil:BAT; |
+| _77 := nil:BAT; |
+| _91 := algebra.kdifference(_82,_26); |
+| _82 := nil:BAT; |
+| _100 := algebra.markT(_91,5,1); |
+| _91 := nil:BAT; |
+| _113 := bat.reverse(_100); |
+| _100 := nil:BAT; |
+| _65:bat[:oid,:str] := sql.bind("sys","_tables","name",0,2...@0,5...@0);
|
+| _119 := algebra.kdifference(_65,_28); |
+| _124 := algebra.semijoin(_28,_65); |
+| _65:bat[:oid,:str] := nil:BAT; |
+| _130 := algebra.kunion(_119,_124); |
+| _119 := nil:BAT; |
+| _124 := nil:BAT; |
+| _135 := algebra.leftjoin(_113,_130); |
+| _113 := nil:BAT; |
+| _130 := nil:BAT; |
+| _57:bat[:oid,:sht] := sql.bind("sys","_tables","type",0,0...@0,2...@0);
|
+| _68 := algebra.thetauselect(_57,2:sht,"<"); |
+| _72 := algebra.kdifference(_68,_19); |
+| _68 := nil:BAT; |
+| _19:bat[:oid,:sht] := nil:BAT; |
+| _76 := algebra.semijoin(_21,_57); |
+| _21 := nil:BAT; |
+| _57:bat[:oid,:sht] := nil:BAT; |
+| _80 := algebra.kunion(_72,_76); |
+| _72 := nil:BAT; |
+| _76 := nil:BAT; |
+| _89 := algebra.kdifference(_80,_26); |
+| _80 := nil:BAT; |
+| _26 := nil:BAT; |
+| _97 := algebra.markT(_89,5,0); |
+| _89 := nil:BAT; |
+| _112 := bat.reverse(_97); |
+| _97 := nil:BAT; |
+| _64:bat[:oid,:str] := sql.bind("sys","_tables","name",0,0...@0,2...@0);
|
+| _117 := algebra.kdifference(_64,_28); |
+| _122 := algebra.semijoin(_28,_64); |
+| _28:bat[:oid,:str] := nil:BAT; |
+| _64:bat[:oid,:str] := nil:BAT; |
+| _129 := algebra.kunion(_117,_122); |
+| _117 := nil:BAT; |
+| _122 := nil:BAT; |
+| _133 := algebra.leftjoin(_112,_129); |
+| _112 := nil:BAT; |
+| _129 := nil:BAT; |
| _2:bat[:oid,:sht] := sql.bind("tmp","_tables","type",0); |
-| _7:bat[:oid,:oid] := sql.bind_dbat("tmp","_tables",1); |
-| _9 := bat.reverse(_7); |
-| _7:bat[:oid,:oid] := nil:BAT; |
-| _10 := algebra.kdifference(_2,_9); |
+| _7 := algebra.thetauselect(_2,2:sht,"<"); |
| _2:bat[:oid,:sht] := nil:BAT; |
-| _11 := algebra.thetauselect(_10,2:sht,"<"); |
-| _10 := nil:BAT; |
-| _14 := algebra.markT(_11,0...@0); |
+| _9:bat[:oid,:oid] := sql.bind_dbat("tmp","_tables",1); |
+| _11 := bat.reverse(_9); |
+| _9:bat[:oid,:oid] := nil:BAT; |
+| _12 := algebra.kdifference(_7,_11); |
+| _7 := nil:BAT; |
| _11 := nil:BAT; |
-| _15 := bat.reverse(_14); |
+| _13 := algebra.markT(_12,0...@0); |
+| _12 := nil:BAT; |
+| _14 := bat.reverse(_13); |
+| _13 := nil:BAT; |
+| _15:bat[:oid,:str] := sql.bind("tmp","_tables","name",0); |
+| _17 := algebra.leftjoin(_14,_15); |
| _14 := nil:BAT; |
-| _16:bat[:oid,:str] := sql.bind("tmp","_tables","name",0); |
-| _18 := algebra.kdifference(_16,_9); |
-| _16:bat[:oid,:str] := nil:BAT; |
-| _9 := nil:BAT; |
-| _19 := algebra.leftjoin(_15,_18,nil:lng); |
-| _15 := nil:BAT; |
-| _18 := nil:BAT; |
-| _21:bat[:oid,:sht] := sql.bind("sys","_tables","type",0); |
-| _23:bat[:oid,:sht] := sql.bind("sys","_tables","type",2); |
-| _25 := algebra.kdifference(_21,_23); |
-| _21:bat[:oid,:sht] := nil:BAT; |
-| _26 := algebra.kunion(_25,_23); |
-| _25 := nil:BAT; |
-| _23:bat[:oid,:sht] := nil:BAT; |
-| _27:bat[:oid,:sht] := sql.bind("sys","_tables","type",1); |
-| _28 := algebra.kunion(_26,_27); |
-| _26 := nil:BAT; |
-| _27:bat[:oid,:sht] := nil:BAT; |
-| _29:bat[:oid,:oid] := sql.bind_dbat("sys","_tables",1); |
-| _30 := bat.reverse(_29); |
-| _29:bat[:oid,:oid] := nil:BAT; |
-| _31 := algebra.kdifference(_28,_30); |
-| _28 := nil:BAT; |
-| _32 := algebra.thetauselect(_31,2:sht,"<"); |
+| _15:bat[:oid,:str] := nil:BAT; |
+| exit _222; |
+| _32:bat[:oid,:str] := bat.new(nil:oid,nil:str); |
+| _31 := mat.pack(_133,_135,_137,_139,_141); |
+| _133 := nil:BAT; |
+| _135 := nil:BAT; |
+| _137 := nil:BAT; |
+| _139 := nil:BAT; |
+| _141 := nil:BAT; |
+| _35 := bat.append(_32,_31,true); |
+| _32:bat[:oid,:str] := nil:BAT; |
| _31 := nil:BAT; |
-| _33 := algebra.markT(_32,0...@0); |
-| _32 := nil:BAT; |
-| _34 := bat.reverse(_33); |
-| _33 := nil:BAT; |
-| _35:bat[:oid,:str] := sql.bind("sys","_tables","name",0); |
-| _36:bat[:oid,:str] := sql.bind("sys","_tables","name",2); |
-| _37 := algebra.kdifference(_35,_36); |
-| _35:bat[:oid,:str] := nil:BAT; |
-| _38 := algebra.kunion(_37,_36); |
+| _37 := bat.append(_35,_17,true); |
+| _35 := nil:BAT; |
+| _17 := nil:BAT; |
+| _38 := sql.resultSet(1,1,_37); |
+| sql.rsColumn(_38,".tables","name","varchar",1024,0,_37); |
| _37 := nil:BAT; |
-| _36:bat[:oid,:str] := nil:BAT; |
-| _39:bat[:oid,:str] := sql.bind("sys","_tables","name",1); |
-| _40 := algebra.kunion(_38,_39); |
-| _38 := nil:BAT; |
-| _39:bat[:oid,:str] := nil:BAT; |
-| _41 := algebra.kdifference(_40,_30); |
-| _40 := nil:BAT; |
-| _30 := nil:BAT; |
-| _42 := algebra.leftjoin(_34,_41,nil:lng); |
-| _34 := nil:BAT; |
-| _41 := nil:BAT; |
-| exit _101; |
-| _43:bat[:oid,:str] := bat.new(nil:oid,nil:str); |
-| _46 := bat.append(_43,_42,true); |
-| _43:bat[:oid,:str] := nil:BAT; |
-| _42 := nil:BAT; |
-| _47 := bat.append(_46,_19,true); |
-| _46 := nil:BAT; |
-| _19 := nil:BAT; |
-| _48 := sql.resultSet(1,1,_47); |
-| sql.rsColumn(_48,".tables","name","varchar",1024,0,_47); |
-| _47 := nil:BAT; |
-| _53 := io.stdout(); |
-| sql.exportResult(_53,_48); |
+| _44 := io.stdout(); |
+| sql.exportResult(_44,_38); |
| end s1_1; |
+--------+
-74 rows
+162 rows
# 15:15:37 >
------------------------------------------------------------------------------
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
