Testcase opt_trace.temp_table is unstable

[Laurynas Biveinis]

On 5.6:

opt_trace.temp_table w3 [ fail ]
        Test ended at 2016-12-07 07:43:01

CURRENT_TEST: opt_trace.temp_table
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/centos5-64/mysql-test/suite/opt_trace/r/temp_table.result 2016-11-16 15:06:39.220325907 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/centos5-64/build/mysql-test/var/3/log/temp_table.reject 2016-12-07 15:43:01.384377915 +0300
@@ -789,7 +789,7 @@
                     {
                       "table": "`t1`",
                       "table_scan": {
- "rows": 66,
+ "rows": 65,
                         "cost": 1
                       } /* table_scan */
                     }
@@ -805,14 +805,14 @@
                         "considered_access_paths": [
                           {
                             "access_type": "scan",
- "rows": 66,
- "cost": 14.2,
+ "rows": 65,
+ "cost": 14,
                             "chosen": true
                           }
                         ] /* considered_access_paths */
                       } /* best_access_path */,
- "cost_for_plan": 14.2,
- "rows_for_plan": 66,
+ "cost_for_plan": 14,
+ "rows_for_plan": 65,
                       "chosen": true
                     }
                   ] /* considered_execution_plans */
@@ -861,7 +861,7 @@
                     {
                       "table": "`t1`",
                       "table_scan": {
- "rows": 66,
+ "rows": 65,
                         "cost": 1
                       } /* table_scan */
                     }
@@ -877,14 +877,14 @@
                         "considered_access_paths": [
                           {
                             "access_type": "scan",
- "rows": 66,
- "cost": 14.2,
+ "rows": 65,
+ "cost": 14,
                             "chosen": true
                           }
                         ] /* considered_access_paths */
                       } /* best_access_path */,
- "cost_for_plan": 14.2,
- "rows_for_plan": 66,
+ "cost_for_plan": 14,
+ "rows_for_plan": 65,
                       "chosen": true
                     }
                   ] /* considered_execution_plans */
@@ -929,7 +929,7 @@
               {
                 "table": " `tt`",
                 "table_scan": {
- "rows": 132,
+ "rows": 130,
                   "cost": 16
                 } /* table_scan */
               }
@@ -945,14 +945,14 @@
                   "considered_access_paths": [
                     {
                       "access_type": "scan",
- "rows": 132,
- "cost": 43,
+ "rows": 130,
+ "cost": 42.5,
                       "chosen": true
                     }
                   ] /* considered_access_paths */
                 } /* best_access_path */,
- "cost_for_plan": 43,
- "rows_for_plan": 132,
+ "cost_for_plan": 42.5,
+ "rows_for_plan": 130,
                 "chosen": true
               }
             ] /* considered_execution_plans */

mysqltest: Result content mismatch

[Laurynas Biveinis (laurynas-biveinis)]

     https://github.com/percona/percona-server/pull/1239
     https://github.com/percona/percona-server/pull/1240

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2216