Public bug reported:
Ubuntu 8.04.1 32bit (as well as 8.10)
openoffice.org-base 1:2.4.1-1ubuntu2
libmyodbc 3.51.15r409-2
German localization
I use a mysql database with tables that include fields defined as DOUBLE.
I access this database with OOBase using MYSQL(ODBC).
However, since hardy the decimal places of numbers in DOUBLE fields are cut off
(e.g. 82.61 -> 82). Additionally these fields cannot be modified, since the
mysql db seems not to accept the data fom OOBAse due to type mismatch.
Error Message: "You have an error in your SQL syntax; check the manual .... for
the right syntax to use near '00000000000000000e+00 WHERE 'ID' = 391' at line
1". OOBase lists field as Double [double].
However, with a kubuntu desktop instead of ubuntu (same packages
otherwise) decimal places are not truncated and everything works fine.
Same behavior with an Intrepid / OpenOffice 3.0.2 installation.
A workaround in ubuntu is to manually install the 5.1.5 odbc driver from
the mysql website. This solves the problem with decimals being
truncated, but causes some other problems (in forms tables are addressed
with tablename only instead of databasename.tablename which causes
incompatibilities).
** Affects: ubuntu
Importance: Undecided
Status: New
--
Decimals truncated in DOUBLE fields
https://bugs.launchpad.net/bugs/298036
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
