[jira] [Commented] (CALCITE-5080) jdbc adapter "zeroDateTimeBehavior=convertToNull" Causes "enumerable" to get stuck

["itxiangkui (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17515826#comment-17515826 ] 

itxiangkui commented on CALCITE-5080:
-------------------------------------

Not sure if this is a problem with calcite's jdbc adapter or a server-side problem

> jdbc adapter "zeroDateTimeBehavior=convertToNull" Causes "enumerable" to get stuck
> ----------------------------------------------------------------------------------
>
>                 Key: CALCITE-5080
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5080
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: itxiangkui
>            Priority: Major
>
> We have a data set stored in Tidb (a distributed mysql database), a field in the database is Timestamp type, there will be data items such as 0000-00-00 00:00:00
> If the jdbc connection parameter does not add the zeroDateTimeBehavior=xx command, the query will report an error, but the zeroDateTimeBehavior=convertToNull command seems to cause the “Enumerable bind” process to freeze and the query does not respond.
> SQL:
> ```
> select * from `catalog_name`.`database_name`.`table_name` limit 1;
> ```
> {
>   "version": "1.0",
>   "defaultSchema": "icuser",
>   "schemas": [{
>     "name": "tidb_test",
>     "type": "custom",
>     "factory": "com.xxxx.TidbCatalogSchema$Factory",
>     "operand": {
>       "jdbcDriver": "com.mysql.cj.jdbc.Driver",
>       "jdbcUrl": "jdbc:mysql://xxxxxx:4037/xx? zeroDateTimeBehavior=round  ",
>       "jdbcUser": "mysql",
>       "jdbcPassword": "mysql"
>     }
>   }]
> }
> *zeroDateTimeBehavior=round   will be ok*
> {
>   "version": "1.0",
>   "defaultSchema": "icuser",
>   "schemas": [{
>     "name": "tidb_test",
>     "type": "custom",
>     "factory": "com.xxxx.TidbCatalogSchema$Factory",
>     "operand": {
>       "jdbcDriver": "com.mysql.cj.jdbc.Driver",
>       "jdbcUrl": "jdbc:mysql://xxxxxx:4037/xx? zeroDateTimeBehavior=convertToNull",
>       "jdbcUser": "mysql",
>       "jdbcPassword": "mysql"
>     }
>   }]
> }
> *zeroDateTimeBehavior=convertToNull will cause stuck*



--
This message was sent by Atlassian Jira
(v8.20.1#820001)