pgsql: Improve test coverage for functional dependencies - Mailing list pgsql-committers

From Tomas Vondra
Subject pgsql: Improve test coverage for functional dependencies
Date
Msg-id E1jDEz9-0001qd-Vc@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Improve test coverage for functional dependencies

The regression tests for functional dependencies were only using clauses
of the form (Var op Const), i.e. with Var on the left side. This adds
a couple of queries with Var on the right, to test other code paths.

It also prints one of the functional dependencies, to test the data type
output function. The functional dependencies are "perfect" with degree
of 1.0 so this should be stable.

Discussion: https://www.postgresql.org/message-id/flat/20200113230008.g67iyk4cs3xbnjju@development
Author: Tomas Vondra

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f9696782c70168e575c0f2d17a1cfe71847fef3d

Modified Files
--------------
src/test/regress/expected/stats_ext.out | 31 +++++++++++++++++++++++++++++++
src/test/regress/sql/stats_ext.sql      |  7 +++++++
2 files changed, 38 insertions(+)


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: C comment: correct commented bytes of max_cached_tuplebufs
Next
From: Tomas Vondra
Date:
Subject: pgsql: Improve test coverage for multi-column MCV lists