Array cast failing after version bump #18456
Comments
|
cc: @dain - this looks like another bug introduced by #18094 which is still present after #18473. ScalarFunctionAdapter.adaptReturn is trying to use |
dain
added a commit
to dain/trino
that referenced
this issue
Jan 20, 2024
When adapting a nullable function to a BLOCK_BUILDER return, a null must be appended when the function return value is null. Fixes trinodb#18456 Co-authored-by: Dain Sundstrom <[email protected]>
dain
added a commit
that referenced
this issue
Jan 20, 2024
When adapting a nullable function to a BLOCK_BUILDER return, a null must be appended when the function return value is null. Fixes #18456 Co-authored-by: Dain Sundstrom <[email protected]>
abusk
pushed a commit
to abusk/trino
that referenced
this issue
Jan 22, 2024
When adapting a nullable function to a BLOCK_BUILDER return, a null must be appended when the function return value is null. Fixes trinodb#18456 Co-authored-by: Dain Sundstrom <[email protected]>
6 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Finding inconsistent behavior between versions when casting between types
Array(JSON)andArray(DOUBLE).Trino 418
Final cast from type
Array(JSON)toArray(DOUBLE)succeeds:with a as (select raw_json_string, cast(json_parse(raw_json_string) as MAP (VARCHAR, JSON)) as map from (values ('{"a":{"price":1},"b":{"price":2}}')) as t(raw_json_string)), b as (select a.*, transform_values(a.map, (k, v) -> json_extract(v, '$.price')) as transformed_map from a), c as (select b.*, map_values(b.transformed_map) as values_from_map from b) select c.*, cast(values_from_map as array(DOUBLE)) as values_as_double from c;Returns:
Trino 421
Same query fails with the following error:
Full stack trace posted at the end
Work around in Trino 421
Pushing the cast to double into the
tranform_valuescall fixes this:with a as (select raw_json_string, cast(json_parse(raw_json_string) as MAP (VARCHAR, JSON)) as map from (values ('{"a":{"price":1},"b":{"price":2}}')) as t(raw_json_string)), b as (select a.*, transform_values(a.map, (k, v) -> cast(json_extract(v, '$.price') as DOUBLE)) as transformed_map from a), c as (select b.*, map_values(b.transformed_map) as values_from_map from b) select c.* from c;Returns
Stack Trace
The text was updated successfully, but these errors were encountered: