List:Commits« Previous MessageNext Message »
From:Christopher Powers Date:June 10 2011 6:21pm
Subject:bzr push into mysql-trunk branch (chris.powers:3179 to 3180) Bug#11766504
View as plain text  
 3180 Christopher Powers	2011-06-10
      Bug#11766504 "59631: BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA"
      
      - Improved test to verify perfschema column types

    modified:
      mysql-test/suite/perfschema/r/table_schema.result*
      mysql-test/suite/perfschema/t/table_schema.test
 3179 Christopher Powers	2011-06-10
      Bug#11766504 "BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA"
      
      - Added test case to verify perfschema column types

    added:
      mysql-test/suite/perfschema/r/table_schema.result
      mysql-test/suite/perfschema/t/table_schema.test
=== modified file 'mysql-test/suite/perfschema/r/table_schema.result' (properties changed: +x to -x)
--- a/mysql-test/suite/perfschema/r/table_schema.result	2011-06-10 17:03:45 +0000
+++ b/mysql-test/suite/perfschema/r/table_schema.result	2011-06-10 18:20:50 +0000
@@ -1,4 +1,5 @@
-select * from information_schema.columns where table_schema="performance_schema" order by table_name, ordinal_position;
+select * from information_schema.columns where table_schema="performance_schema"
+   order by table_name, ordinal_position;
 TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	ORDINAL_POSITION	COLUMN_DEFAULT	IS_NULLABLE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	CHARACTER_SET_NAME	COLLATION_NAME	COLUMN_TYPE	COLUMN_KEY	EXTRA	PRIVILEGES	COLUMN_COMMENT
 def	performance_schema	cond_instances	NAME	1	NULL	NO	varchar	128	384	NULL	NULL	utf8	utf8_general_ci	varchar(128)			select,insert,update,references	
 def	performance_schema	cond_instances	OBJECT_INSTANCE_BEGIN	2	NULL	NO	bigint	NULL	NULL	19	0	NULL	NULL	bigint(20)			select,insert,update,references	
@@ -489,680 +490,16 @@ def	performance_schema	threads	PROCESSLI
 def	performance_schema	threads	PARENT_THREAD_ID	12	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	int(11)			select,insert,update,references	
 def	performance_schema	threads	ROLE	13	NULL	YES	varchar	64	192	NULL	NULL	utf8	utf8_general_ci	varchar(64)			select,insert,update,references	
 def	performance_schema	threads	INSTRUMENTED	14	NULL	NO	enum	3	9	NULL	NULL	utf8	utf8_general_ci	enum('YES','NO')			select,insert,update,references	
-select table_name, column_name, data_type, column_type from information_schema.columns
+select count(*) from information_schema.columns
 where table_schema="performance_schema" and data_type = "bigint"
