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 194980 - code completion in insert .. set
Summary: code completion in insert .. set
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Linux
: P3 normal with 1 vote (vote)
Assignee: matthias42
URL:
Keywords: PATCH_AVAILABLE
Depends on: 172280
Blocks:
  Show dependency tree
 
Reported: 2011-02-02 10:02 UTC by RiaD
Modified: 2015-01-25 19:39 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
proposed patch v1 (8.83 KB, patch)
2014-11-16 12:30 UTC, matthias42 		Details | Diff
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 RiaD 2011-02-02 10:02:55 UTC 
Why code completion after "insert into table set" tries to complete tablename,but not fieldname?

So "UPDATE table SET " works well


Actual result:
"insert into users set"[ctrl+space]
[users]
[sites]
...

Expected result:
"insert into users set"[ctrl+space]
[id]
[name]
...
Comment 1 matthias42 2014-11-16 12:30:49 UTC 
Created attachment 150510 [details]
proposed patch v1

This adds the non-standard behaviour of mysql to the code completion. The patch was created after the changes from bug 172280, so changes in SQLCompletionQuery might conflict. I'll mark this bug as dependend on 172280 to circumvent problems.
Comment 2 matthias42 2015-01-23 21:12:36 UTC 
Implementation committed as http://hg.netbeans.org/core-main/rev/4a9df60e4ea0
Comment 3 Quality Engineering 2015-01-25 02:34:30 UTC 
Integrated into 'main-silver', will be available in build *201501250002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/4a9df60e4ea0
User: Matthias Blaesing <matthias42@netbeans.org>
Log: #194980: Support insert into ... set statement completion
Comment 4 matthias42 2015-01-25 19:39:26 UTC 
Please help with QA - in the nightly build the fix can be tested. Please check if your problem is fixed there. If so, please change the status of this bug to "VERIFIED".