what's the proble of these two query sql statement in mysql cluster 7.4.7?
it's just diffent ahout the position of where contiditon,to my untanstand,i thout the result show same.
mysql> select * from (SELECT * FROM `rt_urls` WHERE s_check_urls_id = 1 ) as t where enabled=1;
Empty set (0.04 sec)
mysql> select * from (SELECT * FROM `rt_urls` WHERE s_check_urls_id = 1 and enabled=1) as t limit 0,5;
+----+------------------+-----------------+-----------------------+---------+------+---------------------+
| id | serverid | s_check_urls_id | url | enabled | msg | createtime |
+----+------------------+-----------------+-----------------------+---------+------+---------------------+
| 1 | fly561f9a54234ce | 1 |
https://www.baidu.com | | NULL | 2015-11-05 17:35:51 |
| 4 | fly561f9a54234ce | 1 |
https://www.baidu.com | | NULL | 2015-11-05 17:36:11 |
| 12 | fly561f9a54234ce | 1 |
https://www.baidu.com | | NULL | 2015-11-05 17:37:01 |
| 13 | fly561f9a54234ce | 1 |
https://www.baidu.com | | NULL | 2015-11-05 17:39:57 |
| 19 | fly561f9a54234ce | 1 |
https://www.baidu.com | | NULL | 2015-11-05 17:40:34 |
+----+------------------+-----------------+-----------------------+---------+------+---------------------+
5 rows in set (0.08 sec)
this situation is not happened on innodb i have test it.
can anybody explain how is it?