Description:
restore fail when backup sql contain \'
How to repeat:
try this:
create table PMTask (
ID bigint not null,
tasksCode varchar(255),
description varchar(255),
note varchar(255),
spec varchar(255),
primary key (ID)
);
INSERT INTO "pmtask" ("ID","tasksCode","description","note","spec") VALUES
(6389761,'2400','Grease the ball screw slides','','-'),
(6422529,'2400','Check the conveyor belts for wear','','-'),
(6455297,'2400','Check the inline material filter for clogging','','-'),
(6488065,'2400','Inspect all moving cables for excessive wear','','-'),
(6520833,'2400','Check the slides for wear and smooth operation','','-'),
(6553601,'VT-9300','Visual inspect signal status light','','-'),
(6586369,'VT-9300','Clean and vacuum all components','','-'),
(6619137,'VT-9300','Visual inspect adapter drive belts','','-'),
(6651905,'VT-9300','Visual inspect adapter clamp','','-'),
(6684673,'VT-9300','Turn off system AC power','','-'),
(6717441,'VT-9300','Use vacuum cleaner & bush to clean','','-'),
(6750209,'VT-9300','Apply grease at movment axis X, Y, Z if it\'s necessary','','-'),
(6782977,'VT-9300','Access the lubrication nipple on the X & Y axis lead screw','','-'),
(6815745,'VT-9300','Apply the grease for lead screw for X, Y, & Z axis','','-'),
(6848513,'VT-9300','Clean the surface of adapter sensor','','-');
INSERT INTO "pmtask" ("ID","tasksCode","description","note","spec") VALUES
(6881281,'VT-9300','Inspect the adapter drive belt, Y & Z aixs and change if necessary','','-'),
(6914049,'VT-9300','Check all screw at conveyor and tighten if it\'s necessary','','-'),
(6946817,'VT-9300','Check the pressure within the range of 4.5-5.5 bar & clean the filter','','4.5-5.5'),
(6979585,'SLCF 24','Check and clean the ready state of chain conveyor','','-'),
(7012353,'SLCF 24','Check and clean the ready state of finger','','-'),
(7045121,'SLCF 24','Check and clean the finger cleaner tank','','-'),
(7077889,'SLCF 24','Check all terminal of electrical system','','-'),
(7110657,'SLCF 24','Check and clean the alignment solder pot module','','-'),
(7143425,'SLCF 24','Check and clean heater element solder pot module','','-'),
(7176193,'SLCF 24','Check the lubricate drive shaft','','-'),
(7208961,'SLCF 24','Check and clean solder pot and solder dross','','-'),
(7241729,'SLCF 24','Check and clean pump of motor solder pot module','','-'),
(7274497,'SLCF 24','Clean dust collector wave soldering','','-');
Suggested fix:
Suggested fix:
Parsing those sql are not correct! They must be 3 sql statement but Query Browser treat
as 2 sql!!
Description: restore fail when backup sql contain \' How to repeat: try this: create table PMTask ( ID bigint not null, tasksCode varchar(255), description varchar(255), note varchar(255), spec varchar(255), primary key (ID) ); INSERT INTO "pmtask" ("ID","tasksCode","description","note","spec") VALUES (6389761,'2400','Grease the ball screw slides','','-'), (6422529,'2400','Check the conveyor belts for wear','','-'), (6455297,'2400','Check the inline material filter for clogging','','-'), (6488065,'2400','Inspect all moving cables for excessive wear','','-'), (6520833,'2400','Check the slides for wear and smooth operation','','-'), (6553601,'VT-9300','Visual inspect signal status light','','-'), (6586369,'VT-9300','Clean and vacuum all components','','-'), (6619137,'VT-9300','Visual inspect adapter drive belts','','-'), (6651905,'VT-9300','Visual inspect adapter clamp','','-'), (6684673,'VT-9300','Turn off system AC power','','-'), (6717441,'VT-9300','Use vacuum cleaner & bush to clean','','-'), (6750209,'VT-9300','Apply grease at movment axis X, Y, Z if it\'s necessary','','-'), (6782977,'VT-9300','Access the lubrication nipple on the X & Y axis lead screw','','-'), (6815745,'VT-9300','Apply the grease for lead screw for X, Y, & Z axis','','-'), (6848513,'VT-9300','Clean the surface of adapter sensor','','-'); INSERT INTO "pmtask" ("ID","tasksCode","description","note","spec") VALUES (6881281,'VT-9300','Inspect the adapter drive belt, Y & Z aixs and change if necessary','','-'), (6914049,'VT-9300','Check all screw at conveyor and tighten if it\'s necessary','','-'), (6946817,'VT-9300','Check the pressure within the range of 4.5-5.5 bar & clean the filter','','4.5-5.5'), (6979585,'SLCF 24','Check and clean the ready state of chain conveyor','','-'), (7012353,'SLCF 24','Check and clean the ready state of finger','','-'), (7045121,'SLCF 24','Check and clean the finger cleaner tank','','-'), (7077889,'SLCF 24','Check all terminal of electrical system','','-'), (7110657,'SLCF 24','Check and clean the alignment solder pot module','','-'), (7143425,'SLCF 24','Check and clean heater element solder pot module','','-'), (7176193,'SLCF 24','Check the lubricate drive shaft','','-'), (7208961,'SLCF 24','Check and clean solder pot and solder dross','','-'), (7241729,'SLCF 24','Check and clean pump of motor solder pot module','','-'), (7274497,'SLCF 24','Clean dust collector wave soldering','','-'); Suggested fix: Suggested fix: Parsing those sql are not correct! They must be 3 sql statement but Query Browser treat as 2 sql!!