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.

Sign up for GitHub

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

Jump to bottom

Parsing errors from mysqldump 8.0 #1339

Open

n0madic opened this issue Sep 11, 2021 · 0 comments

n0madic commented Sep 11, 2021 •

edited

Loading

Bug Report

Getting errors parsing output from mysqldump

mysqldump  Ver 8.0.26 for Linux on x86_64 (MySQL Community Server - GPL)

The problematic part of the dump:

CREATE TABLE `sites` (
  /* skipped... */
  `rules` json NOT NULL DEFAULT (_utf8mb4'[]'),
  `reasons` json NOT NULL DEFAULT (json_array()),
  `date_updated_for_send` int GENERATED ALWAYS AS ((case when ((`status` = _utf8mb3'') or (`status` = _utf8mb3'fail')) then `date_update` else NULL end)) VIRTUAL,
  /* ...skipped */
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

What did you expect to see?
dump as is
What did you see instead?

parse error: line 3 column 34 near "(_utf8mb4'[]'),

parse error: line 4 column 36 near "(json_array());

parse error: line 5 column 86 near "'') or (`status` = _utf8mb3'fail')) then `date_update` else NULL end)) VIRTUAL,

What version of TiDB SQL Parser are you using?
parser v4.0.2

github.com/pingcap/parser v0.0.0-20200623164729-3a18f1e5dceb

The text was updated successfully, but these errors were encountered:

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