BUG #17762: date field casts to null in case section with join's

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17762: date field casts to null in case section with join's
Дата
Msg-id 17762-1a82488048c89e3c@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17762: date field casts to null in case section with join's
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17761: Questionable regular expression behavior
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BUG #17761: Questionable regular expression behavior