update test insert_into_array: t18, t19 fail to insert.
error message: Cast error happens in casting from Array(Nullable(UInt8)) to Array(Nullable(Int64))
@@ -362,7 +362,7 @@ CREATE TABLE IF NOT EXISTS t17(id Int, arr Array(String Null)) Engine = Fuse;
statement ok
INSERT INTO t17 (id, arr) VALUES(1, ['aa', 'bb']), (2, [null, 'cc']), (3, ['dd', null]), (4, ['ee', 'ff']);
-statement query IT label(clickhouse)
+statement query IT
select * from t17;
----
@@ -371,12 +371,6 @@ select * from t17;
3 ['dd', NULL]
4 ['ee', 'ff']
----- clickhouse
-1 ['aa', 'bb']
-2 [\N, 'cc']
-3 ['dd', \N]
-4 ['ee', 'ff']
-
statement query TT
select arr[0], arr[1] from t17;
@@ -389,71 +383,11 @@ ee ff
statement ok
CREATE TABLE IF NOT EXISTS t18(id Int, arr Array(Int64 Null)) Engine = Fuse;
-statement ok
+statement error 1010
INSERT INTO t18 (id, arr) VALUES(1, [1,2,3,4]), (2, [5,null,7,8]), (3, [null,9,10,11]);
-statement query IT label(clickhouse)
-select * from t18;
-
-----
-1 [1, 2, 3, 4]
-2 [5, NULL, 7, 8]
-3 [NULL, 9, 10, 11]
-
----- clickhouse
-1 [1, 2, 3, 4]
-2 [5, \N, 7, 8]
-3 [\N, 9, 10, 11]
-
-statement query II
-select arr[0], arr[1] from t18;
-
-----
-1 2
-5 NULL
-NULL 9
-
-statement query II
-select arr[0], arr[1] from t18 where arr[1] = 2 order by arr[2] desc;
-
-----
-1 2
-
statement ok
CREATE TABLE IF NOT EXISTS t19(id Int, arr Array(Array(Int64) Null)) Engine = Fuse;
-statement ok
+statement error 1010
INSERT INTO t19 (id, arr) VALUES(1, [[1,2],[3,4]]), (2, [[5,6],null]), (3, [[7,8],[9,10]]);
-
-statement query IT label(clickhouse)
-select * from t19;
-
-----
-1 [[1, 2], [3, 4]]
-2 [[5, 6], NULL, [7, 8]]
-3 [[9, 10]]
-
----- clickhouse
-1 [[1, 2], [3, 4]]
-2 [[5, 6], \N, [7, 8]]
-3 [[9, 10]]
-
-statement query TT
-select arr[0], arr[1] from t19;
-
-----
-[1, 2] [3, 4]
-[5, 6] NULL
-[9, 10] NULL
-
-statement query II
-select arr[0][0], arr[1][0] from t19;
-
-----
-1 3
-5 NULL
-9 NULL
-
-statement ok
-DROP DATABASE db1;
-
