Sometime we don’t care about brackets at right position, especially when giving conditional statement. I guess everyone has put himself in trouble at leas once just for this.
A simple example in SQL query (make sure that your table i.e. myTable contains some records),
select * from myTable where 1=1 and 0=0 or 1=1 and 1=2
select * from myTable where 1=1 and (0=0 or 1=1) and 1=2
And it becomes worse when output chagnes depending upon platform in case of statement without any brackets.
Friday, April 20, 2007
Subscribe to:
Posts (Atom)