[SPARK-17194] When emitting SQL for string literals Spark should use single quotes, not double

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Assignee: Josh Rosen
• Reporter: Josh Rosen
• Created: 23/Aug/16 00:38
• Updated: 23/Aug/16 20:33
• Resolved: 23/Aug/16 20:33

Description

When Spark emits SQL for a string literal, it should wrap the string in single quotes, not double quotes. Databases which adhere more strictly to the ANSI SQL standards, such as Postgres, allow only single-quotes to be used for denoting string literals (see http://stackoverflow.com/a/1992331/590203).

Issue Links

• links to: [Github] Pull Request #14763 (JoshRosen)