From a3aff361279ae9fc03fe74df66dcdfded7313c37 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Dani=C3=ABl=20van=20Eeden?= Date: Tue, 27 Jun 2017 12:44:10 +0200 Subject: [PATCH 1/3] Fix Bug#86835 session_connect_attrs.processlist_id should be bigint unsigned --- scripts/mysql_system_tables.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/scripts/mysql_system_tables.sql b/scripts/mysql_system_tables.sql index 3d3eb02c450..d2c5b8b3022 100644 --- a/scripts/mysql_system_tables.sql +++ b/scripts/mysql_system_tables.sql @@ -2341,7 +2341,7 @@ DROP PREPARE stmt; -- SET @cmd="CREATE TABLE performance_schema.session_connect_attrs(" - "PROCESSLIST_ID INT NOT NULL," + "PROCESSLIST_ID BIGINT UNSIGNED NOT NULL," "ATTR_NAME VARCHAR(32) NOT NULL," "ATTR_VALUE VARCHAR(1024)," "ORDINAL_POSITION INT" From e167f6f75f1813b8cacad9b36d5e105a76001016 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Dani=C3=ABl=20van=20Eeden?= Date: Sun, 9 Jul 2017 22:36:34 +0200 Subject: [PATCH 2/3] Update patch to address comments by Marc Alff --- storage/perfschema/table_session_connect.cc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/storage/perfschema/table_session_connect.cc b/storage/perfschema/table_session_connect.cc index 1e1d6d3e1e7..e9f833bca59 100644 --- a/storage/perfschema/table_session_connect.cc +++ b/storage/perfschema/table_session_connect.cc @@ -20,7 +20,7 @@ static const TABLE_FIELD_TYPE field_types[]= { { { C_STRING_WITH_LEN("PROCESSLIST_ID") }, - { C_STRING_WITH_LEN("int(11)") }, + { C_STRING_WITH_LEN("bigint(20)") }, { NULL, 0} }, { From 28cc49874e8be2a4aaf35a32266ff7a3cb860876 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Dani=C3=ABl=20van=20Eeden?= Date: Sun, 9 Jul 2017 22:43:32 +0200 Subject: [PATCH 3/3] Another int->bigint fix --- storage/perfschema/table_session_connect.cc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/storage/perfschema/table_session_connect.cc b/storage/perfschema/table_session_connect.cc index e9f833bca59..48e9f1ba6b8 100644 --- a/storage/perfschema/table_session_connect.cc +++ b/storage/perfschema/table_session_connect.cc @@ -284,7 +284,7 @@ int table_session_connect::read_row_values(TABLE *table, { case FO_PROCESS_ID: if (m_row.m_process_id != 0) - set_field_ulong(f, m_row.m_process_id); + set_field_ulonglong(f, m_row.m_process_id); else f->set_null(); break;