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

creating table in query #182

Closed
Dave3991 opened this Issue Nov 8, 2017 · 3 comments

Comments

Projects
None yet
2 participants
@Dave3991

Dave3991 commented Nov 8, 2017

CREATE TABLE db_name_import.`configuration` (
	`key` VARCHAR(64) NOT NULL DEFAULT '' COLLATE 'utf8_czech_ci',
	`value` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_czech_ci',
	`description` VARCHAR(2000) NULL DEFAULT NULL COLLATE 'utf8_czech_ci',
	PRIMARY KEY (`key`)
)
COLLATE='utf8_czech_ci'
ENGINE=MyISAM
;

syntax is OK - works in mariaDb, getting this errors

 Line 2, col 40 at "COLLATE": A comma or a closing bracket was expected.
 Line 3, col 18 at "300": Unexpected beginning of statement.
 Line 3, col 23 at "NULL": Unrecognized statement type.

@nijel nijel self-assigned this Nov 8, 2017

@nijel nijel added the bug label Nov 8, 2017

@nijel nijel closed this in 50de69f Nov 8, 2017

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Nov 8, 2017

Member

The syntax is not ok according to their documentation, but as it works, we should support it as well...

Member

nijel commented Nov 8, 2017

The syntax is not ok according to their documentation, but as it works, we should support it as well...

@Dave3991

This comment has been minimized.

Show comment
Hide comment
@Dave3991

Dave3991 Nov 8, 2017

this code was originaly generated by HeidiSQL

Dave3991 commented Nov 8, 2017

this code was originaly generated by HeidiSQL

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Nov 8, 2017

Member

According to the docs (which were used to write the parser), the COLLATE should be next to type definition prior to any NULL clauses, but yes, it works...

Member

nijel commented Nov 8, 2017

According to the docs (which were used to write the parser), the COLLATE should be next to type definition prior to any NULL clauses, but yes, it works...

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