bug: with recursive bind table panic

[b41sh]

Search before asking

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

Version

main

What's Wrong?

with recursive bind table panic
found by fuzz sqlite test

panicked at src/query/sql/src/planner/binder/table.rs:243:20:
index out of bounds: the len is 0 but the index is 0

How to Reproduce?

root@0.0.0.0:48000/tt> CREATE TABLE link(aa INT, bb INT);
root@0.0.0.0:48000/tt> WITH RECURSIVE closure(x) AS (VALUES(1) UNION SELECT 1 FROM closure, link WHERE link.bb = closure.x QUALIFY rank() OVER (ORDER BY a ROWS BETWEEN CURRENT ROW AND 4 FOLLOWING) UNION SELECT d = '10', lead(b, b) OVER (PARTITION BY b % 10 ORDER BY b, a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), first_value(b) OVER (ORDER BY b % 10, a ROWS BETWEEN 4 FOLLOWING AND UNBOUNDED FOLLOWING) FROM closure, link WHERE link.aa = closure.x HAVING row_number() OVER (ORDER BY a ROWS BETWEEN 4 PRECEDING AND CURRENT ROW)) SELECT x FROM closure ORDER BY x;
error: APIError: QueryFailed: [1104]index out of bounds: the len is 0 but the index is 0

Are you willing to submit PR?

• Yes I am willing to submit a PR!