With the NULL-export issue another bug came creeping in

Export yields:

/*
SQLyog Enterprise v4.07 RC1
Host - 5.0.7-beta-nt-max : Database - test
*********************************************************************
Server version : 5.0.7-beta-nt-max
*/
create database if not exists `test`;
USE `test`;

/*Table structure for table `tablename1` */
drop table if exists `tablename1`;
CREATE TABLE `tablename1` (
`id` bigint(20) default NULL,
`mytext` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tablename1` */
insert into `tablename1` values (NULL,a\b\c\d);
insert into `tablename1` values (NULL,e\f\g\h);


error msg with import goes


correct insert stmts would be:
insert into `tablename1` values (NULL,'a\\b\\c\\d');
insert into `tablename1` values (NULL,'e\\f\\g\\h');


Select * returns correct result so data are OK, as also pic shows

BTW: This issue gets me stuck with testing other features ....

This bug comes when you export resultset or table data?

Table! Right-clicking on table in object-browser.

The bug is new. Was not in 4.06 and 4.07 Beta1 (not sure about beta2). It is reproduced on MySQL 4.0.24 and 5.0.7

Other examples that fail

/*Data for the table `tablename1` */
insert into `tablename1` values (NULL,a\b\c\d);
insert into `tablename1` values (NULL,e\f\g\h);
insert into `tablename1` values (NULL,ijkl);
insert into `tablename1` values (NULL,m\n\o\p);

/*Data for the table `tablename1` */
insert into `tablename1` values (NULL,abcd);
insert into `tablename1` values (NULL,e\f\g\h);
insert into `tablename1` values (NULL,ijkl);
insert into `tablename1` values (NULL,m\n\o\p);

/*Data for the table `tablename1` */
insert into `tablename1` values (NULL,abcd);
insert into `tablename1` values (NULL,efgh);
insert into `tablename1` values (NULL,ijkl);
insert into `tablename1` values (NULL,mnop);


The following examples show that it is related to "NULL-fix"
With these examples numerical field is auto-increment (and thus not NULL)
and insert-stmts are correct

/*Data for the table `tablename1` */
insert into `tablename1` values (1,'abcd');
insert into `tablename1` values (2,'efgh');
insert into `tablename1` values (3,'ijkl');
insert into `tablename1` values (4,'mnop');

/*Data for the table `tablename1` */
insert into `tablename1` values (1,'a\\b\\c\\d');
insert into `tablename1` values (2,'efgh');
insert into `tablename1` values (3,'i\\j\\k\\l');
insert into `tablename1` values (4,'mnop');

Bug confirmed and fixed. Fix will be available from 4.07 RC2.

I confirm that all export/import issues with 4.06 and 4.07 betas discussed here and here http://www.webyog.com/forums/index.php?act...t=ST&f=6&t=1504 are fixed.