No Clause-No Error On WHERE

[Ilias Karampatsos]

Description:
        Writing an SQL statement and not specifying a clause does not raise an error. 

How-To-Repeat:

CREATE TABLE `test` (`col1` mediumint(10) NOT NULL default '0', PRIMARY KEY  (`col1`) )
ENGINE=MyISAM 
insert into test (col1) values (1),(2),(3),(4),(5);

select * from test where col1;
delete from test where col1;

Fix:
I do not know if this is a bug, but it makes more sense for me to give to the sql-writer a
warning instead (specially for the delete statement)

This applies to all mysql versions/platforms...


----------------------
Ilias Karampatsos
Chief Scientist
Consumer Intelligence
0117 311 8448
0779 110 7205
www.consumerintel.com

This e-mail and any attachments are confidential. If you are not the intended recipient
please do not disclose, copy, store, distribute or take any action in respect of the
content. If you have received this message in error, please notify the sender immediately
by using the reply function and then delete it. Thank you.