Bug #34241 | Falcon; STATE is listed twice in INFORMATION_SCHEMA.FALCON_TRANSACTIONS | ||
---|---|---|---|
Submitted: | 1 Feb 2008 19:34 | Modified: | 5 May 2008 17:11 |
Reporter: | Kevin Lewis | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
Version: | 6.0.4 | OS: | Any |
Assigned to: | Kevin Lewis | CPU Architecture: | Any |
[1 Feb 2008 19:34]
Kevin Lewis
[2 Feb 2008 15:22]
MySQL Verification Team
Thank you for the bug report. Only repeatable in team tree: [miguel@mira 6.0f]$ bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 6.0.5-alpha-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> describe INFORMATION_SCHEMA.FALCON_TRANSACTIONS; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | STATE | varchar(120) | NO | | | | | THREAD_ID | int(4) | NO | | 0 | | | ID | int(4) | NO | | 0 | | | STATE | varchar(10) | NO | | | | | UPDATES | int(4) | NO | | 0 | | | PENDING | int(4) | NO | | 0 | | | DEP | int(4) | NO | | 0 | | | OLDEST | int(4) | NO | | 0 | | | RECORDS | int(4) | NO | | 0 | | | WAITING_FOR | int(4) | NO | | 0 | | | STATEMENT | varchar(120) | NO | | | | +-------------+--------------+------+-----+---------+-------+ 11 rows in set (0.01 sec)
[6 Feb 2008 16:25]
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/41794 ChangeSet@1.2808, 2008-02-06 10:24:25-06:00, klewis@klewis-mysql. +2 -0 Bug#34241 - Deleate the extra state field and use the existing stateNames array for displayed text.
[6 Feb 2008 22:27]
Kevin Lewis
Pushed a change to mysql-6.0-falcon-team which deletes this column from the table.
[25 Feb 2008 19:44]
Kevin Lewis
Patch is in mysql-6.0-release version 6.0.4
[5 May 2008 17:11]
Paul DuBois
Noted in 6.0.4 changelog. The INFORMATION_SCHEMA.FALCON_TRANSACTIONS had two columns named STATE.
[17 Feb 2010 16:42]
Paul DuBois
Fix does not actually appear until 6.0.5.