Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

joinGet with array column and join_use_nulls = 1 throws exception #37562

Closed
oaons opened this issue May 26, 2022 · 0 comments · Fixed by #37650
Closed

joinGet with array column and join_use_nulls = 1 throws exception #37562

oaons opened this issue May 26, 2022 · 0 comments · Fixed by #37650

Comments

@oaons
Copy link

oaons commented May 26, 2022

CREATE TABLE test_db.id_val(`id` Int32, `val` Array(Int32)) ENGINE = Join(ANY, LEFT, id) SETTINGS join_use_nulls = 1

CREATE TABLE test_db.id_val
(
    `id` Int32,
    `val` Array(Int32)
)
ENGINE = Join(ANY, LEFT, id)
SETTINGS join_use_nulls = 1

Query id: 1bb0de31-95a3-41c3-b143-0e9163de44d0

Ok.

0 rows in set. Elapsed: 0.004 sec.

SELECT joinGet(test_db.id_val,'val',toInt32(number)) from numbers(4) SETTINGS join_use_nulls = 1

SELECT joinGet(test_db.id_val, 'val', toInt32(number))
FROM numbers(4)
SETTINGS join_use_nulls = 1

Query id: a4501b62-2baa-40c9-a5d3-d60baf77fe09

0 rows in set. Elapsed: 0.002 sec.

Received exception from server (version 22.5.1):
Code: 43. DB::Exception: Received from xxx.xxx.xxx.xxx:9001. DB::Exception: Nested type Array(Int32) cannot be inside Nullable type: While processing joinGet(keywords.id_val, 'val', toInt32(number)). (ILLEGAL_TYPE_OF_ARGUMENT)
@oaons oaons added the potential bug To be reviewed by developers and confirmed/rejected. label May 26, 2022
@oaons oaons changed the title joinGet with array column throws exception joinGet with array column and join_use_nulls = 1 throws exception May 26, 2022
@amosbird amosbird self-assigned this May 30, 2022
@vdimir vdimir added comp-joins JOINs unexpected behaviour and removed potential bug To be reviewed by developers and confirmed/rejected. labels May 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants