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)

Most upvoted comments

@LittleFall Yes, it has beed fixed, we can close the issue.