• unknown's avatar
    Bug#27874: Non-grouped columns are allowed by * in ONLY_FULL_GROUP_BY mode. · 3ffdeef0
    unknown authored
    When fields are inserted instead of * in the select list they were not marked
    for check for the ONLY_FULL_GROUP_BY mode.
    
    The Field_iterator_table::create_item() function now marks newly created
    items for check when in the ONLY_FULL_GROUP_BY mode.
    The setup_wild() and the insert_fields() functions now maintain the
    cur_pos_in_select_list counter for the ONLY_FULL_GROUP_BY mode.
    
    
    sql/sql_base.cc:
      Bug#27874: Non-grouped columns are allowed by * in ONLY_FULL_GROUP_BY mode.
      The setup_wild() and the insert_fields() functions now maintain the
      cur_pos_in_select_list counter for the ONLY_FULL_GROUP_BY mode.
    sql/table.cc:
      Bug#27874: Non-grouped columns are allowed by * in ONLY_FULL_GROUP_BY mode.
      The Field_iterator_table::create_item() function now marks newly created
      items for check when in the ONLY_FULL_GROUP_BY mode.
    mysql-test/r/group_by.result:
      Added a test case for the bug#27874: Non-grouped columns are allowed by * in ONLY_FULL_GROUP_BY mode.
    mysql-test/t/group_by.test:
      Added a test case for the bug#27874: Non-grouped columns are allowed by * in ONLY_FULL_GROUP_BY mode.
    3ffdeef0
group_by.test 30.6 KB