Changeset: 26dba23fef31 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=26dba23fef31
Modified Files:
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
sql/test/mapi/Tests/sql_int128.stable.out
sql/test/remote/Tests/partition_elim.stable.out
Branch: jit
Log Message:
Approve output
diffs (truncated from 1185 to 300 lines):
diff --git
a/sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
b/sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
--- a/sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
+++ b/sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
@@ -72,6 +72,7 @@ stderr of test 'prepare_stmt.Bug-2533.Bu
MAPI = (monetdb) /var/tmp/mtest-23931/.s.monetdb.39276
QUERY = exec 3(2.3);
+ERROR = !wrong type for argument 1 of function call: decimal, expected wrd
diff --git a/sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
b/sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
--- a/sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
+++ b/sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
@@ -42,7 +42,7 @@ Ready.
% mal # name
% clob # type
% 98 # length
-function user.s3_1():void;
+function user.s6_1():void;
X_30:void := querylog.define("explain select * from test where value =
1;","default_pipe",19);
X_14 := bat.new(nil:oid,nil:str);
X_22 := bat.append(X_14,"sys.test");
@@ -60,7 +60,7 @@ function user.s3_1():void;
C_9 := algebra.subselect(X_6,C_3,1,1,true,false,false);
X_12 := algebra.projection(C_9,X_6);
sql.resultSet(X_22,X_24,X_25,X_27,X_29,X_12);
-end user.s3_1;
+end user.s6_1;
# optimizer.mitosis()
# optimizer.dataflow()
#select * from test where value > 12345678900; # value > INT_MAX
@@ -73,9 +73,9 @@ end user.s3_1;
% mal # name
% clob # type
% 98 # length
-function user.s4_1():void;
+function user.s8_1():void;
X_27:void := querylog.define("explain select * from test where value >
1;","default_pipe",35);
-barrier X_56 := language.dataflow();
+barrier X_76 := language.dataflow();
X_11 := bat.new(nil:oid,nil:str);
X_19 := bat.append(X_11,"sys.test");
X_14 := bat.new(nil:oid,nil:str);
@@ -87,27 +87,54 @@ barrier X_56 := language.dataflow();
X_18 := bat.new(nil:oid,nil:int);
X_26 := bat.append(X_18,0);
X_2 := sql.mvc();
- X_41:bat[:int] := sql.bind(X_2,"sys","test","value",0,0,3);
- X_38:bat[:oid] := sql.tid(X_2,"sys","test",0,3);
- X_44 := algebra.thetasubselect(X_41,X_38,1,">");
- X_47 := algebra.projection(X_44,X_41);
- X_42:bat[:int] := sql.bind(X_2,"sys","test","value",0,1,3);
- X_39:bat[:oid] := sql.tid(X_2,"sys","test",1,3);
- X_45 := algebra.thetasubselect(X_42,X_39,1,">");
- X_48 := algebra.projection(X_45,X_42);
- X_43:bat[:int] := sql.bind(X_2,"sys","test","value",0,2,3);
- X_40:bat[:oid] := sql.tid(X_2,"sys","test",2,3);
- X_46 := algebra.thetasubselect(X_43,X_40,1,">");
- X_49 := algebra.projection(X_46,X_43);
- X_50 := mat.packIncrement(X_47,3);
- X_51 := mat.packIncrement(X_50,X_48);
- X_9 := mat.packIncrement(X_51,X_49);
- language.pass(X_41);
- language.pass(X_42);
- language.pass(X_43);
-exit X_56;
+ X_50:bat[:int] := sql.bind(X_2,"sys","test","value",0,0,3);
+ X_47:bat[:oid] := sql.tid(X_2,"sys","test",0,3);
+ X_54 := algebra.thetasubselect(X_50,X_47,1,">");
+ X_57 := algebra.projection(X_54,X_50);
+ X_51:bat[:int] := sql.bind(X_2,"sys","test","value",0,1,3);
+ X_48:bat[:oid] := sql.tid(X_2,"sys","test",1,3);
+ X_55 := algebra.thetasubselect(X_51,X_48,1,">");
+ X_58 := algebra.projection(X_55,X_51);
+ X_52:bat[:int] := sql.bind(X_2,"sys","test","value",0,2,3);
+ X_49:bat[:oid] := sql.tid(X_2,"sys","test",2,3);
+ X_56 := algebra.thetasubselect(X_52,X_49,1,">");
+ X_59 := algebra.projection(X_56,X_52);
+ X_69 := mat.packIncrement(X_57,3);
+ X_70 := mat.packIncrement(X_69,X_58);
+ X_9 := mat.packIncrement(X_70,X_59);
+ language.pass(X_50);
+ language.pass(X_51);
+ language.pass(X_52);
+exit X_76;
sql.resultSet(X_19,X_21,X_22,X_24,X_26,X_9);
-end user.s4_1;
+end user.s8_1;
+#inline actions= 0 time=2 usec
+#candidates actions= 1 time=20 usec
+#remap actions= 0 time=5 usec
+#costModel actions= 1 time=18 usec
+#coercions actions= 0 time=3 usec
+#evaluate actions= 1 time=34 usec
+#emptybind actions= 0 time=5 usec
+#pushselect actions= 2 time=24 usec
+#aliases actions= 3 time=21 usec
+#mitosis actions= 1 time=40 usec
+#mergetable actions= 2 time=81 usec
+#deadcode actions= 7 time=27 usec
+#aliases actions= 0 time=8 usec
+#constants actions= 4 time=32 usec
+#commonTerms actions= 0 time=8 usec
+#projectionpath actions= 0 time=6 usec
+#deadcode actions= 0 time=16 usec
+#reorder actions= 1 time=42 usec
+#reduce actions=39 time=46 usec
+#matpack actions= 1 time=23 usec
+#dataflow actions=28 time=39 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=4 usec
+#generator actions= 0 time=2 usec
+#profiler actions= 1 time=22 usec
+#garbageCollector actions= 1 time=29 usec
+#total actions= 1 time=646 usec
#select * from test where value >= 12345678900; # value > INT_MAX
% sys.test # table_name
% value # name
@@ -118,9 +145,9 @@ end user.s4_1;
% mal # name
% clob # type
% 99 # length
-function user.s5_1():void;
+function user.s10_1():void;
X_27:void := querylog.define("explain select * from test where value >=
1;","default_pipe",35);
-barrier X_56 := language.dataflow();
+barrier X_76 := language.dataflow();
X_11 := bat.new(nil:oid,nil:str);
X_19 := bat.append(X_11,"sys.test");
X_14 := bat.new(nil:oid,nil:str);
@@ -132,27 +159,54 @@ barrier X_56 := language.dataflow();
X_18 := bat.new(nil:oid,nil:int);
X_26 := bat.append(X_18,0);
X_2 := sql.mvc();
- X_41:bat[:int] := sql.bind(X_2,"sys","test","value",0,0,3);
- X_38:bat[:oid] := sql.tid(X_2,"sys","test",0,3);
- X_44 := algebra.thetasubselect(X_41,X_38,1,">=");
- X_47 := algebra.projection(X_44,X_41);
- X_42:bat[:int] := sql.bind(X_2,"sys","test","value",0,1,3);
- X_39:bat[:oid] := sql.tid(X_2,"sys","test",1,3);
- X_45 := algebra.thetasubselect(X_42,X_39,1,">=");
- X_48 := algebra.projection(X_45,X_42);
- X_43:bat[:int] := sql.bind(X_2,"sys","test","value",0,2,3);
- X_40:bat[:oid] := sql.tid(X_2,"sys","test",2,3);
- X_46 := algebra.thetasubselect(X_43,X_40,1,">=");
- X_49 := algebra.projection(X_46,X_43);
- X_50 := mat.packIncrement(X_47,3);
- X_51 := mat.packIncrement(X_50,X_48);
- X_9 := mat.packIncrement(X_51,X_49);
- language.pass(X_41);
- language.pass(X_42);
- language.pass(X_43);
-exit X_56;
+ X_50:bat[:int] := sql.bind(X_2,"sys","test","value",0,0,3);
+ X_47:bat[:oid] := sql.tid(X_2,"sys","test",0,3);
+ X_54 := algebra.thetasubselect(X_50,X_47,1,">=");
+ X_57 := algebra.projection(X_54,X_50);
+ X_51:bat[:int] := sql.bind(X_2,"sys","test","value",0,1,3);
+ X_48:bat[:oid] := sql.tid(X_2,"sys","test",1,3);
+ X_55 := algebra.thetasubselect(X_51,X_48,1,">=");
+ X_58 := algebra.projection(X_55,X_51);
+ X_52:bat[:int] := sql.bind(X_2,"sys","test","value",0,2,3);
+ X_49:bat[:oid] := sql.tid(X_2,"sys","test",2,3);
+ X_56 := algebra.thetasubselect(X_52,X_49,1,">=");
+ X_59 := algebra.projection(X_56,X_52);
+ X_69 := mat.packIncrement(X_57,3);
+ X_70 := mat.packIncrement(X_69,X_58);
+ X_9 := mat.packIncrement(X_70,X_59);
+ language.pass(X_50);
+ language.pass(X_51);
+ language.pass(X_52);
+exit X_76;
sql.resultSet(X_19,X_21,X_22,X_24,X_26,X_9);
-end user.s5_1;
+end user.s10_1;
+#inline actions= 0 time=2 usec
+#candidates actions= 1 time=20 usec
+#remap actions= 0 time=4 usec
+#costModel actions= 1 time=18 usec
+#coercions actions= 0 time=2 usec
+#evaluate actions= 1 time=31 usec
+#emptybind actions= 0 time=5 usec
+#pushselect actions= 2 time=23 usec
+#aliases actions= 3 time=21 usec
+#mitosis actions= 1 time=41 usec
+#mergetable actions= 2 time=63 usec
+#deadcode actions= 7 time=26 usec
+#aliases actions= 0 time=8 usec
+#constants actions= 4 time=23 usec
+#commonTerms actions= 0 time=8 usec
+#projectionpath actions= 0 time=6 usec
+#deadcode actions= 0 time=8 usec
+#reorder actions= 1 time=63 usec
+#reduce actions=39 time=45 usec
+#matpack actions= 1 time=23 usec
+#dataflow actions=28 time=41 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=5 usec
+#generator actions= 0 time=2 usec
+#profiler actions= 1 time=21 usec
+#garbageCollector actions= 1 time=28 usec
+#total actions= 1 time=620 usec
#select * from test where value < 12345678900; # value > INT_MAX
% sys.test # table_name
% value # name
@@ -166,9 +220,9 @@ end user.s5_1;
% mal # name
% clob # type
% 98 # length
-function user.s6_1():void;
+function user.s12_1():void;
X_27:void := querylog.define("explain select * from test where value <
1;","default_pipe",35);
-barrier X_56 := language.dataflow();
+barrier X_76 := language.dataflow();
X_11 := bat.new(nil:oid,nil:str);
X_19 := bat.append(X_11,"sys.test");
X_14 := bat.new(nil:oid,nil:str);
@@ -180,27 +234,54 @@ barrier X_56 := language.dataflow();
X_18 := bat.new(nil:oid,nil:int);
X_26 := bat.append(X_18,0);
X_2 := sql.mvc();
- X_41:bat[:int] := sql.bind(X_2,"sys","test","value",0,0,3);
- X_38:bat[:oid] := sql.tid(X_2,"sys","test",0,3);
- X_44 := algebra.thetasubselect(X_41,X_38,1,"<");
- X_47 := algebra.projection(X_44,X_41);
- X_42:bat[:int] := sql.bind(X_2,"sys","test","value",0,1,3);
- X_39:bat[:oid] := sql.tid(X_2,"sys","test",1,3);
- X_45 := algebra.thetasubselect(X_42,X_39,1,"<");
- X_48 := algebra.projection(X_45,X_42);
- X_43:bat[:int] := sql.bind(X_2,"sys","test","value",0,2,3);
- X_40:bat[:oid] := sql.tid(X_2,"sys","test",2,3);
- X_46 := algebra.thetasubselect(X_43,X_40,1,"<");
- X_49 := algebra.projection(X_46,X_43);
- X_50 := mat.packIncrement(X_47,3);
- X_51 := mat.packIncrement(X_50,X_48);
- X_9 := mat.packIncrement(X_51,X_49);
- language.pass(X_41);
- language.pass(X_42);
- language.pass(X_43);
-exit X_56;
+ X_50:bat[:int] := sql.bind(X_2,"sys","test","value",0,0,3);
+ X_47:bat[:oid] := sql.tid(X_2,"sys","test",0,3);
+ X_54 := algebra.thetasubselect(X_50,X_47,1,"<");
+ X_57 := algebra.projection(X_54,X_50);
+ X_51:bat[:int] := sql.bind(X_2,"sys","test","value",0,1,3);
+ X_48:bat[:oid] := sql.tid(X_2,"sys","test",1,3);
+ X_55 := algebra.thetasubselect(X_51,X_48,1,"<");
+ X_58 := algebra.projection(X_55,X_51);
+ X_52:bat[:int] := sql.bind(X_2,"sys","test","value",0,2,3);
+ X_49:bat[:oid] := sql.tid(X_2,"sys","test",2,3);
+ X_56 := algebra.thetasubselect(X_52,X_49,1,"<");
+ X_59 := algebra.projection(X_56,X_52);
+ X_69 := mat.packIncrement(X_57,3);
+ X_70 := mat.packIncrement(X_69,X_58);
+ X_9 := mat.packIncrement(X_70,X_59);
+ language.pass(X_50);
+ language.pass(X_51);
+ language.pass(X_52);
+exit X_76;
sql.resultSet(X_19,X_21,X_22,X_24,X_26,X_9);
-end user.s6_1;
+end user.s12_1;
+#inline actions= 0 time=3 usec
+#candidates actions= 1 time=20 usec
+#remap actions= 0 time=4 usec
+#costModel actions= 1 time=19 usec
+#coercions actions= 0 time=2 usec
+#evaluate actions= 1 time=33 usec
+#emptybind actions= 0 time=4 usec
+#pushselect actions= 2 time=24 usec
+#aliases actions= 3 time=20 usec
+#mitosis actions= 1 time=41 usec
+#mergetable actions= 2 time=64 usec
+#deadcode actions= 7 time=27 usec
+#aliases actions= 0 time=8 usec
+#constants actions= 4 time=24 usec
+#commonTerms actions= 0 time=8 usec
+#projectionpath actions= 0 time=6 usec
+#deadcode actions= 0 time=8 usec
+#reorder actions= 1 time=42 usec
+#reduce actions=39 time=46 usec
+#matpack actions= 1 time=23 usec
+#dataflow actions=28 time=39 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=4 usec
+#generator actions= 0 time=2 usec
+#profiler actions= 1 time=21 usec
+#garbageCollector actions= 1 time=29 usec
+#total actions= 1 time=600 usec
#select * from test where value <= 12345678900; # value > INT_MAX
% sys.test # table_name
% value # name
@@ -214,9 +295,9 @@ end user.s6_1;
% mal # name
% clob # type
% 99 # length
-function user.s7_1():void;
+function user.s14_1():void;
X_27:void := querylog.define("explain select * from test where value <=
1;","default_pipe",35);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
