New export-bug

[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