Importing an Oracle number column into an Exasol (var)char column may lead to a crash

Details

Detail name Value
Changelog Number 5862
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.0, EXASolution 5.0.0
Fix Versions EXASOL 6.0.9
Resolution Date 2018-03-16

When using the IMPORT INTO ... FROM ORA statement, importing a number column from an Oracle database into an Exasol CHAR/VARCHAR column, which is not large enough to the hold the string value, may lead to a crash and the following error message.

Successfully reconnected after internal server error, transaction was rolled back.

For example, the following statements would cause a crash because the string value of 1 would be '01.E0' (length 5) in Exasol.

select * from (
  import into (c1 varchar(3)) from ora at ora_conn statement 'select 1 from dual'
);

select * from (
  import into (c1 char(3)) from ora at ora_conn statement 'select 1 from dual'
);

However, the following statements would execute normally.

select * from (
  import into (c1 varchar(5)) from ora at ora_conn statement 'select 1 from dual'
);

select * from (
  import into (c1 char(5)) from ora at ora_conn statement 'select 1 from dual'
);