Fix testlibpq3

alvherre · alvherre · commit 9b8e99e90509 · 2019-09-18T16:34:34.000-03:00
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.
diff --git 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
@@ -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');

Original file line number	Diff line number	Diff line change
`@@ -11,8 +11,8 @@`
`11`	`11`	`* CREATE SCHEMA testlibpq3;`
`12`	`12`	`* SET search_path = testlibpq3;`
`13`	`13`	`* CREATE TABLE test1 (i int4, t text, b bytea);`
`14`		`- * INSERT INTO test1 values (1, 'joe''s place', '\\000\\001\\002\\003\\004');`
`15`		`- * INSERT INTO test1 values (2, 'ho there', '\\004\\003\\002\\001\\000');`
	`14`	`+ * INSERT INTO test1 values (1, 'joe''s place', '\000\001\002\003\004');`
	`15`	`+ * INSERT INTO test1 values (2, 'ho there', '\004\003\002\001\000');`
`16`	`16`	`*`
`17`	`17`	`* The expected output is:`
`18`	`18`	`*`