re: explain bug?
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
explain bug?
Hi, I've tried an EXPLAIN of the SELECT below. Please can anyone tell me why it's Impossible WHERE noticed after reading const tables ? I've droped and created the table - but the error/message occurs. When I leave '(chetPosition = 1)' away, it works! A bug or ??? The statement works without explain! Thx a lot, Robert MySql 3.23.49 mysql explain - SELECT * FROM hmChartEntry - WHERE (ctId = 1) AND - (chSubId = 1) AND - (chetPosition = 1) - ; +-+ | Comment | +-+ | Impossible WHERE noticed after reading const tables | +-+ 1 row in set (0.00 sec) mysql desc hmChartEntry; +--+---+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-+---+ | ctId | mediumint(8) unsigned | | PRI | 0 | | | chSubId | tinyint(3) unsigned | | PRI | 1 | | | chetPosition | tinyint(3) unsigned | | PRI | 0 | | | chetArtist | varchar(50) | YES | | NULL| | | chetTitle| varchar(80) | YES | | NULL| | | chetLabel| varchar(30) | YES | | NULL| | | coIdLabel| char(2) | YES | | NULL| | | chetDoLabelCheck | char(1) | | | Y | | | ctIdLabel| mediumint(8) unsigned | YES | | NULL| | +--+---+--+-+-+---+ 9 rows in set (0.00 sec) mysql mysql show index from hmChartEntry; +--++--+--+--+-- -+-+--++ -+ | Table| Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Com ment | +--++--+--+--+-- -+-+--++ -+ | hmChartEntry | 0 | PRIMARY |1 | ctId | A | 67 | NULL | NULL | | | hmChartEntry | 0 | PRIMARY |2 | chSubId | A | 71 | NULL | NULL | | | hmChartEntry | 0 | PRIMARY |3 | chetPosition | A |1208 | NULL | NULL | | +--++--+--+--+-- -+-+--++ -+ 3 rows in set (0.00 sec) mysql - 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