When generate-table-partitions is invoked, it will replace whitespace in primary key literals with a single space. The issue is due to this function - _extract_where.
This function replaces whitespace with a single space. This is appropriate, except the replace function used also replaces whitespace within quoted strings. This is incorrect behavior.
We will need to parse and only do the replacement for those parts of the string that are not quoted strings.
Hi,
When generate-table-partitions is invoked, it will replace whitespace in primary key literals with a single space. The issue is due to this function - _extract_where.
This function replaces whitespace with a single space. This is appropriate, except the replace function used also replaces whitespace within quoted strings. This is incorrect behavior.
We will need to parse and only do the replacement for those parts of the string that are not quoted strings.
Thanks.
Sundar Mudupalli