-   order by table_name, column_name;
-table_name	column_name	data_type	column_type
-cond_instances	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_stages_current	EVENT_ID	bigint	bigint(20) unsigned
-events_stages_current	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_stages_current	TIMER_END	bigint	bigint(20) unsigned
-events_stages_current	TIMER_START	bigint	bigint(20) unsigned
-events_stages_current	TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_history	EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history	TIMER_END	bigint	bigint(20) unsigned
-events_stages_history	TIMER_START	bigint	bigint(20) unsigned
-events_stages_history	TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_history_long	EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history_long	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history_long	TIMER_END	bigint	bigint(20) unsigned
-events_stages_history_long	TIMER_START	bigint	bigint(20) unsigned
-events_stages_history_long	TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_current	CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_current	CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_current	ERRORS	bigint	bigint(20) unsigned
-events_statements_current	EVENT_ID	bigint	bigint(20) unsigned
-events_statements_current	LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_current	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_statements_current	NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_current	NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_current	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_statements_current	ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_current	ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_current	ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_current	SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_current	SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_current	SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_current	SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_current	SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_current	SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_current	SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_current	SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_current	SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_current	TIMER_END	bigint	bigint(20) unsigned
-events_statements_current	TIMER_START	bigint	bigint(20) unsigned
-events_statements_current	TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_current	WARNINGS	bigint	bigint(20) unsigned
-events_statements_history	CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_history	CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_history	ERRORS	bigint	bigint(20) unsigned
-events_statements_history	EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history	LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_history	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history	NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history	NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_statements_history	ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_history	ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_history	ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_history	SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_history	SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_history	SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_history	SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_history	SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_history	SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_history	SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_history	SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_history	SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_history	TIMER_END	bigint	bigint(20) unsigned
-events_statements_history	TIMER_START	bigint	bigint(20) unsigned
-events_statements_history	TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_history	WARNINGS	bigint	bigint(20) unsigned
-events_statements_history_long	CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_history_long	CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_history_long	ERRORS	bigint	bigint(20) unsigned
-events_statements_history_long	EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history_long	LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_history_long	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history_long	NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history_long	NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history_long	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_statements_history_long	ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_history_long	ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_history_long	ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_history_long	TIMER_END	bigint	bigint(20) unsigned
-events_statements_history_long	TIMER_START	bigint	bigint(20) unsigned
-events_statements_history_long	TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_history_long	WARNINGS	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ERRORS	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_WARNINGS	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ERRORS	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_WARNINGS	bigint	bigint(20) unsigned
-events_waits_current	EVENT_ID	bigint	bigint(20) unsigned
-events_waits_current	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_waits_current	NUMBER_OF_BYTES	bigint	bigint(20)
-events_waits_current	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_waits_current	TIMER_END	bigint	bigint(20) unsigned
-events_waits_current	TIMER_START	bigint	bigint(20) unsigned
-events_waits_current	TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_history	EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history	NUMBER_OF_BYTES	bigint	bigint(20)
-events_waits_history	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_waits_history	TIMER_END	bigint	bigint(20) unsigned
-events_waits_history	TIMER_START	bigint	bigint(20) unsigned
-events_waits_history	TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_history_long	EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history_long	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history_long	NUMBER_OF_BYTES	bigint	bigint(20)
-events_waits_history_long	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_waits_history_long	TIMER_END	bigint	bigint(20) unsigned
-events_waits_history_long	TIMER_START	bigint	bigint(20) unsigned
-events_waits_history_long	TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	COUNT_STAR	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-events_waits_summary_by_instance	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-file_summary_by_event_name	COUNT_READ	bigint	bigint(20) unsigned
-file_summary_by_event_name	COUNT_WRITE	bigint	bigint(20) unsigned
-file_summary_by_event_name	SUM_NUMBER_OF_BYTES_READ	bigint	bigint(20)
-file_summary_by_event_name	SUM_NUMBER_OF_BYTES_WRITE	bigint	bigint(20)
-file_summary_by_instance	COUNT_READ	bigint	bigint(20) unsigned
-file_summary_by_instance	COUNT_WRITE	bigint	bigint(20) unsigned
-file_summary_by_instance	SUM_NUMBER_OF_BYTES_READ	bigint	bigint(20)
-file_summary_by_instance	SUM_NUMBER_OF_BYTES_WRITE	bigint	bigint(20)
-mutex_instances	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-objects_summary_global_by_type	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-objects_summary_global_by_type	COUNT_STAR	bigint	bigint(20) unsigned
-objects_summary_global_by_type	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-objects_summary_global_by_type	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-objects_summary_global_by_type	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-performance_timers	TIMER_FREQUENCY	bigint	bigint(20)
-performance_timers	TIMER_OVERHEAD	bigint	bigint(20)
-performance_timers	TIMER_RESOLUTION	bigint	bigint(20)
-rwlock_instances	OBJECT_INSTANCE_BEGIN	bigint	bigint(20)
-table_io_waits_summary_by_index_usage	AVG_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_STAR	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_STAR	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_STAR	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-threads	PROCESSLIST_TIME	bigint	bigint(20)
-select table_name, column_name, data_type, column_type from information_schema.columns
-where table_schema="performance_schema" and data_type = "bigint" and column_type like "%unsigned"
-   order by table_name, column_name;
-table_name	column_name	data_type	column_type
-events_stages_current	EVENT_ID	bigint	bigint(20) unsigned
-events_stages_current	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_stages_current	TIMER_END	bigint	bigint(20) unsigned
-events_stages_current	TIMER_START	bigint	bigint(20) unsigned
-events_stages_current	TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_history	EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history	TIMER_END	bigint	bigint(20) unsigned
-events_stages_history	TIMER_START	bigint	bigint(20) unsigned
-events_stages_history	TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_history_long	EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history_long	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_stages_history_long	TIMER_END	bigint	bigint(20) unsigned
-events_stages_history_long	TIMER_START	bigint	bigint(20) unsigned
-events_stages_history_long	TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_by_thread_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_stages_summary_global_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_current	CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_current	CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_current	ERRORS	bigint	bigint(20) unsigned
-events_statements_current	EVENT_ID	bigint	bigint(20) unsigned
-events_statements_current	LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_current	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_statements_current	NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_current	NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_current	ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_current	ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_current	ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_current	SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_current	SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_current	SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_current	SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_current	SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_current	SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_current	SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_current	SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_current	SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_current	TIMER_END	bigint	bigint(20) unsigned
-events_statements_current	TIMER_START	bigint	bigint(20) unsigned
-events_statements_current	TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_current	WARNINGS	bigint	bigint(20) unsigned
-events_statements_history	CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_history	CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_history	ERRORS	bigint	bigint(20) unsigned
-events_statements_history	EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history	LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_history	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history	NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history	NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history	ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_history	ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_history	ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_history	SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_history	SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_history	SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_history	SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_history	SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_history	SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_history	SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_history	SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_history	SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_history	TIMER_END	bigint	bigint(20) unsigned
-events_statements_history	TIMER_START	bigint	bigint(20) unsigned
-events_statements_history	TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_history	WARNINGS	bigint	bigint(20) unsigned
-events_statements_history_long	CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_history_long	CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_history_long	ERRORS	bigint	bigint(20) unsigned
-events_statements_history_long	EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history_long	LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_history_long	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_statements_history_long	NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history_long	NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_history_long	ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_history_long	ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_history_long	ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_history_long	SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_history_long	SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_history_long	TIMER_END	bigint	bigint(20) unsigned
-events_statements_history_long	TIMER_START	bigint	bigint(20) unsigned
-events_statements_history_long	TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_history_long	WARNINGS	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ERRORS	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_by_thread_by_event_name	SUM_WARNINGS	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_CREATED_TMP_DISK_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_CREATED_TMP_TABLES	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ERRORS	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_LOCK_TIME	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_NO_GOOD_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_NO_INDEX_USED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ROWS_AFFECTED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ROWS_EXAMINED	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_ROWS_SENT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_FULL_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_FULL_RANGE_JOIN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_RANGE_CHECK	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SELECT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_MERGE_PASSES	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_RANGE	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_ROWS	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_SORT_SCAN	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_statements_summary_global_by_event_name	SUM_WARNINGS	bigint	bigint(20) unsigned
-events_waits_current	EVENT_ID	bigint	bigint(20) unsigned
-events_waits_current	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_waits_current	TIMER_END	bigint	bigint(20) unsigned
-events_waits_current	TIMER_START	bigint	bigint(20) unsigned
-events_waits_current	TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_history	EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history	TIMER_END	bigint	bigint(20) unsigned
-events_waits_history	TIMER_START	bigint	bigint(20) unsigned
-events_waits_history	TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_history_long	EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history_long	NESTING_EVENT_ID	bigint	bigint(20) unsigned
-events_waits_history_long	TIMER_END	bigint	bigint(20) unsigned
-events_waits_history_long	TIMER_START	bigint	bigint(20) unsigned
-events_waits_history_long	TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	COUNT_STAR	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_instance	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_by_thread_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	COUNT_STAR	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-events_waits_summary_global_by_event_name	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-file_summary_by_event_name	COUNT_READ	bigint	bigint(20) unsigned
-file_summary_by_event_name	COUNT_WRITE	bigint	bigint(20) unsigned
-file_summary_by_instance	COUNT_READ	bigint	bigint(20) unsigned
-file_summary_by_instance	COUNT_WRITE	bigint	bigint(20) unsigned
-objects_summary_global_by_type	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-objects_summary_global_by_type	COUNT_STAR	bigint	bigint(20) unsigned
-objects_summary_global_by_type	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-objects_summary_global_by_type	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-objects_summary_global_by_type	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	AVG_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_STAR	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	COUNT_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MAX_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	MIN_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_index_usage	SUM_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	AVG_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_STAR	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	COUNT_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MAX_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	MIN_TIMER_WRITE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_DELETE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_FETCH	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_INSERT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_READ	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_UPDATE	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_io_waits_summary_by_table	SUM_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	AVG_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_STAR	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	COUNT_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MAX_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	MIN_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_HIGH_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_NORMAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_NO_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_READ_WITH_SHARED_LOCKS	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WAIT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_ALLOW_WRITE	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_CONCURRENT_INSERT	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_DELAYED	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_EXTERNAL	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_LOW_PRIORITY	bigint	bigint(20) unsigned
-table_lock_waits_summary_by_table	SUM_TIMER_WRITE_NORMAL	bigint	bigint(20) unsigned
+   and column_name like "%number_of_bytes" into @count_columns;
+select @count_columns > 0;
+@count_columns > 0
+1
+select count(*) from information_schema.columns
+where table_schema="performance_schema" and data_type="bigint"
+   and column_name like "%number_of_bytes"
+   and column_type not like "%unsigned" into @count_signed;
+select @count_columns - @count_signed;
+@count_columns - @count_signed
+0

