Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3
Date: 2021-12-16 19:44:12
Message-ID: 1124027.1639683852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

John Naylor <john(dot)naylor(at)enterprisedb(dot)com> writes:
> A customer reported a planning regression from 11.5 to 12.9. After
> bisecting, it seems the fix for the thread subject here, commit
> f230614da28, broke partition pruning in some cases.

[ facepalm... ] I didn't consider the possibility that
find_typmod_coercion_function would find something ...
so we're getting an actual call of bpchar(), not just
a RelabelType.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message James Pang (chaolpan) 2021-12-17 03:27:05 RE: BUG #17326: Postgres crashed when pg_reload_conf() with ssl certificate parameters
Previous Message John Naylor 2021-12-16 18:38:29 Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3