Bug #26787 table connection not allowed even in mysql 5.0.36
Submitted: 2 Mar 2007 7:44 Modified: 4 Apr 2007 8:06
Reporter: Pradeep Thiyag Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.36, 5.2 OS:Linux (Linux, Solaris)
Assigned to: CPU Architecture:Any

[2 Mar 2007 7:44] Pradeep Thiyag
Description:
connection was a reserved key from mysql 5 and mysql 5.0.36 had this corrected (as per the release note) but mysql 5.0.36 still doesnt allow connection as a table or field without using backtics (``).

How to repeat:
mysql> create table connection (conn varchar(15) NOT NULL);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection (conn varchar(15) NOT NULL)' at line 1
mysql>
[2 Mar 2007 7:47] Pradeep Thiyag
OS: Solaris
[2 Mar 2007 8:08] Sveta Smirnova
Thank you for the report.

It is not repeatable with current development 5.0 and 5.1 sources.

But it is repeatable with 5.2 sources, I mark it as verified and change status.
[2 Mar 2007 8:09] Sveta Smirnova
In previous comment "change status" should be "change version".
[2 Mar 2007 8:28] Pradeep Thiyag
Hi,
Iam getting this error in 5.0.36 (which is the latest available version in 5.0.x)pls see below but you have commented saying not reproducable in 5.0 and 5.1. 
Pls tell me the version of 5.0.x that you tried? or is it fixed in version later to 5.0.36?

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.36 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use ipselect;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> create table connection (conn varchar(15) NOT NULL);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection (conn varchar(15) NOT NULL)' at line 1
[2 Mar 2007 8:43] Sveta Smirnova
As I noted in previous email, I tested with last development sources. This means bug has fixed and will be available in next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Please, don't remove 5.2 version and OS Linux from bug information: you'll remove chance for fixing bug in this version doing that.
[2 Mar 2007 10:15] Pradeep Thiyag
hi,
Thanks for your prompt information.

By next release do you mean 5.0.38?
In that case why does 5.0.36 release note saying this problem is fixed. Pls clarify.

thanks,
Pradeep
[2 Mar 2007 10:55] Sveta Smirnova
Thank you for the additional comment.

Will mark it as packaging problem
[6 Mar 2007 7:23] Calvin Sun
It is a duplicate of bug#12204. The fix of bug#12204 did not get into 5.0.36.
[8 Mar 2007 10:36] Pradeep Thiyag
So, Will this be fixed in 5.0.38?
Pls comment.

Thanks
[8 Mar 2007 10:38] Pradeep Thiyag
So, Will this be fixed in 5.0.38?
Pls comment.

Thanks
[9 Mar 2007 7:27] Sveta Smirnova
Yes.
[4 Apr 2007 6:02] Pradeep Thiyag
when is mysql 5.0.38 community server released?
this bug was to be fixed in 5.0.36 but did not even happen in 5.0.37

Pls let me know if there is a patch that I can load on top of 5.0.37 community version to get this 'connection' working.

Note: This is been an oustanding issue since long.

thanks,
Pradeep
[4 Apr 2007 8:06] Sveta Smirnova
5.0.38 Enterprise server has released. You can find it at https://enterprise.mysql.com

We have no information when next Community server will be relased.