pgsql: Fix portability issue in test indirect_toast

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix portability issue in test indirect_toast
Date: 2021-06-07 09:14:21
Message-ID: E1lqBKv-000812-VZ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix portability issue in test indirect_toast

When run on a server using default_toast_compression set to LZ4, this
test would fail because of a consistency issue with the order of the
tuples treated. LZ4 causes one tuple to be stored inline instead of
getting externalized. As the goal of this test is to check after data
stored externally, stick to pglz as the compression algorithm used, so
as all data of this test is stored the way it should.

Analyzed-by: Dilip Kumar
Discussion: https://postgr.es/m/YLrDWxJgM8WWMoCg@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/68a6d8a87006ba727d9662ec84c7a3d9de402df0

Modified Files
--------------
src/test/regress/expected/indirect_toast.out | 7 +++++++
src/test/regress/sql/indirect_toast.sql | 10 ++++++++++
2 files changed, 17 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2021-06-07 15:05:50 pgsql: Fix compiler warning
Previous Message Amit Kapila 2021-06-07 04:12:38 pgsql: Remove two_phase variable from CreateReplicationSlotCmd struct.