Changeset: 5705e7e2a333 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5705e7e2a333
Modified Files:
        sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out
        sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
        sql/test/remote/Tests/partition_elim.stable.out
Branch: Mar2018
Log Message:

Some approvals.


diffs (truncated from 462 to 300 lines):

diff --git a/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out 
b/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out
--- a/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out
+++ b/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out
@@ -46,6 +46,22 @@ Ready.
 [ 0.0000000000000      ]
 [ 0.0000000000000      ]
 [ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
+[ 0.0000000000000      ]
 
 # 18:14:35 >  
 # 18:14:35 >  "Done."
diff --git a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out 
b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
--- a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
+++ b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
@@ -5,7 +5,7 @@ stdout of test 'explain.SF-1739353` in d
 # 15:11:17 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=33800" "--set" 
"mapi_usock=/var/tmp/mtest-7180/.s.monetdb.33800" "--set" "monet_prompt=" 
"--forcemito" 
"--dbpath=/ufs/sjoerd/@Monet-virgin/var/MonetDB/mTests_sql_test_BugTracker"
 # 15:11:17 >  
 
-# MonetDB 5 server v11.28.0 (hg id: 623015a562d3)
+# MonetDB 5 server v11.29.0
 # This is an unreleased version
 # Serving database 'mTests_sql_test_BugTracker', using 8 threads
 # Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers
@@ -31,11 +31,11 @@ Ready.
 
 Operation successful
 
+------------------------------------------------------------------------------------------------------------------------+
-| mal                                                                          
                             |
+| mal                                                                          
                                          |
 
+========================================================================================================================+
-| function user.s4_1():void;                                                   
                             |
+| function user.s4_1():void;                                                   
                                          |
 |     X_1:void := querylog.define("explain select \"name\" from 
\"tables\"\n;":str, "sequential_pipe":str, 36:int);      |
-|     X_35:bat[:str] := bat.new(nil:str);                                      
                             |
+|     X_35:bat[:str] := bat.new(nil:str);                                      
                                          |
 |     X_4:int := sql.mvc();                                                    
                                          |
 |     X_18:bat[:sht] := sql.bind(X_4:int, "sys":str, "_tables":str, 
"type":str, 0:int);                                  |
 |     C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "_tables":str);             
                                          |
@@ -65,34 +65,33 @@ Operation successful
 |     X_53:bat[:int] := bat.append(X_44:bat[:int], 1024:int);                  
                                          |
 |     X_55:bat[:int] := bat.append(X_46:bat[:int], 0:int);                     
                                          |
 |     sql.resultSet(X_47:bat[:str], X_49:bat[:str], X_51:bat[:str], 
X_53:bat[:int], X_55:bat[:int], X_39:bat[:str]);     |
-| end user.s4_1;                                                               
                             |
-| #inline               actions= 0 time=0 usec                                 
                                          |
-| #remap                actions= 0 time=1 usec                                 
                             |
+| end user.s4_1;                                                               
                                          |
+| #inline               actions= 0 time=1 usec                                 
                                          |
+| #remap                actions= 0 time=2 usec                                 
                                          |
 | #costmodel            actions= 1 time=1 usec                                 
                                          |
-| #coercion             actions= 1 time=3 usec                                 
                                          |
-| #evaluate             actions= 0 time=3 usec                                 
                                          |
+| #coercion             actions= 1 time=5 usec                                 
                                          |
+| #evaluate             actions= 0 time=4 usec                                 
                                          |
 | #emptybind            actions= 0 time=0 usec                                 
                                          |
-| #pushselect           actions= 5 time=28 usec                                
                                          |
-| #aliases              actions= 2 time=5 usec                                 
                                          |
-| #mergetable           actions= 0 time=24 usec                                
                                          |
-| #deadcode             actions= 3 time=6 usec                                 
                                          |
+| #pushselect           actions= 5 time=22 usec                                
                                          |
+| #aliases              actions= 2 time=6 usec                                 
                                          |
+| #mergetable           actions= 0 time=29 usec                                
                                          |
+| #deadcode             actions= 3 time=8 usec                                 
                                          |
 | #aliases              actions= 0 time=1 usec                                 
                                          |
-| #constants            actions= 2 time=5 usec                                 
                                          |
-| #commonTerms          actions= 0 time=4 usec                                 
                                          |
-| #projectionpath       actions= 0 time=3 usec                                 
                             |
