History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FRG-26
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Xiaoyang Luo
Reporter: John Pham
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Farrago

Should trim string values before casting to numeric values

Created: 23/Jan/06 05:01 PM   Updated: 13/Feb/06 09:45 PM
Component/s: Java Calc Codegen
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
For example:

values cast(' -123 ' as int);
0: jdbc:farrago:> Error: java.lang.NumberFormatException: For input string: " -123 " (state=,code=0)

see SqlOperatorsTest

 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
Xiaoyang Luo - 13/Feb/06 09:45 PM
need to trim first.