You cannot use explicit casts in client collections. For example, the following example is not allowed:
$client collection list(row( a udt_1, b list(int))) mylist; $insert into table (:mylist) values (CAST(1 AS udt_1), list{1,2,3}); $insert into table (:mylist) values (1::udt_1, list{1,2,3});
When you enter esql -e client.ec, you get the following errors:
esqlc: "client.ec", line 2: Error -33074: Cannot use CAST in client collections.
esqlc: "client.ec", line 3: Error -33074: Cannot use CAST in client collections.