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

ALTER TABLE parser error #13595

Closed
lem9 opened this Issue Aug 19, 2017 · 1 comment

Comments

Projects
None yet
2 participants
@lem9
Contributor

lem9 commented Aug 19, 2017

Steps to reproduce

Enter the following in the SQL area (tested on phpMyAdmin 4.7.3) :

ALTER TABLE posts
PARTITION BY LIST COLUMNS (status) (
PARTITION P1 VALUES IN ('public', 'admin', 'moder', 'rec'),
PARTITION P2 VALUES IN ('archive')
);

Expected behaviour

No parser error, as the code runs fine when executed (even if 'status' is a reserved word).

Actual behaviour

red x error:
unrecognized alter operation. near;)

Server configuration

Operating system:

Web server:

Database:

PHP version:

phpMyAdmin version:

Client configuration

Browser:

Operating system:

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Aug 21, 2017

Member

Duplicate of phpmyadmin/sql-parser#164

Thanks, I've opened issue for this on the SQL parser repository.

Member

nijel commented Aug 21, 2017

Duplicate of phpmyadmin/sql-parser#164

Thanks, I've opened issue for this on the SQL parser repository.

@nijel nijel closed this Aug 21, 2017

@nijel nijel self-assigned this Aug 21, 2017

@nijel nijel added bug parser labels Aug 21, 2017

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