MySQL Bugs: #26787: table connection not allowed even in mysql 5.0.36

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

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>

OS: Solaris

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.

In previous comment "change status" should be "change version".

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

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.

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

Thank you for the additional comment.

Will mark it as packaging problem

It is a duplicate of bug#12204. The fix of bug#12204 did not get into 5.0.36.

So, Will this be fixed in 5.0.38?
Pls comment.

Thanks

So, Will this be fixed in 5.0.38?
Pls comment.

Thanks

Yes.

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

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.