tiflash: Cannot convert NULL value to non-Nullable type
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql -uroot -h 172.16.4.99 -P 41324 -D agg_decimal_subquery700
SELECT ( ( table1 . `col_decimal_30_10_not_null_key` ) * ( table1 . `col_decimal_30_10_not_null_key` ) ) AS field1 , table1 . `col_decimal_20_20_not_null_key` = ALL ( SELECT SUBQUERY1_t1 . `col_decimal_unsigned_not_null_key` AS SUBQUERY1_field1 FROM ( BB AS SUBQUERY1_t1 INNER JOIN ( C AS SUBQUERY1_t2 RIGHT OUTER JOIN BB AS SUBQUERY1_t3 ON (SUBQUERY1_t3 . `col_int_key` = SUBQUERY1_t2 . `col_decimal_30_10_unsigned_not_null_key` ) ) ON (SUBQUERY1_t3 . `col_tinyint_unsigned` = SUBQUERY1_t2 . `col_int_key` ) ) WHERE SUBQUERY1_t3 . `col_bigint_unsigned` <= -5 ) AS field2 , count( table1 . `col_int_not_null` ) AS field3 FROM ( D AS table1 INNER JOIN ( ( D AS table2 RIGHT OUTER JOIN ( SELECT SUBQUERY2_t1 . * FROM ( D AS SUBQUERY2_t1 STRAIGHT_JOIN ( AA AS SUBQUERY2_t2 STRAIGHT_JOIN C AS SUBQUERY2_t3 ON (SUBQUERY2_t3 . `col_int_unsigned` = SUBQUERY2_t2 . `col_decimal_65_key` ) ) ON (SUBQUERY2_t3 . `col_decimal_20_20_unsigned_not_null` = SUBQUERY2_t2 . `col_decimal_20_20_key` ) ) WHERE SUBQUERY2_t1 . `col_bigint_not_null_key` = 9 ) AS table3 ON (table3 . `col_decimal_65_not_null`
= table2 . `col_int_key` ) ) ) ON (table3 . `col_int_unsigned_key` = table2 . `col_decimal_65_key` ) ) WHERE ( EXISTS ( SELECT SUBQUERY3_t1 . `col_decimal_20_20` AS SUBQUERY3_field1 FROM ( C AS SUBQUERY3_t1 INNER JOIN CC AS SUBQUERY3_t2 ON (SUBQUERY3_t2 . `col_tinyint_unsigned_key` = SUBQUERY3_t1 . `col_decimal_65_10_key` ) ) WHERE SUBQUERY3_t2 . `col_decimal_65` <= table3 . `col_decimal_30_10_unsigned_not_null_key` AND SUBQUERY3_t1 . `col_int_not_null` <> table2 . `col_decimal_65_unsigned` ) ) AND table1 . `col_decimal_30_10_key` IN (84) GROUP BY field1, field2 ;
ERROR 1105 (HY000): other error for mpp stream: DB::Exception: Exchange receiver meet error : DB::Exception: Cannot convert NULL value to non-Nullable type
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiFlash version? (Required)
nightly of yesterday
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 16 (14 by maintainers)
@LittleFall Yes, it has beed fixed, we can close the issue.