Changeset: 54caa5ce0edb for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=54caa5ce0edb Added Files: sql/test/BugTracker-2017/Tests/coalesc-limit.Bug-6316.sql sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: default Log Message:
Another bug detected with sqlsmith diffs (31 lines): diff --git a/sql/test/BugTracker-2017/Tests/All b/sql/test/BugTracker-2017/Tests/All --- a/sql/test/BugTracker-2017/Tests/All +++ b/sql/test/BugTracker-2017/Tests/All @@ -55,3 +55,5 @@ lateral.Bug-6310 limit_clause.Bug-6312 type-resolution-error.Bugs-6313 lateral02.Bug-6314 +exist-bigint-missing.Bug-6315 +coalesc-limit.Bug-6316 diff --git a/sql/test/BugTracker-2017/Tests/coalesc-limit.Bug-6316.sql b/sql/test/BugTracker-2017/Tests/coalesc-limit.Bug-6316.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/coalesc-limit.Bug-6316.sql @@ -0,0 +1,5 @@ +-- test for Bug 6316 +select role_id, + cast(coalesce(role_id, login_id) as int) +from sys.user_role +limit 145; diff --git a/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql b/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql @@ -0,0 +1,7 @@ +select + case when EXISTS ( select hashes from sys.tablestoragemodel ) + then (true) + else (false) + end +from sys.tables; + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