-| #reorder              actions= 1 time=18 usec                                
                                          |
-| #deadcode             actions= 0 time=4 usec                                 
                                          |
-| #matpack              actions= 0 time=0 usec                                 
                             |
-| #multiplex            actions= 0 time=1 usec                                 
                                          |
-| #profiler             actions=1 time=1 usec                                  
                             |
+| #constants            actions= 2 time=6 usec                                 
                                          |
+| #commonTerms          actions= 0 time=5 usec                                 
                                          |
+| #projectionpath       actions= 0 time=4 usec                                 
                                          |
+| #reorder              actions= 1 time=24 usec                                
                                          |
+| #deadcode             actions= 0 time=7 usec                                 
                                          |
+| #matpack              actions= 0 time=1 usec                                 
                                          |
+| #multiplex            actions= 0 time=2 usec                                 
                                          |
+| #profiler             actions=1 time=1 usec                                  
                                          |
 | #candidates           actions=1 time=0 usec                                  
                                          |
-| #postfix              actions= 0 time=0 usec                                 
                                          |
-| #deadcode             actions= 0 time=4 usec                                 
                                          |
-| #wlc                  actions= 0 time=0 usec                                 
                             |
-| #garbagecollector     actions= 1 time=38 usec                                
                                          |
-| #total                actions=26 time=217 usec                               
                                          |
+| #deadcode             actions= 0 time=5 usec                                 
                                          |
+| #wlc                  actions= 0 time=0 usec                                 
                                          |
+| #garbagecollector     actions= 1 time=36 usec                                
                                          |
+| #total                actions=26 time=242 usec                               
                                          |
 
+------------------------------------------------------------------------------------------------------------------------+
-58 rows
+57 rows
 
 # 15:11:18 >  
 # 15:11:18 >  "Done."
diff --git a/sql/test/remote/Tests/partition_elim.stable.out 
b/sql/test/remote/Tests/partition_elim.stable.out
--- a/sql/test/remote/Tests/partition_elim.stable.out
+++ b/sql/test/remote/Tests/partition_elim.stable.out
@@ -137,34 +137,34 @@ Ready.
 % 130 # length
 function user.SQLanalyze():void;
     X_5:void := querylog.define("explain select x,y from test where x between 
4.0 and 6.0;":str, "default_pipe":str, 51:int);
-barrier X_147:bit := language.dataflow();
+barrier X_149:bit := language.dataflow();
     X_43:bat[:dbl] := bat.new(nil:dbl);
     X_8:int := sql.mvc();
-    X_123:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str, 
0:int, 0:int, 2:int);
-    C_120:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 0:int, 2:int);
-    C_128:bat[:oid] := algebra.select(X_123:bat[:dbl], C_120:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
-    X_130:bat[:dbl] := algebra.projection(C_128:bat[:oid], X_123:bat[:dbl]);
-    X_124:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str, 
0:int, 1:int, 2:int);
-    C_122:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 1:int, 2:int);
-    C_129:bat[:oid] := algebra.select(X_124:bat[:dbl], C_122:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
-    X_131:bat[:dbl] := algebra.projection(C_129:bat[:oid], X_124:bat[:dbl]);
-    X_142:bat[:dbl] := mat.packIncrement(X_130:bat[:dbl], 2:int);
-    X_28:bat[:dbl] := mat.packIncrement(X_142:bat[:dbl], X_131:bat[:dbl]);
+    X_125:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str, 
0:int, 0:int, 2:int);
+    C_122:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 0:int, 2:int);
+    C_130:bat[:oid] := algebra.select(X_125:bat[:dbl], C_122:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
+    X_132:bat[:dbl] := algebra.projection(C_130:bat[:oid], X_125:bat[:dbl]);
+    X_126:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str, 
0:int, 1:int, 2:int);
+    C_124:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 1:int, 2:int);
+    C_131:bat[:oid] := algebra.select(X_126:bat[:dbl], C_124:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
+    X_133:bat[:dbl] := algebra.projection(C_131:bat[:oid], X_126:bat[:dbl]);
+    X_144:bat[:dbl] := mat.packIncrement(X_132:bat[:dbl], 2:int);
+    X_28:bat[:dbl] := mat.packIncrement(X_144:bat[:dbl], X_133:bat[:dbl]);
     X_32:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test3":str, "x":str, 
0:int);
     C_30:bat[:oid] := sql.tid(X_8:int, "sys":str, "test3":str);
     C_40:bat[:oid] := algebra.select(X_32:bat[:dbl], C_30:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
     X_34:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test3":str, "y":str, 
0:int);
     X_42:bat[:dbl] := algebra.projection(C_40:bat[:oid], X_34:bat[:dbl]);
     X_41:bat[:dbl] := algebra.projection(C_40:bat[:oid], X_32:bat[:dbl]);
