[ https://issues.apache.org/jira/browse/CALCITE-5981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alessandro Solimando reassigned CALCITE-5981: --------------------------------------------- Assignee: Mihai Budiu (was: Alessandro Solimando) > TIMESTAMPDIFF function returns incorrect result > ------------------------------------------------ > > Key: CALCITE-5981 > URL: https://issues.apache.org/jira/browse/CALCITE-5981 > Project: Calcite > Issue Type: Bug > Components: avatica > Affects Versions: 1.23.0 > Reporter: Mihai Budiu > Assignee: Mihai Budiu > Priority: Minor > Labels: pull-request-available > Fix For: 1.24.0 > > Time Spent: 10m > Remaining Estimate: 0h > > The following test fails, when added to SqlOperatorTest: > {code:java} > f.checkScalar("timestampdiff(month, DATE '2004-02-29', DATE '2005-02-28')", > "11", "INTEGER NOT NULL"); > {code} > The result returned by the expression is 12. However, MySQL returns 11. > The semantics of this function is not described clearly in the documentation, > but according to several prior issues [1] [2] [3] the intended semantics > should be the same as in MySQL. > A corresponding MySQL test: [4] > The implementation seems to be in > StandardConvertletTable.TimestampDiffConvertlet. > [1] https://issues.apache.org/jira/browse/CALCITE-1827, > [2] https://issues.apache.org/jira/browse/CALCITE-3529, > [3] https://issues.apache.org/jira/browse/CALCITE-1124. > [4] > [https://github.com/mysql/mysql-server/blob/ea1efa9822d81044b726aab20c857d5e1b7e046a/mysql-test/r/func_time.result#L1151] > -- This message was sent by Atlassian Jira (v8.20.10#820010)