dynamobi/dynamobi — Issue #844: [FRG-26] Should trim string values before casting to numeric values
Author: dynamobi-build
Created: 2011-12-30 03:52:20+00:00
State: open
Labels: FRG, Java Calc Codegen

[reporter="jpham", created="Mon, 23 Jan 2006 17:01:11 -0500 (GMT-05:00)"]
For example:

values cast(' -123 ' as int);

0: jdbc:farrago:> Error: java.lang.NumberFormatException: For input string: " -123 " (state=,code=0)

see SqlOperatorsTest