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

MySQL 8 information_schema object type 'SYSTEM VIEW' issues #3121

Open
dmoagx opened this Issue Jul 22, 2018 · 0 comments

Comments

Projects
None yet
1 participant
@dmoagx
Member

dmoagx commented Jul 22, 2018

In MySQL 8.0 the tables in information_schema db are of type SYSTEM VIEWwhich breaks Sequel Pro when it does the SHOW FULL TABLES query.

Previous MySQL versions already returned SYSTEM VIEW, which Sequel Pro interprets as TABLE. Coincidentally previous MySQL versions returned a valid table syntax for queries like

SHOW CREATE TABLE `CHARACTER_SETS`;

which made it look like Sequel Pro worked as expected.
However in MySQL 8.0 this will return a CREATE VIEW … syntax instead.

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