#4444 (ok 4.2.12) No insert statement produced in SQL export for queries with alias

[Chirayu Chiripal]

Steps to reproduce:

1) Execute query like this:

select * from `sakila`.`actor` as a

2) Select some rows from displayed result table.
3) Click "Export" from "With Selected: " options.
4) Export with default configurations i.e. (Format: SQL, Export Method: Quick).

The generated export data will not contain insert statements for the rows selected.Moreover an error is generated in export file:

-- Error reading data: (#1054 - Unknown column 'actor.actor_id' in 'where clause')

[Madhura Jayaratne]

Can be reproduced for a query with alias

[Chirayu Chiripal]

To be specific, for queries with table alias.

[Smita Kumari]

I have opened a pull request with a patch to fix this issue, here it is https://github.com/phpmyadmin/phpmyadmin/pull/1333 .
let me know if it works as expected.

[Madhura Jayaratne]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/8252099d9d5d026ffc08e2205fa73bf85537fe39