Comment 2 for bug 341115

Revision history for this message
Nidhi Shrotriya (nidhi-shrotriya) wrote :

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)