main.percona_query_response_time-stored fails on 5.1.50-rel12.1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Undecided
|
Oleg Tsarev |
Bug Description
main.percona_
Test ended at 2010-09-28 12:53:37
CURRENT_TEST: main.percona_
--- /mnt/data1/
+++ /mnt/data1/
@@ -22,12 +22,13 @@
Variable_name Value
query_
FLUSH QUERY_RESPONSE_
-SELECT c.count,
+SELECT d.count,
(SELECT SUM(a.count) FROM INFORMATION_
-(SELECT COUNT(*) FROM INFORMATION_
+(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_
+(SELECT COUNT(*) FROM INFORMATION_
(SELECT COUNT(*) FROM INFORMATION_
-FROM INFORMATION_
-count query_count not_zero_
+FROM INFORMATION_
+count query_count query_total not_zero_
SELECT COUNT(*) as region_count FROM INFORMATION_
region_count
44
@@ -76,7 +77,7 @@
2097152.00000
4194304.00000
8388608.00000
-TOO LONG QUERY
+TOO LONG
SET GLOBAL ENABLE_
SELECT test_f();
test_f()
@@ -91,14 +92,15 @@
test_f()
Hello, world!
SET GLOBAL ENABLE_
-SELECT c.count,
+SELECT d.count,
(SELECT SUM(a.count) FROM INFORMATION_
-(SELECT COUNT(*) FROM INFORMATION_
+(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_
+(SELECT COUNT(*) FROM INFORMATION_
(SELECT COUNT(*) FROM INFORMATION_
-FROM INFORMATION_
-count query_count not_zero_
-1 5 2 44
-4 5 2 44
+FROM INFORMATION_
+count query_count query_total not_zero_
+1 5 4 2 44
+4 5 4 2 44
SELECT COUNT(*) as region_count FROM INFORMATION_
region_count
44
@@ -147,7 +149,7 @@
2097152.00000
4194304.00000
8388608.00000
-TOO LONG QUERY
+TOO LONG
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_
Variable_name Value
query_
@@ -161,14 +163,15 @@
test_f()
Hello, world!
SET GLOBAL ENABLE_
-SELECT c.count,
+SELECT d.count,
(SELECT SUM(a.count) FROM INFORMATION_
-(SELECT COUNT(*) FROM INFORMATION_
+(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_
+(SELECT COUNT(*) FROM INFORMATION_
(SELECT COUNT(*) FROM INFORMATION_
-FROM INFORMATION_
-count query_count not_zero_
-1 2 2 14
-1 2 2 14
+FROM INFORMATION_
+count query_count query_total not_zero_
+1 2 1 2 14
+1 2 1 2 14
SELECT COUNT(*) as region_count FROM INFORMATION_
region_count
14
@@ -187,7 +190,7 @@
10000.000000
100000.000000
1000000.00000
-TOO LONG QUERY
+TOO LONG
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_
Variable_name Value
query_
@@ -201,14 +204,15 @@
test_f()
Hello, world!
SET GLOBAL ENABLE_
-SELECT c.count,
+SELECT d.count,
(SELECT SUM(a.count) FROM INFORMATION_
-(SELECT COUNT(*) FROM INFORMATION_
+(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_
+(SELECT COUNT(*) FROM INFORMATION_
(SELECT COUNT(*) FROM INFORMATION_
-FROM INFORMATION_
-count query_count not_zero_
-1 2 2 17
-1 2 2 17
+FROM INFORMATION_
+count query_count query_total not_zero_
+1 2 1 2 17
+1 2 1 2 17
SELECT COUNT(*) as region_count FROM INFORMATION_
region_count
17
@@ -230,7 +234,7 @@
117649.000000
823543.000000
5764801.00000
-TOO LONG QUERY
+TOO LONG
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_
Variable_name Value
query_
@@ -244,14 +248,15 @@
test_f()
Hello, world!
SET GLOBAL ENABLE_
-SELECT c.count,
+SELECT d.count,
(SELECT SUM(a.count) FROM INFORMATION_
-(SELECT COUNT(*) FROM INFORMATION_
+(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_
+(SELECT COUNT(*) FROM INFORMATION_
(SELECT COUNT(*) FROM INFORMATION_
-FROM INFORMATION_
-count query_count not_zero_
-1 2 2 7
-1 2 2 7
+FROM INFORMATION_
+count query_count query_total not_zero_
+1 2 1 2 7
+1 2 1 2 7
SELECT COUNT(*) as region_count FROM INFORMATION_
region_count
7
@@ -263,7 +268,7 @@
156.000000
24336.000000
3796416.00000
-TOO LONG QUERY
+TOO LONG
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_
Variable_name Value
query_
@@ -277,14 +282,15 @@
test_f()
Hello, world!
SET GLOBAL ENABLE_
-SELECT c.count,
+SELECT d.count,
(SELECT SUM(a.count) FROM INFORMATION_
-(SELECT COUNT(*) FROM INFORMATION_
+(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_
+(SELECT COUNT(*) FROM INFORMATION_
(SELECT COUNT(*) FROM INFORMATION_
-FROM INFORMATION_
-count query_count not_zero_
-1 2 2 6
-1 2 2 6
+FROM INFORMATION_
+count query_count query_total not_zero_
+1 2 1 2 6
+1 2 1 2 6
SELECT COUNT(*) as region_count FROM INFORMATION_
region_count
6
@@ -295,7 +301,7 @@
1.000000
1000.000000
1000000.00000
-TOO LONG QUERY
+TOO LONG
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_
Variable_name Value
query_
mysqltest: Result content mismatch
- saving '/mnt/data1/
Changed in percona-server: | |
milestone: | none → 5.1.50-12.1 |
assignee: | nobody → Aleksandr Kuzminsky (akuzminsky) |
assignee: | Aleksandr Kuzminsky (akuzminsky) → Oleg Tsarev (tsarev) |
Changed in percona-server: | |
status: | New → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → Fix Released |
should this be fix released?