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

Add test for #7771


diffs (45 lines):

diff --git a/sql/test/BugTracker-2026/Tests/7771-assertion-failure.test 
b/sql/test/BugTracker-2026/Tests/7771-assertion-failure.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7771-assertion-failure.test
@@ -0,0 +1,29 @@
+statement ok
+CREATE TABLE v0 ( v1 FLOAT )
+
+statement ok
+INSERT INTO v0 VALUES ( 83386963.000000 )
+
+query I nosort
+SELECT 0 FROM v0 WHERE ( v1 = -128 AND v1 = -1 ) OR ( v1 * ( SELECT -128 FROM 
( SELECT v1 AS v2 , ( 0 < v1 AND v1 < 'x' ) FROM v0 BOOLEAN GROUP BY v1 * 12 , 
v1 ) ) + v1 )
+----
+0
+
+query R nosort
+SELECT v1 FROM v0
+----
+83386963.000
+
+-- sql/backends/monet5/sql_statement.c:4610: stmt_alias_: Assertion `label' 
failed.
+statement ok
+INSERT INTO v0 VALUES ( 0 ) , ( 16 ) , ( 12 ) , ( 34 ) , ( 16 ) , ( -32768 ) , 
( 255 )
+ , ( ( SELECT 0 FROM v0 WHERE ( v1 = -128 AND v1 = -1 ) OR ( v1 * ( SELECT 
-128 FROM ( SELECT v1 AS v2 , ( 0 < v1 AND v1 < 'x' ) FROM v0 BOOLEAN GROUP BY 
v1 * 12 , v1 ) ) + v1 ) ) )
+
+query I nosort
+SELECT count(*) FROM v0
+----
+9
+
+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
@@ -2,6 +2,7 @@
 7767-assertion-failure
 7769-assertion-failure
 7770-assertion-failure
+7771-assertion-failure
 7780-unnest-slow
 7782-roles-view
 7783-deleted-row
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to