Issue 85639 - mysql odbc: updates and insert on currency fields result in 0 value
Summary: mysql odbc: updates and insert on currency fields result in 0 value
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOH680m4
Hardware: All Linux, all
: P2 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
Keywords: regression, release_blocker
Depends on:
Blocks: 84957
  Show dependency tree
Reported: 2008-01-28 13:15 UTC by Mechtilde
Modified: 2008-02-11 21:22 UTC (History)
1 user (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 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, you should speak up in 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

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.
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:
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