Issue 91906 - Field length enforcement incorrect in dBase table
Summary: Field length enforcement incorrect in dBase table
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 3.1
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-21 11:10 UTC by bmarcelly
Modified: 2009-04-09 19:30 UTC (History)
2 users (show)

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

Attachments
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 bmarcelly 2008-07-21 11:10:28 UTC 
1 - Create a new database, using dBase.
2 - In this database create a simple table, example:
  Table Products
  Field Name : VARCHAR, length = 6
  Field Quantity : DECIMAL, length = 3
3 - fill the table
You will see that numbers with more than 2 digits are rejected in field Quantity. A 
3-digits number (123) should be accepted.
A text of 6 characters is correctly accepted in field Name.

In OOo 1.1.5 you could enter a number like 123 in the decimal fields.
I can't say when the regression occurred.
Comment 1 bmarcelly 2008-07-21 12:24:48 UTC 
In OOo 2.3.1 it was also incorrect, but in another way: a Quantity with 4 digits max 
was accepted instead of 3 max.
Comment 2 christoph.lukasiak 2008-08-12 10:49:46 UTC 
i can repro that like described
Comment 3 christoph.lukasiak 2008-08-12 10:50:35 UTC 
set to 'new'
Comment 4 ocke.janssen 2008-08-13 14:30:07 UTC 
Fixed in cws dba31b
Comment 5 ocke.janssen 2008-08-19 12:24:56 UTC 
Please verify. Thanks.
Comment 6 marc.neumann 2008-09-03 12:34:31 UTC 
verified in CWS dba31b

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%2Fdba31b
Comment 7 nadejda 2009-04-09 07:10:33 UTC 
Verified in master version dev 3.1
Comment 8 natalia_hitekschool 2009-04-09 19:30:34 UTC 
Fixed on master version OOo 3.1, can be closed