List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:May 8 2003 2:23pm
Subject:re: A seroius trouble with MySQL
View as plain text  
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
       <___/   www.mysql.com



Thread
A seroius trouble with MySQLNitin Nanivadekar8 May
  • Re: A seroius trouble with MySQLBrian Reichert8 May
    • Re: A seroius trouble with MySQLCurtis Maurand12 May
  • Re: A seroius trouble with MySQLDan Nelson8 May
  • Re: A seroius trouble with MySQLKeith C. Ivey8 May
  • re: A seroius trouble with MySQLEgor Egorov10 May