Re: [Phpmyadmin-devel] 2.10.0-dev: No column sorting possible
Hi Marc!
Try the "better fix":
I can confirm that this fixes the problem I've reported. However I didn't dare touch the parser, so I hope it has no other side-effects. Like when ordering by "COUNT(x) AS tempsort" or other reserved words... Best regards, Garvin -- ++ Garvin Hicking | Web-Entwickler [PHP] | www.garv.in | ICQ 21392242 ++ Developer of | www.phpMyAdmin.net | www.s9y.org ++ Make me happy | http://wishes.garv.in -- ++ Garvin Hicking | Web-Entwickler [PHP] | www.garv.in | ICQ 21392242 ++ Developer of | www.phpMyAdmin.net | www.s9y.org ++ Make me happy | http://wishes.garv.in
Garvin Hicking a écrit :
Hi Marc!
Try the "better fix":
I can confirm that this fixes the problem I've reported. However I didn't dare touch the parser, so I hope it has no other side-effects. Like when ordering by "COUNT(x) AS tempsort" or other reserved words...
Best regards, Garvin
Hi Garvin! I don't fear side-effects because PMA would generate ORDER BY `COUNT(x) as tempsort` in which COUNT is not a reserved word. If some side-effects are reported, we can always check specifically for ASC and DESC. Marc
participants (2)
-
Garvin Hicking -
Marc Delisle