Improve the IMPORT of strings from JDBC data sources when string precision is zero

Detail name	Value
Changelog Number	8568
Type	Improvement
Status	Resolved
Fix Versions	Exasol 7.0.0, Exasol 6.2.2
Resolution Date	2019-08-19

When importing strings which are not stored in tables using JDBC, some JDBC drivers (e.g. Teradata) return a string precision of 0. This leads to an error message (see below) in Exasol if the string is longer than one character.

As in improvement, if the string precision is given as 0, a default value of 2,000,000 will be used in Exasol so that the values may be imported.

Example statement:

select * from (
  import from jdbc at teradata_conn statement 'select ''test_string'''
);

Error message:

ETL-3003: [Column=0 Row=0] [String data right truncation. String length exceeds limit of 1 characters]

Changed behavior