[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3223: ------------------------------------- SQL 2012: StringNum - varchar CharValue - char DoubleNum - decimal BigIntegerValue - decimal ShortValue - decimal FloatNum - float ObjectValue - text IntNum - decimal BigDecimalValue - decimal LongNum - decimal BooleanValue - bit TimestampValue - datetime ByteNum - decimal IntKey - decimal StringKey - varchar TimeValue - datetime DateValue - datetime SQL 2008: IntKey - decimal StringKey - varchar IntNum - decimal StringNum - varchar FloatNum - float LongNum - decimal DoubleNum - decimal ByteNum - decimal DateValue - datetime TimeValue - datetime TimestampValue - datetime BooleanValue - bit CharValue - char ShortValue - decimal BigIntegerValue - decimal BigDecimalValue - decimal ObjectValue - text SQL 2005: IntKey - decimal StringKey - varchar IntNum - decimal StringNum - varchar FloatNum - float LongNum - decimal DoubleNum - decimal ByteNum - decimal DateValue - datetime TimeValue - datetime TimestampValue - datetime BooleanValue - bit CharValue - char ShortValue - decimal BigIntegerValue - decimal BigDecimalValue - decimal ObjectValue - text -- This message was sent by Atlassian JIRA (v6.3.8#6338)