On Thursday 08 May 2003 13:12, Nitin Nanivadekar wrote:
> i am using mysql 3.23 on a machine with 150MB HDD and
> 96 MB ram. i've already mailed you about some problems
> regarding mysqld functioning.
> now i am getting a serious problem.
> 1. the max () keyword reports 'different' resultsets
> when following queries are sent to it,
> a. select max(id) from table1;
> b. select max(id) from table1 where id2=100;
> in any condition (like the low resources etc.) i
> should not get different results from seemingly
> identical queries.
But these queries are different. The first query returns max id from thr whole
table, but the second one max id for which id2=100.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net