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.

Sign up for GitHub

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

Jump to bottom

MULTISET on PostgreSQL runs into trouble with more than 50 attributes #1979

Closed
beikov opened this issue Dec 24, 2024 · 0 comments · Fixed by #2008
Closed

MULTISET on PostgreSQL runs into trouble with more than 50 attributes #1979

beikov opened this issue Dec 24, 2024 · 0 comments · Fixed by #2008
Assignees
@beikov
Labels
component: core kind: bug worth: high Implementing this has a high worth
Milestone
1.6.15

Comments

@beikov
Copy link
Member

beikov commented Dec 24, 2024

Description

When multiset fetching something with more than 50 attributes/selections, a PostgreSQL error occurs because one can't pass more than 100 arguments to functions. The SO post mentions a workaround, which is to split the function with a concatenation operator.

Environment

Version: 1.6.14
JPA-Provider: -
DBMS: -
Application Server: -
@beikov beikov added kind: bug component: core worth: high Implementing this has a high worth labels Dec 24, 2024
@beikov beikov self-assigned this Dec 24, 2024
@beikov beikov added this to the 1.6.15 milestone Feb 22, 2025
beikov added a commit to beikov/blaze-persistence that referenced this issue Feb 23, 2025
@beikov
[Blazebit#1979] Use jsonb object concat to avoid PostgreSQL 100 funct…
7d7c5d8 
…ion argument limit
@beikov beikov mentioned this issue Feb 23, 2025
Merged
beikov added a commit that referenced this issue Feb 24, 2025
@beikov
[#1979] Use jsonb object concat to avoid PostgreSQL 100 function argu…
92c341d 
…ment limit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@beikov beikov

Labels
component: core kind: bug worth: high Implementing this has a high worth
Projects
None yet
Milestone
1.6.15
1 participant
@beikov