List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:September 9 1999 4:32pm
Subject:Re: Little bug in mysql.exe
View as plain text  
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.

Thread
Little bug in mysql.exePatrice Bulat31 Aug
  • Re: Little bug in mysql.exeChristian Mack9 Sep