search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-26] Should trim string values before casting to numeric values #844

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[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

dynamobi-build commented 12 years ago

[author="xluo", created="Mon, 13 Feb 2006 21:45:50 -0500 (GMT-05:00)"] need to trim first.