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

Summary: 'update' commands appear to honor result set limit
Product: db Reporter: mcorey <mcorey>
Component: SQL EditorAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED DUPLICATE    
Severity: blocker CC: romanmostyka
Priority: P3    
Version: 6.x   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Exception Reporter:

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 ***