Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Reproduced locally on MariaDB Columnstore 25.10.4 (stable-23.10).
A simple aggregate query with ordinal ORDER BY returns an internal error:
ERROR 1815 (HY000): Internal error: column is not found in info map.
Reproducer
CREATE DATABASE IF NOT EXISTS cs_repro; |
USE cs_repro; |
|
|
DROP TABLE IF EXISTS orders; |
CREATE TABLE orders (o_custkey INT, o_orderstatus CHAR(1)) ENGINE=Columnstore; |
INSERT INTO orders VALUES (10,'F'),(20,'O'),(10,'P'),(30,'F'),(20,'O'),(40,'P'); |
|
|
SELECT COUNT(o_orderstatus), o_orderstatus |
FROM orders |
ORDER BY 1, 2 DESC; |
Expected
Under default MariaDB semantics without ONLY_FULL_GROUP_BY, the query is accepted and should not fail with an internal engine error.
Actual
Columnstore returns:
ERROR 1815 (HY000): Internal error: column is not found in info map.
