Description:
main.func_misc [ fail ]
Test ended at 2008-12-26 12:50:28
CURRENT_TEST: main.func_misc
--- C:/cygwin/home/pushbuild/pb1/pb/bzr_mysql-6.0-rpl/139/mysql-6.0.10-alpha-pb139/mysql-test/r/func_misc.result 2008-12-26 12:54:49.000000000 +0300
+++ C:\cygwin\home\pushbuild\pb1\pb\bzr_mysql-6.0-rpl\139\mysql-6.0.10-alpha-pb139\mysql-test\r\func_misc.reject 2008-12-26 14:50:26.328125000 +0300
@@ -178,7 +178,7 @@
BETWEEN 0 AND @max_acceptable_delay;
SELECT @aux1 AS "Expect 1";
Expect 1
-1
+0
# Test 2: Does the query with SLEEP need a reasonable time even in case
# of the non first execution?
SELECT COUNT(*) >= 4 - 1 - 1 INTO @aux2 FROM t_history
@@ -187,13 +187,20 @@
AND attempt > 1;
SELECT @aux2 AS "Expect 1";
Expect 1
-1
+0
# Test 3: The query with SLEEP must be not cached.
SELECT COUNT(*) = 4 INTO @aux3 FROM t_history
WHERE end_cached = start_cached;
SELECT @aux3 AS "Expect 1";
Expect 1
1
+# Some tests failed, dumping the content of t_history
+SELECT * FROM t_history;
+attempt start_ts end_ts start_cached end_cached
+1 2008-12-26 14:49:59 2008-12-26 14:50:06 0 0
+2 2008-12-26 14:50:06 2008-12-26 14:50:13 0 0
+3 2008-12-26 14:50:13 2008-12-26 14:50:19 0 0
+4 2008-12-26 14:50:19 2008-12-26 14:50:26 0 0
DROP TABLE t1;
DROP TEMPORARY TABLE t_history;
SET @@global.query_cache_size = default;
mysqltest: Result content mismatch
- saving 'e:/var-embedded-101/log/main.func_misc/' to 'e:/var-embedded-101/log/main.func_misc/'
Retrying test, attempt(2/3)...
How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=140 [vm-win2003-32-]
http://tinyurl.com/9ruwac
Description: main.func_misc [ fail ] Test ended at 2008-12-26 12:50:28 CURRENT_TEST: main.func_misc --- C:/cygwin/home/pushbuild/pb1/pb/bzr_mysql-6.0-rpl/139/mysql-6.0.10-alpha-pb139/mysql-test/r/func_misc.result 2008-12-26 12:54:49.000000000 +0300 +++ C:\cygwin\home\pushbuild\pb1\pb\bzr_mysql-6.0-rpl\139\mysql-6.0.10-alpha-pb139\mysql-test\r\func_misc.reject 2008-12-26 14:50:26.328125000 +0300 @@ -178,7 +178,7 @@ BETWEEN 0 AND @max_acceptable_delay; SELECT @aux1 AS "Expect 1"; Expect 1 -1 +0 # Test 2: Does the query with SLEEP need a reasonable time even in case # of the non first execution? SELECT COUNT(*) >= 4 - 1 - 1 INTO @aux2 FROM t_history @@ -187,13 +187,20 @@ AND attempt > 1; SELECT @aux2 AS "Expect 1"; Expect 1 -1 +0 # Test 3: The query with SLEEP must be not cached. SELECT COUNT(*) = 4 INTO @aux3 FROM t_history WHERE end_cached = start_cached; SELECT @aux3 AS "Expect 1"; Expect 1 1 +# Some tests failed, dumping the content of t_history +SELECT * FROM t_history; +attempt start_ts end_ts start_cached end_cached +1 2008-12-26 14:49:59 2008-12-26 14:50:06 0 0 +2 2008-12-26 14:50:06 2008-12-26 14:50:13 0 0 +3 2008-12-26 14:50:13 2008-12-26 14:50:19 0 0 +4 2008-12-26 14:50:19 2008-12-26 14:50:26 0 0 DROP TABLE t1; DROP TEMPORARY TABLE t_history; SET @@global.query_cache_size = default; mysqltest: Result content mismatch - saving 'e:/var-embedded-101/log/main.func_misc/' to 'e:/var-embedded-101/log/main.func_misc/' Retrying test, attempt(2/3)... How to repeat: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=140 [vm-win2003-32-] http://tinyurl.com/9ruwac