Hi Jacek,

I am still getting error at "SHOW VARIABLES…"; also not sure if "SELECT @@session.auto_increment_increment" will work.

SET commands work fine.

Tatiana


On Nov 18, 2014, at 1:44 PM, Jacek Becla <[log in to unmask]> wrote:

Tatiana, John, Trey

I tweaked Qserv and it will now successfully process the queries Tatiana posted, so unless there is another class of queries that
JDBC issues which we haven't seen yet, things should work.

The changes are on tip of Qserv master. I am not sure what
the best way is for you to grab them. Can you do git pull?
Don't forget you will need to rebuild qserv, and restart
services (at minimum mysql proxy).

Good luck :)

Jacek



On 11/17/2014 02:18 PM, Tatiana Goldina wrote:

*SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name =
'net_write_timeout' OR Variable_name = 'interactive_timeout' OR
Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client'
OR Variable_name = 'character_set_connection' OR Variable_name =
'character_set' OR Variable_name = 'character_set_server' OR
Variable_name = 'tx_isolation' OR Variable_name =
'transaction_isolation' OR Variable_name = 'character_set_results' OR
Variable_name = 'timezone' OR Variable_name = 'time_zone' OR
Variable_name = 'system_time_zone' OR Variable_name =
'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR
Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR
Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size'
OR Variable_name = 'license' OR Variable_name = 'init_connect'*

2.  duration: 0 ms, connection-id: 1233, statement-id: 1, resultset-id:
2, message: /* mysql-connector-java-5.1.34 ( Revision:
[log in to unmask]
<mailto:[log in to unmask]> )
*/*SELECT @@session.auto_increment_increment*

3.  duration: 0 ms, connection-id: 1233, statement-id: 999,
resultset-id: 0, message: *SET NAMES latin1*

4. duration: 0 ms, connection-id: 1233, statement-id: 999, resultset-id:
0, message: *SET character_set_results = NULL*

5. duration: 0 ms, connection-id: 1233, statement-id: 999, resultset-id:
0, message: *SET autocommit=1*

6. duration: 0 ms, connection-id: 1233, statement-id: 999, resultset-id:
0, message: *SET sql_mode='STRICT_TRANS_TABLES'*

--
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------

Teach CanIt if this mail (ID 04Nh9KDKl) is spam:
Spam:        https://canit.ipac.caltech.edu/canit/b.php?i=04Nh9KDKl&m=5296c1b7b0d7&c=s
Not spam:    https://canit.ipac.caltech.edu/canit/b.php?i=04Nh9KDKl&m=5296c1b7b0d7&c=n
Forget vote: https://canit.ipac.caltech.edu/canit/b.php?i=04Nh9KDKl&m=5296c1b7b0d7&c=f
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS