Changeset: d4a0bf428073 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d4a0bf428073
Modified Files:
sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
Branch: default
Log Message:
approve after c360e613b861: leftjoin -> leftfetchjoin
diffs (truncated from 440 to 300 lines):
diff --git a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
@@ -113,7 +113,7 @@ function user.s11_1{autoCommit=true}():v
X_20 := algebra.kdifference(X_19,X_10);
X_21 := algebra.markT(X_20,0@0:oid);
X_22 := bat.reverse(X_21);
- X_23 := algebra.leftjoin(X_22,X_19);
+ X_23 := algebra.leftfetchjoin(X_22,X_19);
X_24 := bat.append(X_18,X_23,true);
X_25:bat[:oid,:bte] := sql.bind(X_2,"sys","udf_fuse","b",0);
X_27:bat[:oid,:bte] := sql.bind(X_2,"sys","udf_fuse","b",2);
@@ -121,7 +121,7 @@ function user.s11_1{autoCommit=true}():v
X_29 := algebra.kunion(X_28,X_27);
X_30 := algebra.leftjoin(X_13,X_29);
X_31:bat[:oid,:bte] := sql.bind(X_2,"sys","udf_fuse","b",1);
- X_34 := algebra.leftjoin(X_22,X_31);
+ X_34 := algebra.leftfetchjoin(X_22,X_31);
X_35 := bat.append(X_30,X_34,true);
X_37:bat[:oid,:sht] := batudf.fuse(X_24,X_35);
X_39 := sql.resultSet(1,1,X_37);
@@ -154,7 +154,7 @@ function user.s12_1{autoCommit=true}():v
X_23 := algebra.markT(X_22,0@0:oid);
X_24 := bat.reverse(X_23);
X_25:bat[:oid,:sht] := sql.bind(X_2,"sys","udf_fuse","c",1);
- X_26 := algebra.leftjoin(X_24,X_25);
+ X_26 := algebra.leftfetchjoin(X_24,X_25);
X_27 := bat.append(X_20,X_26,true);
X_28:bat[:oid,:sht] := sql.bind(X_2,"sys","udf_fuse","d",0);
X_30:bat[:oid,:sht] := sql.bind(X_2,"sys","udf_fuse","d",2);
@@ -162,7 +162,7 @@ function user.s12_1{autoCommit=true}():v
X_32 := algebra.kunion(X_31,X_30);
X_33 := algebra.leftjoin(X_13,X_32);
X_34:bat[:oid,:sht] := sql.bind(X_2,"sys","udf_fuse","d",1);
- X_38 := algebra.leftjoin(X_24,X_34);
+ X_38 := algebra.leftfetchjoin(X_24,X_34);
X_39 := bat.append(X_33,X_38,true);
X_41:bat[:oid,:int] := batudf.fuse(X_27,X_39);
X_43 := sql.resultSet(1,1,X_41);
@@ -195,7 +195,7 @@ function user.s13_1{autoCommit=true}():v
X_23 := algebra.markT(X_22,0@0:oid);
X_24 := bat.reverse(X_23);
X_25:bat[:oid,:int] := sql.bind(X_2,"sys","udf_fuse","e",1);
- X_26 := algebra.leftjoin(X_24,X_25);
+ X_26 := algebra.leftfetchjoin(X_24,X_25);
X_27 := bat.append(X_20,X_26,true);
X_28:bat[:oid,:int] := sql.bind(X_2,"sys","udf_fuse","f",0);
X_30:bat[:oid,:int] := sql.bind(X_2,"sys","udf_fuse","f",2);
@@ -203,7 +203,7 @@ function user.s13_1{autoCommit=true}():v
X_32 := algebra.kunion(X_31,X_30);
X_33 := algebra.leftjoin(X_13,X_32);
X_34:bat[:oid,:int] := sql.bind(X_2,"sys","udf_fuse","f",1);
- X_38 := algebra.leftjoin(X_24,X_34);
+ X_38 := algebra.leftfetchjoin(X_24,X_34);
X_39 := bat.append(X_33,X_38,true);
X_41:bat[:oid,:lng] := batudf.fuse(X_27,X_39);
X_43 := sql.resultSet(1,1,X_41);
diff --git a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
@@ -98,7 +98,7 @@ function user.s7_1{autoCommit=true}():vo
X_20 := algebra.kdifference(X_19,X_10);
X_21 := algebra.markT(X_20,0@0:oid);
X_22 := bat.reverse(X_21);
- X_23 := algebra.leftjoin(X_22,X_19);
+ X_23 := algebra.leftfetchjoin(X_22,X_19);
X_24 := bat.append(X_18,X_23,true);
X_25:bat[:oid,:str] := batudf.reverse(X_24);
X_27 := sql.resultSet(1,1,X_25);
diff --git a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
--- a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
+++ b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
@@ -44,7 +44,7 @@ function user.s0_1{autoCommit=true}(A0:d
X_21 := algebra.kdifference(X_20,X_11);
X_22 := algebra.markT(X_21,0@0:oid);
X_23 := bat.reverse(X_22);
- X_24 := algebra.leftjoin(X_23,X_20);
+ X_24 := algebra.leftfetchjoin(X_23,X_20);
X_25 := bat.append(X_19,X_24,true);
X_26:bat[:oid,:dbl] := batmmath.pow(X_25,A0);
X_28 := sql.resultSet(1,1,X_26);
@@ -73,7 +73,7 @@ function user.s1_1{autoCommit=true}():vo
X_20 := algebra.kdifference(X_19,X_10);
X_21 := algebra.markT(X_20,0@0:oid);
X_22 := bat.reverse(X_21);
- X_23 := algebra.leftjoin(X_22,X_19);
+ X_23 := algebra.leftfetchjoin(X_22,X_19);
X_24 := bat.append(X_18,X_23,true);
X_25:bat[:oid,:dbl] := batcalc.*(X_24,X_24);
X_27 := sql.resultSet(1,1,X_25);
diff --git
a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
--- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
+++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
@@ -149,7 +149,7 @@ function user.s4_1{autoCommit=true}():vo
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_34 := sql.resultSet(1,1,X_29);
sql.rsColumn(X_34,"sys.oblo","a","int",32,0,X_29);
@@ -181,7 +181,7 @@ function user.s5_1{autoCommit=true}():vo
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_36 := calc.wrd(2:wrd);
X_38 := calc.wrd(nil:wrd);
@@ -191,7 +191,7 @@ function user.s5_1{autoCommit=true}():vo
X_44 := calc.oid(0@0);
X_45 := algebra.markT(X_43,X_44);
X_46 := bat.reverse(X_45);
- X_47 := algebra.leftjoin(X_46,X_29);
+ X_47 := algebra.leftfetchjoin(X_46,X_29);
X_52 := sql.resultSet(1,1,X_47);
sql.rsColumn(X_52,"sys.oblo","a","int",32,0,X_47);
X_58 := io.stdout();
@@ -222,7 +222,7 @@ function user.s6_1{autoCommit=true}():vo
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_36 := calc.wrd(0:wrd);
X_38 := calc.wrd(2:wrd);
@@ -232,7 +232,7 @@ function user.s6_1{autoCommit=true}():vo
X_44 := calc.oid(0@0);
X_45 := algebra.markT(X_43,X_44);
X_46 := bat.reverse(X_45);
- X_47 := algebra.leftjoin(X_46,X_29);
+ X_47 := algebra.leftfetchjoin(X_46,X_29);
X_52 := sql.resultSet(1,1,X_47);
sql.rsColumn(X_52,"sys.oblo","a","int",32,0,X_47);
X_58 := io.stdout();
@@ -263,7 +263,7 @@ function user.s7_1{autoCommit=true}():vo
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_36 := calc.wrd(2:wrd);
X_38 := calc.wrd(1:wrd);
@@ -273,7 +273,7 @@ function user.s7_1{autoCommit=true}():vo
X_44 := calc.oid(0@0);
X_45 := algebra.markT(X_43,X_44);
X_46 := bat.reverse(X_45);
- X_47 := algebra.leftjoin(X_46,X_29);
+ X_47 := algebra.leftfetchjoin(X_46,X_29);
X_52 := sql.resultSet(1,1,X_47);
sql.rsColumn(X_52,"sys.oblo","a","int",32,0,X_47);
X_58 := io.stdout();
@@ -304,7 +304,7 @@ function user.s8_1{autoCommit=true}():vo
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_36 := calc.wrd(1:wrd);
X_38 := calc.wrd(2:wrd);
@@ -314,7 +314,7 @@ function user.s8_1{autoCommit=true}():vo
X_44 := calc.oid(0@0);
X_45 := algebra.markT(X_43,X_44);
X_46 := bat.reverse(X_45);
- X_47 := algebra.leftjoin(X_46,X_29);
+ X_47 := algebra.leftfetchjoin(X_46,X_29);
X_52 := sql.resultSet(1,1,X_47);
sql.rsColumn(X_52,"sys.oblo","a","int",32,0,X_47);
X_58 := io.stdout();
@@ -345,10 +345,10 @@ function user.s9_1{autoCommit=true}():vo
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
(X_34,r1_34,r2_34) := algebra.subsort(X_29,false,false);
- X_38 := algebra.leftjoin(r1_34,X_29);
+ X_38 := algebra.leftfetchjoin(r1_34,X_29);
X_43 := sql.resultSet(1,1,X_38);
sql.rsColumn(X_43,"sys.oblo","a","int",32,0,X_38);
X_50 := io.stdout();
@@ -379,10 +379,10 @@ function user.s10_1{autoCommit=true}():v
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
(X_34,r1_34,r2_34) := algebra.subsort(X_29,false,false);
- X_38 := algebra.leftjoin(r1_34,X_29);
+ X_38 := algebra.leftfetchjoin(r1_34,X_29);
X_45 := calc.wrd(2:wrd);
X_47 := calc.wrd(nil:wrd);
X_49 := calc.+(X_45,X_47);
@@ -391,7 +391,7 @@ function user.s10_1{autoCommit=true}():v
X_53 := calc.oid(0@0);
X_55 := algebra.markT(X_52,X_53);
X_56 := bat.reverse(X_55);
- X_57 := algebra.leftjoin(X_56,X_38);
+ X_57 := algebra.leftfetchjoin(X_56,X_38);
X_60 := sql.resultSet(1,1,X_57);
sql.rsColumn(X_60,"sys.oblo","a","int",32,0,X_57);
X_66 := io.stdout();
@@ -422,7 +422,7 @@ function user.s11_1{autoCommit=true}():v
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_34 := calc.wrd(0:wrd);
X_36 := calc.wrd(2:wrd);
@@ -431,7 +431,7 @@ function user.s11_1{autoCommit=true}():v
X_40 := calc.oid(0@0);
X_41 := algebra.markT(X_39,X_40);
X_42 := bat.reverse(X_41);
- X_43 := algebra.leftjoin(X_42,X_29);
+ X_43 := algebra.leftfetchjoin(X_42,X_29);
X_48 := calc.wrd(0:wrd);
X_49 := calc.wrd(2:wrd);
X_50 := calc.+(X_48,X_49);
@@ -440,7 +440,7 @@ function user.s11_1{autoCommit=true}():v
X_54 := calc.oid(0@0);
X_56 := algebra.markT(X_53,X_54);
X_57 := bat.reverse(X_56);
- X_58 := algebra.leftjoin(X_57,X_43);
+ X_58 := algebra.leftfetchjoin(X_57,X_43);
X_61 := sql.resultSet(1,1,X_58);
sql.rsColumn(X_61,"sys.oblo","a","int",32,0,X_58);
X_67 := io.stdout();
@@ -471,7 +471,7 @@ function user.s12_1{autoCommit=true}():v
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_34 := calc.wrd(0:wrd);
X_36 := calc.wrd(2:wrd);
@@ -482,7 +482,7 @@ function user.s12_1{autoCommit=true}():v
X_43 := calc.oid(0@0);
X_44 := algebra.markT(X_42,X_43);
X_45 := bat.reverse(X_44);
- X_46 := algebra.leftjoin(X_45,X_29);
+ X_46 := algebra.leftfetchjoin(X_45,X_29);
X_51 := calc.wrd(1:wrd);
X_52 := calc.wrd(2:wrd);
X_53 := calc.+(X_51,X_52);
@@ -491,7 +491,7 @@ function user.s12_1{autoCommit=true}():v
X_57 := calc.oid(0@0);
X_59 := algebra.markT(X_56,X_57);
X_60 := bat.reverse(X_59);
- X_61 := algebra.leftjoin(X_60,X_46);
+ X_61 := algebra.leftfetchjoin(X_60,X_46);
X_64 := sql.resultSet(1,1,X_61);
sql.rsColumn(X_64,"sys.oblo","a","int",32,0,X_61);
X_70 := io.stdout();
@@ -522,7 +522,7 @@ function user.s13_1{autoCommit=true}():v
X_25 := algebra.markT(X_23,X_24);
X_26 := bat.reverse(X_25);
X_27:bat[:oid,:int] := sql.bind(X_2,"sys","oblo","a",1);
- X_28 := algebra.leftjoin(X_26,X_27);
+ X_28 := algebra.leftfetchjoin(X_26,X_27);
X_29 := bat.append(X_21,X_28,true);
X_34 := calc.wrd(0:wrd);
X_36 := calc.wrd(1:wrd);
@@ -533,7 +533,7 @@ function user.s13_1{autoCommit=true}():v
X_43 := calc.oid(0@0);
X_44 := algebra.markT(X_42,X_43);
X_45 := bat.reverse(X_44);
- X_46 := algebra.leftjoin(X_45,X_29);
+ X_46 := algebra.leftfetchjoin(X_45,X_29);
X_51 := calc.wrd(2:wrd);
X_52 := calc.wrd(1:wrd);
X_53 := calc.+(X_51,X_52);
@@ -542,7 +542,7 @@ function user.s13_1{autoCommit=true}():v
X_57 := calc.oid(0@0);
X_59 := algebra.markT(X_56,X_57);
X_60 := bat.reverse(X_59);
- X_61 := algebra.leftjoin(X_60,X_46);
+ X_61 := algebra.leftfetchjoin(X_60,X_46);
X_64 := sql.resultSet(1,1,X_61);
sql.rsColumn(X_64,"sys.oblo","a","int",32,0,X_61);
X_70 := io.stdout();
diff --git
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
--- a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
+++ b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
@@ -55,7 +55,7 @@ function user.s4_1{autoCommit=true}():vo
X_20 := algebra.kdifference(X_19,X_10);
X_21 := algebra.markT(X_20,0@0:oid);
X_22 := bat.reverse(X_21);
- X_23 := algebra.leftjoin(X_22,X_19);
+ X_23 := algebra.leftfetchjoin(X_22,X_19);
X_24 := bat.append(X_18,X_23,true);
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
