From 5f19412e4eae6468361f24fd20e05fb433da5538 Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Wed, 31 Jan 2024 15:02:28 +0900 Subject: [PATCH] Add tests for int4_bool() in int.c This cast was previously not covered at all by the regression tests. Author: Christoph Berg Discussion: https://postgr.es/m/ZYQZ1hNfLd_4rzkn@msg.df7cb.de --- src/test/regress/expected/boolean.out | 19 +++++++++++++++++++ src/test/regress/sql/boolean.sql | 5 +++++ 2 files changed, 24 insertions(+) diff --git a/src/test/regress/expected/boolean.out b/src/test/regress/expected/boolean.out index 57d251eea76..0e99eb7ffc0 100644 --- a/src/test/regress/expected/boolean.out +++ b/src/test/regress/expected/boolean.out @@ -566,6 +566,25 @@ SELECT isnul OR istrue OR isfalse FROM booltbl4; t (1 row) +-- Casts +SELECT 0::boolean; + bool +------ + f +(1 row) + +SELECT 1::boolean; + bool +------ + t +(1 row) + +SELECT 2::boolean; + bool +------ + t +(1 row) + -- -- Clean up -- Many tables are retained by the regression test, but these do not seem diff --git a/src/test/regress/sql/boolean.sql b/src/test/regress/sql/boolean.sql index 5b9dcd23172..85c6b019882 100644 --- a/src/test/regress/sql/boolean.sql +++ b/src/test/regress/sql/boolean.sql @@ -250,6 +250,11 @@ SELECT isfalse OR isnul OR istrue FROM booltbl4; SELECT istrue OR isfalse OR isnul FROM booltbl4; SELECT isnul OR istrue OR isfalse FROM booltbl4; +-- Casts +SELECT 0::boolean; +SELECT 1::boolean; +SELECT 2::boolean; + -- -- Clean up -- 2.39.5