Issue 117798 - Input new tuples ignore 0.00 €
Summary: Input new tuples ignore 0.00 €
Status: CLOSED DUPLICATE of issue 117666
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m106
Hardware: PC All
: P2 Normal (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
Keywords: regression, release_blocker
Depends on:
Reported: 2011-04-10 07:40 UTC by Mechtilde
Modified: 2012-06-13 12:26 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description Mechtilde 2011-04-10 07:40:02 UTC
I want to input new tuples in to a table containing also 3 columns with currency values. Most of the time two columns of it contains 0,00 €. But they are defined as "NOT NULL2. So I define the default value as "0,00 €" but this is ignored in DEV300m106.

It works since years in older versions, also in OOO3.3.0 final It is a regression and make it unusual to use a form to input data into the database

the database engine is MySQl and I use the mysql connector 1.0.1
Comment 1 r4zoli 2011-04-10 11:10:51 UTC
@ mechtilde 
This happens in table data view or with forms?

Possible duplicate of bug 117666 where the zero can not be inserted into numerical fields, in table data view or with form. now it is fixed.
Comment 2 ocke.janssen 2011-04-11 05:59:27 UTC
Duplicate one.

*** This issue has been marked as a duplicate of issue 117666 ***
Comment 3 r4zoli 2011-04-11 07:13:26 UTC
Duplicate -> Closing.
Comment 4 Oliver-Rainer Wittmann 2012-06-13 12:26:55 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.