-    X_126:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str, 
0:int, 1:int, 2:int);
-    X_133:bat[:dbl] := algebra.projection(C_129:bat[:oid], X_126:bat[:dbl]);
-    X_125:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str, 
0:int, 0:int, 2:int);
-    X_132:bat[:dbl] := algebra.projection(C_128:bat[:oid], X_125:bat[:dbl]);
+    X_128:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str, 
0:int, 1:int, 2:int);
+    X_135:bat[:dbl] := algebra.projection(C_131:bat[:oid], X_128:bat[:dbl]);
+    X_127:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str, 
0:int, 0:int, 2:int);
+    X_134:bat[:dbl] := algebra.projection(C_130:bat[:oid], X_127:bat[:dbl]);
     X_45:bat[:dbl] := bat.append(X_43:bat[:dbl], X_28:bat[:dbl], true:bit);
     X_46:bat[:dbl] := bat.append(X_45:bat[:dbl], X_41:bat[:dbl], true:bit);
     X_47:bat[:dbl] := bat.new(nil:dbl);
-    X_144:bat[:dbl] := mat.packIncrement(X_132:bat[:dbl], 2:int);
-    X_29:bat[:dbl] := mat.packIncrement(X_144:bat[:dbl], X_133:bat[:dbl]);
+    X_146:bat[:dbl] := mat.packIncrement(X_134:bat[:dbl], 2:int);
+    X_29:bat[:dbl] := mat.packIncrement(X_146:bat[:dbl], X_135:bat[:dbl]);
     X_48:bat[:dbl] := bat.append(X_47:bat[:dbl], X_29:bat[:dbl], true:bit);
     X_49:bat[:dbl] := bat.append(X_48:bat[:dbl], X_42:bat[:dbl], true:bit);
     X_51:bat[:str] := bat.new(nil:str);
@@ -182,13 +182,13 @@ barrier X_147:bit := language.dataflow()
     X_71:bat[:str] := bat.append(X_62:bat[:str], "double":str);
     X_72:bat[:int] := bat.append(X_64:bat[:int], 53:int);
     X_73:bat[:int] := bat.append(X_66:bat[:int], 0:int);
-    language.pass(X_123:bat[:dbl]);
-    language.pass(X_124:bat[:dbl]);
+    language.pass(X_125:bat[:dbl]);
+    language.pass(X_126:bat[:dbl]);
     language.pass(C_40:bat[:oid]);
     language.pass(X_32:bat[:dbl]);
-    language.pass(C_129:bat[:oid]);
-    language.pass(C_128:bat[:oid]);
-exit X_147:bit;
+    language.pass(C_131:bat[:oid]);
+    language.pass(C_130:bat[:oid]);
+exit X_149:bit;
     sql.resultSet(X_68:bat[:str], X_69:bat[:str], X_71:bat[:str], 
X_72:bat[:int], X_73:bat[:int], X_46:bat[:dbl], X_49:bat[:dbl]);
 end user.SQLanalyze;
 #inline               actions= 0 time=4 usec 
