[teiid-issues] [JBoss JIRA] (TEIID-4226) HANA translator: boolean type converted to tinyint in each convert

HANA translator: boolean type converted to tinyint in each convert ------------------------------------------------------------------ Key: TEIID-4226 URL: https://issues.jboss.org/browse/TEIID-4226 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Jan Stastny Assignee: Steven Hawkins Priority: Critical Fix For: 9.0, 8.12.5, 8.13.5 HANA translator blindly converts boolean values to tinyint when a boolean column is pushed as part of a convert function to datasource. Example query: {code:sql} SELECT CONCAT2(stringNum,booleanvalue) FROM BQT1.SmallA; {code} and its DATA SRC COMMAND: {code:sql} SELECT CONCAT2(g_0.STRINGNUM, convert(g_0.BOOLEANVALUE, string)) FROM BQT1.SMALLA AS g_0 {code} and its SOURCE SRC COMMAND: {code:sql} SELECT CASE WHEN g_0."STRINGNUM" IS NULL AND cast(g_0."BOOLEANVALUE" AS tinyint) IS NULL THEN NULL ELSE concat(ifnull(g_0."STRINGNUM", ''), ifnull(cast(g_0."BOOLEANVALUE" AS tinyint), '')) END FROM "BQT1"."SMALLA" AS g_0 {code}