• sergefp@mysql.com's avatar
    BUG#17314: Can't use index_merge/intersection for MERGE tables · f95b5b0a
    sergefp@mysql.com authored
    1. Fix index access costs for MERGE tables, set block_size=myisam_block_size/#underlying_tables 
       instead of 0 which it was before.
    2. Make index scans on MERGE table to return records in (key_tuple, merge_table_rowid) order, 
       instead of just (key_tuple) order. This makes an index scan on MERGE table to be truly a ROR-scan
       which is a requirement for index_merge union/intersection.
    f95b5b0a
index_merge.test 12.2 KB