@@ -223,34 +223,34 @@ end user.SQLanalyze;
 % 130 # length
 function user.SQLanalyze():void;
     X_8:void := querylog.define("explain select x,y from test where x between 
(7-3) and (7-1);":str, "default_pipe":str, 61:int);
-barrier X_160:bit := language.dataflow();
+barrier X_162:bit := language.dataflow();
     X_53:bat[:dbl] := bat.new(nil:dbl);
     X_11:int := sql.mvc();
-    X_136:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str, 
0:int, 0:int, 2:int);
-    C_133:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 0:int, 2:int);
-    C_141:bat[:oid] := algebra.select(X_136:bat[:dbl], C_133:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
-    X_143:bat[:dbl] := algebra.projection(C_141:bat[:oid], X_136:bat[:dbl]);
-    X_137:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str, 
0:int, 1:int, 2:int);
-    C_135:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 1:int, 2:int);
-    C_142:bat[:oid] := algebra.select(X_137:bat[:dbl], C_135:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
-    X_144:bat[:dbl] := algebra.projection(C_142:bat[:oid], X_137:bat[:dbl]);
-    X_155:bat[:dbl] := mat.packIncrement(X_143:bat[:dbl], 2:int);
-    X_34:bat[:dbl] := mat.packIncrement(X_155:bat[:dbl], X_144:bat[:dbl]);
+    X_138:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str, 
0:int, 0:int, 2:int);
+    C_135:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 0:int, 2:int);
+    C_143:bat[:oid] := algebra.select(X_138:bat[:dbl], C_135:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
+    X_145:bat[:dbl] := algebra.projection(C_143:bat[:oid], X_138:bat[:dbl]);
+    X_139:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str, 
0:int, 1:int, 2:int);
+    C_137:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 1:int, 2:int);
+    C_144:bat[:oid] := algebra.select(X_139:bat[:dbl], C_137:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
+    X_146:bat[:dbl] := algebra.projection(C_144:bat[:oid], X_139:bat[:dbl]);
+    X_157:bat[:dbl] := mat.packIncrement(X_145:bat[:dbl], 2:int);
+    X_34:bat[:dbl] := mat.packIncrement(X_157:bat[:dbl], X_146:bat[:dbl]);
     X_38:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test3":str, "x":str, 
0:int);
     C_36:bat[:oid] := sql.tid(X_11:int, "sys":str, "test3":str);
     C_50:bat[:oid] := algebra.select(X_38:bat[:dbl], C_36:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
     X_40:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test3":str, "y":str, 
0:int);
     X_52:bat[:dbl] := algebra.projection(C_50:bat[:oid], X_40:bat[:dbl]);
     X_51:bat[:dbl] := algebra.projection(C_50:bat[:oid], X_38:bat[:dbl]);
-    X_139:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str, 
0:int, 1:int, 2:int);
-    X_146:bat[:dbl] := algebra.projection(C_142:bat[:oid], X_139:bat[:dbl]);
-    X_138:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str, 
0:int, 0:int, 2:int);
-    X_145:bat[:dbl] := algebra.projection(C_141:bat[:oid], X_138:bat[:dbl]);
+    X_141:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str, 
0:int, 1:int, 2:int);
+    X_148:bat[:dbl] := algebra.projection(C_144:bat[:oid], X_141:bat[:dbl]);
+    X_140:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str, 
0:int, 0:int, 2:int);
+    X_147:bat[:dbl] := algebra.projection(C_143:bat[:oid], X_140:bat[:dbl]);
     X_55:bat[:dbl] := bat.append(X_53:bat[:dbl], X_34:bat[:dbl], true:bit);
     X_56:bat[:dbl] := bat.append(X_55:bat[:dbl], X_51:bat[:dbl], true:bit);
     X_57:bat[:dbl] := bat.new(nil:dbl);
-    X_157:bat[:dbl] := mat.packIncrement(X_145:bat[:dbl], 2:int);
-    X_35:bat[:dbl] := mat.packIncrement(X_157:bat[:dbl], X_146:bat[:dbl]);
+    X_159:bat[:dbl] := mat.packIncrement(X_147:bat[:dbl], 2:int);
+    X_35:bat[:dbl] := mat.packIncrement(X_159:bat[:dbl], X_148:bat[:dbl]);
     X_58:bat[:dbl] := bat.append(X_57:bat[:dbl], X_35:bat[:dbl], true:bit);
     X_59:bat[:dbl] := bat.append(X_58:bat[:dbl], X_52:bat[:dbl], true:bit);
     X_61:bat[:str] := bat.new(nil:str);
@@ -268,13 +268,13 @@ barrier X_160:bit := language.dataflow()
     X_81:bat[:str] := bat.append(X_72:bat[:str], "double":str);
     X_82:bat[:int] := bat.append(X_74:bat[:int], 53:int);
     X_83:bat[:int] := bat.append(X_76:bat[:int], 0:int);
-    language.pass(X_136:bat[:dbl]);
-    language.pass(X_137:bat[:dbl]);
+    language.pass(X_138:bat[:dbl]);
+    language.pass(X_139:bat[:dbl]);
     language.pass(C_50:bat[:oid]);
     language.pass(X_38:bat[:dbl]);
