bug: test failed when select * from table with semi structured data type array

[ZeaLoVe]

Search before asking

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

Version

v0.7.59-nightly-debian

What's Wrong?

case in 02_function\02_0005_function_compare

select '==Array(String)==';

CREATE TABLE IF NOT EXISTS t14(id Int, arr Array(String)) Engine = fuse;

INSERT INTO t14 (id, arr) VALUES(1, ['aa', 'bb']), (2, ['cc', 'dd']);

select * from t14;
select arr[0], arr[1] from t14;

select '==Array(String) Nullable==';

CREATE TABLE IF NOT EXISTS t15(id Int, arr Array(String) Null) Engine = fuse;

INSERT INTO t15 (id, arr) VALUES(1, ['aa', 'bb']), (2, ['cc', 'dd']), (3, null), (4, ['ee', 'ff']);

select * from t15;
select arr[0], arr[1] from t15;

return error

mysql> select * from t15;
ERROR 1105 (HY000): Code: 1015, displayText = Any { .. }.

cc @b41sh

How to Reproduce?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!