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

alias: ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2016: Non supported item on the GROUP BY list.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 23.10.2, 23.10.3, 23.10.4
    • None
    • Compability

    Description

      The following testcase throw:

      CREATE TABLE `test2` (
      		 
        `id` INT UNSIGNED NOT NULL,
      		 
        `GBP` DOUBLE UNSIGNED NOT NULL,
      		 
        `cat_id` INT UNSIGNED NOT NULL,
      		 
        `cat_id_level_0` INT UNSIGNED NOT NULL
      		 
      ) ENGINE=Columnstore;
      		 
       
      		 
      SELECT cat_id_level_0 AS entity_id, SUM(GBP) AS spend, cat_id_level_0 AS cat_id
      		 
      FROM test2
      		 
      GROUP BY cat_id;

      throw
      ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2016: Non supported item 'cat_id' on the GROUP BY list.

      since 23.10.2

      Maybe a regression from MCOL-4234 or MCOL-4235

      Expected:

       
      		 
      Warning: #1052 Column 'cat_id' in group statement is ambiguous

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4234 ORDER BY clause if not included in the GROUP BY clause fails

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4235 Group By ... Order By NULL fails

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sergey.zefirov Sergey Zefirov
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.