Issue 117798

Summary:	Input new tuples ignore 0.00 €
Product:	Base	Reporter:	Mechtilde <mechtilde>
Component:	code	Assignee:	ocke.janssen
Status:	CLOSED DUPLICATE	QA Contact:	issues@dba <issues>
Severity:	Normal
Priority:	P2	CC:	issues, r4zoli
Version:	DEV300m106	Keywords:	regression, release_blocker
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.