MonetDB: Dec2016 - Approvals after changeset 1ba49a99910f.
Changeset: 9f6f9e7e0d3e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f6f9e7e0d3e Modified Files: sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out Branch: Dec2016 Log Message: Approvals after changeset 1ba49a99910f. diffs (12 lines): 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 @@ -57,7 +57,7 @@ function user.s6_1():void; X_3 := sql.mvc(); X_7:bat[:int] := sql.bind(X_3,"sys","test","value",0:int); C_4:bat[:oid] := sql.tid(X_3,"sys","test"); -C_18 := algebra.subselect(X_7,C_4,1:int,1:int,true,false,false); +C_18 := algebra.subselect(X_7,C_4,1:int,1:int,true,true,false); X_22 := algebra.projection(C_18,X_7); sql.resultSet(X_31,X_33,X_34,X_36,X_38,X_22); end user.s6_1; ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: Dec2016 - Approvals after changeset 1ba49a99910f.
Changeset: 2522e00678cd for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2522e00678cd Modified Files: sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out Branch: Dec2016 Log Message: Approvals after changeset 1ba49a99910f. diffs (273 lines): diff --git a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out --- a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out +++ b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out @@ -300,36 +300,36 @@ end user.s10_1; % 140 # length function user.s20_1():void; X_0:void := querylog.define("explain select name,func from functions where contains(name, \\'optimizers\\');","sequential_pipe",31:int); -X_36 := bat.new(nil:str); -X_43 := bat.append(X_36,"sys.functions"); -X_53 := bat.append(X_43,"sys.functions"); +X_35 := bat.new(nil:str); +X_42 := bat.append(X_35,"sys.functions"); +X_52 := bat.append(X_42,"sys.functions"); +X_37 := bat.new(nil:str); +X_44 := bat.append(X_37,"name"); +X_53 := bat.append(X_44,"func"); X_38 := bat.new(nil:str); -X_45 := bat.append(X_38,"name"); -X_54 := bat.append(X_45,"func"); -X_39 := bat.new(nil:str); -X_47 := bat.append(X_39,"varchar"); -X_55 := bat.append(X_47,"varchar"); -X_40 := bat.new(nil:int); -X_49 := bat.append(X_40,256:int); -X_56 := bat.append(X_49,8196:int); -X_42 := bat.new(nil:int); -X_51 := bat.append(X_42,0:int); -X_58 := bat.append(X_51,0:int); +X_46 := bat.append(X_38,"varchar"); +X_54 := bat.append(X_46,"varchar"); +X_39 := bat.new(nil:int); +X_48 := bat.append(X_39,256:int); +X_55 := bat.append(X_48,8196:int); +X_41 := bat.new(nil:int); +X_50 := bat.append(X_41,0:int); +X_57 := bat.append(X_50,0:int); X_3 := sql.mvc(); C_4:bat[:oid] := sql.tid(X_3,"sys","functions"); X_7:bat[:str] := sql.bind(X_3,"sys","functions","name",0:int); (C_10:bat[:oid],r1_12:bat[:str]) := sql.bind(X_3,"sys","functions","name",2:int); X_13:bat[:str] := sql.bind(X_3,"sys","functions","name",1:int); X_16 := sql.projectdelta(C_4,X_7,C_10,r1_12,X_13); -X_75:bat[:bit] := batalgebra.like(X_16,"%optimizers%":str); -C_23 := algebra.subselect(X_75,true,true,true,false,false); -X_26 := algebra.projection(C_23,X_16); -X_27:bat[:str] := sql.bind(X_3,"sys","functions","func",0:int); -(C_29:bat[:oid],r1_31:bat[:str]) := sql.bind(X_3,"sys","functions","func",2:int); -X_31:bat[:str] := sql.bind(X_3,"sys","functions","func",1:int); -X_33 := sql.projectdelta(C_4,X_27,C_29,r1_31,X_31); -X_34 := algebra.projection(C_23,X_33); -sql.resultSet(X_53,X_54,X_55,X_56,X_58,X_26,X_34); +X_74:bat[:bit] := batalgebra.like(X_16,"%optimizers%":str); +C_23 := algebra.subselect(X_74,true,true,true,true,false); +X_25 := algebra.projection(C_23,X_16); +X_26:bat[:str] := sql.bind(X_3,"sys","functions","func",0:int); +(C_28:bat[:oid],r1_30:bat[:str]) := sql.bind(X_3,"sys","functions","func",2:int); +X_30:bat[:str] := sql.bind(X_3,"sys","functions","func",1:int); +X_32 := sql.projectdelta(C_4,X_26,C_28,r1_30,X_30); +X_33 := algebra.projection(C_23,X_32); +sql.resultSet(X_52,X_53,X_54,X_55,X_57,X_25,X_33); end user.s20_1; #inline actions= 0 time=12 usec #remapactions= 1 time=100 usec @@ -361,36 +361,36 @@ end user.s20_1; % 144 # length function user.s22_1():void; X_0:void := querylog.define("explain select name,func from functions where not_contains(name, \\'optimizers\\');","sequential_pipe",31:int); -X_36 := bat.new(nil:str); -X_43 := bat.append(X_36,"sys.functions"); -X_53 := bat.append(X_43,"sys.functions"); +X_35 := bat.new(nil:str); +X_42 := bat.append(X_35,"sys.functions"); +X_52 := bat.append(X_42,"sys.functions"); +X_37 := bat.new(nil:str); +X_44 := bat.append(X_37,"name"); +X_53 := bat.append(X_44,"func"); X_38 := bat.new(nil:str); -X_45 := bat.append(X_38,"name"); -X_54 := bat.append(X_45,"func"); -X_39 := bat.new(nil:str); -X_47 := bat.append(X_39,"varchar"); -X_55 := bat.append(X_47,"varchar"); -X_40 := bat.new(nil:int); -X_49 := bat.append(X_40,256:int); -X_56 := bat.append(X_49,8196:int); -X_42 := bat.new(nil:int); -X_51 := bat.append(X_42,0:int); -X_58 := bat.append(X_51,0:int); +X_46 := bat.append(X_38,"varchar"); +X_54 := bat.append(X_46,"varchar"); +X_39 := bat.new(nil:int); +X_48 := bat.append(X_39,256:int); +X_55 := bat.append(X_48,8196:int); +X_41 := bat.new(nil:int); +X_50 := bat.append(X_41,0:int); +X_57 := bat.append(X_50,0:int); X_3 := sql.mvc();
MonetDB: Dec2016 - Approvals.
Changeset: fad95961255a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fad95961255a Added Files: sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 Modified Files: sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out sql/test/testdb/Tests/testdb-dump.stable.out.Windows Branch: Dec2016 Log Message: Approvals. diffs (68 lines): diff --git a/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out b/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out --- a/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out +++ b/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out @@ -69,11 +69,11 @@ function user.s8_1():void; C_4:bat[:oid] := sql.tid(X_3,"sys","dbg"); X_7:bat[:int] := sql.bind(X_3,"sys","dbg","a",0:int); X_10 := algebra.projection(C_4,X_7); -(X_11,r1_14,r2_14) := group.subgroupdone(X_10); -X_14 := algebra.projection(r1_14,X_10); +(X_11,C1_14,r2_14) := group.subgroupdone(X_10); +X_14 := algebra.projection(C1_14,X_10); X_17:bat[:int] := sql.bind(X_3,"sys","dbg","b",0:int); X_19 := algebra.projection(C_4,X_17); -X_20:bat[:lng] := aggr.subsum(X_19,X_11,r1_14,true,true); +X_20:bat[:lng] := aggr.subsum(X_19,X_11,C1_14,true,true); X_15 := bat.setKey(X_14,true); X_22:bat[:lng] := batcalc./(X_20,2:bte); X_26:bat[:lng] := batcalc.*(X_22,2:bte); @@ -155,11 +155,11 @@ function user.s20_1():void; C_4:bat[:oid] := sql.tid(X_3,"sys","dbg"); X_7:bat[:int] := sql.bind(X_3,"sys","dbg","a",0:int); X_10 := algebra.projection(C_4,X_7); -(X_11,r1_14,r2_14) := group.subgroupdone(X_10); -X_14 := algebra.projection(r1_14,X_10); +(X_11,C1_14,r2_14) := group.subgroupdone(X_10); +X_14 := algebra.projection(C1_14,X_10); X_17:bat[:int] := sql.bind(X_3,"sys","dbg","b",0:int); X_19 := algebra.projection(C_4,X_17); -X_20:bat[:lng] := aggr.subsum(X_19,X_11,r1_14,true,true); +X_20:bat[:lng] := aggr.subsum(X_19,X_11,C1_14,true,true); X_15 := bat.setKey(X_14,true); X_22:bat[:lng] := batcalc./(X_20,2:bte); X_26:bat[:lng] := batcalc.*(X_22,2:bte); diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out @@ -400,12 +400,12 @@ Ready. #SELECT * FROM sys.tablestoragemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); % .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel # table_name % schema, table, count, columnsize, heapsize, hashes, imprints, auxiliary # name -% clob,clob, bigint, bigint, bigint, bigint, bigint, hugeint # type +% clob,clob, bigint, bigint, bigint, bigint, bigint, bigint # type % 0, 0, 1, 1, 1, 1, 1, 1 # length #SELECT * FROM sys.tablestoragemodel WHERE table NOT IN (SELECT name FROM sys._tables); % .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel # table_name % schema, table, count, columnsize, heapsize, hashes, imprints, auxiliary # name -% clob,clob, bigint, bigint, bigint, bigint, bigint, hugeint # type +% clob,clob, bigint, bigint, bigint, bigint, bigint, bigint # type % 0, 0, 1, 1, 1, 1, 1, 1 # length # 16:15:38 > diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 copy from sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out copy to sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 diff --git a/sql/test/testdb/Tests/testdb-dump.stable.out.Windows b/sql/test/testdb/Tests/testdb-dump.stable.out.Windows --- a/sql/test/testdb/Tests/testdb-dump.stable.out.Windows +++ b/sql/test/testdb/Tests/testdb-dump.stable.out.Windows @@ -101174,8 +101174,8 @@ CREATE TABLE "testschema"."typestest" ( "json" JSON ); COPY 2 RECORDS INTO "testschema"."typestest" FROM stdin USING DELIMITERS '\t','\n','"'; -true 10 1 100 100 100 1e+030 1e+020 1.000 123456789 12345.678 3.1415 3.1415 3.1415 2009-04-15 24 18 3 1728000.000 108000.000 12.000 10.000 36000.000 6000.0002000.000
MonetDB: Dec2016 - Approvals.
Changeset: 363a79a5b7ce for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=363a79a5b7ce Modified Files: sql/test/BugTracker-2016/Tests/storagemodel.stable.out sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit sql/test/BugTracker-2016/Tests/storagemodel.stable.out.int128 Branch: Dec2016 Log Message: Approvals. diffs (120 lines): diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out --- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out +++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out @@ -67,7 +67,7 @@ Ready. #create table bug3923(i integer); #select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage('sys','_tables'); -% .L3, .L4,.L5,.L6,.L7,.L10, .L11, .L12, .L13, .L14 # table_name +% .L3, .L3,.L3,.L3,.L3,.L3,.L3,.L3,.L3,.L3 # table_name % schema, table, column, type, mode, typewidth, hashes, phash, imprints, sorted # name % clob,clob, clob, clob, clob, int,bigint, boolean, bigint, boolean # type % 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 # length @@ -84,7 +84,7 @@ Ready. #update storagemodelinput set "distinct" =10 where "table" ='bug3923' and "column" ='i'; [ 1] #select * from storagemodel() where "table" = 'bug3923'; -% ., ., ., ., ., ., ., ., ., ., ., ., . # table_name +% .L1, .L1,.L1,.L1,.L1,.L1,.L1,.L1,.L1,.L1, .L1,.L1,.L1 # table_name % schema, table, column, type, count, columnsize, heapsize, hashes, imprints, sorted, revsorted, unique, orderidx # name % clob,clob, clob, clob, bigint, bigint, bigint, bigint, bigint, boolean,boolean,boolean,bigint # type % 3, 7, 1, 3, 5, 5, 1, 1, 4, 5, 5, 5, 1 # length @@ -92,11 +92,11 @@ Ready. #drop table bug3923; #create table bug3923(i integer); #select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage('sys','_tables'); -% .L3, .L4,.L5,.L6,.L7,.L10, .L11, .L12, .L13, .L14 # table_name +% .L3, .L3,.L3,.L3,.L3,.L3,.L3,.L3,.L3,.L3 # table_name % schema, table, column, type, mode, typewidth, hashes, phash, imprints, sorted # name % clob,clob, clob, clob, clob, int,bigint, boolean, bigint, boolean # type -% 3, 7, 13, 8, 8, 2, 4, 5, 1, 5 # length -[ "sys", "_tables", "id", "int", "writable", 4, 2600, false, 0, NULL] +% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 # length +[ "sys", "_tables", "id", "int", "writable", 4, 0, false, 0, true] [ "sys", "_tables", "name", "varchar", "writable", 8, 0, false, 0, false ] [ "sys", "_tables", "schema_id","int", "writable", 4, 0, false, 0, NULL] [ "sys", "_tables", "query","varchar", "writable", 45, 0, false, 0, NULL] @@ -109,7 +109,7 @@ Ready. #update storagemodelinput set "distinct" =10 where "table" ='bug3923' and "column" ='i'; [ 1] #select * from storagemodel() where "table" = 'bug3923'; -% ., ., ., ., ., ., ., ., ., ., ., ., . # table_name +% .L1, .L1,.L1,.L1,.L1,.L1,.L1,.L1,.L1,.L1, .L1,.L1,.L1 # table_name % schema, table, column, type, count, columnsize, heapsize, hashes, imprints, sorted, revsorted, unique, orderidx # name % clob,clob, clob, clob, bigint, bigint, bigint, bigint, bigint, boolean,boolean,boolean,bigint # type % 3, 7, 1, 3, 5, 5, 1, 1, 4, 5, 5, 5, 1 # length diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit --- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit +++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit @@ -67,7 +67,7 @@ Ready. #create table bug3923(i integer); #select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage('sys','_tables'); -% .L3, .L4,.L5,.L6,.L7,.L10, .L11, .L12, .L13, .L14 # table_name +% .L3, .L3,.L3,.L3,.L3,.L3,.L3,.L3,.L3,.L3 # table_name % schema, table, column, type, mode, typewidth, hashes,
MonetDB: Dec2016 - Approvals: mostly adding types to explain out...
Changeset: 1a8aa1773dab for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1a8aa1773dab Modified Files: monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/mal/Tests/tst661.stable.out monetdb5/mal/Tests/tst903.stable.out monetdb5/modules/mal/Tests/call00.stable.out monetdb5/optimizer/Tests/ARexample.stable.out monetdb5/optimizer/Tests/dataflow4.stable.out monetdb5/optimizer/Tests/dataflow5.stable.out monetdb5/optimizer/Tests/inlineFunction.stable.out monetdb5/optimizer/Tests/inlineFunction2.stable.out monetdb5/optimizer/Tests/inlineFunction4.stable.out monetdb5/optimizer/Tests/projectionchain.stable.out monetdb5/optimizer/Tests/reorder00.stable.out monetdb5/optimizer/Tests/tst4004.stable.out monetdb5/optimizer/Tests/tst4030.stable.out sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.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/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.stable.out sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.stable.out.int128 sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.stable.out sql/test/BugTracker-2012/Tests/any_null.Bug-2594.stable.out sql/test/BugTracker-2012/Tests/boolean_coersion.Bug-3012.stable.out sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.stable.out sql/test/BugTracker-2012/Tests/cast-tinyint-Bug-3137.stable.out sql/test/BugTracker-2012/Tests/cast_varchar_to_double.Bug-3071.stable.out sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.stable.out sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.out sql/test/BugTracker-2012/Tests/date_script_test.Bug-2973.stable.out sql/test/BugTracker-2012/Tests/day-of-month-localization.Bug-2962.stable.out sql/test/BugTracker-2012/Tests/fixed_limit_for_prepare.Bug-3208.stable.out sql/test/BugTracker-2012/Tests/float-mod.Bug-3086.stable.out sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.out sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out.int128 sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.stable.out sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.out sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.out sql/test/BugTracker-2012/Tests/null_except_null.Bug-3040.stable.out sql/test/BugTracker-2012/Tests/order_by_on_column_exp.Bug-3193.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out.int128 sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2012/Tests/round-type-inference.Bug-2987.stable.out sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.stable.out sql/test/BugTracker-2012/Tests/server-crash.Bug-3046.stable.out sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.out sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.out sql/test/BugTracker-2012/Tests/sticky-precision.Bug-2969.stable.out sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.stable.out sql/test/BugTracker-2012/Tests/tuples_INTERSECT_vs_count_intersect_differs.Bug-2659.stable.out sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.out sql/test/BugTracker-2012/Tests/user_defined_decimal_function.Bug-2992.stable.out sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.stable.out sql/test/BugTracker-2012/Tests/with_in_derived_table.Bug-3043.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
MonetDB: Dec2016 - Approvals.
Changeset: 171fff564f68 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=171fff564f68 Modified Files: clients/Tests/MAL-signatures.stable.out Branch: Dec2016 Log Message: Approvals. diffs (69 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -5661,43 +5661,11 @@ Ready. [ "batcalc", "sign", "pattern batcalc.sign(b:bat[:sht]):bat[:bte] ", "CMDbatSIGN;", "Unary sign (-1,0,1) over the tail of the bat" ] [ "batcalc", "sign", "pattern batcalc.sign(b:bat[:sht],s:bat[:oid]):bat[:bte] ", "CMDbatSIGN;", "Unary sign (-1,0,1) over the tail of the bat with candidates list" ] [ "batcalc", "sqlblob", "command batcalc.sqlblob(v:bat[:str]):bat[:sqlblob] ", "batstr_2_sqlblob;","cast to sqlblob" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:bit]):bat[:str] ", "CMDconvertsignal_str;","cast from bit to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:bit],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from bit to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:bte]):bat[:str] ", "CMDconvertsignal_str;","cast from bte to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:bte],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from bte to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:dbl]):bat[:str] ", "CMDconvertsignal_str;","cast from dbl to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:dbl],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from dbl to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:flt]):bat[:str] ", "CMDconvertsignal_str;","cast from flt to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:flt],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from flt to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:int]):bat[:str] ", "CMDconvertsignal_str;","cast from int to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:int],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from int to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:lng]):bat[:str] ", "CMDconvertsignal_str;","cast from lng to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:lng],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from lng to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from oid to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:oid],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from oid to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:sht]):bat[:str] ", "CMDconvertsignal_str;","cast from sht to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:sht],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from sht to str with candidates list, signal error on overflow" ] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:str]):bat[:str] ", "CMDconvertsignal_str;","cast from str to str, signal error on overflow"] -[ "batcalc", "str", "pattern batcalc.str(b:bat[:str],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from str to str with candidates list, signal error on overflow" ] +[ "batcalc", "str", "pattern batcalc.str(b:bat[:any]):bat[:str] ", "CMDconvertsignal_str;","cast from any to str, signal error on overflow"] +[ "batcalc", "str", "pattern batcalc.str(b:bat[:any],s:bat[:oid]):bat[:str] ", "CMDconvertsignal_str;","cast from any to str with candidates list, signal error on overflow" ] [ "batcalc", "str", "pattern batcalc.str(eclass:int,d1:int,s1:int,has_tz:int,v:bat[:any_1],digits:int):bat[:str] ", "SQLbatstr_cast;", "cast to string and check for overflow" ] -[ "batcalc", "str_noerror", "pattern batcalc.str_noerror(b:bat[:bit]):bat[:str] ", "CMDconvert_str;", "cast from bit to str" ] -[ "batcalc", "str_noerror", "pattern batcalc.str_noerror(b:bat[:bit],s:bat[:oid]):bat[:str] ", "CMDconvert_str;", "cast from bit to str with
MonetDB: Dec2016 - Approvals.
Changeset: 86d00c6c6a7e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=86d00c6c6a7e Modified Files: sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: Dec2016 Log Message: Approvals. diffs (162 lines): diff --git a/sql/test/Tests/systemfunctions.stable.out b/sql/test/Tests/systemfunctions.stable.out --- a/sql/test/Tests/systemfunctions.stable.out +++ b/sql/test/Tests/systemfunctions.stable.out @@ -55,7 +55,7 @@ Ready. # 16:20:25 > #select s.name as "schema", f.name as "function", a.number as "argno", a.type as "argtype", case a.number when 0 then f.func else '' end as "definition" from sys.functions f, sys.schemas s, sys.args a where s.id = f.schema_id and f.id = a.func_id and f.id in (select * from sys.systemfunctions) order by s.name, f.name, f.id, a.number; -% sys.L4, sys.L5, sys.L6, sys.L7, sys.L10 # table_name +% sys.L14, sys.L16,sys.L20,sys.L22,sys.L24 # table_name % schema, function, argno, argtype,definition # name % varchar, varchar,int,varchar,varchar # type % 8, 35, 2, 14, 611 # length @@ -3051,9 +3051,9 @@ Ready. [ "sys", "setmasklen", 0, "inet", "create function \"setmasklen\" (p inet, mask int) returns inet\n external name inet.\"setmasklen\";" ] [ "sys", "setmasklen", 1, "inet", "" ] [ "sys", "setmasklen", 2, "int", "" ] -[ "sys", "setsession", 0, "bigint", "create procedure sys.setsession(\"timeout\" bigint)\n external name sql.setsession;" ] -[ "sys", "settimeout", 0, "bigint", "create procedure sys.settimeout(\"query\" bigint)\n external name sql.settimeout;" ] -[ "sys", "settimeout", 0, "bigint", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint)\n external name sql.settimeout;" ] +[ "sys", "setsession", 0, "bigint", "create procedure sys.setsession(\"timeout\" bigint)\n external name clients.setsession;" ] +[ "sys", "settimeout", 0, "bigint", "create procedure sys.settimeout(\"query\" bigint)\n external name clients.settimeout;" ] +[ "sys", "settimeout", 0, "bigint", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint)\n external name clients.settimeout;" ] [ "sys", "settimeout", 1, "bigint", "" ] [ "sys", "shpattach",0, "clob", "create procedure shpattach(fname string) external name shp.attach;"] [ "sys", "shpload", 0, "int", "create procedure shpload(fid integer) external name shp.load;" ] diff --git a/sql/test/Tests/systemfunctions.stable.out.int128 b/sql/test/Tests/systemfunctions.stable.out.int128 --- a/sql/test/Tests/systemfunctions.stable.out.int128 +++ b/sql/test/Tests/systemfunctions.stable.out.int128 @@ -55,7 +55,7 @@ Ready. # 16:20:25 > #select s.name as "schema", f.name as "function", a.number as "argno", a.type as "argtype", case a.number when 0 then f.func else '' end as "definition" from sys.functions f, sys.schemas s, sys.args a where s.id = f.schema_id and f.id = a.func_id and f.id in (select * from sys.systemfunctions) order by s.name, f.name, f.id, a.number; -% sys.L4, sys.L5, sys.L6, sys.L7, sys.L10 # table_name +% sys.L14, sys.L16,sys.L20,sys.L22,sys.L24 # table_name % schema, function, argno, argtype,definition # name % varchar, varchar,int,varchar,varchar # type % 8, 35, 2, 14, 611 # length @@ -3413,9 +3413,9 @@ Ready. [ "sys", "setmasklen", 0, "inet", "create function \"setmasklen\" (p inet, mask int) returns inet\n external name inet.\"setmasklen\";" ] [ "sys", "setmasklen", 1, "inet", "" ] [ "sys", "setmasklen", 2, "int", "" ] -[ "sys", "setsession", 0, "bigint", "create procedure sys.setsession(\"timeout\" bigint)\n external name sql.setsession;" ] -[ "sys", "settimeout", 0, "bigint", "create procedure sys.settimeout(\"query\" bigint)\n external name sql.settimeout;" ] -[ "sys", "settimeout", 0, "bigint", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint)\n external name sql.settimeout;" ] +[ "sys", "setsession", 0,
MonetDB: Dec2016 - Approvals.
Changeset: a9cd088f96b5 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a9cd088f96b5 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.32bit sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/emptydb/Tests/load.stable.out Branch: Dec2016 Log Message: Approvals. diffs (truncated from 1056 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -57,7 +57,7 @@ Ready. # 14:39:22 > #select * from sys.malfunctions() order by module, "function", address, signature, comment; -% ., ., ., ., . # table_name +% .L1, .L1,.L1,.L1,.L1 # table_name % module, function, signature, address,comment # name % clob,clob, clob, clob, clob # type % 11, 28, 346,44, 874 # length @@ -7443,9 +7443,9 @@ Ready. [ "clients", "setListing", "pattern clients.setListing(flag:int):int ", "CLTsetListing;", "Turn on/off echo of MAL instructions:\n\t1 - echo input,\n\t2 - show mal instruction,\n\t4 - show details of type resolutoin, \n\t8 - show binding information." ] [ "clients", "setPassword", "pattern clients.setPassword(user:str,pass:str):void ", "CLTsetPassword;", "Set the password for the given user" ] [ "clients", "setScenario", "pattern clients.setScenario(msg:str):str ", "CLTsetScenario;", "Switch to other scenario handler, return previous one."] -[ "clients", "setTimeout", "pattern clients.setTimeout(q:lng,s:lng):void ","CLTsetTimeout;", "Abort a query after q seconds (q=0 means run undisturbed).\nThe session timeout aborts the connection after spending too\nmany seconds on query processing." ] [ "clients", "setsession", "pattern clients.setsession(n:lng):void ", "CLTsetSessionTimeout;","Abort a session after n seconds." ] [ "clients", "settimeout", "pattern clients.settimeout(n:lng):void ", "CLTsetTimeout;", "Abort a query after n seconds." ] +[ "clients", "settimeout", "pattern clients.settimeout(q:lng,s:lng):void ","CLTsetTimeout;", "Abort a query after q seconds (q=0 means run undisturbed).\nThe session timeout aborts the connection after spending too\nmany seconds on query processing." ] [ "clients", "sha1sum", "command clients.sha1sum(pw:str):str ", "CLTsha1sum;", "Return hex string representation of the SHA-1 hash of the given string"] [ "clients", "sha2sum", "command clients.sha2sum(pw:str,bits:int):str ","CLTsha2sum;", "Return hex string representation of the SHA-2 hash with bits of the given string" ] [ "clients", "shutdown", "pattern clients.shutdown(delay:int):str ", "CLTshutdown;", "" ] @@ -8466,8 +8466,6 @@ Ready. [ "sql", "row_number", "pattern sql.row_number(b:any_1,p:bit,o:bit):int ", "SQLrow_number;", "return the row_numer-ed groups"] [ "sql", "sessions", "pattern sql.sessions() (user:bat[:str],start:bat[:timestamp],stimeout:bat[:lng],lastcmd:bat[:timestamp],qtimeout:bat[:lng],idle:bat[:bit]) ", "sql_sessions_wrap;", "SQL export table of active sessions, their timeouts and idle status" ] [ "sql", "setVariable", "pattern sql.setVariable(mvc:int,varname:str,value:any_1):int ","setVariable;", "Set the value of a session variable" ] -[ "sql", "settimeout", "pattern sql.settimeout(s:lng):void ", "CLTsetTimeout;", "Abort query after s seconds" ] -[ "sql", "settimeout", "pattern sql.settimeout(s:lng,t:lng):void ", "CLTsetTimeout;", "Abort query after s and session after t seconds" ] [ "sql", "shrink", "pattern sql.shrink(sch:str,tbl:str):void ", "SQLshrink;", "Consolidate the deletion table over all columns using shrinking" ] [ "sql", "shutdown", "pattern sql.shutdown(delay:bte):str ", "SQLshutdown_wrap;","" ] [ "sql", "shutdown", "pattern sql.shutdown(delay:bte,force:bit):str ", "SQLshutdown_wrap;",
MonetDB: Dec2016 - Approvals.
Changeset: fd159fa212fa for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd159fa212fa Modified Files: sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 sql/benchmarks/tpch/Tests/01-plan.stable.out sql/benchmarks/tpch/Tests/03-plan.stable.out sql/benchmarks/tpch/Tests/05-plan.stable.out sql/benchmarks/tpch/Tests/06-plan.stable.out sql/benchmarks/tpch/Tests/07-plan.stable.out sql/benchmarks/tpch/Tests/08-plan.stable.out sql/benchmarks/tpch/Tests/09-plan.stable.out sql/benchmarks/tpch/Tests/10-plan.stable.out sql/benchmarks/tpch/Tests/11-plan.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/14-plan.stable.out sql/benchmarks/tpch/Tests/15-plan.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 sql/benchmarks/tpch/Tests/17-plan.stable.out sql/benchmarks/tpch/Tests/18-plan.stable.out sql/benchmarks/tpch/Tests/19-plan.stable.out sql/benchmarks/tpch/Tests/20-explain.stable.out.int128 sql/benchmarks/tpch/Tests/20-plan.stable.out Branch: Dec2016 Log Message: Approvals. diffs (truncated from 958 to 300 lines): diff --git a/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 b/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 --- a/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 +++ b/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 @@ -50,112 +50,112 @@ Ready. % .explain # table_name % mal # name % clob # type -% 109 # length +% 124 # length function user.main():void; -X_844 := bat.new(nil:str); -X_851 := bat.append(X_844,"sys.lineitem"); -X_861 := bat.append(X_851,"sys.lineitem"); -X_867 := bat.append(X_861,"sys.L5"); -X_877 := bat.append(X_867,"sys.L10"); -X_884 := bat.append(X_877,"sys.L13"); -X_892 := bat.append(X_884,"sys.L16"); -X_900 := bat.append(X_892,"sys.L21"); -X_910 := bat.append(X_900,"sys.L24"); -X_917 := bat.append(X_910,"sys.L27"); -X_924 := bat.append(X_917,"sys.L32"); -X_846 := bat.new(nil:str); -X_853 := bat.append(X_846,"l_returnflag"); -X_862 := bat.append(X_853,"l_linestatus"); -X_869 := bat.append(X_862,"sum_qty"); -X_879 := bat.append(X_869,"sum_base_price"); -X_886 := bat.append(X_879,"sum_disc_price"); -X_894 := bat.append(X_886,"sum_charge"); -X_902 := bat.append(X_894,"avg_qty"); -X_912 := bat.append(X_902,"avg_price"); -X_919 := bat.append(X_912,"avg_disc"); -X_926 := bat.append(X_919,"count_order"); -X_847 := bat.new(nil:str); -X_855 := bat.append(X_847,"char"); -X_864 := bat.append(X_855,"char"); -X_871 := bat.append(X_864,"decimal"); -X_881 := bat.append(X_871,"decimal"); -X_888 := bat.append(X_881,"decimal"); -X_896 := bat.append(X_888,"decimal"); -X_904 := bat.append(X_896,"double"); -X_914 := bat.append(X_904,"double"); -X_921 := bat.append(X_914,"double"); -X_928 := bat.append(X_921,"bigint"); -X_848 := bat.new(nil:int); -X_857 := bat.append(X_848,1); -X_865 := bat.append(X_857,1); -X_873 := bat.append(X_865,39); -X_882 := bat.append(X_873,39); -X_889 := bat.append(X_882,39); -X_897 := bat.append(X_889,39); -X_906 := bat.append(X_897,53); -X_915 := bat.append(X_906,53); -X_922 := bat.append(X_915,53); -X_930 := bat.append(X_922,64); -X_850 := bat.new(nil:int); -X_859 := bat.append(X_850,0); -X_866 := bat.append(X_859,0); -X_875 := bat.append(X_866,2); -X_883 := bat.append(X_875,2); -X_890 := bat.append(X_883,4); -X_898 := bat.append(X_890,6); -X_908 := bat.append(X_898,0); -X_916 := bat.append(X_908,0); -X_923 := bat.append(X_916,0); -X_932 := bat.append(X_923,0); -X_710 := sql.mvc(); -X_714:bat[:date] := sql.bind(X_710,"sys","lineitem","l_shipdate",0); -C_711:bat[:oid] := sql.tid(X_710,"sys","lineitem"); -X_726:date := mtime.date_sub_msec_interval("1998-12-01",777600); -C_727 := algebra.thetasubselect(X_714,C_711,X_726,"<="); -X_729:bat[:str] := sql.bind(X_710,"sys","lineitem","l_linestatus",0); -X_736 := algebra.projection(C_727,X_729); -X_737:bat[:str] := sql.bind(X_710,"sys","lineitem","l_returnflag",0); -X_744 := algebra.projection(C_727,X_737); -(X_745,r1_44,r2_44) := group.subgroup(X_744); -(X_748,r1_47,r2_47) := group.subgroupdone(X_736,X_745); -X_751 := algebra.projection(r1_47,X_736); -X_752 := algebra.projection(r1_47,X_744); -X_763:bat[:lng] := sql.bind(X_710,"sys","lineitem","l_quantity",0); -X_770 := algebra.projection(C_727,X_763); -X_771:bat[:hge] := aggr.subsum(X_770,X_748,r1_47,true,true); -X_775:bat[:lng] := sql.bind(X_710,"sys","lineitem","l_extendedprice",0); -X_782 := algebra.projection(C_727,X_775); -X_783:bat[:hge] := aggr.subsum(X_782,X_748,r1_47,true,true); -X_793:bat[:lng] :=