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

select * into file from (select ... group by) produces spurious error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 23.10.2
    • None
    • None
    • 2024-1

    Description

      drop table if exists `C2`;
      CREATE TABLE `C2` (
      `intc` int(6) DEFAULT NULL,
      `id` int(11) NOT NULL,
      `mm_prezzo` decimal(12,0) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8;

      select * into outfile '/tmp/result.dml' from (SELECT id,intc FROM C2 WHERE intc IN (201909) GROUP BY id,intc) as sel1;
      ERROR 1815 (HY000): Internal error: IDB-2021: 'intc' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be included in the GROUP BY clause.

      Attachments

        Issue Links

          Activity

            People

              denis0x0D Denis Khalikov
              gdorman Gregory Dorman (Inactive)
              Kirill Perov Kirill Perov
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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