=== modified file 'mysql-test/suite/perfschema/t/table_schema.test'
--- a/mysql-test/suite/perfschema/t/table_schema.test	2011-06-10 17:03:45 +0000
+++ b/mysql-test/suite/perfschema/t/table_schema.test	2011-06-10 18:20:50 +0000
@@ -20,17 +20,28 @@
 
 # Use the INFORMATION_SCHEMA to examine the tables in the PERFORMANCE_SCHEMA
 # and detect any tables that have changed.
-select * from information_schema.columns where table_schema="performance_schema" order by table_name, ordinal_position;
+
+select * from information_schema.columns where table_schema="performance_schema"
+   order by table_name, ordinal_position;
 
 # Bug#11766504 "59631: BIGINT UNSIGNED BYTE RELATED COLUMNS IN PERFORMANCE_SCHEMA"
 
-# Confirm that BIGINT columns exist.
-select table_name, column_name, data_type, column_type from information_schema.columns
+# Goal: Confirm that all byte related columns are BIGINT signed. This test will
+# not have to be changed to accommodate new or deleted columns.
+
+# Count the number of NUMBER_OF_BYTES columns.
+select count(*) from information_schema.columns
    where table_schema="performance_schema" and data_type = "bigint"
-   order by table_name, column_name;
+   and column_name like "%number_of_bytes" into @count_columns;
+
+# Confirm that at least one column was found.
+select @count_columns > 0;
+
+# Confirm that all NUMBER_OF_BYTES columns are BIGINT signed.
+select count(*) from information_schema.columns
+   where table_schema="performance_schema" and data_type="bigint"
+   and column_name like "%number_of_bytes"
+   and column_type not like "%unsigned" into @count_signed;
 
-# Now confirm that the BIGINT columns are unsigned.
-select table_name, column_name, data_type, column_type from information_schema.columns
-   where table_schema="performance_schema" and data_type = "bigint" and column_type like "%unsigned"
-   order by table_name, column_name;
+select @count_columns - @count_signed;
 


Attachment: [text/bzr-bundle] bzr/chris.powers@oracle.com-20110610182050-5zb0me0epso3gw9x.bundle
Thread
• bzr push into mysql-trunk branch (chris.powers:3179 to 3180) Bug#11766504Christopher Powers11 Jun