-    language.pass(C_142:bat[:oid]);
-    language.pass(C_141:bat[:oid]);
-exit X_160:bit;
+    language.pass(C_144:bat[:oid]);
+    language.pass(C_143:bat[:oid]);
+exit X_162:bit;
     sql.resultSet(X_78:bat[:str], X_79:bat[:str], X_81:bat[:str], 
X_82:bat[:int], X_83:bat[:int], X_56:bat[:dbl], X_59:bat[:dbl]);
 end user.SQLanalyze;
 #inline               actions= 0 time=4 usec 
@@ -309,27 +309,27 @@ end user.SQLanalyze;
 % 151 # length
 function user.SQLanalyze():void;
     X_9:void := querylog.define("explain select x,y from test where x between 
4.0 and 6.0 and y between 0.0 and 2.0;":str, "default_pipe":str, 40:int);
-barrier X_139:bit := language.dataflow();
+barrier X_141:bit := language.dataflow();
     X_40:bat[:str] := bat.new(nil:str);
     X_46:bat[:int] := bat.new(nil:int);
     X_44:bat[:int] := bat.new(nil:int);
     X_43:bat[:str] := bat.new(nil:str);
     X_42:bat[:str] := bat.new(nil:str);
     X_12:int := sql.mvc();
-    X_116:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str, 
0:int, 1:int, 2:int);
-    X_114:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str, 
0:int, 1:int, 2:int);
-    C_112:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 1:int, 2:int);
-    C_119:bat[:oid] := algebra.select(X_114:bat[:dbl], C_112:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
-    C_121:bat[:oid] := algebra.select(X_116:bat[:dbl], C_119:bat[:oid], 0:dbl, 
2:dbl, true:bit, true:bit, false:bit);
-    X_125:bat[:dbl] := algebra.projection(C_121:bat[:oid], X_116:bat[:dbl]);
-    X_115:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str, 
0:int, 0:int, 2:int);
-    X_113:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str, 
0:int, 0:int, 2:int);
-    C_110:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 0:int, 2:int);
-    C_118:bat[:oid] := algebra.select(X_113:bat[:dbl], C_110:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
-    C_120:bat[:oid] := algebra.select(X_115:bat[:dbl], C_118:bat[:oid], 0:dbl, 
2:dbl, true:bit, true:bit, false:bit);
-    X_124:bat[:dbl] := algebra.projection(C_120:bat[:oid], X_115:bat[:dbl]);
-    X_123:bat[:dbl] := algebra.projection(C_121:bat[:oid], X_114:bat[:dbl]);
-    X_122:bat[:dbl] := algebra.projection(C_120:bat[:oid], X_113:bat[:dbl]);
+    X_118:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str, 
0:int, 1:int, 2:int);
+    X_116:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str, 
0:int, 1:int, 2:int);
+    C_114:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 1:int, 2:int);
+    C_121:bat[:oid] := algebra.select(X_116:bat[:dbl], C_114:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
+    C_123:bat[:oid] := algebra.select(X_118:bat[:dbl], C_121:bat[:oid], 0:dbl, 
2:dbl, true:bit, true:bit, false:bit);
+    X_127:bat[:dbl] := algebra.projection(C_123:bat[:oid], X_118:bat[:dbl]);
+    X_117:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str, 
0:int, 0:int, 2:int);
+    X_115:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str, 
0:int, 0:int, 2:int);
+    C_112:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 0:int, 2:int);
+    C_120:bat[:oid] := algebra.select(X_115:bat[:dbl], C_112:bat[:oid], 4:dbl, 
6:dbl, true:bit, true:bit, false:bit);
+    C_122:bat[:oid] := algebra.select(X_117:bat[:dbl], C_120:bat[:oid], 0:dbl, 
2:dbl, true:bit, true:bit, false:bit);
+    X_126:bat[:dbl] := algebra.projection(C_122:bat[:oid], X_117:bat[:dbl]);
+    X_125:bat[:dbl] := algebra.projection(C_123:bat[:oid], X_116:bat[:dbl]);
+    X_124:bat[:dbl] := algebra.projection(C_122:bat[:oid], X_115:bat[:dbl]);
     X_47:bat[:str] := bat.append(X_40:bat[:str], "sys.test":str);
     X_49:bat[:str] := bat.append(X_42:bat[:str], "x":str);
     X_51:bat[:str] := bat.append(X_43:bat[:str], "double":str);
@@ -340,17 +340,17 @@ barrier X_139:bit := language.dataflow()
     X_60:bat[:str] := bat.append(X_51:bat[:str], "double":str);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to