summaryrefslogtreecommitdiff
path: root/mysql-test/r/group_by_null.result
blob: 01053514cb0c4d42ba7522259e9bb2c35dec16e3 (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 values(a), extractvalue('bar','qux') order by "v";
max('foo')
foo
drop table t1;