Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

Internal server error in MERGE statement with multiple ROWID join references

Details

Detail name	Value
Changelog Number	5272
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.3
Fix Versions	EXASOL 6.0.6
Resolution Date	2017-11-02

ROWID is often used in joins or exists to eliminate duplicated rows in tables. If the table row count is above replication border (SOL-101), a global join is executed and the ROWIDs might need to be prefetched.

When a table is globally joined multiple times over ROWID, the query might crash due to a bug in column prefetch.

Workaround

Rewrite the query using ORDER BY FALSE to materialize ROWID usages
Increase system replication border to enforce local joins over ROWID

Internal server error in MERGE statement with multiple ROWID join references

Details

PRODUCT

RESOURCES