diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-03-17 16:29:16 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-03-17 16:29:16 +0200 |
| commit | 7af84377cc19136067ff818322e27d5e15167202 (patch) | |
| tree | ff528124dd951beb07cda51eb0d128cd5ea0c231 /mysql-test/r/information_schema.result | |
| parent | c14a43cd40012a41096fafe519a304adbab7e766 (diff) | |
| parent | 8a5a804530eb0ee9c935b2b581d62ead93ae2854 (diff) | |
| download | mariadb-git-7af84377cc19136067ff818322e27d5e15167202.tar.gz | |
Bug 22047: Time in SHOW PROCESSLIST for SQL thread in replication seems to
become negative
- merged the fix to 5.1
- extended to cover I_S.PROCESSLIST.TIME
- Changed the column type of I_S.PROCESSLIST.TIME from LOGNLONG
UNSIGNED
to LONG (to match the SHOW PROCESSLIST type)
- Added a test case
Diffstat (limited to 'mysql-test/r/information_schema.result')
| -rw-r--r-- | mysql-test/r/information_schema.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result index 5dd0f159428..9a75e478264 100644 --- a/mysql-test/r/information_schema.result +++ b/mysql-test/r/information_schema.result @@ -1720,4 +1720,9 @@ SELECT CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; CREATE_OPTIONS KEY_BLOCK_SIZE=1 DROP TABLE t1; +SET TIMESTAMP=@@TIMESTAMP + 10000000; +SELECT 'OK' AS TEST_RESULT FROM INFORMATION_SCHEMA.PROCESSLIST WHERE time < 0; +TEST_RESULT +OK +SET TIMESTAMP=DEFAULT; End of 5.1 tests. |