Skip to content
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 : Parse error with a very simple script and mixed simple / double quotes #611

Closed
bgaillard opened this issue Sep 21, 2013 · 3 comments
Closed

Comments

@bgaillard
Copy link

@bgaillard bgaillard commented Sep 21, 2013

Hi, I think I have encountered a parse bug using flyway and MySQL using this very simple SQL script :

create table sample_table_a(
    id  integer not null,
    string varchar(128) not null
);

create table sample_table_b(
    id integer not null
);

insert into sample_table_a(id, string)
values (1, '["GIF", "JPG", "PNG"]');

insert into sample_table_b(id)
values (1);

It seems that the problem comes from the double quotes around the GIF, JPG and PNG keywords.

I've tested it using the last version of Flyway Command Line 2.2.1. The script is valid because I can execute it directly in MySQL.

If somebody encounters this bug a simple workaround is to espace the double quotes.

insert into sample_table_a(id, string)
values (1, '[\"GIF\", \"JPG\", \"PNG\"]');

Baptiste

@ehardy
Copy link

@ehardy ehardy commented Sep 23, 2013

We are facing the same issue with Flyway 2.2.1. The same scripts run fine with the 2.0.3 and fail with Flyway 2.2.1.

Loading

@Patrick1701
Copy link

@Patrick1701 Patrick1701 commented Oct 24, 2013

Hi all,
this is a quite urgent issue for us, due to an huge amount of sql script-lines containing "".

It would be very cool to fix this in the next version.

kind regards
Patrick

Loading

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Dec 9, 2013

Fixed with @bigslack 's pull request.

Thanks!

Loading

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants