Apache OpenOffice (AOO) Bugzilla – Issue 112520
errore in reading big tables
Last modified: 2010-12-21 20:26:19 UTC
i installed Openoffice 3.2 but i found tha can't work with one file created with version 3.1. in particular a big table was modified by Base duplicating row several times. i disinstalled 3.2 version and installed 3.1 version and the same file was opened without error at all. bye
@ olazzari Please describe what you means under "big table", what data it stores, how many fields in it, and what data type. Could you upload an example file?
Created attachment 70118 [details] BASE file
here it is the file in particular the table "Commesse" when i open this tables with Ooo3.2 the data stored appeared modified, the number of the rows were the same but there were a duplication of the same row several times (also the primary key was duplicated) the was also another strange fact: using the existing query "Ricerca_Commesse" the rows appeared not duplicated but the right ones, instead creating a new query similar to "Ricerca_Commesse" the result was in according tio the table with duplicated rows i resolved installing previous version Ooo3.1 and using the same file (it wasn't corrupted by the Ooo3.2, the data stored wasn' modified by the program) translation ecco il file il difetto l'ho riscontrato sulla tabella "Commesse" aprendo la tabella dopo aver installato la versione Ooo3.2 al posto delle righe con i dati inseriti da me nel corso degli anni, apparivano un gruppo di 20 righe circa replicate varie volte (anche i dati della colonna individuata come primary key risultavano duplicati e senza per questo che si verificasse un messaggio di errore) l'altro fatto strano è che utilizzando la query esistente "Ricerca_commesse" le righe apparivano giuste con i dati inseriti da me, creando invece una nuova query simile a questa i dati visualizzati erano sbagliati come aprendo la tabella cioè con duplicazione delle righe ho risolto reinstallando la versione precedente Ooo3.1 ed utilizzando lo stesso file (la versione 3.2 non ha infatti modificato il file o cancellato i dati) bye
I can confirm it on win7 with OOo 3.2.1 and DEV300m83, and on ubuntu with DEV300m76. Change platform and OS. Not happens with ubuntu 10.04 own(debian) version of OOo 3.2.0 Not happens with OOo 3.1.1 on win7, this bug seems to me as regression.
sounds like a 3.3 bug then ...
Another example to this problem the sample.odb file tblkey_wetter table, attached to issue 111959. See the differences in attached screenshot, taken with OOo 3.2.0 and DEV300_m83.
Created attachment 70310 [details] two version of same table
*** Issue 111514 has been marked as a duplicate of this issue. ***
Fixed in cws dba33g
I opened Issue 111514, which has been marked as a duplicate of this, issue, and I think that's accurate. Look at that issue for similar attachments showing the same problem.
Please verify. Thanks.
*** Issue 112693 has been marked as a duplicate of this issue. ***
verified in CWS dba33g find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33g
*** Issue 112299 has been marked as a duplicate of this issue. ***
*** Issue 113509 has been marked as a duplicate of this issue. ***
Verified in OOO330_m2 Closed.
*** Issue 114310 has been marked as a duplicate of this issue. ***
*** Issue 115068 has been marked as a duplicate of this issue. ***
*** Issue 115100 has been marked as a duplicate of this issue. ***
*** Issue 115634 has been marked as a duplicate of this issue. ***
*** Issue 115928 has been marked as a duplicate of this issue. ***
*** Issue 116199 has been marked as a duplicate of this issue. ***