[MDEV-16341] Wrong length for USER columns in performance_schema tables Created: 2018-05-30  Updated: 2021-01-12  Resolved: 2021-01-12

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.0, 10.1, 10.2.15, 10.2, 10.3
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9

Type: Bug Priority: Major
Reporter: dnt Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

The USER columns in the performance_schema tables have a length of 16 but should have 80 (the maximum allowed user name length). As far as I've seen this affects the following tables:

  • accounts
  • events_stages_summary_by_account_by_event_name
  • events_stages_summary_by_user_by_event_name
  • events_statements_summary_by_account_by_event_name
  • events_statements_summary_by_user_by_event_name
  • events_waits_summary_by_account_by_event_name
  • events_waits_summary_by_user_by_event_name
  • setup_actors
  • threads (column PROCESSLIST_USER)
  • users

 Comments   
Comment by Elena Stepanova [ 2018-06-01 ]

Thanks for the report.
I've set the fix version to 10.3 for now, although I'm not quite sure whether it can be changed in a post-GA release, so it might be modified later.

Generated at Thu Feb 08 08:28:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.