IMPORT FROM EXA does not handle HASHTYPE

Detail name	Value
Changelog Number	12210
Type	Bug
Status	Open
Affected Versions

Description

IMPORT FROM EXA returns VARCHAR for columns with datatype HASHTYPE.

Preparation

CREATE SCHEMA TEST;
CREATE CONNECTION exa_connection 
TO 'localhost:8563'
USER 'agent_007'
IDENTIFIED BY 'secret';
CREATE TABLE T(C1 HASHTYPE);
INSERT INTO T VALUES ('a7b38db6-d985-42ca-a3ba-cc78c3d5bc2f');

Example

CREATE TABLE T2 AS (
    SELECT * FROM (
        IMPORT FROM EXA AT exa_connection TABLE TEST.T
    )
);
DESCRIBE T2;

Workaround

Explicitly cast the datatype in the IMPORT command.

CREATE TABLE T2 AS (
    SELECT * FROM (
        IMPORT INTO (C1 HASHTYPE) FROM EXA AT exa_connection TABLE TEST.T
    )
);

Fix

IMPORT FROM EXA returns HASHTYPE in this case as expected.