Skip to content

Allow using unquoted status column identifier in INSERT statements #2195

@knutwannheden

Description

@knutwannheden

Currently when trying to reference a column status in an INSERT statement an error is reported:

create table x(status int);
insert into x(status) values (42);

This is a bit awkward since:

  • in MySQL status is a keyword only and not a reserved word
  • using the status identifier for the column name in the CREATE TABLE statements works fine

I think it would make sense to allow status to be used in unquoted form in the INSERT statement as well. This may also apply to other DML statements.

Additionally, if Dolt SQL is different from MySQL with regards to what are keywords and reserved words, it would make sense to document this.

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions