Re: mysqldump bug during regenerate enum field. - Pete Harlan - com.mysql.lists.mysql

11 messages in com.mysql.lists.mysqlRe: mysqldump bug during regenerate e...

From	Sent On	Attachments
John Cichy	18 Jun 2001 05:08
gfou...@profile4u.com	18 Jun 2001 05:53
Sinisa Milivojevic	18 Jun 2001 06:04
Thomas Karcher	18 Jun 2001 06:08
Guillaume Fougnies	18 Jun 2001 06:18
Andrew Schmidt	18 Jun 2001 06:20
John Cichy	18 Jun 2001 06:34
Sinisa Milivojevic	18 Jun 2001 06:46
Guillaume Fougnies	18 Jun 2001 07:54
Pete Harlan	19 Jun 2001 08:17
Guillaume Fougnies	19 Jun 2001 08:32

Subject:	Re: mysqldump bug during regenerate enum field.
From:	Pete Harlan (har...@artselect.com)
Date:	06/19/2001 08:17:13 AM
List:	com.mysql.lists.mysql

It would seem that there is a bug, and it's that "create table" accepts an 'illegal' definition. It should either convert the integer to a literal (making the definition legal and dumpable), or it should barf on it.

IMO, of course.

--Pete

[Charset iso-8859-1 unsupported, filtering to ASCII...]

But my problem is perhaps simply in the concept:

When MySQL accept a create table in entry (as bad as it is like this one from a
guy in my team), mysqldump should regenerate from this table a create table
statement accepted by MySQL too.

no? it's not logic? ;-)

Regards,

Le Mon, Jun 18, 2001 at 09:34:27AM -0400, John Cichy a _crit:

Sinisa,

A good way to prove that mysqldump is doing what it should, might be to do a describe TESTBADDUMP;

I think this will prove that mysqldump is just dumping what is in the table def, which is all you can expect.

Have a great day... John

On Monday 18 June 2001 09:46, Sinisa Milivojevic wrote:

Guillaume Fougnies writes:

ok so it's a failure from mysqldump.

I know this declaration is not really correct but mysqldump must regenerate a correct sql statement (good when pipe in mysql client i mean at least ;) ). It's not the case.

Regards,

No, it is not mysqldump failure. If you specify integers where literals are expected, then it is your fault. Use quotes and a problem will dissapear.

Regards,

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-john=gree...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail
<mysql-unsubscribe-harlan=poin...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php