Hi,
I am transferring the regex statements in the method
PMA_getDisplayPropertyParams($sql_query, $is_select) in sql.lib.php to the
sql analyzer. I feel like some of the regex expressions are not valid (eg.
GROUP SELECT). I would appreciate if someone can validate these regex
statements and provide some test queries or guide me so that I can gain the
required knowledge in order to test the functionality.
Regards Supun
On Thu, Jun 13, 2013 at 6:33 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Supun Nakandala a écrit :
On Thu, Jun 13, 2013 at 12:38 PM, Michal Čihař
<michal(a)cihar.com> wrote:
> Hi
>
> Dne Thu, 13 Jun 2013 11:51:18 +0530
> Supun Nakandala <supun.nakandala(a)gmail.com> napsal(a):
>
>> I am refactoring sql.php and I see some places where parsing of the sql
>> query done in the sql.php (eg line 445). I am planning to crate new
> methods
>> for these tasks in sqlparser.lib.php and call them from sql.php . I
would
like to know the opinion from the developers about
this approach.
Actually it would be better if those regular expressions would use
parser because it would give it more tolerance to comments in SQL.
Hi Michal,
PMA_SQP_parse($sql_query) in sqlparser.lib.php is basically checking the
sql query and setting some global variables. Could you please
elaborate on how to use that function instead of these regular
expressions
such that it gives more tolerance to comments in
SQL.
Thank you.
Hi Supun,
PMA_SQP_analyze() is the one to modify. Look at the 'queryflags' in loop
#2 and set a new queryflags value.
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
This
SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
--
Thank you
Supun Nakandala
Dept. Computer Science and Engineering
University of Moratuwa