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.

Sign up for GitHub

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

Jump to bottom

`primary key (password)` requires password to be backticked #6290

Closed

timsehn opened this issue Jul 6, 2023 · 0 comments · Fixed by dolthub/vitess#252

Assignees

Labels

bug customer issue

Sponsor Contributor

timsehn commented Jul 6, 2023

This is not the case with MySQL.

CREATE TABLE common_breached_passwords (
  password VARCHAR(191) NOT NULL,
  PRIMARY KEY (password)

Should work but Dolt requires:

CREATE TABLE common_breached_passwords (
  password VARCHAR(191) NOT NULL,
  PRIMARY KEY (`password`)

timsehn added bug 1hr customer issue labels

timsehn assigned zachmu

zachmu mentioned this issue

Fixed keyword usage in primary key clauses dolthub/vitess#252

Merged

zachmu closed this as completed in dolthub/vitess#252

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment