Bug #90241 An error occurs when mysql_client_test is executed

• Submitted: 28 Mar 2018 10:48
• Modified: 2 Apr 2018 10:30
• Reporter: Rungong An
• Status: Verified
• Category: MySQL Server: C API (client library)
• Severity: S3 (Non-critical)
• Version: 5.7.21
• OS: Linux
• CPU Architecture: Any

[28 Mar 2018 10:48] Rungong An

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

[28 Mar 2018 12:35] Rungong An

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

[29 Mar 2018 20:45] MySQL Verification Team

Please try latest version 5.7.21. Thanks.

[31 Mar 2018 9:28] Rungong An

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.

[2 Apr 2018 10:30] MySQL Verification Team

Thank you for the feedback.

Thanks,
Umesh

[30 Jul 2018 4:18] Erlend Dahl

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.