bug: InSubquery returns error result

[fkuner]

Search before asking

• I had searched in the issues and found no similar issues.

Version

c774f80

What's Wrong?

mysql> select * from numbers(10) where number in (select * from numbers(5)) order by number;
+--------+
| number |
+--------+
|      0 |
|      1 |
|      4 |
|      5 |
|      6 |
+--------+
5 rows in set (0.03 sec)
Read 15 rows, 120.00 B in 0.008 sec., 1.9 thousand rows/sec., 14.81 KiB/sec.

The result should be 0 1 2 3 4.

How to Reproduce?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[fkuner]

cc @xudong963 @leiysky

[sundy-li]

related to method mark_join_blocks. I think it's incorrect to call build_indexes.extend_from_slice .

[xudong963]

related to method mark_join_blocks. I think it's incorrect to call build_indexes.extend_from_slice .

I'll verify it and give a fix tomorrow.