-
Notifications
You must be signed in to change notification settings - Fork 39
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
Problems with UNIQUE parsing #236
Comments
cfhowes
added a commit
to cfhowes/simple-ddl-parser
that referenced
this issue
Jan 25, 2024
…KEY statements.
xnuinside
added a commit
that referenced
this issue
Jan 29, 2024
Issue #236: Updates to handle stand-alone UNIQUE and UNIQUE KEY statements
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
There appears to be a couple of problems with UNIQUE parsing.
simple-ddl-parser/tests/test_simple_ddl_parser.py
Line 365 in f605740
constraints.uniques
with both columns listed in the columns. See https://www.mysqltutorial.org/mysql-basics/mysql-unique-constraint/#:~:text=To%20define%20a%20UNIQUE%C2%A0%20constraint%20for%20two%20or%20more%20columns%2C%20you%20use%20the%20following%20syntax%3AUNIQUE KEY
statements currently cause the entire table to be ignored. IEUNIQUE KEY "fun_unique_key" ("fun_unique_column"),
In this case I think we'd like a single column to parse into a column UNIQUE statement, and multiple columns to parse into theconstraints.uniques
location.The text was updated successfully, but these errors were encountered: