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 173536 - columns with "#" are not parsed correctly
Summary: columns with "#" are not parsed correctly
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: Macintosh All
: P3 blocker (vote)
Assignee: Jiri Skrivanek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-01 22:41 UTC by billep
Modified: 2009-10-02 08:32 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 billep 2009-10-01 22:41:57 UTC 
Error code -104, SQL state 42601: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>.

Legacy Database specifically AS400 have columns '#'.  This is unfortunate but there appears to be know way to specify
these in a select or insert. 

DbVisualizer and Intellij support this out of the box.
Comment 1 Jiri Skrivanek 2009-10-02 08:32:20 UTC 
It was fixed in issue 172904. If you have another failing use case, please reopen this issue.