[SPARK-28449] Missing escape_string_warning and standard_conforming_strings config

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 19/Jul/19 12:31
• Updated: 29/Dec/19 07:11
• Resolved: 29/Dec/19 07:10

Description

When on, a warning is issued if a backslash (}}) appears in an ordinary string literal ({{'...' syntax) and standard_conforming_strings is off. The default is on.

Applications that wish to use backslash as escape should be modified to use escape string syntax (E'...'), because the default behavior of ordinary strings is now to treat backslash as an ordinary character, per SQL standard. This variable can be enabled to help locate code that needs to be changed.

 

https://www.postgresql.org/docs/11/runtime-config-compatible.html