Bug #29732 mysqltest fails when connecting through mysql proxy
Submitted: 11 Jul 2007 20:45 Modified: 12 Jul 2007 14:07
Reporter: Philip Stoev
Status: Closed
Category:Proxy: Core Severity:S3 (Non-critical)
Version:revision 81 OS:Linux (Fedora Core 5)
Assigned to: Jan Kneschke Target Version:
Tags: qc

[11 Jul 2007 20: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.
[12 Jul 2007 0:02] Sveta Smirnova 
Thank you for the report.

Verified as described.
[12 Jul 2007 14: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.