From 9b8e99e905097e104c295bff1c47b6c0d652efdb Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Wed, 18 Sep 2019 16:29:55 -0300 Subject: [PATCH] Fix testlibpq3 The sample output assumes non-standard-conforming interpretation of backslashes in input literals, so the actual output didn't match. Noticed while perusing another patch that touches this file. Evidently this code is seldom checked, so I'm not going to bother backpatching this fix. --- src/test/examples/testlibpq3.c | 4 ++-- src/test/examples/testlibpq3.sql | 5 +++-- 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/src/test/examples/testlibpq3.c b/src/test/examples/testlibpq3.c index c3b524cfdf..efc3ed3eb0 100644 --- a/src/test/examples/testlibpq3.c +++ b/src/test/examples/testlibpq3.c @@ -11,8 +11,8 @@ * CREATE SCHEMA testlibpq3; * SET search_path = testlibpq3; * CREATE TABLE test1 (i int4, t text, b bytea); - * INSERT INTO test1 values (1, 'joe''s place', '\\000\\001\\002\\003\\004'); - * INSERT INTO test1 values (2, 'ho there', '\\004\\003\\002\\001\\000'); + * INSERT INTO test1 values (1, 'joe''s place', '\000\001\002\003\004'); + * INSERT INTO test1 values (2, 'ho there', '\004\003\002\001\000'); * * The expected output is: * diff --git a/src/test/examples/testlibpq3.sql b/src/test/examples/testlibpq3.sql index 2213306509..35a95ca347 100644 --- a/src/test/examples/testlibpq3.sql +++ b/src/test/examples/testlibpq3.sql @@ -1,5 +1,6 @@ CREATE SCHEMA testlibpq3; SET search_path = testlibpq3; +SET standard_conforming_strings = ON; CREATE TABLE test1 (i int4, t text, b bytea); -INSERT INTO test1 values (1, 'joe''s place', '\\000\\001\\002\\003\\004'); -INSERT INTO test1 values (2, 'ho there', '\\004\\003\\002\\001\\000'); +INSERT INTO test1 values (1, 'joe''s place', '\000\001\002\003\004'); +INSERT INTO test1 values (2, 'ho there', '\004\003\002\001\000'); -- 2.40.0