"Brian Shearer" <[EMAIL PROTECTED]> wrote: > I have a simple query: > SELECT * FROM cart > WHERE CartID=999 AND ProdID=333 > > The primary key is made of both CartID and ProdID, both integers. > > The query will not return the record in question > > This returns the row: > SELECT * FROM cart > WHERE CartID=999 > > And this returns the same row: > SELECT * FROM cart > WHERE ProdID=333 > > But this returns zero records: > SELECT * FROM cart > WHERE CartID=999 AND ProdID=333 > > Any ideas?
Check that queries SELECT * FROM cart WHERE CartID=999 and SELECT * FROM cart WHERE ProdID=333 return the same row. If so, recreate indexes. If it doesn't help create a repeatable test case. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
