CREATE TABLE `zikula2`.`sometable` (
`a` INT NOT NULL ,
`b` INT NOT NULL
insert into sometable VALUES (1,2),(1,2),(2,3),(2,1)
create view someview as select a,avg(b) from sometable;
Now issue "SELECT * FROM `someview`" and then click on the second column to order it -> SQL error, since the column name is not backquoted.