Skip to content
  • Roy Lyseng's avatar
    e6f2ad2d
    Bug#14272788: Query with MaterializeScan and materialized subquery · e6f2ad2d
    Roy Lyseng authored
                  returns too many rows
    
    Patch #11 - Rename generated key fields in derived tables.
    
    Generated key fields in derived tables are currently named auto_keyN,
    where N is a sequentially generated number. This patch renames these
    fields to <auto_keyN>. This change is done for consistency, making
    all generated table and field names being enclosed in angular brackets.
    
    internal/mysql-test/suite/i_main/r/subquery.result
    mysql-test/r/derived.result
    mysql-test/r/func_analyse.result
    mysql-test/r/heap.result
    mysql-test/r/innodb_explain_json_non_select_all.result
    mysql-test/r/innodb_explain_json_non_select_none.result
    mysql-test/r/innodb_explain_non_select_all.result
    mysql-test/r/innodb_explain_non_select_none.result
    mysql-test/r/myisam_explain_json_non_select_all.result
    mysql-test/r/myisam_explain_json_non_select_none.result
    mysql-test/r/myisam_explain_non_select_all.result
    mysql-test/r/myisam_explain_non_select_none.result
    mysql-test/r/subquery_sj_all.result
    mysql-test/r/subquery_sj_all_bka.result
    mysql-test/r/subquery_sj_all_bka_nixbnl.result
    mysql-test/r/subquery_sj_all_bkaunique.result
    mysql-test/r/subquery_sj_dupsweed.result
    mysql-test/r/subquery_sj_dupsweed_bka.result
    mysql-test/r/subquery_sj_dupsweed_bka_nixbnl.result
    mysql-test/r/subquery_sj_dupsweed_bkaunique.result
    mysql-test/r/subquery_sj_firstmatch.result
    mysql-test/r/subquery_sj_firstmatch_bka.result
    mysql-test/r/subquery_sj_firstmatch_bka_nixbnl.result
    mysql-test/r/subquery_sj_firstmatch_bkaunique.result
    mysql-test/r/subquery_sj_loosescan.result
    mysql-test/r/subquery_sj_loosescan_bka.result
    mysql-test/r/subquery_sj_loosescan_bka_nixbnl.result
    mysql-test/r/subquery_sj_loosescan_bkaunique.result
    mysql-test/r/subquery_sj_mat.result
    mysql-test/r/subquery_sj_mat_bka.result
    mysql-test/r/subquery_sj_mat_bka_nixbnl.result
    mysql-test/r/subquery_sj_mat_bkaunique.result
    mysql-test/r/subquery_sj_mat_nosj.result
    mysql-test/r/subquery_sj_none.result
    mysql-test/r/subquery_sj_none_bka.result
    mysql-test/r/subquery_sj_none_bka_nixbnl.result
    mysql-test/r/subquery_sj_none_bkaunique.result
    mysql-test/suite/opt_trace/r/filesort_pq.result
    mysql-test/suite/opt_trace/r/general_no_prot_all.result
    mysql-test/suite/opt_trace/r/general_no_prot_none.result
    mysql-test/suite/opt_trace/r/general_ps_prot_all.result
    mysql-test/suite/opt_trace/r/general_ps_prot_none.result
    mysql-test/suite/opt_trace/r/subquery_no_prot.result
    mysql-test/suite/opt_trace/r/subquery_ps_prot.result
      Changed generated key field names for derived tables from
      auto_keyN to <auto_keyN>.
    
    sql/table.cc
      In TABLE_LIST::generate_keys(), add angular brackets to generated
      key field names for derived tables.
    e6f2ad2d
    Bug#14272788: Query with MaterializeScan and materialized subquery
    Roy Lyseng authored
                  returns too many rows
    
    Patch #11 - Rename generated key fields in derived tables.
    
    Generated key fields in derived tables are currently named auto_keyN,
    where N is a sequentially generated number. This patch renames these
    fields to <auto_keyN>. This change is done for consistency, making
    all generated table and field names being enclosed in angular brackets.
    
    internal/mysql-test/suite/i_main/r/subquery.result
    mysql-test/r/derived.result
    mysql-test/r/func_analyse.result
    mysql-test/r/heap.result
    mysql-test/r/innodb_explain_json_non_select_all.result
    mysql-test/r/innodb_explain_json_non_select_none.result
    mysql-test/r/innodb_explain_non_select_all.result
    mysql-test/r/innodb_explain_non_select_none.result
    mysql-test/r/myisam_explain_json_non_select_all.result
    mysql-test/r/myisam_explain_json_non_select_none.result
    mysql-test/r/myisam_explain_non_select_all.result
    mysql-test/r/myisam_explain_non_select_none.result
    mysql-test/r/subquery_sj_all.result
    mysql-test/r/subquery_sj_all_bka.result
    mysql-test/r/subquery_sj_all_bka_nixbnl.result
    mysql-test/r/subquery_sj_all_bkaunique.result
    mysql-test/r/subquery_sj_dupsweed.result
    mysql-test/r/subquery_sj_dupsweed_bka.result
    mysql-test/r/subquery_sj_dupsweed_bka_nixbnl.result
    mysql-test/r/subquery_sj_dupsweed_bkaunique.result
    mysql-test/r/subquery_sj_firstmatch.result
    mysql-test/r/subquery_sj_firstmatch_bka.result
    mysql-test/r/subquery_sj_firstmatch_bka_nixbnl.result
    mysql-test/r/subquery_sj_firstmatch_bkaunique.result
    mysql-test/r/subquery_sj_loosescan.result
    mysql-test/r/subquery_sj_loosescan_bka.result
    mysql-test/r/subquery_sj_loosescan_bka_nixbnl.result
    mysql-test/r/subquery_sj_loosescan_bkaunique.result
    mysql-test/r/subquery_sj_mat.result
    mysql-test/r/subquery_sj_mat_bka.result
    mysql-test/r/subquery_sj_mat_bka_nixbnl.result
    mysql-test/r/subquery_sj_mat_bkaunique.result
    mysql-test/r/subquery_sj_mat_nosj.result
    mysql-test/r/subquery_sj_none.result
    mysql-test/r/subquery_sj_none_bka.result
    mysql-test/r/subquery_sj_none_bka_nixbnl.result
    mysql-test/r/subquery_sj_none_bkaunique.result
    mysql-test/suite/opt_trace/r/filesort_pq.result
    mysql-test/suite/opt_trace/r/general_no_prot_all.result
    mysql-test/suite/opt_trace/r/general_no_prot_none.result
    mysql-test/suite/opt_trace/r/general_ps_prot_all.result
    mysql-test/suite/opt_trace/r/general_ps_prot_none.result
    mysql-test/suite/opt_trace/r/subquery_no_prot.result
    mysql-test/suite/opt_trace/r/subquery_ps_prot.result
      Changed generated key field names for derived tables from
      auto_keyN to <auto_keyN>.
    
    sql/table.cc
      In TABLE_LIST::generate_keys(), add angular brackets to generated
      key field names for derived tables.
Loading