• Georgi Kodinov's avatar
    Bug #39656: Behaviour different for agg functions with & without where - · d795963c
    Georgi Kodinov authored
    ONLY_FULL_GROUP_BY
    
    The check for non-aggregated columns in queries with aggregate function, but without
    GROUP BY was treating all the parts of the query as if they are in the SELECT list.
    Fixed by ignoring the non-aggregated fields in the WHERE clause.
    
    mysql-test/r/func_group.result:
      Bug #39656: test case
    mysql-test/t/func_group.test:
      Bug #39656: test case
    sql/sql_select.cc:
      Bug #39656: ignore the new non-aggregated column refs in a WHERE
      by saving the state so far and then adding only the new values of the other
      parts of the bitmask.
    d795963c
func_group.test 30.7 KB