diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2021-03-29 08:40:39 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2021-03-29 08:40:39 +0200 |
| commit | ebedd0c78fc51c293abe56e99a18c67af14da0c9 (patch) | |
| tree | d83e06ca56eaa8c610c0a1cbc51d177c19e913c7 /src | |
| parent | 30aaab26e52144097a1a5bbb0bb66ea1ebc0cb81 (diff) | |
| download | postgresql-ebedd0c78fc51c293abe56e99a18c67af14da0c9.tar.gz postgresql-ebedd0c78fc51c293abe56e99a18c67af14da0c9.zip | |
Reset standard_conforming_strings in strings test
After some tests relating to standard_conforming_strings behavior, the
value was not reset to the default value. Therefore, the rest of the
tests in that file ran with the nondefault setting, which affected the
results of some tests. For clarity, reset the value and run the rest
of the tests with the default setting again.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/strings.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/strings.sql | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/src/test/regress/expected/strings.out b/src/test/regress/expected/strings.out index f751f0ca159..afd84249c82 100644 --- a/src/test/regress/expected/strings.out +++ b/src/test/regress/expected/strings.out @@ -2027,6 +2027,7 @@ select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' as f4, ' a\bcd | a\b'cd | a\b''cd | abcd\ | ab\'cd | \\ (1 row) +reset standard_conforming_strings; -- -- Additional string functions -- @@ -2230,6 +2231,6 @@ SELECT encode(overlay(E'Th\\000omas'::bytea placing E'\\002\\003'::bytea from 5 SELECT bit_count('\x1234567890'::bytea); bit_count ----------- - 31 + 15 (1 row) diff --git a/src/test/regress/sql/strings.sql b/src/test/regress/sql/strings.sql index c043f025417..9aa1825f921 100644 --- a/src/test/regress/sql/strings.sql +++ b/src/test/regress/sql/strings.sql @@ -693,6 +693,8 @@ set standard_conforming_strings = off; select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' as f4, 'ab\\\'cd' as f5, '\\\\' as f6; +reset standard_conforming_strings; + -- -- Additional string functions |