Thread: pgsql/src backend/parser/gram.y backend/utils/ ...

pgsql/src backend/parser/gram.y backend/utils/ ...

From
thomas@postgresql.org
Date:
CVSROOT:    /cvsroot
Module name:    pgsql
Changes by:    thomas@postgresql.org    01/10/19 21:02:22

Modified files:
    src/backend/parser: gram.y
    src/backend/utils/adt: datetime.c nabstime.c timestamp.c
    src/test/regress/expected: horology.out timestamptz.out

Log message:
    Fix transposed arguments for typmod for one INTERVAL production.
    Mask both typmod subfields for INTERVAL to avoid setting the high bit,
    per dire warning from Tom Lane.
    Clear tmask for DTK_ISO_TIME case to avoid time zone troubles.
    Symptom reported by Tom Lane.
    Clean up checking for valid time zone info in output routine.
    This should now work for both SQL99 and Unix-style time zones.
    Put in explicit check for INTERVAL() typmod rounding to avoid accumulating
    cruft in the lower bits. Not sure that this helps, but we'll need to do
    something. The symptom is visible with a query like
    select interval(2) '10000 days 01:02:03.040506';
    Regression tests are patched to repair the Tom Lane symptom, and all pass.