BUG #17762: date field casts to null in case section with join's - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17762: date field casts to null in case section with join's
Date
Msg-id 17762-1a82488048c89e3c@postgresql.org
Whole thread Raw
Responses Re: BUG #17762: date field casts to null in case section with join's  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17762
Logged by:          Evgeny Nee
Email address:      jounts@gmail.com
PostgreSQL version: 15.1
Operating system:   debian 11
Description:

Query works fine:
SELECT id, 
CASE
    WHEN date_field IS NOT NULL THEN date_field::TEXT
END AS date_str
FROM my_table

But this query:
SELECT t1id, t2.name, 
CASE
    WHEN t1.date_field IS NOT NULL THEN t1.date_field::TEXT
END AS date_str
FROM my_table t1
JOIN my_table2 t2 ON t1.id = t2.id

returns: null in date_str


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17761: Questionable regular expression behavior
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: BUG #17761: Questionable regular expression behavior