Changeset: c83958a6e83f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c83958a6e83f Added Files: sql/test/BugTracker-2024/Tests/order-by-false-or-false-Bug-7456.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7456 diffs (61 lines): diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -22,3 +22,4 @@ function_return_issue where_null-7450 between-boolean-7451 concat_order-7455 +order-by-false-or-false-Bug-7456 diff --git a/sql/test/BugTracker-2024/Tests/order-by-false-or-false-Bug-7456.test b/sql/test/BugTracker-2024/Tests/order-by-false-or-false-Bug-7456.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/order-by-false-or-false-Bug-7456.test @@ -0,0 +1,48 @@ +query I +SELECT false +---- +0 + +query I +SELECT ((false)OR(false)) +---- +0 + +statement ok +CREATE TABLE t0(c0 BOOLEAN) + +-- when using order by false it works, when using order by false or false it fails +statement ok +CREATE VIEW v0(c0) AS SELECT 1 FROM t0 HAVING true ORDER BY false + +query I +SELECT * FROM v0 +---- +1 + +query II +SELECT * FROM t0 INNER JOIN v0 ON v0.c0 +---- + +statement ok +DROP VIEW v0 + +-- repeat with using order by false or false +statement ok +CREATE VIEW v0(c0) AS SELECT 1 FROM t0 HAVING true ORDER BY ((false)OR(false)) + +query I +SELECT * FROM v0 +---- +1 + +-- Program terminated with signal SIGSEGV, Segmentation fault in bin_find_smallest_column () from lib64/libmonetdbsql.so.14 +query II +SELECT * FROM t0 INNER JOIN v0 ON v0.c0 +---- + +statement ok +DROP VIEW v0 + +statement ok +DROP TABLE t0 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
