Thanks all.
David G. Johnston <david.g.johnston@xxxxxxxxx> 于2022年5月10日周二 13:41写道:
On Monday, May 9, 2022, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:=?UTF-8?B?5q2j5Y2O5ZCV?= <kainwen@xxxxxxxxx> writes:
> I test the following SQL in pg15dev (seems same behavior as the
> previous version).
> select '2020701'::date;
> date
> ------------
> 0202-07-01
> (1 row)
> At the first glance, the result seems quite strange.
[ shrug... ] You left out a zero. It's not apparent to me that
this answer is wrong.
If you want to pursue this question, you could start by bisecting
to find just which commit changed it and why.
Manual history inspection of datetime.cThe goal seemed to be able to accept 5-digit years…this behavior change didn’t show in the tests (or discussion) though I didn’t look for the of testing the pre-existing failure mode.David J.