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.
Build: NetBeans IDE Dev (Build 080808) VM: Java HotSpot(TM) Client VM, 11.0-b12, Java(TM) SE Runtime Environment, 1.6.0_10-beta-b25 OS: Windows Vista, 6.0, x86 User Comments: Trying to create new unique index on table actor Stacktrace: java.lang.reflect.InvocationTargetException: Unable to execute command: create unique index actor_idx on `actor` ( ) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4 at org.netbeans.modules.db.explorer.DbUtilities.doWithProgress(DbUtilities.java:117) at org.netbeans.modules.db.explorer.dlg.AddIndexDialog$1.actionPerformed(AddIndexDialog.java:185) at org.netbeans.core.windows.services.NbPresenter$ButtonListener.actionPerformed(NbPresenter.java:1134) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
Created attachment 66889 [details] stacktrace
Can you describe exactly what you put into the create index dialog to reproduce this? This sounds like a serious issue.
Steps to reproduce bug: 1.) Connect to sakila database 2.) Expand tables tree -> expand actor table 3.) Right-click on Indexes -> Add Index 4.) Change nothing on the window that opens and just press OK 5.) The exception is thrown, but the error window is also shown Ideally the exception should not come up and only the error window should be shown, just like with other tables and databases.
This is a very minor issue. Perhaps the OK button should be disabled until an item to add to the index is checked.
Sorry, won't be fixed in 6.5
Reassigned to new owner.
Created attachment 123569 [details] proposed patch v1 (implementing solution from comment 4)
Patch integrated: http://hg.netbeans.org/core-main/rev/68dad7b8f822 Thank you, Matthias!
Integrated into 'main-golden', will be available in build *201209220001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/68dad7b8f822 User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #143271: Add index dialog allows proceeding without selected columns