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

[Oracle] Migration of JSON_ARRAYAGG(numeric) is unsupported #1542

Open
shubham-yb opened this issue Jun 5, 2024 · 0 comments
Open

[Oracle] Migration of JSON_ARRAYAGG(numeric) is unsupported #1542

shubham-yb opened this issue Jun 5, 2024 · 0 comments
Labels
triage Needs to be triaged

Comments

@shubham-yb
Copy link
Contributor

PostgreSQL's JSON_ARRAYAGG function does not support numeric inputs directly. It requires inputs that can be converted directly to JSON, such as text. Therefore, numeric values need to be cast to text before they can be used with JSON_ARRAYAGG.

The above is supported by Oracle and thus migrating such a clause causes errors.

Workaround: Use the JSON_AGG() function instead for such an input.

@github-actions github-actions bot added the triage Needs to be triaged label Jun 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
triage Needs to be triaged
Projects
None yet
Development

No branches or pull requests

1 participant