[TRAFODION-2383] Support TINYINT for TMUDFs

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1-incubating
• Fix Version/s: 2.1-incubating
• Component/s: sql-cmp
• Assignee: Hans Zeller
• Reporter: Hans Zeller
• Created: 30/Nov/16 20:58
• Updated: 26/Mar/18 17:13
• Resolved: 04/Jan/17 00:06

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:

select *
from udf(join_udf(16, 'A', 'B'));

This will the following error, since the integer parameter is considered a NUMERIC with a length of 1 byte:

*** ERROR[11252] TypeInfo::getLong() and getDouble() not supported for SQL type 4 (SQLSTATE 38902)