-
-
Notifications
You must be signed in to change notification settings - Fork 527
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
SequelizeMeta structure incompatible with SingleStore/memsql #1397
Comments
A quick workaround is to remove this line locally; Line 132 in a2526ed
We officially do not support memsql/SingleStore btw. What dialect did you use in the sequelize config? |
We are using mysql dialect w/ sequelize. Since you don't officially support it, we may be able to ask the SingleStore team to support a flag instead. |
What you are doing?
The table schema for the SequelizeMeta table is in conflict with the memsql/SingleStore dbms. The problematic query is the following table create:
which causes an error due to validation on the memsql side with
name
being the PK and also defined as UNIQUE explicitlysimply skipping the explicit
UNIQUE
constraint onname
avoids this issueIs there any reason not to remove the unique flag in the table definition? It is theoretically extraneous since it is the PK already.
What do you expect to happen?
I would expect the SequelizeMeta table to initialize successfully without intervention - or for there to be a way to configure my way out of the problem.
What is actually happening?
Error is being thrown due to validation on the dbms being confused that the key is also manually defined as unique.
Dialect: memsql/SingleStore
Database version: 8.1
Sequelize CLI version: 5.5.1
Sequelize version: 6.17.0
The text was updated successfully, but these errors were encountered: