Changeset: 567582612f6f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=567582612f6f
Added Files:
sql/test/BugTracker-2018/Tests/aggr-in-case.Bug-6526.sql
Modified Files:
sql/test/BugTracker-2018/Tests/All
Branch: Jul2017
Log Message:
Added test for bug 6526.
diffs (75 lines):
diff --git a/sql/test/BugTracker-2018/Tests/All
b/sql/test/BugTracker-2018/Tests/All
--- a/sql/test/BugTracker-2018/Tests/All
+++ b/sql/test/BugTracker-2018/Tests/All
@@ -1,10 +1,10 @@
HAVE_LIBPY?pyUDF-crash.Bug-6508
HAVE_HGE?sqlitelogictest-wrong-aggregation-count.Bug-6510
sqlitelogictest-wrong-select-not-between.Bug-6511
+case_with_orderby_limit.Bug-6512
sqlitelogictest-wrong-mal-function-generation.Bug-6513
sqlitelogictest-select-range-null.Bug-6514
insert-null-second-interval-0.Bug-6515
-case_with_orderby_limit.Bug-6512
sqlitelogictest-bat-undefined.Bug-6516
sqlitelogictest-overflow-in-conversion.Bug-6517
HAVE_HGE?sqlitelogictest-count-not-in.Bug-6518
@@ -12,4 +12,5 @@ sqlitelogictest-algebra-join-not-in.Bug-
update-with-correlated-subquery.Bug-6520
sqlitelogictest-in-single-column.Bug-6522
sqlitelogictest-case-subquery-missing.Bug-6523
+aggr-in-case.Bug-6526
crash-orderby-alias.Bug-6527
diff --git a/sql/test/BugTracker-2018/Tests/aggr-in-case.Bug-6526.sql
b/sql/test/BugTracker-2018/Tests/aggr-in-case.Bug-6526.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/aggr-in-case.Bug-6526.sql
@@ -0,0 +1,49 @@
+start transaction;
+
+create table "t1" (
+ "id" int,
+ "c1" varchar(100),
+ "d1" int,
+ "d2" int
+);
+
+insert into "t1" values
+(1, 'A', 50, 80),
+(2, 'A', 200, 350),
+(3, 'A', 89, 125),
+(4, 'B', 4845, 13),
+(5, 'B', 194, 597),
+(6, 'C', 5636, 5802),
+(7, 'C', 375, 3405),
+(7, 'D', 365, 0),
+(7, 'D', 87, 0);
+
+-- Works
+select
+ "c1",
+ sum("d1") as "d1",
+ sum("d2") as "d2"
+from "t1"
+group by "c1"
+having sum("d1") < case when 5 > 10 then 500 else 400 end;
+
+-- Works
+select
+ "c1",
+ sum("d1")as "d1",
+ sum("d2") as "d2",
+ 1.0 * sum("d1") / (1.0 * case when sum("d2") > 0 then sum("d2") else null
end) as "formula"
+from "t1"
+group by "c1";
+
+-- Crashes
+select
+ "c1",
+ sum("d1")as "d1",
+ sum("d2") as "d2",
+ 1.0 * sum("d1") / (1.0 * case when sum("d2") > 0 then sum("d2") else null
end) as "formula"
+from "t1"
+group by "c1"
+having (1.0 * sum("d1") / (1.0 * case when sum("d2") > 0 then sum("d2") else
null end)) > 1;
+
+rollback;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
