[ 
https://issues.apache.org/jira/browse/SPARK-28449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuming Wang updated SPARK-28449:
--------------------------------
    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]

  was:
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.


> Missing escape_string_warning/standard_conforming_strings config
> ----------------------------------------------------------------
>
>                 Key: SPARK-28449
>                 URL: https://issues.apache.org/jira/browse/SPARK-28449
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> 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]



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to