You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The table "IOUs" is not found since the .sql file used for database initialization does not put the table name between double quotes and Postgres by default initializes the table as "ious" (lowercase).
I solved this issue by forcing a lowercase conversion for table names extracted from RML if the source is a Postgres DB. However, I don't know if this is a good assumption or if it would be better to update the test case.
The text was updated successfully, but these errors were encountered:
Interesting! I have seen this problem like a lot. IMO, we should even define this as part of the rml-io-registry where we define for each reference formulation 'special' handling. We cannot change the behavior of various RDBMS vendors so we have to define how to handle these cases I guess?
I agree with you @DylanVanAssche, if you think it is more related to the rml-io-registry, we can transfer the issue to that repository.
dachafra
changed the title
Issue with Postgres test cases RMLTC0005a-PostgreSQL and RMLTC0005b-PostgreSQL
Describe special behavior of each RDBM?
Jul 4, 2024
The table "IOUs" is not found since the
.sql
file used for database initialization does not put the table name between double quotes and Postgres by default initializes the table as "ious" (lowercase).I solved this issue by forcing a lowercase conversion for table names extracted from RML if the source is a Postgres DB. However, I don't know if this is a good assumption or if it would be better to update the test case.
The text was updated successfully, but these errors were encountered: