exasol / compatibility-test-suite Goto Github PK

As an ETL tool manufacturer,
I want to test reading from and writing to an Exasol database
so that I know if my ETL tool handles Exasol-specifics correctly.

Currently this public repository does not have Exasol internal Slack webhook.

I did not found an example of compare_table_contents() script output in the documentation.
I think we should add at least one example.

We got the following review findings from an ETL maker:

1. Missing ";" in column_size_limit_check after CREATE
2. Missing last ";" in uncommon identifiers
3. Missing "(" in create_test_schema

I get the following error when checking two character tables using compare_table_contents function:

EXA: EXECUTE SCRIPT ETL.compare_table_contents(...
Error: [43000] "Feature not supported: subselects as row value expressions" caught in script "ETL"."COMPARE_TABLE_CONTENTS" at line 2 (Session: 1625173672729535107)

A proposed solution is to add name alias to the subselect,

(SELECT '<<<', A.* FROM (subselect with except) A)
...

When doing compatibility tests on numeric values,
I want to test the Exasol numeric aliases,
to ensure that the clients handles them also correctly.

Some possible numeric aliases (similar to other db types) from Exasol Manual 6.1:

• DOUBLE
• FLOAT
• INTEGER
• SHORTINT
• SMALLINT
• TINYINT

As an ETL tool maker,
I want to test CHAR and VARCHAR values in ASCII encoding in combination to the standard UTF-8 encoding,
to make sure my client handles this correctly.