Bug #29732 mysqltest fails when connecting through mysql proxy
Submitted: 11 Jul 2007 18:45 Modified: 12 Jul 2007 12:07
Reporter: Philip Stoev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Core Severity:S3 (Non-critical)
Version:revision 81 OS:Linux (Fedora Core 5)
Assigned to: Jan Kneschke CPU Architecture:Any
Tags: qc

[11 Jul 2007 18:45] Philip Stoev 
Description:
Without other options, MySQL proxy can be used to simply pass the query to another mysql server. Therefore, it should be possible to run the MySQL test suite against MySQL proxy.

How to repeat:
shell1> /usr/local/libexec/mysqld --skip-grant-tables -uroot

shell2> ./mysql-proxy -D --proxy-lua-script=../examples/tutorial-packets.lua

shell3> mysqltest --host=127.0.1 --port=4040 --database=test < ../mysql-test/t/select.test

shell2 reports:

file network-mysqld-proto.c: line 63 (network_mysqld_proto_decode_lenenc): assertion failed: (0)

shell3 reports:

mysqltest: At line 1300: query 'explain select fld3 from t2 ignore index (fld3,not_used)' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1176...
not ok

Suggested fix:
It would be nice to be able to run the entire mysql test suite via mysql proxy.
[11 Jul 2007 22:02] Sveta Smirnova 
Thank you for the report.

Verified as described.
[12 Jul 2007 12:07] Jan Kneschke 
Thanks for the report. It is fixed in [89].

The t/select.test is now passing.

The proxy is disabling SSL and Compression support in the protocol. All SSL and compression tests are expected to fail.