Test main.derived is unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
On 5.6 trunk:
main.derived w2 [ fail ]
Test ended at 2016-12-09 08:42:56
CURRENT_TEST: main.derived
--- /mnt/workspace/
+++ /mnt/workspace/
@@ -2002,7 +2002,7 @@
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t2 ALL NULL NULL NULL NULL 2 NULL
1 PRIMARY <derived2> ref <auto_key1> <auto_key1> 4 test.t2.a 2 Using where
-2 DERIVED t1 ALL NULL NULL NULL NULL 9 NULL
+2 DERIVED t1 ALL NULL NULL NULL NULL 10 NULL
SELECT a1.a, a1.b, a1.c FROM (SELECT a, b, c FROM t1 ) a1
JOIN t2 ON a1.a=t2.a WHERE a1.b='xxx';
a b c
mysqltest: Result content mismatch
tags: | added: ci upstream |
https:/ /github. com/percona/ percona- server/ pull/1244 /github. com/percona/ percona- server/ pull/1245
https:/