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: | Update statements only affect the first 21 rows | ||
---|---|---|---|
Product: | db | Reporter: | grimlock81 <grimlock81> |
Component: | Show Data | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED FIXED | ||
Severity: | blocker | CC: | blaha, hmichel, mmirilovic, nleck, romanmostyka |
Priority: | P2 | ||
Version: | 6.x | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
grimlock81
2009-01-19 05:31:27 UTC
I am pretty sure this has to do with page size settings used by the data view (note the default is to have a page size of 20). Ahi, can you investigate please? Fixed in NB7.0, now it works for me in NetBeans IDE Dev (Build 090205) *** Issue 156835 has been marked as a duplicate of this issue. *** Ran NB 6.7 RC 2 and this issue is still unresolved. I can't reproduce the bug the the RC2 build with MySQL server and embedded MySQL JDBC driver that is in IDE. It seems that it's related to SQL Server 2005 only because this bug and also issue #156835 are reproducible on this database server. MS SQL server isn't supported database in NB 6.7, see the document http://wiki.netbeans.org/NB67TestedPlatformAndRuntimes. I'm closing the bug as WONTFIX. Okay that's understandable but the original bug was reported against 6.5 and SQL Server 2005 is listed under http://wiki.netbeans.org/NB65TestedPlatformAndRuntimes Percentage of the projects with MS SQL database in NetBeans is 7% (http://statistics.netbeans.org/analytics/graph/databaseservers.jsp). Therefore, I'm reopening the bug and downgrading to P3 for evaluation. reopen *** Issue 166554 has been marked as a duplicate of this issue. *** Confirmed the problem is not reproducible with JavaDB neither with MySQL. no one uses JavaDB and most enterprise projects don't use MySQL. How about *real* databases like Oracle, Sybase or MSSQL ? This is a really nasty bug as there was no indication that something was wrong. Agreed with nleck - would be nice to fix that for NB 6.7 Patch 1 nleck, we spoke about DB engines bundles with NetBeans IDE. If you think they're fake db, it's your opinion. Anyway, NetBeans is open source, nobody will obstruct you to fix it yourself and provide the patch back in NetBeans sources. Otherwise, it might be welcome. On the other hand, any offensive comments won't be welcome never. I mean you didn't test on the largest databases by market share ie. Oracle, Sybase and MSSQL. Since these three are the biggest by market share it is most likely that is what people will be using. We use Oracle, postgres and Sybase. This bug caused me to lose ( well had to get back from backup) a fair amount of data. There was no indication that the statements had failed and when selecting back before commit I could see data ( first page of). I'm sorry if these comments were offensive but I think this is the same problem we have been having in #161367 & #166714 the IDE hasn't been tested on large projects or in this case the largest databases. This problem exists on Sybase, Postgres and from comment below MSSQL as well. I haven't tested other database. Sample SQL is :- SELECT * INTO zz_person FROM person In the table person there is thousands of records. The resulting table zz_person there is only 20 If not fixed then it should be noted in "known limitations" I tried Oracle 10 and it works without problems. cool... that means the only know ones are Postgres, Sybase and MSSQL. I just tested HSQLDB and that works also. Please, stop the sarcasm that doesn't help us. We will need to install MSSQL/Sybase and debug the issue now and include the fix in patch1. Jirko, would you add the debugging messages that would bring the light what would be issue? You're miss reading my comments. I think this is a serious issue but I was *not* being sarcastic. I thought that was valuable information. From the comments below we have tested this on Oracle, Postgres, Sybase, MSSQL, JavaDB, HSQLDB and MYSQL. Of these Postgres, Sybase, MSSQL is having trouble the others work fine. The problem was reproduced with MSSQL server. Now I'm going to investigate what goes wrong... The problem is not reproducible with MSSQL/jtds-1.2.2 outside NetBeans IDE. It's definitely a problem in DB tools in IDE. core-main/rev/6fed6e1ae3e1< Integrated into 'main-golden', will be available in build *200906300200* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/6fed6e1ae3e1 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #157022: Update statements only affect the first 21 rows v. The fix has been ported into the release67_fixes repository. http://hg.netbeans.org/release67_fixes/rev/26f9236b3fc5 Just tested 6.7.1rc on a PostgreSQL database. The following SQL only inserted 20 rows from a table of ~70 rows. select * into zz_dns from aspc_dns Fixed at least in NB6.8. I don't know more about build schedule for NB6.7.1 The whiteboard status says 6.7 patch 1 Jiri Kovalsky is check the port to the 6.7.1 branch The original issue with update/insert statements is already resolved in NB 6.7.1 but the case that was brought by nleck above is different bug with same symptom. Tracking this as issue #168812. |