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

Fix trigger for collection tiles update_collection_tiles #193

Closed
raphaelrpl opened this issue May 12, 2023 · 0 comments
Closed

Fix trigger for collection tiles update_collection_tiles #193

raphaelrpl opened this issue May 12, 2023 · 0 comments
Assignees
@raphaelrpl
Labels
bug Something isn't working
Milestone
Version 1.0.2

Comments

@raphaelrpl
Copy link
Contributor

The trigger bdc_catalog/triggers/collection_tiles.sql tries to join "null" into JSON object. In this case, the postgres raises an invalid JSON field.

Consider to use NULLIF with COALESCE to avoid it. We should also change default value to {}.
@raphaelrpl raphaelrpl added the bug Something isn't working label May 12, 2023
@raphaelrpl raphaelrpl self-assigned this May 12, 2023
@raphaelrpl raphaelrpl added this to the Version 1.0.2 milestone May 12, 2023
raphaelrpl added a commit that referenced this issue May 12, 2023
@raphaelrpl
Merge pull request #194 from raphaelrpl/b-1.0
99c7359 
🐛 Fix bug related collection tiles trigger (close #193)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@raphaelrpl raphaelrpl

Labels
bug Something isn't working
Projects
None yet
Milestone
Version 1.0.2
Development

No branches or pull requests
1 participant
@raphaelrpl