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

Unmatching dimensions are allowed in multidimensional arrays #5096

Closed
stdrc opened this issue Sep 5, 2022 · 1 comment
Closed

Unmatching dimensions are allowed in multidimensional arrays #5096

stdrc opened this issue Sep 5, 2022 · 1 comment
Labels
type/bug Something isn't working

Comments

@stdrc
Copy link
Member

stdrc commented Sep 5, 2022

Describe the bug

PG checks the dimensions when constructing, concatenating and aggregating multidimensional arrays, but we currently don't.

To Reproduce

# constructing
select array[array[1,2], array[3]];

# concatenating
select array[array[1,2]] || array[array[3]];

# batch aggregating
select array_agg(a) from (values (array[array[1,2]]), (array[array[3]])) t(a);

# streaming aggregating
create table t (a int[][]);
insert into t values (array[array[1,2]]), (array[array[3]]);
create materialized view mv as select array_agg(a) as agg from t;
select * from mv;

Expected behavior

These queries all fail on PG, but succeed on RW.

Additional context

#5060 (comment)

@stdrc stdrc added the type/bug Something isn't working label Sep 5, 2022
@github-actions github-actions bot added this to the release-0.1.13 milestone Sep 5, 2022
@stdrc stdrc removed this from the release-0.1.13 milestone Sep 5, 2022
@stdrc stdrc added the good first issue Good for newcomers label Sep 5, 2022
@stdrc
Copy link
Member Author

stdrc commented Sep 5, 2022

Ah, seems to be duplicate with #3811. Close this for now.

@stdrc stdrc closed this as not planned Won't fix, can't repro, duplicate, stale Sep 5, 2022
@stdrc stdrc removed the good first issue Good for newcomers label Sep 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant