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 201110290600) Java: 1.6.0_26; Java HotSpot(TM) 64-Bit Server VM 20.1-b02-384 System: Mac OS X version 10.6.8 running on x86_64; MacRoman; ka_GE (nb) I intended to type following query(from specs): select tb from my_table tb GROUP BY 1 but i couldn't invoke autocomplete on GROUP after i typed tb , same goes for "order by" instead of "group by"
Created attachment 112599 [details] Code Completion on GROUP BY Works for me on Product Version = NetBeans IDE Dev (Build 20111031-d6562f82b82f) (#d6562f82b82f) Operating System = Linux version 3.0.0-12-generic running on amd64 Java; VM; Vendor = 1.7.0; Java HotSpot(TM) 64-Bit Server VM 21.0-b17; Oracle Corporation Runtime = Java(TM) SE Runtime Environment 1.7.0-b147 Java Home = /usr/local/share/java/jdk1.7.0/jre System Locale; Encoding = en (nb); UTF-8 Could you verify it's working for you on the same connection? Thanks
Works for me on Product Version = NetBeans IDE Dev (Build 20111031-d6562f82b82f) (#d6562f82b82f) Operating System = Linux version 3.0.0-12-generic running on amd64 Java; VM; Vendor = 1.7.0; Java HotSpot(TM) 64-Bit Server VM 21.0-b17; Oracle Corporation Runtime = Java(TM) SE Runtime Environment 1.7.0-b147 Java Home = /usr/local/share/java/jdk1.7.0/jre System Locale; Encoding = en (nb); UTF-8 Could you verify it's working for you on the same connection? Thanks
Just saw the attachment, that it is not what i have meant: type for e.g "gr" and then invoke autocomplete, it should suggest group by but id doesn't. The only keyword that autocompleted is "where" Thanks, Medea
Created attachment 113347 [details] proposed patch v1 (In reply to comment #3) > Just saw the attachment, that it is not what i have meant: > type for e.g "gr" and then invoke autocomplete, it should suggest group by but > id doesn't. > The only keyword that autocompleted is "where" The attached patch makes GROUP and ORDER recognized keywords in the FROM-Context, which should do the trick.
*** Bug 194173 has been marked as a duplicate of this bug. ***
http://hg.netbeans.org/core-main/rev/59236b70d544 Patch applied. Thank you, Matthias.
Integrated into 'main-golden', will be available in build *201205240002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/59236b70d544 User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #204410 - autocomplete don't work as expected on group by