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

funcs_1.is_tables_is and main.information_schema-big fail in buildbot

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-debian6-x86/builds/3349/steps/test_4/logs/stdio
      (and many more)

      funcs_1.is_tables_is                     w4 [ fail ]
              Test ended at 2014-11-23 00:28:56
       
      CURRENT_TEST: funcs_1.is_tables_is
      --- /usr/share/mysql/mysql-test/suite/funcs_1/r/is_tables_is.result	2014-11-22 22:33:32.000000000 +0100
      +++ /dev/shm/var/4/log/is_tables_is.reject	2014-11-23 00:28:55.932248607 +0100
      @@ -290,6 +290,29 @@
       Separator	-----------------------------------------------------
       TABLE_CATALOG	def
       TABLE_SCHEMA	information_schema
      +TABLE_NAME	GEOMETRY_COLUMNS
      +TABLE_TYPE	SYSTEM VIEW
      +ENGINE	MEMORY
      +VERSION	10
      +ROW_FORMAT	Fixed
      +TABLE_ROWS	#TBLR#
      +AVG_ROW_LENGTH	#ARL#
      +DATA_LENGTH	#DL#
      +MAX_DATA_LENGTH	#MDL#
      +INDEX_LENGTH	#IL#
      +DATA_FREE	#DF#
      +AUTO_INCREMENT	NULL
      +CREATE_TIME	#CRT#
      +UPDATE_TIME	#UT#
      +CHECK_TIME	#CT#
      +TABLE_COLLATION	utf8_general_ci
      +CHECKSUM	NULL
      +CREATE_OPTIONS	#CO#
      +TABLE_COMMENT	#TC#
      +user_comment	
      +Separator	-----------------------------------------------------
      +TABLE_CATALOG	def
      +TABLE_SCHEMA	information_schema
       TABLE_NAME	GLOBAL_STATUS
       TABLE_TYPE	SYSTEM VIEW
       ENGINE	MEMORY
      @@ -635,6 +658,29 @@
       Separator	-----------------------------------------------------
       TABLE_CATALOG	def
       TABLE_SCHEMA	information_schema
      +TABLE_NAME	SPATIAL_REF_SYS
      +TABLE_TYPE	SYSTEM VIEW
      +ENGINE	MEMORY
      +VERSION	10
      +ROW_FORMAT	Fixed
      +TABLE_ROWS	#TBLR#
      +AVG_ROW_LENGTH	#ARL#
      +DATA_LENGTH	#DL#
      +MAX_DATA_LENGTH	#MDL#
      +INDEX_LENGTH	#IL#
      +DATA_FREE	#DF#
      +AUTO_INCREMENT	NULL
      +CREATE_TIME	#CRT#
      +UPDATE_TIME	#UT#
      +CHECK_TIME	#CT#
      +TABLE_COLLATION	utf8_general_ci
      +CHECKSUM	NULL
      +CREATE_OPTIONS	#CO#
      +TABLE_COMMENT	#TC#
      +user_comment	
      +Separator	-----------------------------------------------------
      +TABLE_CATALOG	def
      +TABLE_SCHEMA	information_schema
       TABLE_NAME	STATISTICS
       TABLE_TYPE	SYSTEM VIEW
       ENGINE	MEMORY
      @@ -1180,6 +1226,29 @@
       Separator	-----------------------------------------------------
       TABLE_CATALOG	def
       TABLE_SCHEMA	information_schema
      +TABLE_NAME	GEOMETRY_COLUMNS
      +TABLE_TYPE	SYSTEM VIEW
      +ENGINE	MEMORY
      +VERSION	10
      +ROW_FORMAT	Fixed
      +TABLE_ROWS	#TBLR#
      +AVG_ROW_LENGTH	#ARL#
      +DATA_LENGTH	#DL#
      +MAX_DATA_LENGTH	#MDL#
      +INDEX_LENGTH	#IL#
      +DATA_FREE	#DF#
      +AUTO_INCREMENT	NULL
      +CREATE_TIME	#CRT#
      +UPDATE_TIME	#UT#
      +CHECK_TIME	#CT#
      +TABLE_COLLATION	utf8_general_ci
      +CHECKSUM	NULL
      +CREATE_OPTIONS	#CO#
      +TABLE_COMMENT	#TC#
      +user_comment	
      +Separator	-----------------------------------------------------
      +TABLE_CATALOG	def
      +TABLE_SCHEMA	information_schema
       TABLE_NAME	GLOBAL_STATUS
       TABLE_TYPE	SYSTEM VIEW
       ENGINE	MEMORY
      @@ -1506,6 +1575,29 @@
       TABLE_TYPE	SYSTEM VIEW
       ENGINE	MEMORY
       VERSION	10
      +ROW_FORMAT	Fixed
      +TABLE_ROWS	#TBLR#
      +AVG_ROW_LENGTH	#ARL#
      +DATA_LENGTH	#DL#
      +MAX_DATA_LENGTH	#MDL#
      +INDEX_LENGTH	#IL#
      +DATA_FREE	#DF#
      +AUTO_INCREMENT	NULL
      +CREATE_TIME	#CRT#
      +UPDATE_TIME	#UT#
      +CHECK_TIME	#CT#
      +TABLE_COLLATION	utf8_general_ci
      +CHECKSUM	NULL
      +CREATE_OPTIONS	#CO#
      +TABLE_COMMENT	#TC#
      +user_comment	
      +Separator	-----------------------------------------------------
      +TABLE_CATALOG	def
      +TABLE_SCHEMA	information_schema
      +TABLE_NAME	SPATIAL_REF_SYS
      +TABLE_TYPE	SYSTEM VIEW
      +ENGINE	MEMORY
      +VERSION	10
       ROW_FORMAT	Fixed
       TABLE_ROWS	#TBLR#
       AVG_ROW_LENGTH	#ARL#
       
      mysqltest: Result length mismatch

      Apparently it was introduced by this revision:

      Changed by	Alexey Botchkov <holyfoot@montyprogram.com>
      Changed at	Tue 21 Oct 2014 10:25:47
      Repository	https://github.com/MariaDB/server
      Branch	10.1
      Revision	c3db4459561bc491582bef6bea7b83e9fe464a10
      Comments
       
      MDEV-12 OpenGIS: create required tables: GeometryColumns, related views.
      GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables added to the INFORMATION_SCHEMA.

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/3453/steps/test_2/logs/stdio

      CURRENT_TEST: main.information_schema-big
      --- /mnt/buildbot/build/mariadb-10.1.2/mysql-test/r/information_schema-big.result	2014-11-23 16:58:52.000000000 +0200
      +++ /mnt/buildbot/build/mariadb-10.1.2/mysql-test/r/information_schema-big.reject	2014-11-23 19:36:59.000000000 +0200
      @@ -31,6 +31,7 @@
       ENGINES	ENGINE
       EVENTS	EVENT_SCHEMA
       FILES	TABLE_SCHEMA
      +GEOMETRY_COLUMNS	F_TABLE_SCHEMA
       GLOBAL_STATUS	VARIABLE_NAME
       GLOBAL_VARIABLES	VARIABLE_NAME
       INDEX_STATISTICS	TABLE_SCHEMA
      @@ -47,6 +48,7 @@
       SCHEMA_PRIVILEGES	TABLE_SCHEMA
       SESSION_STATUS	VARIABLE_NAME
       SESSION_VARIABLES	VARIABLE_NAME
      +SPATIAL_REF_SYS	SRID
       STATISTICS	TABLE_SCHEMA
       SYSTEM_VARIABLES	VARIABLE_NAME
       TABLES	TABLE_SCHEMA
      @@ -86,6 +88,7 @@
       ENGINES	ENGINE
       EVENTS	EVENT_SCHEMA
       FILES	TABLE_SCHEMA
      +GEOMETRY_COLUMNS	F_TABLE_SCHEMA
       GLOBAL_STATUS	VARIABLE_NAME
       GLOBAL_VARIABLES	VARIABLE_NAME
       INDEX_STATISTICS	TABLE_SCHEMA
      @@ -102,6 +105,7 @@
       SCHEMA_PRIVILEGES	TABLE_SCHEMA
       SESSION_STATUS	VARIABLE_NAME
       SESSION_VARIABLES	VARIABLE_NAME
      +SPATIAL_REF_SYS	SRID
       STATISTICS	TABLE_SCHEMA
       SYSTEM_VARIABLES	VARIABLE_NAME
       TABLES	TABLE_SCHEMA
       
      mysqltest: Result length mismatch

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: