[MDEV-8487] mysql-test - main.information_schema 'xtradb' fails Created: 2015-07-17  Updated: 2016-04-24  Resolved: 2016-04-24

Status: Closed
Project: MariaDB Server
Component/s: Character Sets, Tests
Affects Version/s: 10.0.20
Fix Version/s: 10.0.25

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: SUSE
Environment:

SLES12 x86_64


Issue Links:
Relates
relates to MDEV-7693 MariaDB - mysql-test - SUITE:funcs_1 ... Closed
Sprint: 10.0.25

 Description   

mariadb-10.0.20-18.1.x86_64

francine:/usr/share/mysql-test # ./mysql-test-run.pl main.information_schema --force
Logging: ./mysql-test-run.pl  main.information_schema --force
vardir: /usr/share/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/share/mysql-test/var'...
Checking supported features...
MariaDB Version 10.0.20-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
main.information_schema 'xtradb'         [ fail ]
        Test ended at 2015-07-13 10:17:39
 
CURRENT_TEST: main.information_schema
--- /usr/share/mysql-test/r/information_schema.result	2015-06-17 16:54:11.000000000 +0200
+++ /usr/share/mysql-test/r/information_schema.reject	2015-07-13 10:17:39.153640098 +0200
@@ -9,7 +9,7 @@
 create user mysqltest_3;
 select * from information_schema.SCHEMATA where schema_name > 'm';
 CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH
-def	mtr	latin1	latin1_swedish_ci	NULL
+def	mtr	utf8	utf8_general_ci	NULL
 def	mysql	latin1	latin1_swedish_ci	NULL
 def	performance_schema	utf8	utf8_general_ci	NULL
 def	test	latin1	latin1_swedish_ci	NULL
 
mysqltest: Result length mismatch
 
 - saving '/usr/share/mysql-test/var/log/main.information_schema-xtradb/' to '/usr/share/mysql-test/var/log/main.information_schema-xtradb/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 7 seconds executing testcases
 
Completed: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): main.information_schema
 
The log files in var/log may give you some hint of what went wrong.
 
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
 
mysql-test-run: *** ERROR: there were failing test cases

https://bugzilla.suse.com/show_bug.cgi?id=937790



 Comments   
Comment by Elena Stepanova [ 2015-08-20 ]

Server built with -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

Comment by Jan Lindström (Inactive) [ 2016-04-22 ]

http://lists.askmonty.org/pipermail/commits/2016-April/009308.html

Comment by Sergei Golubchik [ 2016-04-22 ]

jplindst, I've fixed it differently. This discrepancy in results comes from the fact that CREATE TABLE gtid_slave_pos does not specify a charset. I think this should be fixed instead.

Generated at Thu Feb 08 07:27:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.