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 156835 - 'update' commands appear to honor result set limit
Summary: 'update' commands appear to honor result set limit
Status: RESOLVED DUPLICATE of bug 157022
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-14 17:42 UTC by mcorey
Modified: 2009-02-24 14:16 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description mcorey 2009-01-14 17:42:42 UTC
When I execute a bulk 'update' SQL statement on a table that contains more than 20 rows, it appears to only update the
first page of 'results'.  For example, if I have a table 'USER', which has a column 'ENABLED', and I want to disable all
of the users, I might execute the following query:

   update USER set ENABLED = 0

The intention here is to update every row in the table.  If I have 100 rows, however, I receive the following response:

Executed successfully in 0.094 s, 21 rows affected.
Line 1, column 1

At first, the table looks correct when I view the data, because I'm shown the first 20 entries, but if I go to page 2 of
the results, I start to see that the values are unchanged.

This is occurring on SQL Server 2005, with the Microsoft JDBC driver.
Comment 1 Jiri Rechtacek 2009-02-10 15:32:25 UTC
Reassigned to new owner.
Comment 2 Jiri Rechtacek 2009-02-24 14:16:41 UTC

*** This issue has been marked as a duplicate of 157022 ***