VARCHAR - HASHTYPE join does not always throw exception
Details
| Detail name | Value |
|---|---|
| Changelog Number | 12603 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | |
| Fix Versions | Exasol 7.1.2, Exasol 7.0.13 |
| Resolution Date | 2021-09-24 |
Background
HASHTYPE is a performance feature, so implicit type conversions during joins are forbidden.
Description
In some cases, an error message is not thrown.
Note
If you want to join HASHTYPE with VARCHAR (without the HASHTYPE-performance) you must explicitly cast the HASHTYPE to VARCHAR.
Fix
The exception that a join between VARCHAR and HASHTYPE is always raised.
