-
-
Notifications
You must be signed in to change notification settings - Fork 126
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
Problem with JS library adding elements using external array keys #483
Comments
Can you share the generated HTTP request of the supabase call? (the URI plus headers) It seems to be related to this feature: https://postgrest.org/en/stable/references/api/tables_views.html#limited-update-delete, which limits the amount of updated rows. But the order should only be required if you limit the root table. |
Unfortunately, I don't know how to share queries from your library because I use it on the BED side. If necessary I will transfer to FED and try to get but the case is very simple. To answer your question I don't want to limit how many elements will get the update just the result of select which is executed after the update. I checked and if I execute it as a separate element then it works correctly ie. Scenario 1:
The result has many "images", the limit does not work and i get an error about "order" Scenario 2:
The result is correct images are limited to 1 and there is no error |
I've resolve the issue by returning a .maybeSingle() without .limit(1) |
Bug report
Describe the bug
When calling a select query after using the update option with an external key, the limit does not work correctly. An error "A 'limit' was applied without an explicit 'order'" is returned. After adding an additional order, the limit is not applied at all. The problem does not occur when using select alone.
Example of implementation:
It is a combination of one to many one house can have many images. As a result, we want to get only one instead of a list of all.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
The result should be the same as for select called separately.
The text was updated successfully, but these errors were encountered: