To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58101
Issue #:|58101
Summary:|Arithmetics in SQL statement gets truncated in
|queries (MySQL/ODBC)
Component:|Database access
Version:|OOo 2.0 Beta
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|kaimartin
------- Additional comments from [EMAIL PROTECTED] Fri Nov 18 03:49:36 -0800
2005 -------
Arithmetics in SQL statement gets truncated in ooffice queries.
Example:
A simple MySQL table that contains just one column `test` of type varchar(10).
The first row of this colunm is filled with the value "1.23"
This value can be retrieved by openoffice and is correctly displayed as a
numeric value with two digits after the decimal point. Query as created by the
query editor is in this case:
SELECT `test` FROM `lila`.`Waren` `Waren`
returns
1.23
If there is any arithmetics involved in the SQL statement the calculation the
calculation is carried out correctly, but the result is truncated. Example:
SELECT `test`+1 FROM `lila`.`Waren` `Waren`
returns
2
In a form based on this query, this value shows up like "2.00"
The very same SQL command works correct outside openoffice:
mysql> SELECT `test`+1 FROM `lila`.`Waren` `Waren`;
+----------+
| `test`+1 |
+----------+
| 2.23 |
+----------+
The option "execute SQL command directly" in the query editor still gives the
same truncated result.
---<(kaimartin)>---
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
