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' );