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.
Product Version: NetBeans IDE Dev (Build 200808260201) Java: 1.6.0_05; Java HotSpot(TM) Client VM 10.0-b19 System: Linux version 2.6.20-15-generic running on i386; UTF-8; en_US (nb) 1. Connect to Oracle and open SQL Editor. 2. Run following statement: "select p.JOBTITLE, p.NAME from PERSON p group by p.JOBTITLE, p.NAME". It executed successfully. 3. Type following statement: "select from PERSON p". 4. Move cursor after "select " and press Ctrl+Space. 5. Choose alias name and press Enter. Result: '"p"' is inserted, but if type '.', invoke CC list, choose NAME and execute statement, error arises.
Looks Oracle is stupid. Why make a difference between aliases and database identifiers? Looks I will have to disable quoting for aliases. But I will note the following works on Derby: select "foo bar".CUSTOMER_ID from CUSTOMER as "foo bar"
The absolutely correct solution would be to only quote inserted aliases if they were quoted in the original statement in the editor. However, quoted aliases are not common, so simplest just to not quote them. #7070d189820b
Integrated into 'main-golden', will be available in build *200809031401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/7070d189820b User: Andrei Badea <abadea@netbeans.org> Log: #145173: SQL CC: CC add quoting for Oracle which prevents successful execution
Verified with build 080910.