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 267706 - Autogenerated SQL statements [UPDATE, INSERT, DELETE] have an error in table name [PostgreSQL]
Summary: Autogenerated SQL statements [UPDATE, INSERT, DELETE] have an error in table ...
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 8.2
Hardware: All All
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-08-25 19:18 UTC by moto1101
Modified: 2016-08-27 02:19 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
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 moto1101 2016-08-25 19:18:00 UTC 
After the table name is always the sting 'LIMIT 500' which has nothing to to in these statements.
Reproducing: 
1. Login into an PostgreSQL database;
2. Select a table and show contents;
3. edit one or more items in the table [Netbeans]
4. Click to update [or insert a new row or delete...]
5. the autobuilt statement is not correct and has the additional statement 'LIMIT 500' after the table name.
Comment 1 matthias42 2016-08-26 09:05:46 UTC 
This is a bug in the postgresql driver - please test with a recent postgresql driver. I'm checking to update the driver bundled in netbeans.
Comment 2 matthias42 2016-08-26 11:31:01 UTC 
Fix is pushed as:

http://hg.netbeans.org/core-main/rev/4bfc38d4e9c9

this changeset updates the bundled driver to the current version. That version correctly reports the table name.

Thank you for finding this issue!

In the next few days a nightly build will contain this fix a message should be appended here by then. Please check that build and VERIFY the fix if you find it fixed. Thanks.
Comment 3 Quality Engineering 2016-08-27 02:19:32 UTC 
Integrated into 'main-silver', will be available in build *201608270002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/4bfc38d4e9c9
User: Matthias Blaesing <matthias42@netbeans.org>
Log: #267706: Autogenerated SQL statements [UPDATE, INSERT, DELETE] have an error in table name [PostgreSQL]

The postgresql driver returns wrong info - update to current version.