search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.15k stars 3.81k forks source link

sql: enable setting standard_conforming_strings to off #36215

Open BramGruneir opened 5 years ago

BramGruneir commented 5 years ago

This came up in psycopg testing. The test turns off standard_conforming_strings.

More info on them here: https://www.postgresql.org/docs/9.1/runtime-config-compatible.html

standard_conforming_strings (boolean) This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. Beginning in PostgreSQL 9.1, the default is on (prior releases defaulted to off). Applications can check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported. Escape string syntax (Section 4.1.2.2) should be used if an application desires backslashes to be treated as escape characters.

I wanted to add this issue in case there is indeed a need for this from the community, but for now, I don't see any reason to do this.

Jira issue: CRDB-4515

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!