MySQL Forums
Forum List  »  Quality Assurance

MyIsam table returns erronous results
Posted by: liviu macoviciuc
Date: February 18, 2008 11:13AM

Description:
I have an application, written in php, which executes the following
query :

$query="SELECT * FROM agenda WHERE inuse=0 AND $crit='$val' AND
crt <> ALL(SELECT crt FROM apun WHERE campania='$campania') AND
crt <> ALL(SELECT crt FROM agiorn WHERE campania='$campania') AND
crt <> ALL(SELECT crt FROM reprog WHERE datarec>NOW() AND
campania='$campania') ORDER BY crt DESC LIMIT 1";

So, this query should return a row from agenda table which doesn't have
a corespondent in the others tables.The agenda table has a PRIMARY KEY
whichis used to establish the reference with the other specified tables
The application works perfect 99,99% of time.However, from time to
time, the query returns a record which should not be returned(for
example, a record from agenda table which has a correspondent in the
apun table)
WHY ?
I am using Windows 2000 Professional with all updates,Mysql 5.0.45
Community Edition and only MyIsam tables
Please somebody give me an advice :liviu.macoviciuc@gmail.com !
Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
MyIsam table returns erronous results
2903
February 18, 2008 11:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.