# HG changeset patch # User Sjoerd Mullender <sjoerd@acm.org> # Date 1586432866 -7200 # Node ID a06a76170d39bf6bee46bf7071e614fbfaca198b # Parent f8f1617c2fb3560c0a07b7b01c7df9ad911a4ab0 When using \n in SQL strings, the strings need an E prefix. diff --git a/tests/SQLcopyinto.java b/tests/SQLcopyinto.java --- a/tests/SQLcopyinto.java +++ b/tests/SQLcopyinto.java @@ -109,7 +109,7 @@ public class SQLcopyinto { // the leading 's' is essential, since it is a protocol marker // that should not be omitted, likewise the trailing semicolon mclOut.write('s'); - mclOut.write("COPY INTO " + tablenm + " FROM STDIN USING DELIMITERS ',','\\n';"); + mclOut.write("COPY INTO " + tablenm + " FROM STDIN USING DELIMITERS ',',E'\\n';"); mclOut.newLine(); // now write the row data values as csv data lines to the STDIN stream for (int i = 0; i < 40; i++) {