Changeset: 35ca77fd20ef for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=35ca77fd20ef
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
sql/test/SQLancer/Tests/sqlancer05.stable.out
Branch: Oct2020
Log Message:
This is a rel_push_project_down optimizer issue
diffs (24 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer05.sql
b/sql/test/SQLancer/Tests/sqlancer05.sql
--- a/sql/test/SQLancer/Tests/sqlancer05.sql
+++ b/sql/test/SQLancer/Tests/sqlancer05.sql
@@ -446,4 +446,5 @@ join (select 1, '1', cast(l1v57.vc1 as b
v5 as l1v5, v76 as l1v76) as sub1 on false) with check option;
WITH cte0(c0,c1,c2) AS (SELECT CAST('1' AS INT), 1, 0.82 FROM v82 AS l1v82)
SELECT 1 FROM cte0 AS l0cte0;
+ --rel_push_project_down optimizer issue
ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.out
b/sql/test/SQLancer/Tests/sqlancer05.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer05.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.out
@@ -532,6 +532,11 @@ stdout of test 'sqlancer05` in directory
#select case l0cte1.c1 when true then least(null, l0cte1.c0) end, 1 from cte1
as l0cte1
#join (select 1, '1', cast(l1v57.vc1 as bigint) from v57 as l1v57,
#v5 as l1v5, v76 as l1v76) as sub1 on false) with check option;
+#WITH cte0(c0,c1,c2) AS (SELECT CAST('1' AS INT), 1, 0.82 FROM v82 AS l1v82)
SELECT 1 FROM cte0 AS l0cte0;
+% .%34 # table_name
+% %34 # name
+% tinyint # type
+% 1 # length
#ROLLBACK;
# 12:00:38 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
