The Script "$ODBCJDBC".preprocess_DDEX throws an error if the given SQL statement has a subselect
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6861 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | |
| Fix Versions | Exasol 6.1.0, Exasol 6.0.13 |
| Resolution Date | 2018-10-10 |
Background
Certain BI front ends determine column names and types with queries such as this:
select * from tab
Since this is inefficient we have a preprocessor script "$ODBCJDBC".preprocess_DDEX, that optimizes these queries (by adding "where false").
Problem
This script causes an error, if the input query contains a subselect, such as this:
select t.* from (select 1 from dual) as t
How to reproduce
Activate the preprocessor script "$ODBCJDBC".preprocess_DDEX and run a query with a subselect.
Fix
Starting with database version 6.0.13 the script will work as expected.
