Skip to content
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

default charset=binary is messing up in a create table statement #7576

Closed
timsehn opened this issue Mar 7, 2024 · 0 comments · Fixed by dolthub/vitess#315
Closed

default charset=binary is messing up in a create table statement #7576

timsehn opened this issue Mar 7, 2024 · 0 comments · Fixed by dolthub/vitess#315
Assignees
Labels
bug Something isn't working correctness We don't return the same result as MySQL integrations Issues with tools connecting to/querying Dolt sql Issue with SQL

Comments

@timsehn
Copy link
Contributor

timsehn commented Mar 7, 2024

Works in MySQL:

CREATE TABLE `site_identifiers` (
si_type VARBINARY(32) NOT NULL,
si_key VARBINARY(32) NOT NULL,
si_site INT UNSIGNED NOT NULL,
INDEX si_site (si_site),
INDEX si_key (si_key),
PRIMARY KEY(si_type, si_key)
) ENGINE=InnoDB, DEFAULT CHARSET=binary

Fails in Dolt with:

Error parsing SQL: 
syntax error at position 245 near 'binary'
@timsehn timsehn added bug Something isn't working sql Issue with SQL integrations Issues with tools connecting to/querying Dolt correctness We don't return the same result as MySQL labels Mar 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working correctness We don't return the same result as MySQL integrations Issues with tools connecting to/querying Dolt sql Issue with SQL
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants