[
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:
0: jdbc:calcite:model=src/test/resources/mode> select week(date '2022-01-01');
+--------+
| EXPR$0 |
+--------+
| 52 |
+--------+
mysql> select week(date '2022-01-01');
+-------------------------+
| week(date '2022-01-01') |
+-------------------------+
| 0 |
+-------------------------+
1 row in set (0.01 sec)
> 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)
