[MDEV-24177] main.sp2 test fails: Result length mismatch Created: 2020-11-09  Updated: 2020-12-07  Resolved: 2020-12-07

Status: Closed
Project: MariaDB Server
Component/s: Server, Tests
Affects Version/s: 10.5.7
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9

Type: Bug Priority: Minor
Reporter: Thomas Deutschmann Assignee: Anel Husakovic
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24178 main.upgrade_MDEV-19650 test fails: R... Closed

 Description   

$ ./mtr main.sp2
Logging: /var/tmp/portage/dev-db/mariadb-10.5.7/work/mysql/mysql-test/mysql-test-run.pl  main.sp2
vardir: /var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var
Removing old var directory...
Creating var directory '/var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var'...
Checking supported features...
MariaDB Version 10.5.7-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
main.sp2                                 [ fail ]
        Test ended at 2020-11-09 17:33:20
 
CURRENT_TEST: main.sp2
--- /var/tmp/portage/dev-db/mariadb-10.5.7/work/mysql/mysql-test/main/sp2.result        2020-11-03 10:50:46.000000000 -0000
+++ /var/tmp/portage/dev-db/mariadb-10.5.7/work/mysql/mysql-test/main/sp2.reject        2020-11-09 17:33:20.172426740 -0000
@@ -5,8 +5,8 @@
 mtr    add_suppression PROCEDURE       root@localhost  #       #       DEFINER         utf8    utf8_general_ci latin1_swedish_ci
 mtr    check_testcase  PROCEDURE       root@localhost  #       #       DEFINER         utf8    utf8_general_ci latin1_swedish_ci
 mtr    check_warnings  PROCEDURE       root@localhost  #       #       DEFINER         utf8    utf8_general_ci latin1_swedish_ci
-mysql  AddGeometryColumn       PROCEDURE       mariadb.sys@localhost   #       #       INVOKER         latin1  latin1_swedish_ci       latin1_swedish_ci
-mysql  DropGeometryColumn      PROCEDURE       mariadb.sys@localhost   #       #       INVOKER         latin1  latin1_swedish_ci       latin1_swedish_ci
+mysql  AddGeometryColumn       PROCEDURE       mariadb.sys@localhost   #       #       INVOKER         utf8    utf8_general_ci utf8_general_ci
+mysql  DropGeometryColumn      PROCEDURE       mariadb.sys@localhost   #       #       INVOKER         utf8    utf8_general_ci utf8_general_ci
 test   sp2     PROCEDURE       root@localhost  #       #       DEFINER         latin1  latin1_swedish_ci       latin1_swedish_ci
 test1  sp1     PROCEDURE       root@localhost  #       #       DEFINER         latin1  latin1_swedish_ci       latin1_swedish_ci
 test1  sp3     PROCEDURE       root@localhost  #       #       DEFINER         latin1  latin1_swedish_ci       latin1_swedish_ci
 
mysqltest: Result length mismatch
 
 - saving '/var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/log/main.sp2/' to '/var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/log/main.sp2/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 2 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): main.sp2
 
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



 Comments   
Comment by Thomas Deutschmann [ 2020-11-09 ]

Test is passing with -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci.

Comment by Sergei Golubchik [ 2020-11-10 ]

whissi, just curious, are you the new maintainer of MariaDB in Gentoo?

Comment by Anel Husakovic [ 2020-12-07 ]

Pushed to 10.2 with a82209ca31684a5f .

Generated at Thu Feb 08 09:28:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.