Changeset: 511a0fbebd3c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=511a0fbebd3c Modified Files: sql/test/Tests/alastair_udf_mergetable_bug.py sql/test/Tests/alastair_udf_mergetable_bug.stable.out Branch: default Log Message:
added casts (convert float to int before calling fuse) approved output diffs (30 lines): diff --git a/sql/test/Tests/alastair_udf_mergetable_bug.py b/sql/test/Tests/alastair_udf_mergetable_bug.py --- a/sql/test/Tests/alastair_udf_mergetable_bug.py +++ b/sql/test/Tests/alastair_udf_mergetable_bug.py @@ -23,7 +23,7 @@ insert into tab2 values (1,111),(2,222), set optimizer='default_pipe'; select optimizer; -select tab1.group_by_col,SUM(fuse(tab1.f,tab2.f)) from tab2 inner join tab1 on tab1.index_col = tab2.index_col group by tab1.group_by_col; +select tab1.group_by_col,SUM(fuse(cast (tab1.f as INT),cast (tab2.f as INT))) from tab2 inner join tab1 on tab1.index_col = tab2.index_col group by tab1.group_by_col; drop table tab1; drop table tab2; diff --git a/sql/test/Tests/alastair_udf_mergetable_bug.stable.out b/sql/test/Tests/alastair_udf_mergetable_bug.stable.out --- a/sql/test/Tests/alastair_udf_mergetable_bug.stable.out +++ b/sql/test/Tests/alastair_udf_mergetable_bug.stable.out @@ -18,10 +18,10 @@ stdout of test 'alastair_udf_mergetable_ % varchar # type % 12 # length [ "default_pipe" ] -#select tab1.group_by_col,SUM(fuse(tab1.f,tab2.f)) from tab2 inner join tab1 on tab1.index_col = tab2.index_col group by tab1.group_by_col; -% sys.tab1, sys.L1 # table_name -% group_by_col, L1 # name -% int, bigint # type +#select tab1.group_by_col,SUM(fuse(cast (tab1.f as INT),cast (tab2.f as INT))) from tab2 inner join tab1 on tab1.index_col = tab2.index_col group by tab1.group_by_col; +% sys.tab1, sys.L3 # table_name +% group_by_col, L3 # name +% int, hugeint # type % 1, 11 # length [ 1, 12884902221 ] [ 2, 30064771405 ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
