Add some tests for encoding conversion in COPY TO/FROM This adds a couple of tests to trigger encoding conversion when input and server encodings do not match in COPY FROM/TO, or need_transcoding set to true in the COPY state data. These tests rely on UTF8 <-> LATIN1 for the valid cases as LATIN1 accepts any bytes, and UTF8 <-> EUC_JP for some of the invalid cases where a character cannot be understood, causing a conversion failure.
Both ENCODING and client_encoding are covered. Test suggested by Andres Freund. Author: Sutou Kouhei Discussion: https://postgr.es/m/20240206222445.hzq22pb2nye7r...@awork3.anarazel.de Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/3ad8b840ce8b1d7279f2d0d5fb7d346c0a6a3e8d Modified Files -------------- src/test/regress/expected/copyencoding.out | 46 ++++++++++++++++++++++++ src/test/regress/expected/copyencoding_1.out | 8 +++++ src/test/regress/parallel_schedule | 2 +- src/test/regress/sql/copyencoding.sql | 53 ++++++++++++++++++++++++++++ 4 files changed, 108 insertions(+), 1 deletion(-)
