From 528abc749e8a65674dd10f59a2d99d7841709939 Mon Sep 17 00:00:00 2001 From: Haidong Ji Date: Sun, 2 May 2021 15:43:04 -0500 Subject: MDEV-25325 built-in documentation for performance_schema tables Improve documentation of performance_schema tables by appending COLUMN comments to tables. Additionally improve test coverage and update corresponding tests. --- .../suite/perfschema/r/dml_session_connect_attrs.result | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/suite/perfschema/r/dml_session_connect_attrs.result') diff --git a/mysql-test/suite/perfschema/r/dml_session_connect_attrs.result b/mysql-test/suite/perfschema/r/dml_session_connect_attrs.result index d1dea1472d4..c56af4a448d 100644 --- a/mysql-test/suite/perfschema/r/dml_session_connect_attrs.result +++ b/mysql-test/suite/perfschema/r/dml_session_connect_attrs.result @@ -23,3 +23,14 @@ UNLOCK TABLES; LOCK TABLES performance_schema.session_connect_attrs WRITE; ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'session_connect_attrs' UNLOCK TABLES; +# +# MDEV-25325 column_comment for performance_schema tables +# +select column_name, column_comment +from information_schema.columns +where table_schema='performance_schema' and table_name='session_connect_attrs'; +column_name column_comment +PROCESSLIST_ID Session connection identifier. +ATTR_NAME Attribute name. +ATTR_VALUE Attribute value. +ORDINAL_POSITION Order in which attribute was added to the connection attributes. -- cgit v1.2.1