Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1
    • Fix Version/s: 10.1.5
    • Component/s: Tests
    • Labels:
      None

      Description

      CURRENT_TEST: funcs_1.is_columns_is_embedded
      2015-05-12 21:17:23 7f79de02c720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
      2015-05-12 21:17:23 7f79de02c720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
      --- /data/repo/git/10.1/mysql-test/suite/funcs_1/r/is_columns_is_embedded.result	2015-05-12 01:55:28.000000000 +0300
      +++ /data/repo/git/10.1/mysql-test/suite/funcs_1/r/is_columns_is_embedded.reject	2015-05-12 21:17:27.000000000 +0300
      @@ -258,6 +258,7 @@
       def	information_schema	PROCESSLIST	HOST	3		NO	varchar	64	192	NULL	NULL	NULL	utf8	utf8_general_ci	varchar(64)				
       def	information_schema	PROCESSLIST	ID	1	0	NO	bigint	NULL	NULL	19	0	NULL	NULL	NULL	bigint(4)				
       def	information_schema	PROCESSLIST	INFO	8	NULL	YES	longtext	4294967295	4294967295	NULL	NULL	NULL	utf8	utf8_general_ci	longtext			
      +def	information_schema	PROCESSLIST	INFO_BINARY	16	NULL	YES	blob	65535	65535	NULL	NULL	NULL	NULL	NULL	blob				
       def	information_schema	PROCESSLIST	MAX_STAGE	11	0	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(2)				
       def	information_schema	PROCESSLIST	MEMORY_USED	13	0	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(7)				
       def	information_schema	PROCESSLIST	PROGRESS	12	0.000	NO	decimal	NULL	NULL	7	3	NULL	NULL	NULL	decimal(7,3)				
      @@ -480,6 +481,7 @@
       AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1
       ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML;
       COL_CML	DATA_TYPE	CHARACTER_SET_NAME	COLLATION_NAME
      +1.0000	blob	NULL	NULL
       1.0000	longtext	utf8	utf8_general_ci
       SELECT DISTINCT
       CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
      @@ -792,6 +794,7 @@
       NULL	information_schema	PROCESSLIST	MEMORY_USED	int	NULL	NULL	NULL	NULL	int(7)
       NULL	information_schema	PROCESSLIST	EXAMINED_ROWS	int	NULL	NULL	NULL	NULL	int(7)
       NULL	information_schema	PROCESSLIST	QUERY_ID	bigint	NULL	NULL	NULL	NULL	bigint(4)
      +1.0000	information_schema	PROCESSLIST	INFO_BINARY	blob	65535	65535	NULL	NULL	blob
       3.0000	information_schema	REFERENTIAL_CONSTRAINTS	CONSTRAINT_CATALOG	varchar	512	1536	utf8	utf8_general_ci	varchar(512)
       3.0000	information_schema	REFERENTIAL_CONSTRAINTS	CONSTRAINT_SCHEMA	varchar	64	192	utf8	utf8_general_ci	varchar(64)
       3.0000	information_schema	REFERENTIAL_CONSTRAINTS	CONSTRAINT_NAME	varchar	64	192	utf8	utf8_general_ci	varchar(64)

      Apparently it started happening with this commit: https://github.com/MariaDB/server/commit/91ee98a8c88d2595d903e70cd4e1824dffb9e43c

      MDEV-7807 information_schema.processlist truncates queries with binary strings
       
      Adding a new column INFORMATION_SCHEMA.PROCESSLIST.INFO_BINARY.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: