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

Add test for #7766


diffs (30 lines):

diff --git a/sql/test/BugTracker-2026/Tests/7766-assertion-failure.test 
b/sql/test/BugTracker-2026/Tests/7766-assertion-failure.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7766-assertion-failure.test
@@ -0,0 +1,17 @@
+statement ok
+CREATE TABLE v0 ( v1 FLOAT , v2 FLOAT )
+
+statement ok
+INSERT INTO v0 VALUES ( 33296913.000000 , 46714997.000000 )
+
+statement error 42000!SELECT: cannot use non GROUP BY column 'v1' in query 
results without an aggregate function
+SELECT v1 AS v4 FROM v0 AS v3 GROUP BY v2
+
+-- exp_bin: CRITICAL: Could not find v3.v1
+-- sql/backends/monet5/rel_bin.c:1899: exp_bin: Assertion `s' failed.
+statement error 42000!SELECT: cannot use non GROUP BY column 'v1' in query 
results without an aggregate function
+SELECT MAX ( ( SELECT v1 AS v4 FROM v0 AS v3 GROUP BY v2 ) ) FROM v0
+
+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
@@ -1,3 +1,4 @@
+7766-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