Execute batch file ERROR

[dany]

If you try to use the “Execute batch file” function with this code:

Code:

SET FOREIGN_KEY_CHECKS=0;

create database if not exists `GW`;

use `GW`;
/*
Table struture for CTL
*/

drop table if exists `CTL`;
CREATE TABLE `CTL` (
 `id` int(11) NOT NULL auto_increment,
 `idT` int(11) NOT NULL default '0',
 `idL` int(11) NOT NULL default '0',
 `testo` text NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `indexIdT` (`idT`),
 KEY `IndexIdL` (`idL`),
 CONSTRAINT `0_1521` FOREIGN KEY (`idT`) REFERENCES `t` (`id`),
 CONSTRAINT `0_1522` FOREIGN KEY (`idL`) REFERENCES `l` (`id`)
) TYPE=InnoDB ROW_FORMAT=DYNAMIC;

/*
Table data for GW.CTL
*/

INSERT INTO `CTL` VALUES (376,374,1,'La riga\”*uno*\” \ndell\'anagrafica (es. cli, for, …)');

SET FOREIGN_KEY_CHECKS=1;

SQLyog 3.11 reports an error.

I've tried 3.5 and it seems OK but you've not mentioned this (IMPORTANT) bug in the bugfix list.

Can I expect SQLyog 3.5 “Execute batch file” to REALLY work as expected? 😮

Bye

[Ritesh]

OOPPPSSS….

There was a BUG fix in 3.5 whereby certain Escape Sequences are properly handled 😀

[chris]

Ritesh wrote on Jun 21 2003, 06:20 PM:

OOPPPSSS….

There was a BUG fix in 3.5 whereby certain Escape Sequences are properly handled 😀

Sorry but the Bug ist still there in V3.5. I have some mediumblob with JPEG Images and it doesnt

run. It appears that there still several escape sequences wrong are interpreted.

😮

[Ritesh]

Can you send us a sample SQL file that is reporting error?

You can send them to [email protected]. Once we are able to duplicate the bug out here, it will be fixed in the next release.

[Ritesh]

All BUGS related to Escape Sequence has been fixed in SQLyog 3.51

HTH

[Author]

Posts