Re: BUG: Cannot DELETE all records with NULL entries in UNIQUE KEYfields

2001-04-09 Thread Matt Loschert
Okay..? Your explanation makes sense, but it seems a bit counter-intuitive. In my mind, if you insert identical values (no matter what they are) into a field that is declared to be a unique key, the database should complain like crazy, if not completely disallow the action. In any case, thank

BUG: Cannot DELETE all records with NULL entries in UNIQUE KEY fields

2001-04-09 Thread loschert
ND SQL TEST OUTPUT >Fix: No idea. >Submitter-Id: >Originator:Matt Loschert >Organization: ServInt Internet Services Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http:

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > Matt Loschert writes: > > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > > > > > [EMAIL PROTECTED] writes: > > > > >Description: > > > > > > > > As of mysql

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
, > > KEY User(User) < pukes on this line > > ) TYPE=MyISAM COMMENT='Database privileges'; > > > >If a space is added (as in: "KEY User (User)"), the file will import correctly.

mysqldump output file not valid as input file for mysql client

2001-02-22 Thread loschert
< pukes on this line ) TYPE=MyISAM COMMENT='Database privileges'; If a space is added (as in: "KEY User (User)"), the file will import correctly. I looked through the source file mysqldump.c and it appears that there always should be a sp