connect.tbl_thread fails sporadically, error in your SQL syntax

connect.tbl_thread                       w1 [ fail ]

        Test ended at 2017-10-29 23:45:52

CURRENT_TEST: connect.tbl_thread

mysqltest: At line 89: query 'SELECT * FROM total order by v desc' failed: 1296: Got error 174 '(1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ЏѴ' at line 1 [ЏѴ]' from CONNECT

The result from queries just before the failure was:

< snip >

connection master;

DROP TABLE rt2;

connection slave;

DROP TABLE rt3,rt4,rt5;

connection default;

DROP TABLE t1,t2,t3,t4,t5,total;

#

# Old thread TBL tables test modified

#

CREATE TABLE t1 ENGINE=CONNECT TABLE_TYPE=MYSQL SRCDEF='select 11 as v' OPTION_LIST='port=MASTER_PORT';

SELECT * FROM t1;

v

11

CREATE TABLE t2 ENGINE=CONNECT TABLE_TYPE=MYSQL SRCDEF='select 22 as v' OPTION_LIST='port=SLAVE_PORT';

SELECT * FROM t2;

v

22

CREATE TABLE total (v BIGINT(20) UNSIGNED NOT NULL) ENGINE=CONNECT TABLE_TYPE=TBL TABLE_LIST='t1,t2' OPTION_LIST='thread=yes,port=PORT';;

set connect_xtrace=1;

SELECT * FROM total order by v desc;

More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/1/log/tbl_thread.log

Warnings from just before the error:

Error 1296 Got error 174 '(1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ЏѴ' at line 1 [ЏѴ]' from CONNECT

 - saving '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/1/log/connect.tbl_thread/' to '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/log/connect.tbl_thread/