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

    • Sprint:
      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

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            drrtuy Roman
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: