[jira] [Created] (FLINK-19913) The precision in document and code of `INTERVAL DAY(p1) TO SECOND(p2)` are inconsistent

[Shang Yuanchun (Jira)]

sunjincheng created FLINK-19913:
-----------------------------------

             Summary: The precision in document and code of `INTERVAL DAY(p1) TO SECOND(p2)` are inconsistent
                 Key: FLINK-19913
                 URL: https://issues.apache.org/jira/browse/FLINK-19913
             Project: Flink
          Issue Type: Improvement
          Components: Table SQL / API
    Affects Versions: 1.11.1, 1.12.0
            Reporter: sunjincheng


The precision in document and code of `INTERVAL DAY(p1) TO SECOND(p2)` are inconsistent. In doc:
{code:java}
INTERVAL DAY(p1) TO SECOND(p2)

The type can be declared using the above combinations where p1 is the number of digits of days (day precision) and p2 is the number of digits of fractional seconds (fractional precision). p1 must have a value between 1 and 6 (both inclusive). p2 must have a value between 0 and 9 (both inclusive). If no p1 is specified, it is equal to 2 by default. If no p2 is specified, it is equal to 6 by default.

{code}

In code:
{code}
 case typeName if DAY_INTERVAL_TYPES.contains(typeName) =>
        if (relDataType.getPrecision > 3) {
          throw new TableException(
            s"DAY_INTERVAL_TYPES precision is not supported: ${relDataType.getPrecision}")
        }
{code}

We can also refer to Oracle's definition of support for INTERVAL:
https://oracle-base.com/articles/misc/oracle-dates-timestamps-and-intervals#interval





--
This message was sent by Atlassian Jira
(v8.3.4#803005)