Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.1.1
-
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.