dbUp fails when a combination of "\'" & ";" is in the script

[keren-steinberg]

The following script is failing when running in mySQL.

DROP TABLE IF EXISTS test;

CREATE TABLE test (
id int DEFAULT NULL,
message varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40000 ALTER TABLE test DISABLE KEYS /;
INSERT INTO test VALUES
(1,'CCP\'s valuation') ;
INSERT INTO test VALUES
(2,'UTI = ;') ;
/!40000 ALTER TABLE test ENABLE KEYS */;

The following script runs successfully. Only change is removing the "\'" and having "CCPs" instead of "CCP\'s".
DROP TABLE IF EXISTS test;

CREATE TABLE test (
id int DEFAULT NULL,
message varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40000 ALTER TABLE test DISABLE KEYS /;
INSERT INTO test VALUES
(1,'CCPs valuation') ;
INSERT INTO test VALUES
(2,'UTI = ;') ;
/!40000 ALTER TABLE test ENABLE KEYS */;

The error of the failing script is:
error.txt

this is some kind of relation between the quoted "\'" and the ";"

Appreciate if you can run this script and see it is failing since it is 3rd time I am opening this bug and getting irrelevant answers

[mjauernig]

Appreciate if you can run this script and see it is failing since it is 3rd time I am opening this bug and getting irrelevant answers

Sorry for supporting you in our spare time and not satisfying you.
You can comment on closed issues, so you do not need to open new issues. Also it would be good if you answer the questions.

I did a first test today. Can you live with the following workaround?

DROP TABLE IF EXISTS test;

CREATE TABLE test (
id int DEFAULT NULL,
message varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO test VALUES
(1,"CCP's valuation") ;
INSERT INTO test VALUES
(2,"UTI = ;") ;

The use of ' with \' looks like a bug in the parser. But I need to look deeper.

[keren-steinberg]

Hi, thanks very much for checking it. this solution works and I am happy with it. Thanks again.