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
Snapperfish opened this issue
May 2, 2024
· 1 comment
Labels
dialect: mysqlFor issues and PRs. Things that involve MySQL (and do not involve all dialects).type: featureFor issues and PRs. For new features. Never breaking changes.v6
Describe the feature you'd like to see implemented
The documents state:
Apply a schema to this model. For postgres, this will actually place the schema in front of the table name - "schema"."tableName", while the schema will be prepended to the table name for mysql and sqlite - 'schema.tablename'.
I would like to use the 'schema' feature for MySQL. Prepending the schema to the table name does not work in MySQL.
Sequelize/MySQL supports schema if I use the following hack: sequelize.dialect.supports.schemas = true
The request is that Sequelize implements this feature for MySQL as for Postgres, without the need for the above hack.
Describe why you would like this feature to be added to Sequelize
This feature would allow joins across databases without the need for the above hack.
Is this feature dialect-specific?
No. This feature is relevant to Sequelize as a whole.
Yes. This feature only applies to the following dialect(s): MySQL
Would you be willing to resolve this issue by submitting a Pull Request?
No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in implementing my feature.
Indicate your interest in the addition of this feature by adding the 👍 reaction. Comments such as "+1" will be removed.
The text was updated successfully, but these errors were encountered:
Snapperfish
added
pending-approval
Bug reports that have not been verified yet, or feature requests that have not been accepted yet
type: feature
For issues and PRs. For new features. Never breaking changes.
labels
May 2, 2024
Since we have this enabled for MariaDB on v6, I think the code should be there to support schemas for MySQL as well. But when working on v7 we have significantly improved the support for schemas. If your project is not running on production yet, I would recommend checking out the v7 alphas. We're not going to make any major breaking changes anymore to it, so you can start using it for new projects or migrating old projects to non-production environments.
WikiRik
added
dialect: mysql
For issues and PRs. Things that involve MySQL (and do not involve all dialects).
v6
pending-approval
Bug reports that have not been verified yet, or feature requests that have not been accepted yet
and removed
pending-approval
Bug reports that have not been verified yet, or feature requests that have not been accepted yet
labels
May 5, 2024
dialect: mysqlFor issues and PRs. Things that involve MySQL (and do not involve all dialects).type: featureFor issues and PRs. For new features. Never breaking changes.v6
Issue Creation Checklist
Feature Description
Describe the feature you'd like to see implemented
The documents state:
I would like to use the 'schema' feature for MySQL. Prepending the schema to the table name does not work in MySQL.
Sequelize/MySQL supports schema if I use the following hack:
sequelize.dialect.supports.schemas = true
The request is that Sequelize implements this feature for MySQL as for Postgres, without the need for the above hack.
Describe why you would like this feature to be added to Sequelize
This feature would allow joins across databases without the need for the above hack.
Is this feature dialect-specific?
Would you be willing to resolve this issue by submitting a Pull Request?
Indicate your interest in the addition of this feature by adding the 👍 reaction. Comments such as "+1" will be removed.
The text was updated successfully, but these errors were encountered: