Bug #18801 | mysqldumpslow does not summarize negative numbers correctly | ||
---|---|---|---|
Submitted: | 5 Apr 2006 13:13 | Modified: | 7 Apr 2006 10:39 |
Reporter: | Oli Sennhauser | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.19 | OS: | Linux (linux) |
Assigned to: | CPU Architecture: | Any |
[5 Apr 2006 13:13]
Oli Sennhauser
[5 Apr 2006 14:01]
Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat the problem you described with the following simple test (on 5.0.21-BK): Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 5.0.21-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> desc t; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | x | int(11) | YES | | | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.01 sec) mysql> select sleep(20) from t where x = 1; +-----------+ | sleep(20) | +-----------+ | 0 | +-----------+ 1 row in set (20.07 sec) mysql> select sleep(20) from t where x = -1; Empty set (0.03 sec) mysql> exit Bye openxs@suse:~/dbs/5.0> bin/mysqldumpslow var/suse-slow.log Reading mysql slow query log from var/suse-slow.log Count: 1 Time=20.00s (20s) Lock=0.00s (0s) Rows=1.0 (1), root[root]@localhost select sleep(N) from t where x = N Count: 2 Time=15.00s (30s) Lock=0.00s (0s) Rows=1.0 (2), root[root]@localhost select sleep(N)
[7 Apr 2006 10:39]
Oli Sennhauser
Hi Valeriy 5.0.19 and 5.1.7 have still the same (erroneous) behaviour and I could not find any comment in the change list for a bugfix/change on this. Where can I get 5.0.21?