Support single quotes nested in double quotes in SQL scripts [SPR-13218]

[spring-projects-issues]

Nicolas Debeissat opened SPR-13218 and commented

Status Quo

Some databases (e.g., Oracle) permit double quoted column aliases that include case-sensitive characters, single quotes, and other special special characters.

For example, in the following SQL statement that is used to populate an embedded database from scripts with Spring, the single quote should not be interpreted as a literal.

select address as "programmer's address" from programmer

Analysis

Spring's ScriptUtils currently interprets a single quote nested in double quotes as the start of a string literal, causing the parsing of the SQL statement to fail.

Deliverables

1. Ensure that single quotes nested in double quotes do not result in a parsing error.

---

Affects: 4.0.3

Reference URL: #835

Issue Links:

• Oracle SQL hints are ignored as comments in ScriptUtils [SPR-15389] #19952 Oracle SQL hints are ignored as comments in ScriptUtils

Referenced from: commits 629bcb6

[spring-projects-issues]

Sam Brannen commented

Completed as described in GitHub commit 649d145:

Support single quotes nested in double quotes in SQL scripts

Some databases such as Oracle permit double quoted column aliases that
contain case-sensitive characters, single quotes, and other special
characters; however, prior to this commit, SqlScripts interpreted a
single quote nested within double quotes as the start of a string
literal resulting in improper parsing.

This commit addresses this issue by ensuring that double quoted strings
such as column aliases are properly parsed even when containing single
quotes.