Bug #90241 An error occurs when mysql_client_test is executed

Description:

When I run bin/mysql_client_test, the fatal occurs:

#####################################
197 of (1/1): test_bug14169
#####################################
GROUP_CONCAT() result type 253/home/rgdb/mysql-5717/source/testclients/mysql_client_test.c:15534: check failed: 'field[1].type == MYSQL_TYPE_BLOB'
2018-03-28T09:51:46.479690Z 17 [Note]

The instance config file is:

[mysqld]
datadir=the datadir
basedir=the basedir
character_set_server=utf8

The cmake option is:

cmake /home/username/mysql-5717/source  \
-DCMAKE_INSTALL_PREFIX=.                \
-DWITH_DEBUG=ON                         \
-DENABLE_GCOV=ON                        \
-DWITH_BOOST=/home/username/mysql-5717/source/boost

How to repeat:

(1) Create a database called 'test';
(2) Run bin/mysql_client_test -u root -p .

Suggested fix:
None

Other failed tests are:

test_bug14169
test_bug36326
test_ps_query_cache
test_wl6587
test_bug20810928
Test_bug20444737
test_bug21104470
test_bug21293012
test_bug21199582
test_wl8754
test_bug17883203
test_bug20821550
test_bug20645725

Please try latest version 5.7.21. Thanks.

I switch the version to 5.7.21 and run ./testclients/mysql_client_test, the error of test_bug14169 occurs when the my.cnf is like this:

[mysqld]
datadir=/home/username/mysql-5721/instance/data
basedir=/home/username/mysql-5721/build-install/
character_set_server=utf8

If the my.cnf file is like this:

[mysqld]
datadir=/home/username/mysql-5721/instance/data
basedir=/home/username/mysql-5721/build-install/

Then the error of test_bug14169 does not appear, but the first error 
is test_ps_query_cache test case. 

If I run ./mtr mysql_client_test, the errors do not happen.

Thank you for the feedback.

Thanks,
Umesh

The trouble is the utf8 character set - mysql_client_test expects the default, which is latin1 in 5.7.

Repro with MTR:

./mtr --mem --mysqld=--character-set-server=utf8 mysql_client_test

There really isn't any reason to make mysql_client_test work with any server character set.