Virtual Schemas: Pushdown of String Literals Containing Double Quotes returns incorrect results
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10894 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.0 |
| Fix Versions | Exasol 7.0.4, Exasol 6.2.13 |
| Resolution Date | 2020-11-26 |
Description
Virtual Schemas will push down queries into the source system.
During the pushdown double quotes in string literals will get escaped unintentionally.
Example
SELECT * FROM virtual_schema.virtual_table WHERE a = '"';
will send a request of a = '\"' to the source database instead of a = '"'.
Workaround
There is no workaround.
Fix
The Virtual Schema will handle string literals containing double quotes correctly and return correct results.
