Bug #262 can not use "#" in select, alter table as part of column name
Submitted: 9 Apr 2003 14:19 Modified: 26 Apr 2003 5:23
Reporter: rich allen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.0.12, 4.1.0 OS:MacOS (Mac OS X)
Assigned to: CPU Architecture:Any

[9 Apr 2003 14:19] rich allen
Description:
CREATE TABLE `lerg1` (
  `OCN_#` varchar(4) default NULL
);

this will create a column name of "OCN_#'

can not do a select or alter table such as

select * from table where `ocn_#`
alter table table change `ocn_#`

thanks
- hcir

How to repeat:

Suggested fix:
allow use of the "#" chatacter when using backticks
[10 Apr 2003 2:43] Indrek Siitan
4.0.12 fails already in the CREATE TABLE phase.
[26 Apr 2003 5:23] Michael Widenius
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

I checked this in the current 4.0 tree and there was no problem in having # as an identifier in SELECT.