dbUp fails when a combination of "\'" & ";" is in the script #1
Description
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