bug: subquery data type in delete/update statement should be boolean

[andylokandy]

Search before asking

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

Version

main

What's Wrong?

> create table t2 (a int);
> delete from t2 where 0 < to_int64((select avg(a) from t2));

error: APIError: ResponseError with 1001: subquery data type in delete/update statement should be boolean

How to Reproduce?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!