Can't lookup with non Int64 keys

[adriangb]

select ('[5, 2]'->(arrow_cast(1, 'UInt32'))) fails with:

Unexpected argument type to 'json_get' at position 2, expected string or int, got UInt32

I don't see why we can't support this.

[davidhewitt]

Perfectly reasonable to do so; it would mean either more generic expansions or casting smaller integer arrays to larger ones before processing.

Take your choice of compile-time or run-time pain 😂

[adriangb]

I think casting is perfectly reasonable. Only thing is what do we cast to? Could have two paths?

• UInt32 for anything that fits in that
• UInt128 for everything else