Changeset: 40ef2a80703a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/40ef2a80703a
Added Files:
        sql/test/BugTracker-2026/Tests/7787-assertion-failure.test
Modified Files:
        sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:

Add test for #7787


diffs (29 lines):

diff --git a/sql/test/BugTracker-2026/Tests/7787-assertion-failure.test 
b/sql/test/BugTracker-2026/Tests/7787-assertion-failure.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7787-assertion-failure.test
@@ -0,0 +1,13 @@
+statement ok
+CREATE TABLE v0 ( v1 INTEGER )
+
+statement error 42000!SELECT: no such operator 'stddev'(boolean)
+SELECT v1 >= -2147483648 AND STDDEV ( v1 NOT LIKE 'x' ) <= 'x' + CUME_DIST ( 
DISTINCT STDDEV ( v1 ) ) FROM v0
+
+-- sql/backends/monet5/sql_execute.c:57: SQLrun: Assertion `!*m->errstr' 
failed.
+statement error 42000!SELECT: no such operator 'stddev'(boolean)
+ALTER TABLE v0 ADD COLUMN v2 INTEGER DEFAULT 2 NOT NULL PRIMARY KEY CHECK ( v1 
>= -2147483648 AND STDDEV ( v2 NOT LIKE 'x' ) <= 'x' + CUME_DIST ( DISTINCT 
STDDEV ( v1 ) ) )
+
+statement ok
+DROP TABLE v0
+
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
@@ -12,6 +12,7 @@ KNOWNFAIL?7781-truncate-sys-tables-corru
 7783-deleted-row
 KNOWNFAIL?7785-recursive-cte-loops-infinitly
 7786-rename-drop-table
+7787-assertion-failure
 7804-querylog-catalog-orderby-bug
 7805-orderby-all-bug
 7806-numeric-no-prec-no-scale
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to