This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 186329 - sql editor does not support sql statement with character "#"
Summary: sql editor does not support sql statement with character "#"
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-18 22:27 UTC by kairguo
Modified: 2011-11-16 16:42 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description kairguo 2010-05-18 22:27:44 UTC 
when a table column name contain "#", sql editor will consider it as the start of comment, hence the sql cannot be executed.
Comment 1 Jiri Rechtacek 2010-05-18 23:01:50 UTC 
Is that  a regression in NB6.9? I guess not.
Comment 2 kairguo 2010-05-19 08:10:30 UTC 
sorry for confusion. the version is: NetBeans IDE Dev (Build 201005132200)
Comment 3 Jiri Rechtacek 2010-06-01 12:28:54 UTC 
What DB allows you to create a column with '#' in name? MySQL, JavaDB refused me to do that. Thank you
Comment 4 kairguo 2010-06-01 23:40:23 UTC 
Oracle 9i or later version supports column name with "#" appended