Sorry I did miss that I have made some corrections and am testing more
before pushing.
I would like to know however if there is a way to directly get the
SESSION variables values a little more directly as I have seen the
SHOW VARIABLES and would not like to build a complex set for variables
I should be able to get myself by more direct means. I would like to
get them as I build my var_list to ensure I can easily reset them when
I am done.
Any direction you can give on this will be greatly appreciated. So
far I really do not think building a SHOW VARIABLES Lex is really
necessary as I also do not need to return that to output if I did
execute that route. Searching around is taking far too long and many
google searches bring up PHP and session variables for web stuff I do
not need.
Joe
On Jul 10, 2009, at 2:07 PM, Sergei Golubchik wrote:
> Hi, Joseph!
>
> On Jul 09, Joseph Lukas wrote:
>>
>> I manually call the set function. I plan on noting and copying the
>> SQLCOM_SET case functions in order to ensure the same checks are
>> used on
>> the set statements. I however am copying the SET case in order to
>> prevent
>> too many my_ok statements to be output. I will note in both
>> sections that
>> the contents is copied elsewhere. I did however do a
>> mysql_execute_command
>> recursive call to perform the select statement. I figured in order
>> to
>> ensure it will work with any future changes to the select methods the
>> overhead of a single recursive call was acceptable. SET statements
>> seem
>> less likely to change as they are not really dependent on creating
>> new
>> methods for optimization etc. that would cause possible
>> implementation
>> changes.
>
> You've probably forgot what was saying in mails
> http://lists.mysql.com/internals/36702
> http://lists.mysql.com/internals/36751
> http://lists.mysql.com/internals/36820
>
> to repeat:
> "
> the syntax should be
>
> SET STATEMENT <assignments> <any statement>
>
> not
>
> SET STATEMENT <assignments> <select>
>
> For example, this should work too:
>
> SET STATEMENT myisam_sort_buffer_size=800M,
> myisam_repair_threads=2 OPTIMIZE TABLE t1;
> "
>
> in other words, you cannot use a solution that is specifically works
> only with SQLCOM_SELECT.
>
> Regards / Mit vielen Grüßen,
> Sergei
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
> / /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server
> Architect
> /_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München
> 161028
> <___/ Sonnenallee 1, 85551 Kirchheim-
> Heimstetten
> Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin Häring
