Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Description
Any query with a scalar subquery containing an aggregate function on a literal (without FROM clause) in WHERE fails with internal error. Works correctly on InnoDB.
Minimal reproducer
CREATE TABLE t (id INT) ENGINE=Columnstore; |
INSERT INTO t VALUES (1),(2),(3); |
|
|
-- All fail with same error:
|
SELECT id FROM t WHERE id > (SELECT MAX(1)); |
SELECT id FROM t WHERE id > (SELECT COUNT(*)); |
SELECT id FROM t WHERE id > (SELECT MIN(1)); |
SELECT id FROM t WHERE id > (SELECT SUM(1)); |
|
|
-- Works fine (aggregate on column with FROM):
|
SELECT id FROM t WHERE id > (SELECT MAX(id) FROM t); |
|
|
-- Works fine on InnoDB:
|
-- SELECT id FROM t_innodb WHERE id > (SELECT MAX(1)); → returns 2, 3
|
Error: ERROR 1815 (HY000): Internal error: No project column found for aggregate function
Environment
- MariaDB 11.4.11-8, Columnstore 25.10.4 (stable-23.10)
- OS: Ubuntu 24.04
Found by SQL mutation fuzzer — triggered 225 times during 106k query run.