Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6330

Internal error "No project column found for aggregate function" on scalar subquery with aggregate on literal

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            abukhalov Aleksei Bukhalov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.