MySQL Bugs: #29171: inconvenient attribute name in table FALCON

Bug #29171	inconvenient attribute name in table FALCON_SYNCOBJECTS
Submitted:	18 Jun 2007 9:55	Modified:	15 May 2009 16:04
Reporter:	Oli Sennhauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S4 (Feature request)
Version:	6.0.0	OS:	Any
Assigned to:	Hakan Küçükyılmaz	CPU Architecture:	Any
Tags:	F_HANDLER

Description:
the attribute `WHERE` forces me to quote it in sql statements. this is very inconvenient.

How to repeat:
desc FALCON_SYNCOBJECTS;

+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| WHERE        | varchar(120) | NO   |     |         |       |
| SHARED       | bigint(4)    | NO   |     | 0       |       |
| EXCLUSIVE    | bigint(4)    | NO   |     | 0       |       |
| WAITS        | bigint(4)    | NO   |     | 0       |       |
| QUEUE_LENGTH | bigint(4)    | NO   |     | 0       |       |
+--------------+--------------+------+-----+---------+-------+

Suggested fix:
choos an other one like module, object, function or so...

We should change the column name.

This was apparently fixed some time ago.  The field is now called 'CALLER' instead of 'WHERE'.  

Hakan, can you research the old releases and find out when it was done and what version it was released in?

storage\falcon\ha_falcon.cpp(3806):	{"CALLER",			120, MYSQL_TYPE_STRING,		0, 0, "Caller", SKIP_OPEN_TABLE},

The fix is in our tree since it's initial import 2007-09-20. That was the transition from 5.0 to the 5.1 tree. So it is safe to say that the fix is in since MySQL 6.0.0.

No changelog entry required.