-
Notifications
You must be signed in to change notification settings - Fork 538
Open
Description
This issue is a (choose one):
- Problem/bug report.
Checklist before submitting:
- I've searched for an existing issue.
Description
After upgrading JSONAPI::Resources to version 0.10.2 (coming from 0.9), we noticed the API is causing SQL errors when loading resources from a different database. We have a multi-tenant database, so some resources are fetched from a shared database. It seems this line is causing the syntax to break:
https://github.com/cerebris/jsonapi-resources/blob/master/lib/jsonapi/active_relation_resource.rb#L117
Fetching resources from a different database results in the given query:
SELECT database.table.id AS database.table_id (...)
The dot (.) in the alias is illegal. This results in the following error:
Internal Server Error: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.table_id ' at line 1:
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels