Regression in an aggregate query from release-9.0

[GuptaManan100]

Overview of the Issue

The following query works on release 9.0 -

select ascii(val1) as a, count(*) from aggr_test group by a

but on main the query fails with the following error -

target: ks.-80.primary: vttablet: rpc error: code = InvalidArgument desc = Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vt_ks.aggr_test.val1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (errno 1055) (sqlstate 42000) (CallerID: userData1): Sql: "select ascii(val1) as a, count(*), weight_string(ascii(val1)) from aggr_test group by a order by a asc", BindVars: {}
target: ks.80-.primary: vttablet: rpc error: code = InvalidArgument desc = Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vt_ks.aggr_test.val1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (errno 1055) (sqlstate 42000) (CallerID: userData1): Sql: "select ascii(val1) as a, count(*), weight_string(ascii(val1)) from aggr_test group by a order by a asc", BindVars: {} (errno 1055) (sqlstate 42000) during query: select ascii(val1) as a, count(*) from aggr_test group by a

Schema for the table is -

create table aggr_test(
	id bigint,
	val1 varchar(16),
	val2 bigint,
	primary key(id)
) Engine=InnoDB;

Reproduction Steps

Add the query as an end to end test and run it.

Binary version

Log Fragments