Patrice Bulat wrote:
>
> Hello,
> Here is a little bug I noticed in mysql.exe, where an invalid command
> causes mysql.exe to quit. Of course the syntax I used for "alter table" is
> not correct (I forgot "set" before "default"), but I wouldn't expect the
> program to quit !
> I'm using the shareware version 3.21.29a-gamma-debug under Windows NT 4.0
>
> ====================
>
> C:\mysql\bin> mysql.exe
>
> [Welcome ...]
>
> mysql> use my_db;
>
> Database changed.
>
> mysql> describe compteur;
>
> Field Type Null Key Default Extra
> ----- ---- ---- --- ------- -----
> serveur smallint(5) unsigned MUL
> jour timestamp(8) YES MUL NULL
> valeur int(10) unsigned 0
>
> (3 row(s) affected)
>
> mysql> alter table compteur alter serveur default 0;
>
> ERROR 1064: parse error near 'default 0' at line 1
> Bye
>
> ====================
>
> Patrice
Hi Patrice
This is already fixed in the licenced version.
Tschau
Christian
PS: Sorry for the late answer, I was really busy.
