calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <>
Subject [jira] [Created] (CALCITE-1632) Return types of datetime + interval
Date Tue, 14 Feb 2017 20:35:41 GMT
Julian Hyde created CALCITE-1632:

             Summary: Return types of datetime + interval
                 Key: CALCITE-1632
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde

Per the SQL standard, the return type of "datetime + interval" is the same as the type of
"datetime". (Postgres, for instance, always widens the result to TIMESTAMP; this is wrong.)

Also, when adding or subtracting to a TIME value, make sure the result stays within the range

This message was sent by Atlassian JIRA

View raw message