Skip to content

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

@timsehn

Description

@timsehn

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'

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingcorrectnessWe don't return the same result as MySQLintegrationsIssues with tools connecting to/querying DoltsqlIssue with SQL

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions