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 191188 - While querying DB we are unable to use '#'
Summary: While querying DB we are unable to use '#'
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P2 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-20 18:00 UTC by cpunji
Modified: 2010-10-23 00:52 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 cpunji 2010-10-20 18:00:56 UTC 
I am able to connect my oracle DB server successfully. But I have a little problem querying my tables 

I have a table structures as below:
Table name :Test
Columns: Record# number
         Name    varchar

Now I want to query 'test' table filtered by 'record#' column value. I am unable to run the query, instead I am getting error as stated below:

Error code 920, SQL state 42000: ORA-00920: invalid relational operator
Comment 1 cpunji 2010-10-20 18:03:26 UTC 
I am using 
Driver: oracle.jdbc.OracleDriver
Database product version: Oracle Database 11g Release 11.2.0.1.0 - 64bit
Comment 2 Jiri Rechtacek 2010-10-20 18:45:55 UTC 
Could you post your query? I'm going to reproduce it. Thans
Comment 3 cpunji 2010-10-20 18:49:22 UTC 
My SQL is as below:

select * from Test where record# = 1;
Comment 4 cpunji 2010-10-22 02:55:52 UTC 
Hi Jiri,

Are you able to reproduce the reported bug?

If not please let me know.
Comment 5 Jiri Rechtacek 2010-10-22 08:30:50 UTC 
I can reproduce it. Needs handle better '#' sign in SQL editor.
Comment 6 Jiri Rechtacek 2010-10-22 21:36:55 UTC 
Changeset: 7e48e4c364e4
Author:    Jiri Rechtacek <jrechtacek@netbeans.org>
Date:      2010-10-22 23:36
Message:   #191188: While querying DB we are unable to use '#'
Issue #191188 - While querying DB we are unable to use '#'
Comment 7 Jiri Rechtacek 2010-10-22 21:38:40 UTC 
Changeset: 8281b5acde13
Author:    Jiri Rechtacek <jrechtacek@netbeans.org>
Date:      2010-10-22 23:38
Message:   #191188: While querying DB we are unable to use '#'
Issue #191188 - While querying DB we are unable to use '#'
Comment 8 Jiri Rechtacek 2010-10-22 21:39:52 UTC 
Changeset: c9435c48c841
Author:    Jiri Rechtacek <jrechtacek@netbeans.org>
Date:      2010-10-22 23:39
Message:   #191188: While querying DB we are unable to use '#'
Issue #191188 - While querying DB we are unable to use '#'
Comment 9 cpunji 2010-10-23 00:52:38 UTC 
Hi Jiri,

Could you please let me know when this fix will be released?