Re: BUG #18327: Column naming inconsistency for boolean literals in ELSE clauses of CASE expressions. - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      18327
Logged by:          Michael Bondarenko
Email address:      work.michael.2956@gmail.com
PostgreSQL version: 14.10
Operating system:   MacOS Sonoma 14.1.1 (23B81)
Description:       

I'm running my queries on the TPC-H schema, which can be found at:
https://github.com/dimitri/tpch-citus/blob/master/schema/tpch-schema.sql

I found the following inconsistency:

```
tpch=# select case when true then true else true end;
 case
------
 t
(1 row)

tpch=# select case when true then true else (select true) end;
 bool
------
 t
(1 row)
```

As you can see, the auto-generated aliases do not correspond. The expected
behaviour was for the first query to also name the column 'bool'.

I base my expectations on:

1) This query naming the result 'bool':
```
tpch=# select true;
 bool
------
 t
(1 row)
```

2) These queries propagating the column name from the else clause of the
case expression:

2.1) Propagation of the aggregate function name
```
tpch=# select case when true then true else bool_or(true) end;
 bool_or
---------
 t
(1 row)
```