Issue 81031 - Function ROUNDMAGIC return value converted to string
Summary: Function ROUNDMAGIC return value converted to string
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-26 12:28 UTC by drewjensen.inbox
Modified: 2008-01-15 22:55 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description drewjensen.inbox 2007-08-26 12:28:51 UTC 
The return value of the RUONDMAGIC function is converted to a string when Escape
Processing is enabled.

With escape processing disabled the return value is of type double, which is
correct.
Comment 1 Frank Schönheit 2007-08-26 21:25:49 UTC 
fs->oj: any chance adding this to our parser?
Comment 2 ocke.janssen 2007-08-28 06:29:38 UTC 
Fixed in cws dba24a
Comment 3 Frank Schönheit 2007-09-03 11:33:38 UTC 
targeting to 2.4, since the fix is part of a CWS aiming for this release
Comment 4 ocke.janssen 2007-09-03 12:39:40 UTC 
Please verify. Thanks.
Comment 5 christoph.lukasiak 2007-09-12 15:20:32 UTC 
1. create a function with corresponding table like: SELECT ROUNDMAGIC ("Real_1")
FROM "Table1"
2. execute in sql view
3. open column format dialog (context on result headder)
-> format was text, now fixed in number
Comment 6 christoph.lukasiak 2007-09-12 15:21:10 UTC 
verified in cws
Comment 7 drewjensen.inbox 2008-01-15 22:55:35 UTC 
Tested w/ 680M_242, xp