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

group by (moda) on FLOAT result in Internal error: TupleAnnexStep::executeNoOrderBy() IDB-2035: An internal error occurred

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 6.2.3
    • 22.08.1
    • None
    • None
    • 2021-17

    Description

      In a simple query like:

      MariaDB [(none)]> sELECT 'AAA' MONDO, ri_mo_id OTHIS_RIMOID, MODA(ri_prezzo) OTHISPRMODA, COUNT(DISTINCT ri_id) OTHISNRI FROM dms_dg_ita_4570.rilevazione WHERE ri_data BETWEEN "2021-09-10" AND "2021-09-17" AND ri_in_id !=3 AND ri_prezzo IS NOT NULL GROUP BY MONDO, OTHIS_RIMOID;

      results in a error:
      ERROR 1815 (HY000): Internal error: TupleAnnexStep::executeNoOrderBy() IDB-2035: An internal error occurred. Check the error log file & contact support.

      Customer cant go ahead

      Issue appears to be related to the alias defined on a constant and then the alias is used for the GROUP BY,

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              massimo.disaro Massimo
              Andrey Piskunov Andrey Piskunov (Inactive)
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.