[
https://issues.apache.org/jira/browse/TRAFODION-2383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Zeller updated TRAFODION-2383:
-----------------------------------
Description:
We need to update the TMUDF interfaces for C++ and Java to support TINYINT as
well.
Here is an example where we run into problems:
Create the UDF shown in TRAFODION-2382.
Run this query:
{code:sql}
select *
from udf(join_udf(16, 'A', 'B'));
{code}
This will the following error, since the integer parameter is considered a
NUMERIC with a length of 1 byte:
{code}
*** ERROR[11252] TypeInfo::getLong() and getDouble() not supported for SQL type
4 (SQLSTATE 38902)
{code}
was:
We need to update the TMUDF interfaces for C++ and Java to support TINYINT as
well.
Here is an example where we run into problems:
Create the UDF shown in TRAFODION-2382.
Run this query:
{code:sql}
select *
from udf(join_udf(16, 'A', 'B'));
{code}
This will cause an error, since the integer parameter is considered a NUMERIC
with a length of 1 byte.
> Support TINYINT for TMUDFs
> --------------------------
>
> Key: TRAFODION-2383
> URL: https://issues.apache.org/jira/browse/TRAFODION-2383
> Project: Apache Trafodion
> Issue Type: Sub-task
> Components: sql-cmp
> Affects Versions: 2.1-incubating
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Priority: Minor
>
> We need to update the TMUDF interfaces for C++ and Java to support TINYINT as
> well.
> Here is an example where we run into problems:
> Create the UDF shown in TRAFODION-2382.
> Run this query:
> {code:sql}
> select *
> from udf(join_udf(16, 'A', 'B'));
> {code}
> This will the following error, since the integer parameter is considered a
> NUMERIC with a length of 1 byte:
> {code}
> *** ERROR[11252] TypeInfo::getLong() and getDouble() not supported for SQL
> type 4 (SQLSTATE 38902)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
