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

        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.