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:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.0.12, 4.1.0 OS:Mac OS X (Mac OS X)
Assigned to: CPU Architecture:Any

[9 Apr 2003 14:19] rich allen
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_#`

- 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 

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