search

planetscale / database-js

A Fetch API-compatible PlanetScale database driver
https://planetscale.com/docs/tutorials/planetscale-serverless-driver
Apache License 2.0
1.17k stars 35 forks source link

New tables not found in foreign key enabled cluster #160

Closed AndrewBarba closed 9 months ago

AndrewBarba commented 10 months ago

Setup

I have a cluster in the foreign key beta and I've successfully migrated tables into the cluster using the PS migrator.

Issue

When connecting the database using database-js, any new table I add to the cluster returns a "table not found" error when I try and query it. Using the regular mysql2 driver works fine. Any table that was added as part of the migration does seem to query correctly using database-js, its limited to tables added after the migration.

mattrobenolt commented 10 months ago

Can you explain what you mean by that? And what your connection string is when it works with mysql2? Please censor the username/password.

Fundamentally database-js doesn't work differently with regard to tables being visible or not.

ayrton commented 9 months ago

Recapping from Discord this wasn't an error relating to the FK constraints beta. The problem was that during the import, since there are multiple databases, and database-js does not pass the database name, you got the error.

Once an import is complete we expect everything is all good again. It's confusing and we'll make it better - in https://github.com/planetscale/database-js/pull/163 we're adding support to set the database name. We're also thinking of inferring the database name from the database URL but have not started any work on this yet.