Re: behaviour of WHERE clause with empty fields

2002-11-01 Thread John Ragan
Returns only rows where grp = 'C' and not undefined > Similar behaviour with LIKE and IN > >Fix: > Puzzled? > Am I not understanding something? > > >Submitter-Id: > >Originator: Kevin McManus ([EMAIL PROTECTED]) > >Organiza

RE: behaviour of WHERE clause with empty fields

2002-11-01 Thread Fernando Grijalba
** -Original Message- From: Gonzo McMuppet [mailto:gonzo@;raq566.uk2net.com] Sent: November 1, 2002 16:29 To: [EMAIL PROTECTED] Subject: behaviour of WHERE clause with empty fields >Description: Empty fields are not matched using where clause NOT IN NOT L

behaviour of WHERE clause with empty fields

2002-11-01 Thread Gonzo McMuppet
Park Row Greenwich London SE10 9LS > >MySQL support: none >Synopsis: behaviour of WHERE clause with empty fields >Severity: serious >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Source distribu