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 139044 - SQL CC doesn't work in subquery
Summary: SQL CC doesn't work in subquery
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-04 15:10 UTC by Petr Blaha
Modified: 2008-07-25 14:40 UTC (History)
1 user (show)

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 Petr Blaha 2008-07-04 15:10:30 UTC 
Product Version: NetBeans IDE Dev (Build 080704)
Java: 1.6.0; Java HotSpot(TM) Client VM 1.6.0-b105
System: Linux version 2.6.22-14-generic running on i386; UTF-8; en_US (nb)
Userdir: /usr/src/nb_all/nbbuild/testuserdir

Try to CC on

select "a".PURCHASE_COST 
from APP.PRODUCT a 
where a.PRODUCT_ID in 
(select | from PRODUCT_CODE b)

and only a and PRODUCT columns are suggested. I expect PRODUCT_CODE columns and b alias.
Comment 1 Andrei Badea 2008-07-24 17:39:26 UTC 
b852d14313cf
Comment 2 Roman Mostyka 2008-07-25 14:40:16 UTC 
Verified with build 080725.