Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Randgen: block schema mismatch #1567

Closed
fzhedu opened this issue Mar 16, 2021 · 0 comments · Fixed by #1670
Closed

Randgen: block schema mismatch #1567

fzhedu opened this issue Mar 16, 2021 · 0 comments · Fixed by #1670
Assignees
Labels
plan bugs related to plans severity/major type/bug The issue is confirmed as a bug.
Milestone

Comments

@fzhedu
Copy link
Contributor

fzhedu commented Mar 16, 2021

mysql -h 127.0.0.1 -P 4002 -uroot -D ssjoin10000

mysql> set @@tidb_allow_mpp=1; Query OK, 0 rows affected (0.00 sec)

SELECT    table1 . `col_int_key` AS field1 , table1 . `pk` AS field2 , SUM(  table1 . `pk` ) AS field3 FROM  DD AS table1  RIGHT OUTER JOIN CC AS table2 ON  table1 . `col_varchar_1024_latin1` =  table2 . `col_varchar_10_latin1_key`  WHERE table1 . `col_int_key` != table1 . `col_int`  GROUP BY field1, field2 HAVING (field3 > 7 AND field2 <> 9) ORDER BY field3  ;
mysql> SELECT    table1 . `pk` AS field1 , SUM(  table1 . `col_int_key` ) AS field2 , table2 . `pk` AS field3 , table2 . `pk` AS field4 , table2 . `col_int` AS field5 , table1 . `pk` AS field6 , table1 . `pk` AS field7 , table1 . `col_int` AS field8 , table1 . `col_int_key` AS field9 , table1 . `col_int` AS field10 , table2 . `col_int_key` AS field11 , table2 . `pk` AS field12 , table2 . `col_int` AS field13 , table2 . `pk` AS field14 FROM  V AS table1  LEFT  JOIN W AS table2 ON  table1 . `col_varchar_1024_latin1` =  table2 . `col_varchar_1024_utf8_key`  WHERE ( table1 . `pk` NOT IN (4, 8, 1, 2, 5) OR table1 . `col_int` <= 2 )  GROUP BY field1, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14 HAVING ((((field1 > 4 AND field12 != 8) AND field12 < 2) OR field3 = 2) AND field2 <= 5) ORDER BY field13  , field12  , field5  ;

ERROR 1105 (HY000): other error for mpp stream: DB::Exception: exchange receiver meet error : DB::Exception: Block schema mismatch in CHBlockChunkCodecStream: different types: expected Nullable(Int32), got Int32
mysql>

@fzhedu fzhedu added the type/bug The issue is confirmed as a bug. label Mar 16, 2021
@fzhedu fzhedu changed the title randgen: block schema mismatch Randgen: block schema mismatch Mar 16, 2021
@fzhedu fzhedu self-assigned this Mar 17, 2021
@jebter jebter added this to the v5.0.0 ga milestone Mar 22, 2021
@fzhedu fzhedu added the plan bugs related to plans label Nov 15, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
plan bugs related to plans severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
3 participants