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.
Summary: | When you issue a select with an order by clause on Oracle DB, the order by clause becomes part of the "insert into" stmt | ||
---|---|---|---|
Product: | db | Reporter: | rcasha <rcasha> |
Component: | SQL Editor | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | paolosca |
Priority: | P3 | ||
Version: | 7.0 | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
rcasha
2010-12-02 08:02:04 UTC
Thanks for your report, I'll evaluate it in code and let you know. I cannot reproduce if I followed your steps on Product Version = NetBeans IDE Dev (Build 201012060001) (#5432c8ce9c0a) Operating System = Linux version 2.6.35-23-generic running on amd64 Java; VM; Vendor = 1.6.0_20; Java HotSpot(TM) 64-Bit Server VM 16.3-b01; Sun Microsystems Inc. Runtime = Java(TM) SE Runtime Environment 1.6.0_20-b02 Java Home = /usr/local/share/java/jdk1.6.0_20/jre System Locale; Encoding = en (nb); UTF-8 Have I missed any detail? Are you able to reproduce again? Which DB? I tried with Java DB and MySQL. Thanks I tested it with 201012050001. It's still there. Database is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production JDBC driver is 10.2.0.2.0 The exact steps were as follows: Connect to the database from the "Services" tab. Select a table and click "View Data" Add an "order by" clause to the generated select statement, and click "Run SQL" again In the results tab, click the "Insert Record(s)" button Fill in all the not nullable columns Click "Show SQL" to see erroneous select statement Note that this only happens if I add an "order by" clause, but not a "where" clause. Thanks. I can reproduce it with Oracle DB too. I'll investigate what's wrong and fix it. Thanks core-main/rev/977e60a99e81 *** Bug 191683 has been marked as a duplicate of this bug. *** Integrated into 'main-golden', will be available in build *201012080001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/977e60a99e81 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #192772: When you issue a select with an order by clause to Oracle DB, then click the "insert row" button, the order by clause becomes part of the "insert into" stmt |