Changeset: 8f559662d114 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8f559662d114
Added Files:
        sql/test/BugTracker-2026/Tests/7804-querylog-catalog-orderby-bug.test
Modified Files:
        sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:

Add test for issue #7804


diffs (55 lines):

diff --git 
a/sql/test/BugTracker-2026/Tests/7804-querylog-catalog-orderby-bug.test 
b/sql/test/BugTracker-2026/Tests/7804-querylog-catalog-orderby-bug.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7804-querylog-catalog-orderby-bug.test
@@ -0,0 +1,42 @@
+statement ok
+call sys.querylog_enable()
+
+statement ok
+call sys.querylog_enable(1000)
+
+statement ok
+call sys.querylog_enable()
+
+# next query (without keyword: desc) works ok
+query TT
+select "owner", "pipe" from sys.querylog_catalog order by id
+----
+monetdb
+default_pipe
+monetdb
+default_pipe
+monetdb
+default_pipe
+
+# next query (with added: desc) crashes mserver5
+# gdk/gdk_bat.c:2703: BATassertProps: Assertion `b->tsorted' failed.
+query TT
+select "owner", "pipe" from sys.querylog_catalog order by id desc
+----
+monetdb
+default_pipe
+monetdb
+default_pipe
+monetdb
+default_pipe
+monetdb
+default_pipe
+
+
+# disable and cleanup
+statement ok
+call sys.querylog_disable()
+
+statement ok
+call sys.querylog_empty()
+
diff --git a/sql/test/BugTracker-2026/Tests/All 
b/sql/test/BugTracker-2026/Tests/All
--- a/sql/test/BugTracker-2026/Tests/All
+++ b/sql/test/BugTracker-2026/Tests/All
@@ -1,3 +1,4 @@
 7780-unnest-slow
 7782-roles-view
 7783-deleted-row
+KNOWNFAIL?7804-querylog-catalog-orderby-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to