Type Conversion Behavior for Numeric Values in Quotes in an Expression - Aster R

Teradata Aster® R User GuideUpdate 3

Product
Aster R
Release Number
7.00.02.01
Published
December 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
fop1497542774450.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
fbp1477004286096
lifecycle
previous
Product Category
Software

For some operators in Aster (for example, "int_col > '1000'") the optimizer will add a type conversion automatically (for example, "int_col > cast('1000' as integer)"A).

This conversion is not available in R.

Because Aster does not detect the potential conversions, which could indicate the available conversions, the translated SQL is put into Aster, and an error message at run-time is returned if the conversion is not available.