Datatype cast issue if prepared parameter is used as part of an operation in NVL() expression
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6601 |
| Type | Bug |
| Status | Open |
| Affected Versions | Exasol 6.1.0, Exasol 6.1.beta1, Exasol 6.0.11, Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0, Exasol 8.29.0, Exasol 2025.1.0, Exasol 2025.2.0 |
This issue potentially affects also following expressions: DECODE, NVL , probably also CASE, NULLIF, COALESCE.
Example:
create table t(d date);
This statement is executed as a prepare statement with one parameter of type DATE.
select nvl(d, ?+1) from t;
results into the Exception:
Feature not supported: Cannot cast from DOUBLE to DATE
Workaround is cast "?" into the expected data type.
select nvl(d, cast(? as date) + 1 ) from t
