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 175042 - No CC in INSERT when columns are specified
Summary: No CC in INSERT when columns are specified
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Skrivanek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-20 19:02 UTC by Jiri Rechtacek
Modified: 2009-11-05 10:19 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 Jiri Rechtacek 2009-10-20 19:02:27 UTC 
I found one minor issue, otherwise it's excellent! Thanks!

To reproduce the issue, open SQL file and put this code in it (I use NB sample DB):
INSERT INTO ANIMAL(WEIGHT) VA|                <-- no CC here, "VALUES" should be offered

If I don't use "(WEIGHT)" part, keyword "VALUES" is completed correctly.

The same applies for PHP SQL code completion.

Thanks a lot.

Product Version: NetBeans IDE Dev (Build 091016)
Java: 1.6.0_16; Java HotSpot(TM) 64-Bit Server VM 14.2-b01
System: Linux version 2.6.28-15-generic running on amd64; UTF-8; cs_CZ (nb)
Comment 1 Jiri Rechtacek 2009-10-20 19:05:09 UTC 
The previous comment was the Tomas's comment quoted from issue 155606.
Comment 2 Tomas Mysik 2009-10-21 09:25:05 UTC 
Sorry, IMHO not enhancement anymore - this is obvious bug.

Thanks.
Comment 3 Jiri Skrivanek 2009-11-04 15:59:33 UTC 
Fixed.
core-main #fc97e9531df9
Comment 4 Quality Engineering 2009-11-05 10:19:45 UTC 
Integrated into 'main-golden', will be available in build *200911050201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/fc97e9531df9
User: Jiri Skrivanek <jskrivanek@netbeans.org>
Log: #175042 - Fixed completion for VALUES keyword in INSERT statement.