Bug #57154 Rename THREADS.ID to THREADS.PROCESSLIST_ID in 5.5

Submitted: 30 Sep 2010 20:33 Modified: 16 Nov 2010 3:41
Reporter: Marc ALFF Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.5.3-m3 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any

[30 Sep 2010 20:33] Marc ALFF
Description:
In 5.5, the performance_schema.THREADS contains a column named ID.

In 5.6, now that WL#4674 is implemented, this column is named PROCESSLIST_ID.

To minimize the impact on users when upgrading from 5.5 to 5.6,
this column should be renamed in 5.5.

How to repeat:
show create table performance_schema.THREADS

Suggested fix:
As described
[30 Sep 2010 22:25] Vladislav Vaintroub
I'd rather rename threads to sessions. that we use thread per user-session is a tradition, or rather a bug that needs to be fixed :)
[7 Oct 2010 0:04] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/120181

3096 Marc Alff	2010-10-06
      Bug#57154 Rename THREADS.ID to THREADS.PROCESSLIST_ID in 5.5
      
      This change is to align the 5.5 performance_schema.THREADS
      table definition with the 5.6 performance_schema.THREADS table,
      to facilitate the 5.5 -> 5.6 migration later.
      
      In the table performance_schema.THREADS:
      - renamed ID to PROCESSLIST_ID, removed not null
      - changed NAME from varchar(64) to varchar(128)
      to match the columns definitions from 5.6
      
      Adjusted the test cases accordingly.
      
      Note: this fix is for 5.5 only, to null merge into 5.6
[8 Oct 2010 17:41] Christopher Powers
Changes look good, patch approved.
[26 Oct 2010 9:07] Marc ALFF
Pushed into mysql-5.5-bugfixing

This fix is for 5.5 only, and should be "null merged" into mysql-trunk
[13 Nov 2010 16:10] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:42] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (pib:21)
[16 Nov 2010 3:41] Paul DuBois
Noted in 5.5.8 changelog.

The following changes were made to the PERFORMANCE_SCHEMA.THREADS
table for conformance with the implementation in MySQL 5.6:

ID column: Renamed to PROCESSLIST_ID, removed NOT NULL from
definition. 

NAME column: Changed from VARCHAR(64) to VARCHAR(128).
[16 Dec 2010 22:28] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.063 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.