• unknown's avatar
    BUG#14940 "MySQL choose wrong index", v.2 · 8dd88f48
    unknown authored
    - Make the range-et-al optimizer produce E(#table records after table 
                                               condition is applied),
    - Make the join optimizer use this value,
    - Add "filtered" column to EXPLAIN EXTENDED to show 
      fraction of records left after table condition is applied
    - Adjust test results, add comments
    
    
    mysql-test/r/archive_gis.result:
      BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
    mysql-test/r/auto_increment.result:
      BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
    mysql-test/r/bdb_gis.result:
      BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
    mysql-test/r/bench_count_distinct.result:
      BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
    mysql-test/r/binlog_stm_blackhole.result:
      BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
    mysql-test/r/case.result:
      BUG#...
    8dd88f48
index_merge_ror.result 12.2 KB