In the same test, queries like
SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2;
SELECT * FROM t2 WHERE c1 > -2147483648 ORDER BY c1,c2;
timeout.
nidhi@nidhi-laptop:~/mysql-builds/mysql-6.0.8-alpha-pbxt/mysql-test$ tail -f var/log/master.log
1 Query SELECT * FROM t2 WHERE c2 IN(8,9) ORDER BY c2 DESC
1 Query UPDATE t2 SET c1=-2147483648 WHERE c2 IS NULL ORDER BY c2 LIMIT 2
1 Query SELECT * FROM t2 WHERE c2 IS NULL ORDER BY c2
1 Query UPDATE t2 SET c1=-2147483648 WHERE c2>= 6 AND c2 < 9 ORDER BY c2 LIMIT 2
1 Query SELECT * FROM t2 WHERE c2>= 6 AND c2 < 9 ORDER BY c2
1 Query UPDATE t2 SET c1=-2147483648 WHERE c1=-12 OR c2=1
1 Query SELECT * FROM t2
1 Query SELECT * FROM t2 WHERE c1=-2147483648
1 Query SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2
mysql> show processlist
-> ;
+----+------+-----------+------+---------+------+----------------+---------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+----------------+---------------------------------------------------------+
| 1 | root | localhost | test | Query | 240 | Sorting result | SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2 |
| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+----+------+-----------+------+---------+------+----------------+---------------------------------------------------------+
2 rows in set (0.00 sec)
--
mysql> show processlist;
+----+------+-----------+------+---------+------+----------------+---------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+----------------+---------------------------------------------------------+
| 1 | root | localhost | test | Query | 849 | Sorting result | SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2 |
| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+----+------+-----------+------+---------+------+----------------+---------------------------------------------------------+
2 rows in set (0.00 sec)
In the same test, queries like
SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2;
SELECT * FROM t2 WHERE c1 > -2147483648 ORDER BY c1,c2;
timeout.
nidhi@nidhi- laptop: ~/mysql- builds/ mysql-6. 0.8-alpha- pbxt/mysql- test$ tail -f var/log/master.log -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- ----+ -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- ----+ -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- ----+ -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- ----+ -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- ----+ -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- --+---- ------- ------- ------- ------- ------- ------- ------- ----+
1 Query SELECT * FROM t2 WHERE c2 IN(8,9) ORDER BY c2 DESC
1 Query UPDATE t2 SET c1=-2147483648 WHERE c2 IS NULL ORDER BY c2 LIMIT 2
1 Query SELECT * FROM t2 WHERE c2 IS NULL ORDER BY c2
1 Query UPDATE t2 SET c1=-2147483648 WHERE c2>= 6 AND c2 < 9 ORDER BY c2 LIMIT 2
1 Query SELECT * FROM t2 WHERE c2>= 6 AND c2 < 9 ORDER BY c2
1 Query UPDATE t2 SET c1=-2147483648 WHERE c1=-12 OR c2=1
1 Query SELECT * FROM t2
1 Query SELECT * FROM t2 WHERE c1=-2147483648
1 Query SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2
mysql> show processlist
-> ;
+----+-
| Id | User | Host | db | Command | Time | State | Info |
+----+-
| 1 | root | localhost | test | Query | 240 | Sorting result | SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2 |
| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+----+-
2 rows in set (0.00 sec)
--
mysql> show processlist;
+----+-
| Id | User | Host | db | Command | Time | State | Info |
+----+-
| 1 | root | localhost | test | Query | 849 | Sorting result | SELECT * FROM t2 WHERE c1 <> -2147483648 ORDER BY c1,c2 |
| 2 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+----+-
2 rows in set (0.00 sec)