Originally, this was for code highlighting. I just made a quick test and don't see a problem when browsing and sorting on a column coming from an UNION.
I guess you could not find anything either?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Found a problem which looks like a parser problem. Using the attached file, try
select supplier.city, supplier.id from supplier union select customer.city, customer.id from customer
then ask to sort on both columns (with shift+click on the second column).
Planned for GSoC 2015. See http://wiki.phpmyadmin.net/pma/GSoC_2015_Ideas_List#Parser.2Fanalyzer_rewrite.2Freplacement
Where exactly do we need this? I mean after correctly splitting the select statements, where do we use/show it?
Originally, this was for code highlighting. I just made a quick test and don't see a problem when browsing and sorting on a column coming from an UNION.
I guess you could not find anything either?
Found a problem which looks like a parser problem. Using the attached file, try
select supplier.city, supplier.id from supplier union select customer.city, customer.id from customer
then ask to sort on both columns (with shift+click on the second column).
This does not look like a parser problem.
I've created a separate ticket at https://sourceforge.net/p/phpmyadmin/bugs/4807/
I accept your fix, but it could be a parser problem because the table name has not been determined.