[MDEV-7171] funcs_1.is_tables_is and main.information_schema-big fail in buildbot Created: 2014-11-23  Updated: 2014-11-24  Resolved: 2014-11-24

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1
Fix Version/s: 10.1.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Blocks
blocks MDEV-7172 Fix buildbot failures in 10.1 tree Closed

 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



 Comments   
Comment by Alexey Botchkov [ 2014-11-24 ]

Fixing patch:
http://lists.askmonty.org/pipermail/commits/2014-November/007067.html

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