Changeset: e946d6eed01a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e946d6eed01a Modified Files: sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.sql sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out Branch: default Log Message:
Variants of SELECT query still produce same assertion failure as reported in bug 3705 Extended test case with those SELECTs and reopened bug 3705 diffs (39 lines): diff --git a/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.sql b/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.sql --- a/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.sql +++ b/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.sql @@ -1,4 +1,7 @@ CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER, d INTEGER, e INTEGER); INSERT INTO t1(e,c,b,d,a) VALUES(103,102,100,101,104); SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1; +SELECT abs(b-c) FROM t1; +SELECT abs(b-c), CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1; +SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, abs(b-c) FROM t1; drop table t1; diff --git a/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out b/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out --- a/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out +++ b/sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out @@ -34,6 +34,24 @@ Ready. % bigint # type % 4 # length [ 1000 ] +#SELECT abs(b-c) FROM t1; +% sys.L1 # table_name +% abs_sql_sub_b # name +% bigint # type +% 1 # length +[ 2 ] +#SELECT abs(b-c), CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1; +% sys.L1, sys.L1 # table_name +% abs_sql_sub_b, ifthenelse_isnull_>_c # name +% bigint, bigint # type +% 1, 4 # length +[ 2, 1000 ] +#SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, abs(b-c) FROM t1; +% sys.L1, sys.L1 # table_name +% ifthenelse_isnull_>_c, abs_sql_sub_b # name +% bigint, bigint # type +% 4, 1 # length +[ 1000, 2 ] #drop table t1; # 12:40:01 > _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
