Re: length coerce for bpchar is broken since 7.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: length coerce for bpchar is broken since 7.0
Дата
Msg-id 28841.972492548@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: length coerce for bpchar is broken since 7.0  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Список pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>>>> Can you give me any example for this case?
>> 
>> UPDATE foo SET bpcharcol = 'a'::char || 'b'::char;
>> 
>> UPDATE foo SET bpcharcol = upper('abc');

> In those cases above bpchar() will be called anyway, so I don't see
> MULTIBYTE length coerce problems there.

So it will, but *only* because the parser realizes that it needs to
add a call to bpchar().  If exprTypmod returns incorrect values then
it's possible that the parser would wrongly decide it didn't need to
call bpchar().
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: [Fwd: [CORE SDI ADVISORY] MySQL weak authentication]
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: --with-perl=/path/to/prefered/perl?