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:
None 
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
Description:
The state field is listed twice in INFORMATION_SCHEMA.FALCON_TRANSACTIONS.  

How to repeat:
describe INFORMATION_SCHEMA.FALCON_TRANSACTIONS;

Suggested fix:
The second occurance should be eliminated.
[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.