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,
> > > > --
> > > > Guillaume FOUGNIES
> > > > Research & Development Profile For You Ltd.
> > >
> > > 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,
> > >
> > > --
> > > For technical support contracts, go to https://order.mysql.com/
> > > __ ___ ___ ____ __
> > > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> > > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> > > <___/ www.mysql.com
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]> Trouble
> > > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> > --
> > Have a great day...
> > John
> >
> --
> Guillaume FOUGNIES
> Research & Development Profile For You Ltd.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php