Robert, Monday, November 04, 2002, 12:39:34 AM, you wrote: RGp> I've tried an EXPLAIN of the SELECT below.
RGp> Please can anyone tell me why it's RGp> "Impossible WHERE noticed after reading const tables" RGp> ? RGp> I've droped and created the table - but the error/message occurs. RGp> When I leave '(chetPosition = 1)' away, it works! RGp> A bug or ??? [skip] RGp> mysql> explain RGp> -> SELECT * FROM hmChartEntry RGp> -> WHERE (ctId = 1) AND RGp> -> (chSubId = 1) AND RGp> -> (chetPosition = 1) RGp> -> ; RGp> +-----------------------------------------------------+ RGp> | Comment | RGp> +-----------------------------------------------------+ RGp> | Impossible WHERE noticed after reading const tables | RGp> +-----------------------------------------------------+ RGp> 1 row in set (0.00 sec) [skip] It's not a bug, it means there are no rows that satisfy the conditions in WHERE clause. -- 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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php