[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
itxiangkui updated CALCITE-5113: -------------------------------- Description: {code:java} mysql> select week(date '2022-01-01'); +-------------------------+ | week(date '2022-01-01') | +-------------------------+ | 0 | +-------------------------+ 1 row in set (0.01 sec) {code} {code:java} 0: jdbc:avatica:remote:url=http://10.192.11.4> select week(date '2022-01-01'); +--------+ | EXPR$0 | +--------+ | 52 | +--------+ {code} was: {code:java} mysql> select week(date '2022-01-01'); +-------------------------+ | week(date '2022-01-01') | +-------------------------+ | 0 | +-------------------------+ 1 row in set (0.01 sec) {code} ++ {code:java} 0: jdbc:avatica:remote:url=http://10.192.11.4> select week(date '2022-01-01'); +--------+ | EXPR$0 | +--------+ | 52 | +--------+ {code} > function week(date 'xxx') return an error number > ------------------------------------------------ > > Key: CALCITE-5113 > URL: https://issues.apache.org/jira/browse/CALCITE-5113 > Project: Calcite > Issue Type: Bug > Reporter: itxiangkui > Priority: Major > > {code:java} > mysql> select week(date '2022-01-01'); > +-------------------------+ > | week(date '2022-01-01') | > +-------------------------+ > | 0 | > +-------------------------+ > 1 row in set (0.01 sec) > {code} > > {code:java} > 0: jdbc:avatica:remote:url=http://10.192.11.4> select week(date '2022-01-01'); > +--------+ > | EXPR$0 | > +--------+ > | 52 | > +--------+ {code} > > -- This message was sent by Atlassian Jira (v8.20.7#820007)