Horton

Add some tests for encoding conversion in COPY TO/FROM

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 3ad8b840ce8b1d7279f2d0d5fb7d346c0a6a3e8d
Author: Michael Paquier <michael@paquier.xyz>
Date: 2024-12-16T02:23:38Z
Releases: 18.0 
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.hzq22pb2nye7rm67@awork3.anarazel.de

Files

PathChange+/−
src/test/regress/expected/copyencoding_1.out added +8 −0
src/test/regress/expected/copyencoding.out added +46 −0
src/test/regress/parallel_schedule modified +1 −1
src/test/regress/sql/copyencoding.sql added +53 −0

Discussion