-
magnus.blaudd@oracle.com authored
- 5.7 outputs additional columns from EXPLAIN since EXTENDED and PARTITIONS have been turned on by default. 1) This causes the 'rows' column to shift from position 9 to 10 2) Also it introduces the new column 'filtered' which is to be considered as unreliable as 'rows'. Quoting comment in existing test case "experience has shown that 'rows' estimates may vary depending on OS, compiler and .. phase of moon." - Fix problem by increasing the column number in masking of 'rows' and at the same time add masking of the 'filtered' column. - NOTE! Should have done this the first time when EXPLAIN output was recorded for 5.7 but the problem went unnoticed at that time.
magnus.blaudd@oracle.com authored- 5.7 outputs additional columns from EXPLAIN since EXTENDED and PARTITIONS have been turned on by default. 1) This causes the 'rows' column to shift from position 9 to 10 2) Also it introduces the new column 'filtered' which is to be considered as unreliable as 'rows'. Quoting comment in existing test case "experience has shown that 'rows' estimates may vary depending on OS, compiler and .. phase of moon." - Fix problem by increasing the column number in masking of 'rows' and at the same time add masking of the 'filtered' column. - NOTE! Should have done this the first time when EXPLAIN output was recorded for 5.7 but the problem went unnoticed at that time.
Loading