summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/group_by_null.result
blob: 1ae090fdc631c73791c34bea7e8e6a022af1df58 (plain)
1
2
3
4
5
6
create table t1 (a int);
insert into t1 values (1),(2);
select max('foo') from t1 group by value(a), extractvalue('bar','qux') order by "v";
max('foo')
foo
drop table t1;