Issue 47315 - copying the bugdoc dBase table into a HSQLDB fails
Summary: copying the bugdoc dBase table into a HSQLDB fails
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m92
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20748
  Show dependency tree
 
Reported: 2005-04-13 09:25 UTC by Frank Schönheit
Modified: 2008-03-12 12:16 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
document to reproduce the bug case (350 bytes, application/dBase)
2005-04-13 09:27 UTC, Frank Schönheit 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2005-04-13 09:25:18 UTC 
- create a dBase database document, pointing the to attached .dbf file
- open this database document, plus an arbitrary HSQLDB-based database
- drag'n'drop the table "invoices" from the dBase DB doc to the HSQLDB DB
=> the "Copy Table Wizard" opens up
- press "Create"
=> the table is copying, but there is an error message inbetween saying
   "Warning! An error occured. Do you want to continue copying?"

After examining the new table, it shows that two records are missing, where the
value in the Decimal column was greater than or equal to 10.
Comment 1 Frank Schönheit 2005-04-13 09:27:02 UTC 
blocking meta issue
Comment 2 Frank Schönheit 2005-04-13 09:27:51 UTC 
Created attachment 25010 [details]
document to reproduce the bug case
Comment 3 ocke.janssen 2007-08-30 13:17:26 UTC 
Here the problem is that in dbase it was possible to enter data which isn't
valid for a decimal field. In this case decimal(3,2) and it was possible to
enter 18.00 which isn't valid in this case.
Fixed in cws dba24a
Comment 4 Frank Schönheit 2007-09-03 11:25:15 UTC 
targeting to 2.4, since the fix is part of a CWS aiming for this release
Comment 5 ocke.janssen 2007-09-03 11:54:45 UTC 
Please verify. Thanks.
Comment 6 christoph.lukasiak 2007-09-10 16:12:29 UTC 
reopen -> still occure like described in cws
Comment 7 christoph.lukasiak 2007-09-10 16:13:50 UTC 
back to dev
Comment 8 ocke.janssen 2007-09-19 11:50:33 UTC 
The mistake here was that Base allows you enter data into a decimal field which
are invalid. The attached db contains such an invalid table. Please change the
values which are bigger than 10.
Comment 9 ocke.janssen 2007-09-19 11:50:54 UTC 
.
Comment 10 christoph.lukasiak 2007-09-24 13:28:10 UTC 
or set decimal field length to >3

verified in cws
Comment 11 drewjensen.inbox 2008-03-12 12:16:08 UTC 
Tested  w/ OOo 2.4 m_10, Win Xp

closing