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

Error with DECIMAL(37,0) column and crossengine join: Internal error: CrossEngineStep::execute() caught getSignedNullValue(): got bad column width (4).

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.1.1
    • 6.2.3
    • None
    • 2021-15, 2021-16

    Description

      The following query:

      SELECT * FROM
      (SELECT
      1 AS test,
      v.`BL_ID` AS `15100_BL`,
      COUNT(DISTINCT(IF((v.`VAL_39_8002`<>0),v.APO_ID,null))) AS `VALUE_2021_1_Q_9583_1_1`
      FROM test.`test_cs` AS v
      GROUP BY `15100_BL`
      ) AS numerator
      JOIN
      (
      SELECT
      v.`BL_ID` as `15100_BL`,
      COUNT(DISTINCT(IF((EH39<>0),v.APO_ID,null))) AS `VALUE_2021_1_Q_9583_1_1`
      FROM test.apo_innodb as v
      GROUP BY `15100_BL`
      ) AS denominator
      USING (`15100_BL`);
      

      leads to error 1815: "Internal error: CrossEngineStep::execute() caught getSignedNullValue(): got bad column width (4).", when EH39 column is defined as DECIMAL(37,0) in the InnoDB table.

      I was not the case with Columnstore from 10.5.9-6. There is no problem when column's data type is changed to LONGINT.

      See full text case attached.

      Attachments

        1. Testcase.txt
          67 kB
          Valerii Kravchuk

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.