postgres.git / summary / log / commit / refs

commit    ebedd0c78fc51c293abe56e99a18c67af14da0c9
Author:   Peter Eisentraut <peter@eisentraut.org>
Date:     Mon Mar 29 06:40:39 2021 +0000

    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.


 src/test/regress/expected/strings.out | 3 ++-
 src/test/regress/sql/strings.sql      | 2 ++
 2 files changed, 4 insertions(+), 1 deletion(-)

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


[parent: 30aaab26e521]