Changeset: 43f5390a57d0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/43f5390a57d0 Added Files: sql/test/BugTracker-2023/Tests/ifnull-6933.test Modified Files: sql/test/BugTracker-2023/Tests/All Branch: Dec2023 Log Message:
Add tests for request 6933 diffs (53 lines): diff --git a/sql/test/BugTracker-2023/Tests/All b/sql/test/BugTracker-2023/Tests/All --- a/sql/test/BugTracker-2023/Tests/All +++ b/sql/test/BugTracker-2023/Tests/All @@ -1,3 +1,4 @@ +ifnull-6933 ambiguous-identifiers-7372 temp-table-foreign-key-crash-7378 update-mask-id-crash-7379 diff --git a/sql/test/BugTracker-2023/Tests/ifnull-6933.test b/sql/test/BugTracker-2023/Tests/ifnull-6933.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2023/Tests/ifnull-6933.test @@ -0,0 +1,40 @@ +statement ok +create unlogged table t6933 (i int, c varchar(8)); + +statement ok +insert into t6933 values (1, 'aa1'), (2, null), (null, 'bb2'), (null, null); + +query ITTTIT +select i, c, IFNULL(i, c) as "IFNULL(i,c)", IFNULL(c, i) as "IFNULL(c,i)", ifnull(i, 999) as "ifnull(i,999)", ifnull(c, 'has null') as "ifnull(c,'x')" from t6933; +---- +1 +aa1 +1 +aa1 +1 +aa1 +2 +NULL +2 +2 +2 +has null +NULL +bb2 +bb2 +bb2 +999 +bb2 +NULL +NULL +NULL +NULL +999 +has null + +statement error syntax error, unexpected ',', expecting ')' or OR in: "select i, c, ifnull(i, c," +select i, c, IFNULL(i, c, 999) as "IFNULL(i,c,999)" from t6933; + +statement ok +drop table t6933; + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
