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.
If one selects table from connected database and chooses View Data from context menu IDE uses followed statement to show data: select * from <table> In case this entered manually using code completion the statement is: SELECT * FROM <table> It's better and more user friendly to use same style for all automated cases.
A fix was committed as: http://hg.netbeans.org/core-main/rev/8163106afb6f The fix changes the case for the SELECT and FROM to uppercase. That should do it. In the next few days a nightly build will be done, that contains this change, please check whether you agree that this is fixed. A messages will be appended to this bug, when the nightly is ready.
Integrated into 'main-silver', will be available in build *201502070001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-silver/rev/8163106afb6f User: Matthias Blaesing <matthias42@netbeans.org> Log: #183475: Move generated SQL case to upper case to match case from code completion