MySQL Bugs: #17850: Query Browser does not interpret the characters of escape

Bug #17850	Query Browser does not interpret the characters of escape
Submitted:	2 Mar 2006 7:53	Modified:	24 Apr 2006 15:09
Reporter:	Stefano Cavazzini	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.1.20	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
I have executed a BackUp with MySQL Administrator.  Executing the rows sql with Query Browser they come signals errors on the characters \ ' \r \n etc.

How to repeat:
executed a BackUp with MySQL Administrator.
Executing the rows sql with Query Browser in order to create the database.
The database it contains many words in Italian with the characters \ ' \r \n etc.

The version of MySQL Administrator is 1.1.8 or 1.1.9

I have the same problem with MySQL database 4.0.26, 4.1.18,5.0.18.

Not there are problems with version 1,1,14 of MySQl Query Browser.  I have unistalled 1.1.20 and installed version 1,1,4 on the same computer.

Thank you for a problem report. Please, send the exact SQL statement that works OK in mysql client and does not work in QB 1.1.20. Just one example.

--
-- Table structure for table `digitime`.`comuni`
--

DROP TABLE IF EXISTS `comuni`;
CREATE TABLE `comuni` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Campo1` varchar(255) default NULL,
  `Campo2` varchar(255) default NULL,
  `Campo3` varchar(255) default NULL,
  `Campo4` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=InnoDB;

--
-- Dumping data for table `digitime`.`comuni`
--

/*!40000 ALTER TABLE `comuni` DISABLE KEYS */;
INSERT INTO `comuni` (`ID`,`Campo1`,`Campo2`,`Campo3`,`Campo4`) VALUES 
 (1,'Abano Terme','PD','35031','049'),
 (2,'Abbadia Cerreto','MI','20070','0371'),
 (3,'Abbadia Lariana','CO','22050','0341'),
 (4,'Abbadia San Salvatore','SI','53021','0577'),
 (5,'Abbasanta','OR','09071','0785'),
 (6,'Abbateggio','PE','65020','085'),
 (7,'Abbiategrasso','MI','20081','02'),
 (8,'Abetone','PT','51021','0573'),
 (9,'Abriola','PZ','85010','0971'),
 (10,'Acate','RG','97011','0932'),
 (11,'Accadia','FG','71021','0881'),
 (12,'Acceglio','CN','12021','0171'),
 (13,'Accettura','MT','75011','0835'),
 (14,'Acciano','AQ','67020','0864'),
 (15,'Accumoli','RI','02011','0746'),
 (16,'Acerenza','PZ','85011','0971'),
 (17,'Acerno','SA','84042','089'),
 (18,'Acerra','NA','80011','081'),
 (19,'Aci Bonaccorsi','CT','95020','095'),
 (20,'Aci Castello','CT','95021','095'),
 (21,'Aci Catena','CT','95022','095'),
 (22,'Aci Sant\'Antonio','CT','95025','095'),
 (23,'Acireale','CT','95024','095'),
 (24,'Acquacanina','MC','62030','0737'),
 (25,'Acquafondata','FR','03040','0776');
INSERT INTO `comuni` (`ID`,`Campo1`,`Campo2`,`Campo3`,`Campo4`) VALUES 
 (26,'Acquaformosa','CS','87010','0981'),
 (27,'Acquafredda','BS','25010','030'),
 (28,'Acqualagna','PS','61041','0721'),
 (29,'Acquanegra Cremonese','CR','26020','0372'),
 (30,'Acquanegra sul Chiese','MN','46011','0376'),
 (31,'Acquapendente','VT','01021','0763'),
 (32,'Acquappesa','CS','87020','0982'),
 (33,'Acquarica del Capo','LE','73040','0833'),
 (34,'Acquaro','VV','88011','0963'),
 (35,'Acquasanta Terme','AP','63041','0736'),
 (36,'Acquasparta','TR','05021','0744'),
 (37,'Acquaviva Collecroce','CB','86030','0875'),
 (38,'Acquaviva d\'Isernia','IS','86080','0865'),
 (39,'Acquaviva delle Fonti','BA','70021','080'),
 (40,'Acquaviva Picena','AP','63030','0735'),
 (41,'Acquaviva Platani','CL','93010','0934'),
 (42,'Acquedolci','ME','98070','0941'),
 (43,'Acqui Terme','AL','15011','0144'),
 (44,'Acri','CS','87041','0984'),
 (45,'Acuto','FR','03010','0775'),
 (46,'Adelfia','BA','70010','080'),
 (47,'Adrano','CT','95031','095'),
 (48,'Adrara San Martino','BG','24060','035');
INSERT INTO `comuni` (`ID`,`Campo1`,`Campo2`,`Campo3`,`Campo4`) VALUES 
 (49,'Adrara San Rocco','BG','24060','035'),
 (50,'Adria','RO','45011','0426'),
 (51,'Adro','BS','25030','030'),
 (52,'Affi','VR','37010','045'),
 (53,'Affile','RM','00021','0774'),
 (54,'Afragola','NA','80021','081'),
 (55,'Africo','RC','89030','0964'),
 (56,'Agazzano','PC','29010','0523'),
 (57,'Agerola','NA','80051','081'),
 (58,'Aggius','SS','07020','079'),
 (59,'Agira','EN','94011','0935'),
 (60,'Agliana','PT','51031','0574'),
 (61,'Agliano','AT','14041','0141'),
 (62,'Agli_','TO','10011','0124'),
 (63,'Aglientu','SS','07020','079'),
 (64,'Agna','PD','35021','049'),
 (65,'Agnadello','CR','26020','0373'),
 (66,'Agnana Calabra','RC','89040','0964'),
 (67,'Agnone','IS','86081','0865'),
 (68,'Agnosine','BS','25071','0365'),
 (69,'Agordo','BL','32021','0437'),
 (70,'Agosta','RM','00020','0774'),
 (71,'Agra','VA','21010','0332'),
 (72,'Agrate Brianza','MI','20041','039'),
 (73,'Agrate Conturbia','NO','28010','0322'),
 (74,'Agrigento','AG','92100','0922');
INSERT INTO `comuni` (`ID`,`Campo1`,`Campo2`,`Campo3`,`Campo4`) VALUES 
 (75,'Agropoli','SA','84043','0974'),
 (76,'Agugliano','AN','60020','071'),
 (77,'Agugliaro','VI','36020','0444'),
 (78,'Aicurzio','MI','20040','039'),
 (79,'Aidomaggiore','OR','09070','0785'),
 (80,'Aidone','EN','94010','0935'),
 (81,'Aielli','AQ','67041','0863'),
 (82,'Aiello Calabro','CS','87031','0982'),
 (83,'Aiello del Friuli','UD','33041','0431'),
 (84,'Aiello del Sabato','AV','83020','0825'),
 (85,'Aieta','CS','87020','0985'),
 (86,'Ailano','CE','81010','0823'),
 (87,'Ailoche','BI','13010','015'),
 (88,'Airasca','TO','10060','011'),
 (89,'Airola','BN','82011','0823'),
 (90,'Airole','IM','18030','0184'),
 (91,'Airuno','LC','22050','039'),
 (92,'Aisone','CN','12010','0171'),
 (93,'Ala','TN','38061','0464'),
 (94,'Al^ dei Sardi','SS','07020','079'),
 (95,'Ala di Stura','TO','10070','0123'),
 (96,'Alagna','PV','27020','0382'),
 (97,'Alagna Valsesia','VC','13021','0163'),
 (98,'Alanno','PE','65020','085'),
 (99,'Alano di Piave','BL','32031','0439'),
 (100,'Alassio','SV','17021','0182');
INSERT INTO `comuni` (`ID`,`Campo1`,`Campo2`,`Campo3`,`Campo4`) VALUES 
 (101,'Alatri','FR','03011','0775'),
 (102,'Alba','CN','12051','0173'),
 (103,'Alba Adriatica','TE','64011','0861'),
 (104,'Albagiara','OR','09090','0783'),
 (105,'Albairate','MI','20080','02'),
 (106,'Albanella','SA','84044','0828'),
 (107,'Albano di Lucania','PZ','85010','0971'),
 (108,'Albano Laziale','RM','00041','06'),
 (109,'Albano Sant\'Alessandro','BG','24061','035'),
 (110,'Albano Vercellese','VC','13030','0161'),
 (111,'Albaredo Arnaboldi','PV','27043','0385'),
 (112,'Albaredo d\'Adige','VR','37041','045'),
 (113,'Albaredo per San Marco','SO','23010','0342'),
 (114,'Albareto','PR','43051','0525'),
 (115,'Albaretto della Torre','CN','12050','0173'),
 (116,'Albavilla','CO','22031','031'),
 (117,'Albenga','SV','17031','0182'),
 (118,'Albera Ligure','AL','15060','0143'),
 (119,'Alberobello','BA','70011','080'),
 (120,'Alberona','FG','71031','0881'),
 (121,'Albese con Cassano','CO','22032','031'),
 (122,'Albettone','VI','36020','0444'),
 (123,'Albi','CZ','88050','0961');
INSERT INTO `comuni` (`ID`,`Campo1`,`Campo2`,`Campo3`,`Campo4`) VALUES 
 (124,'Albiano d\'Ivrea','TO','10010','0125'),
 (125,'Albiano di Trento','TN','38041','0461'),
 (126,'Albiate','MI','20042','0362'),
 (127,'Albidona','CS','87070','0981'),
 (128,'Albignasego','PD','35020','049'),
 (129,'Albinea','RE','42020','0522'),
 (130,'Albino','BG','24021','035'),
 (131,'Albiolo','CO','22070','031'),
 (132,'Albissola Marina','SV','17012','019'),
 (133,'Albissola Superiore','SV','17013','019'),
 (134,'Albizzate','VA','21041','0331'),
 (135,'Albonese','PV','27020','0384'),
 (136,'Albosaggia','SO','23100','0342'),
 (137,'Albugnano','AT','14020','011'),
 (138,'Albuzzano','PV','27010','0382'),
 (139,'Alcamo','TP','91011','0924'),
 (140,'Alcara Li Fusi','ME','98070','0941'),
 (141,'Aldeno','TN','38060','0461'),
 (142,'Aldino','BZ','39040','0471'),
 (143,'Ales','OR','09091','0783'),
 (144,'Alessandria','AL','15100','0131'),
 (145,'Alessandria del Carretto','CS','87070','0981'),
 (146,'Alessandria della Rocca','AG','92010','0922'),
 (147,'Alessano','LE','73031','0833');

I have the same problem in 1.1.20. A script containing:

149 INSERT INTO uf_agree VALUES ('AB05','Barclays Bank');
150 INSERT INTO uf_agree VALUES ('AB0531','Barnardo\'s');
151 INSERT INTO uf_agree VALUES ('AB055','Barnsley Building Society');

Produces an error 1064 at line 150.

I'm using Windows XP SP2. Loading the script as ANSI or UTF-8 makes no difference.

Rolling back to Query Browser 1.14 fixes the issue.

Duplicate of bug #17435.