[Phpmyadmin-devel] Rebuilding the sql from the scratch

[Marc Delisle]

Le 2012-10-28 02:21, Chanaka Dharmarathna a écrit :
> Hi,
> 
> I'm working on bug [0].
> Relevant modifications to the sql query is done inside tbl_export.php,
> according to the selected results from the table browse window which is
> going to export. When modifying the query, it actually rebuild from the
> scratch.
> 
> As I understand there are 2 requirements for modify the query.
> 1. Remove the LIMIT clause (for append any where clause)
> 2. Add needed filtering clause (additional where clause)
> 
> To do the above things is it really need to rebuild the query from the
> scratch ?
> I don't think that there are scenarios which need to modify the beginning
> part of he query (before where clause). So is it okay to modify the query
> only from the where clause. Though the current analyzer doesn't support for
> the multiple select statements, hopefully this will fix the bug I mentioned.
> Any thoughts on this ?

Chanaka,
I believe this is going to be tricky to solve, because there could be
many WHERE clauses (in the main SELECT and in the subselect).

By the way, the original code was [1].

[1] https://github.com/phpmyadmin/phpmyadmin/commit/3a558d15

> 
> [0] :
> http://sourceforge.net/tracker/?func=detail&aid=3034670&group_id=23067&atid=377408
> 
> Regards !



-- 
Marc Delisle
http://infomarc.info