#675 (ok 3.4.5) Order by a column in a view doesn't work smtimes

closed-accepted
1
2011-09-14
2011-08-01
No

Preparation:
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.

Discussion

    • assigned_to: nobody --> madhuracj
    • summary: ordering a column doesn't work in some cases --> Order by a column in a view doesn't work in some cases
    • labels: 509144 --> Displaying results
     
  • Your patch was merged in the repository, thanks.

     
    • priority: 5 --> 1
    • summary: Order by a column in a view doesn't work in some cases --> (ok 3.4.5) Order by a column in a view doesn't work smtimes
    • status: open --> open-accepted
     
  • This fixes just environments where $fields_meta->orgname is available, other environments (e.g. Debian 5 with mysql instead of mysqli) are still affected by this bug. - Maybe it's worth adding a note about this and encourage users not to use mysql

     
  • Marc Delisle
    Marc Delisle
    2011-09-14

    • status: open-accepted --> closed-accepted