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

BIT_OR function in projection and subquery in FROM produce Internal error: IDB-2035

    XMLWordPrintable

Details

    • 2020-3, 2020-4, 2020-5

    Description

      The test case provided by community that returns in 1.2.4:
      ERROR 1815 (HY000): Internal error: IDB-2035: An internal error occurred. Check the error log file & contact support

      CREATE TABLE `bit_or_error` (
      `gby` INT(11) NOT NULL,
      `v` INT(11) NOT NULL
      ) ENGINE=COLUMNSTORE DEFAULT CHARSET=UTF8;

      INSERT INTO bit_or_error
      (`gby`,
      `v`)
      VALUES
      (1,2),
      (2,3);

      SELECT
      gby, COUNT(DISTINCT v), ROUND(SUM(v), 3), BIT_OR(v)
      FROM
      (SELECT
      gby, v
      FROM
      bit_or_error) P
      GROUP BY gby;

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            drrtuy Roman
            Votes:
            1 Vote for this issue
            Watchers:
            6 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.