Issue 85639

Summary:	mysql odbc: updates and insert on currency fields result in 0 value
Product:	Base	Reporter:	Mechtilde <mechtilde>
Component:	code	Assignee:	marc.neumann
Status:	CLOSED FIXED	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P2	CC:	issues
Version:	OOH680m4	Keywords:	regression, release_blocker
Target Milestone:	OOo 2.4
Hardware:	All
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---
Issue Depends on:
Issue Blocks:	84957

Description Mechtilde 2008-01-28 13:15:01 UTC

This is a regression it works in 2.3.1

it also works in m242.

I want to do our book-keeping but I can't input the currency value.

Comment 1 Frank Schönheit 2008-01-28 13:27:51 UTC

Sigh. You certainly want to tell us your database, your database/driver version,
whether it affects all data or only particular data types (or whether you didn't
try this in detail). Perhaps you even want to describe the structure of the
table which is affected. Come on, I don't need to tell you this every time.

Also, note that according to
http://wiki.services.openoffice.org/wiki/OOoRelease24, you should speak up in
releases@openoffice.org when you want to nominate an issue as 2.4 blocker.

Comment 2 Mechtilde 2008-01-28 15:06:47 UTC

yes you must nbot tell it every time ;-)

You can use the same attached files as I attach at issue 85371

http://www.openoffice.org/nonav/issues/showattachment.cgi/51205/HBTest.sql

http://www.openoffice.org/nonav/issues/showattachment.cgi/51206/HBTest.odb

and using an ODBC Connection

yes it was very difficult to create this example to shoe the problem.

and during the meeting time I was working on this example.

Sorry for the confusion.
Mechtilde

Comment 3 marc.neumann 2008-01-29 10:15:05 UTC

I can reproduce this. with the mysql bugdoc database from issue 85371. an update
on a currency field result in a 0 value. also an insert doesn't work.

Comment 4 ocke.janssen 2008-01-29 10:53:51 UTC

Fixed in cws dba24g.
Was a regression of issue 51965

Comment 5 ocke.janssen 2008-01-30 09:43:34 UTC

Please verify. Thanks.

Comment 6 marc.neumann 2008-01-30 11:02:52 UTC

verified in CWS dba24g

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=OOH680%2Fdba24g

Comment 7 marc.neumann 2008-02-05 08:28:58 UTC

set target

Comment 8 Mechtilde 2008-02-11 21:22:28 UTC

verified in m7 -> closed