Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7693

MariaDB - mysql-test - SUITE:funcs_1 - funcs_1.is_tables_mysql is failing on TABLE_COLLATION /DATABASE_COLLATION

    XMLWordPrintable

Details

    Description

      Completed: Failed 3/131 tests, 97.71% were successful.
       
      Failing test(s): funcs_1.is_tables_mysql funcs_1.is_triggers

      (not regression to v11)

      ==========================================================

      funcs_1.is_tables_mysql 'innodb_plugin'  [ fail ]
              Test ended at 2015-03-09 12:57:56
       
      CURRENT_TEST: funcs_1.is_tables_mysql
      --- /usr/share/mysql-test/suite/funcs_1/r/is_tables_mysql.result	2015-01-25 16:21:38.000000000 +0100
      +++ /usr/share/mysql-test/suite/funcs_1/r/is_tables_mysql.reject	2015-03-09 12:57:56.586524508 +0100
      @@ -167,7 +167,7 @@
       CREATE_TIME	#CRT#
       UPDATE_TIME	#UT#
       CHECK_TIME	#CT#
      -TABLE_COLLATION	latin1_swedish_ci
      +TABLE_COLLATION	utf8_general_ci
       CHECKSUM	NULL
       CREATE_OPTIONS	#CO#
       TABLE_COMMENT	#TC#
       
      mysqltest: Result length mismatch
       
       - saving '/usr/share/mysql-test/var/log/funcs_1.is_tables_mysql-innodb_plugin/' to '/usr/share/mysql-test/var/log/funcs_1.is_tables_mysql-innodb_plugin/'

      ==========================================================

      funcs_1.is_tables_mysql 'xtradb'         [ fail ]
              Test ended at 2015-03-09 12:58:19
       
      CURRENT_TEST: funcs_1.is_tables_mysql
      --- /usr/share/mysql-test/suite/funcs_1/r/is_tables_mysql.result	2015-01-25 16:21:38.000000000 +0100
      +++ /usr/share/mysql-test/suite/funcs_1/r/is_tables_mysql.reject	2015-03-09 12:58:19.602524087 +0100
      @@ -167,7 +167,7 @@
       CREATE_TIME	#CRT#
       UPDATE_TIME	#UT#
       CHECK_TIME	#CT#
      -TABLE_COLLATION	latin1_swedish_ci
      +TABLE_COLLATION	utf8_general_ci
       CHECKSUM	NULL
       CREATE_OPTIONS	#CO#
       TABLE_COMMENT	#TC#
       
      mysqltest: Result length mismatch
       
       - saving '/usr/share/mysql-test/var/log/funcs_1.is_tables_mysql-xtradb/' to '/usr/share/mysql-test/var/log/funcs_1.is_tables_mysql-xtradb/'

      ==========================================================

      funcs_1.is_triggers                      [ fail ]
              Test ended at 2015-03-09 12:58:42
       
      CURRENT_TEST: funcs_1.is_triggers
      --- /usr/share/mysql-test/suite/funcs_1/r/is_triggers.result	2015-01-25 16:21:35.000000000 +0100
      +++ /usr/share/mysql-test/suite/funcs_1/r/is_triggers.reject	2015-03-09 12:58:42.466523671 +0100
      @@ -105,8 +105,8 @@
       OR action_condition IS NOT NULL OR action_reference_old_table IS NOT NULL
       OR action_reference_new_table IS NOT NULL;
       TRIGGER_CATALOG	TRIGGER_SCHEMA	TRIGGER_NAME	EVENT_MANIPULATION	EVENT_OBJECT_CATALOG	EVENT_OBJECT_SCHEMA	EVENT_OBJECT_TABLE	ACTION_ORDER	ACTION_CONDITION	ACTION_STATEMENTACTION_ORIENTATION	ACTION_TIMING	ACTION_REFERENCE_OLD_TABLE	ACTION_REFERENCE_NEW_TABLE	ACTION_REFERENCE_OLD_ROW	ACTION_REFERENCE_NEW_ROW	CREATED	SQL_MODE	DEFINER	CHARACTER_SET_CLIENT	COLLATION_CONNECTION	DATABASE_COLLATION
      -def	mtr	gs_insert	INSERT	def	mtr	global_suppressions	0	NULL	BEGIN   DECLARE dummy INT;   SELECT "" REGEXP NEW.pattern INTO dummy; END	ROW	BEFORE	NULL	NULL	OLD	NEW	NULL		root@localhost	latin1	latin1_swedish_ci	latin1_swedish_ci
      -def	mtr	ts_insert	INSERT	def	mtr	test_suppressions	0	NULL	BEGIN   DECLARE dummy INT;   SELECT "" REGEXP NEW.pattern INTO dummy; END	ROW	BEFORE	NULL	NULL	OLD	NEW	NULL		root@localhost	latin1	latin1_swedish_ci	latin1_swedish_ci
      +def	mtr	gs_insert	INSERT	def	mtr	global_suppressions	0	NULL	BEGIN   DECLARE dummy INT;   SELECT "" REGEXP NEW.pattern INTO dummy; END	ROW	BEFORE	NULL	NULL	OLD	NEW	NULL		root@localhost	latin1	latin1_swedish_ci	utf8_general_ci
      +def	mtr	ts_insert	INSERT	def	mtr	test_suppressions	0	NULL	BEGIN   DECLARE dummy INT;   SELECT "" REGEXP NEW.pattern INTO dummy; END	ROW	BEFORE	NULL	NULL	OLD	NEW	NULL		root@localhost	latin1	latin1_swedish_ci	utf8_general_ci
       ##################################################################################
       # Testcase 3.2.18.2 + 3.2.18.3: INFORMATION_SCHEMA.TRIGGERS accessible information
       ##################################################################################
       
      mysqltest: Result length mismatch
       
       - saving '/usr/share/mysql-test/var/log/funcs_1.is_triggers/' to '/usr/share/mysql-test/var/log/funcs_1.is_triggers/'

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

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.