|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | sql update for database in dBase format erase all fields but the ones updated | ||
|---|---|---|---|
| Product: | Base | Reporter: | jmfayard <boulot.dodo> |
| Component: | code | Assignee: | marc.neumann |
| Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | OOo 1.1 | Keywords: | oooqa |
| Target Milestone: | OOo 2.0 | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
I can confirm this on OOo 1.1.0 US, Linux Mandrake 9.2. Setting oooqa. This is an important bug as it leads to data loss/corruption. We ought to up the priority: Frank what do you think ? alex In addition, since dBase is currently the default db format for OOo (at least until 2.?), it is unlikely that many users will have the capability to write Perl scripts like the one proposed for the workaround. alex I suppose P3 is sufficient. Given that nobody ever complained about it ... (and the dBase code is virtually unchanged for years). Nevertheless, we should probably fix it for 2.0. fixed in cws oj08 dba/connectivity/source/drivers/file/FStatement.cxx 1.30.36.1 change subcomponent to 'none' just execute a Update statement by hand. set to fixed set to fixed verify in CWS oj08 I would like to add that the problem does not exist in 1.1.1b Hi, fixed in current developer build -> close. The current developer build can be found at http://download.openoffice.org/680/index.html Feel free to reopen if this issue is not fixed in the developer build. Bye Marc |
reproducible : always Steps to follow : *Create a database, use dBase file format, create a table "Address" with a few fields (say Name, City, Email, Age) * Enter a few entries * Execute this SQL statement : update Address set Name = 'John Doo', Age = '35' * Result : the Name and Age fields are modified as they should but all the other fields (City, Email) in the updated entries are erased Workaround : I did a trivial perl script to do the same thing for the same database, all worked fine $ cat perl_sqlupdate.pl #!/usr/bin/perl use DBI; use DBD::XBase; my $dbh = DBI->connect("DBI:XBase:/autre/adresses") or die $DBI::errstr; my $sth = $dbh->prepare("update Adresses set PrefixeTel = '+33' ") or die $dbh->errstr(); $sth->execute() or die $sth->errstr();