New export-bug

[peterlaursen]

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,abcd);

insert into `tablename1` values (NULL,efgh);

error msg with import goes

Quote:

insert into `tablename1` values (NULL,a)

Line no.:24

Error Code: 1054 – Unknown column 'a' in 'field list'

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 ….

[Ritesh]

This bug comes when you export resultset or table data?

[peterlaursen]

Quote:

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

[peterlaursen]

Other examples that fail

/*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);

/*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);

/*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');

[Ritesh]

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

[peterlaursen]

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.

[Author]

Posts