[jira] [Commented] (CALCITE-5099) ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak

[itxiangkui (Jira)]

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

itxiangkui commented on CALCITE-5099:
-------------------------------------

I did an experiment:
1. Go to the sqlline terminal to query the data of mysql_catalog.database.table
2. Call calcite's api to connect to Calcite's Connection to execute Sql

The former does not call the close() method to close the connection after the 
ResultSetEnumerable is iterated; the latter calls the close() method correctly 
to close the connection

Indeed, as described in the https://calcite.apache.org/avatica/docs/index.html  
documentation, there is no action to close the connection

> ResultSetEnumerable.enumeratorBasedOnStatement  cause the backend connection 
> leak
> ---------------------------------------------------------------------------------
>
>                 Key: CALCITE-5099
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5099
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.30.0
>            Reporter: itxiangkui
>            Priority: Major
>              Labels: connection, connection-pooling, leak
>




--
This message was sent by Atlassian Jira
(v8.20.7#820007)