what others?
Where do you see 0="a" returning true?
Jus try yourself
aah... well so if you just explain that you will get your answer: root@localhost [test]> explain select * from b where "a"=0; +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+ | 1 | SIMPLE | b | NULL | ALL | NULL | NULL | NULL | NULL | 9 | 100.00 | NULL | +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+ 1 row in set, 2 warnings (0.00 sec) root@localhost [test]> show warnings; +---------+------+---------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------+ | Warning | 1292 | Truncated incorrect DOUBLE value: 'a' | | Note | 1003 | /* select#1 */ select `test`.`b`.`id` AS `id` from `test`.`b` | +---------+------+---------------------------------------------------------------+ 2 rows in set (0.00 sec)
Обсуждают сегодня