Changeset: 4932665f33d4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4932665f33d4
Modified Files:
sql/test/miscellaneous/Tests/groupby_error.sql
sql/test/miscellaneous/Tests/groupby_error.stable.out
Branch: Jun2020
Log Message:
Approved output after changeset ef41ae0f5e1c Added new failing queries from
batcalc changes.
diffs (53 lines):
diff --git a/sql/test/miscellaneous/Tests/groupby_error.sql
b/sql/test/miscellaneous/Tests/groupby_error.sql
--- a/sql/test/miscellaneous/Tests/groupby_error.sql
+++ b/sql/test/miscellaneous/Tests/groupby_error.sql
@@ -45,6 +45,25 @@ SELECT col0 FROM tab0 ORDER BY tab0.col0
-- 87
-- 97
+SELECT DISTINCT 99 col2 FROM tab1 WHERE NOT - ( 43 ) + + 98 = + col2;
+ -- 99
+
+SELECT * FROM tab2 AS cor0 WHERE NOT - 59 + + 47 <> + ( + col0 );
+ -- empty
+
+SELECT + col2 * col2 FROM tab2 AS cor0 WHERE NOT - CAST ( NULL AS INTEGER ) <>
- - col1 AND NOT NULL NOT BETWEEN ( NULL ) AND - 91 - - + 27 * + col2;
+ -- empty
+
+SELECT + 2 FROM tab0 AS cor0 WHERE NOT - 29 IS NULL OR NOT NULL IS NULL AND
NOT NULL BETWEEN + col1 - + 60 AND + 37 * + col1 + + col0;
+ -- 2
+ -- 2
+ -- 2
+
+SELECT DISTINCT * FROM tab2 WHERE NOT ( - + 50 + ( 70 ) ) = + col2;
+ -- 64 77 40
+ -- 46 51 23
+ -- 75 67 58
+
SELECT col0 FROM tab0 ORDER BY sys.tab0.col0; --error, TODO
prepare select col0 from tab0 where (?) in (select col0 from tab0);
diff --git a/sql/test/miscellaneous/Tests/groupby_error.stable.out
b/sql/test/miscellaneous/Tests/groupby_error.stable.out
--- a/sql/test/miscellaneous/Tests/groupby_error.stable.out
+++ b/sql/test/miscellaneous/Tests/groupby_error.stable.out
@@ -112,6 +112,20 @@ stdout of test 'groupby_error` in direct
% col0, col1, col2 # name
% int, int, int # type
% 1, 1, 1 # length
+#SELECT * FROM tab2 AS cor0 WHERE NOT - ( - + 57 ) + - ( ( - - col2 ) )
BETWEEN + - col2 AND + col2;
+% sys.cor0, sys.cor0, sys.cor0 # table_name
+% col0, col1, col2 # name
+% int, int, int # type
+% 2, 2, 2 # length
+[ 46, 51, 23 ]
+#SELECT col0 FROM tab2 WHERE - - col2;
+% sys.tab2 # table_name
+% col0 # name
+% int # type
+% 2 # length
+[ 64 ]
+[ 75 ]
+[ 46 ]
#PLAN SELECT col0 FROM tab2 WHERE CAST(col2 AS BIGINT) = 40;
% .plan # table_name
% rel # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
