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

2022-06-28 Thread itxiangkui (Jira)
Title: Message Title itxiangkui updated an

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

2022-06-23 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui reassigned CALCITE-5099: --- Assignee: itxiangkui > ResultSetEnumerable.enumeratorBasedOnStatement cause the backend c

[jira] [Updated] (CALCITE-5190) TPC-H testing of the Calcite framework

2022-06-13 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5190: Component/s: core jdbc-adapter > TPC-H testing of the Calcite framework > --

[jira] [Updated] (CALCITE-5190) TPC-H testing of the Calcite framework

2022-06-13 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5190: Affects Version/s: 1.30.0 > TPC-H testing of the Calcite framework >

[jira] [Created] (CALCITE-5190) TPC-H testing of the Calcite framework

2022-06-13 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5190: --- Summary: TPC-H testing of the Calcite framework Key: CALCITE-5190 URL: https://issues.apache.org/jira/browse/CALCITE-5190 Project: Calcite Issue Type: Wish

[jira] [Commented] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17552661#comment-17552661 ] itxiangkui commented on CALCITE-5187: - Referring to this Trace process, the followi

[jira] [Updated] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5187: Description:   # We define the structure of Schema-Tree: catalog->database->table # 2. A time s

[jira] [Updated] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5187: Description:   # We define the structure of Schema-Tree: catalog->database->table # 2. A time s

[jira] [Updated] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5187: Attachment: (was: Screenshot from 2022-06-10 11-17-02.png) > "CalciteSchema call getSubSchema

[jira] [Updated] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5187: Attachment: Screenshot from 2022-06-10 11-25-06.png > "CalciteSchema call getSubSchemaMap when pr

[jira] [Updated] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5187: Description:     # We define the structure of Schema-Tree: catalog->database->table # 2. A tim

[jira] [Updated] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5187: Attachment: (was: Screenshot from 2022-06-10 11-18-54.png) > "CalciteSchema call getSubSchema

[jira] [Created] (CALCITE-5187) "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down

2022-06-09 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5187: --- Summary: "CalciteSchema call getSubSchemaMap when prepareSql" will Causes SQL execution to slow down Key: CALCITE-5187 URL: https://issues.apache.org/jira/browse/CALCITE-5187

[jira] [Updated] (CALCITE-5173) ProjectableFilterableTable may provoke DefaultEnumerable “java.lang.Long cannot be cast to java.lang.String” error

2022-05-30 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5173: Summary: ProjectableFilterableTable may provoke DefaultEnumerable “java.lang.Long cannot be cast

[jira] [Updated] (CALCITE-5173) ProjectableFilterableTable may provoke DefaultEnumerable “java.lang.Long cannot be cast to java.lang.String” erro

2022-05-30 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5173: Description: when i defined a table  +"implements {color:#4c9aff}ProjectableFilterableTable{colo

[jira] [Created] (CALCITE-5173) ProjectableFilterableTable may provoke DefaultEnumerable “java.lang.Long cannot be cast to java.lang.String” erro

2022-05-30 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5173: --- Summary: ProjectableFilterableTable may provoke DefaultEnumerable “java.lang.Long cannot be cast to java.lang.String” erro Key: CALCITE-5173 URL: https://issues.apache.org/jira/brow

[jira] [Commented] (CALCITE-1739) backend jdbc connection does not returned to connection pool after execute a query.

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539161#comment-17539161 ] itxiangkui commented on CALCITE-1739: - [~jingwuli]   Let's take a look at the CALCI

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

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Description: We have extended JdbcSchema and JdbcCatalogSchema in order to connect to the back-e

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

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Component/s: avatica > ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connecti

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

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538759#comment-17538759 ] itxiangkui commented on CALCITE-5099: - Hi, [~julianhyde]    > ResultSetEnumerable.

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

2022-05-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538758#comment-17538758 ] itxiangkui commented on CALCITE-5099: - I think I have sorted out the conditions and

[jira] [Commented] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534210#comment-17534210 ] itxiangkui commented on CALCITE-5146: - 0: jdbc:avatica:remote:url=http://localhost:

[jira] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146 ] itxiangkui deleted comment on CALCITE-5146: - was (Author: JIRAUSER286541): 0: jdbc:avatica:remote:url=http://localhost:6> select from_unixtime(unix_timestamp(timestamp'2022-05-01')-25*86400

[jira] [Commented] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534211#comment-17534211 ] itxiangkui commented on CALCITE-5146: - {code:java} 0: jdbc:avatica:remote:url=http:

[jira] [Comment Edited] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534207#comment-17534207 ] itxiangkui edited comment on CALCITE-5146 at 5/10/22 7:53 AM: ---

[jira] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146 ] itxiangkui deleted comment on CALCITE-5146: - was (Author: JIRAUSER286541): editting... > Udf-Timestamp Function Rel get a weird value > > >

[jira] [Comment Edited] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534207#comment-17534207 ] itxiangkui edited comment on CALCITE-5146 at 5/10/22 7:52 AM: ---

[jira] [Commented] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534207#comment-17534207 ] itxiangkui commented on CALCITE-5146: - A bug that would trigger a floating-point ov

[jira] [Updated] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5146: Description: I have defined several UDFs: {code:java} public static String from_unixtime(long uni

[jira] [Updated] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5146: Description: I have defined several UDFs: {code:java} // code placeholder public static String fr

[jira] [Commented] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534205#comment-17534205 ] itxiangkui commented on CALCITE-5146: - editting... > Udf-Timestamp Function Rel ge

[jira] [Created] (CALCITE-5146) Udf-Timestamp Function Rel get a weird value

2022-05-10 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5146: --- Summary: Udf-Timestamp Function Rel get a weird value Key: CALCITE-5146 URL: https://issues.apache.org/jira/browse/CALCITE-5146 Project: Calcite Issue Type: Bu

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-08 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533583#comment-17533583 ] itxiangkui commented on CALCITE-5133: - Maybe because of the jira permission setting

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532594#comment-17532594 ] itxiangkui commented on CALCITE-5133: - [~nobigo]  Hi Sorry to bother you again. I

[jira] [Commented] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532587#comment-17532587 ] itxiangkui commented on CALCITE-5132: - Sorry for misunderstanding.. > When the IN-

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532163#comment-17532163 ] itxiangkui commented on CALCITE-5133: - [~nobigo] Hi I earnestly hope that a new is

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Affects Version/s: 1.30.0 > JdbcValues lost some values when the value of in was more than 20 > -

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Fix Version/s: (was: 1.30.0) > JdbcValues lost some values when the value of in was more than

[jira] [Comment Edited] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532149#comment-17532149 ] itxiangkui edited comment on CALCITE-5133 at 5/5/22 8:54 AM:

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532150#comment-17532150 ] itxiangkui commented on CALCITE-5133: - calcite :  1.30.0 > JdbcValues lost some va

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532149#comment-17532149 ] itxiangkui commented on CALCITE-5133: - {code:java} 0: jdbc:avatica:remote:url=http:

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Fix Version/s: 1.30.0 > JdbcValues lost some values when the value of in was more than 20 > -

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532098#comment-17532098 ] itxiangkui commented on CALCITE-5133: - [~nobigo]   Sorry, just added some info...

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Component/s: core > JdbcValues lost some values when the value of in was more than 20 > -

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:   I have a piece of data, the example is as follows: ||channel||gettime|| |c1|2022-

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:   I have a piece of data, the example is as follows: ||channel||gettime|| |c1|2022-

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:   I have a piece of data, the example is as follows: ||channel||gettime|| |c1|2022-

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:     ||channel||gettime|| |c1|2022-04-27 00:00:00| |c2|2022-04-27 00:00:00| |c3|2022

[jira] [Created] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-04 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5133: --- Summary: JdbcValues lost some values when the value of in was more than 20 Key: CALCITE-5133 URL: https://issues.apache.org/jira/browse/CALCITE-5133 Project: Calcite

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

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17528509#comment-17528509 ] itxiangkui edited comment on CALCITE-5099 at 4/27/22 3:31 AM: ---

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

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17528509#comment-17528509 ] itxiangkui commented on CALCITE-5099: - I have defined an AvaticalServer and it look

[jira] [Closed] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui closed CALCITE-5113. --- Resolution: Works for Me > function week(date 'xxx') returns a different number than mysql > --

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17528482#comment-17528482 ] itxiangkui commented on CALCITE-5113: - We carefully understood the iso-8601 standar

[jira] [Updated] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5113: Summary: function week(date 'xxx') returns a different number than mysql (was: function week(dat

[jira] [Updated] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5113: Affects Version/s: 1.30.0 > function week(date 'xxx') return an error number > --

[jira] [Updated] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5113: Component/s: core > function week(date 'xxx') return an error number > --

[jira] [Updated] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread itxiangkui (Jira)
[ 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'); +-+ | wee

[jira] [Updated] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread itxiangkui (Jira)
[ 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'); +-+ | wee

[jira] [Updated] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread itxiangkui (Jira)
[ 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'); +-+ | wee

[jira] [Created] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5113: --- Summary: function week(date 'xxx') return an error number Key: CALCITE-5113 URL: https://issues.apache.org/jira/browse/CALCITE-5113 Project: Calcite Issue Type

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

2022-04-25 Thread 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 te

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

2022-04-19 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Priority: Major (was: Critical) > ResultSetEnumerable.enumeratorBasedOnStatement cause the back

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

2022-04-19 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17524219#comment-17524219 ] itxiangkui commented on CALCITE-5099: - I guess setting connection = null; here is t

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

2022-04-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Labels: connection connection-pooling leak (was: ) > ResultSetEnumerable.enumeratorBasedOnStatem

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

2022-04-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5099: Priority: Critical (was: Major) > ResultSetEnumerable.enumeratorBasedOnStatement cause the back

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

2022-04-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17524036#comment-17524036 ] itxiangkui edited comment on CALCITE-5099 at 4/19/22 4:03 AM: ---

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

2022-04-18 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17524036#comment-17524036 ] itxiangkui commented on CALCITE-5099: - We have extended JdbcSchema and JdbcCatalogS

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

2022-04-18 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5099: --- Summary: ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak Key: CALCITE-5099 URL: https://issues.apache.org/jira/browse/CALCITE-5099 Pro

[jira] [Updated] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the int(10) unsigned column of mysql

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Summary: JdbcAdapter will "NumberOutOfRange" when iterating over the int(10) unsigned column of m

[jira] [Updated] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the int(10) unsigned column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Summary: JdbcAdapter will "NumberOutOfRange" when iterating over the int(10) unsigned column of m

[jira] [Commented] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522774#comment-17522774 ] itxiangkui commented on CALCITE-5094: - I think this problem can be fixed by changin

[jira] [Commented] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522763#comment-17522763 ] itxiangkui commented on CALCITE-5094: - Yes ,im sure the jdbc adapter will occur the

[jira] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094 ] itxiangkui deleted comment on CALCITE-5094: - was (Author: JIRAUSER286541): {code:java} JdbcSchema // code placeholder switch (SqlType.valueOf(dataType)) { case TIMESTAMP: case TIME:

[jira] [Commented] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522760#comment-17522760 ] itxiangkui commented on CALCITE-5094: - I guess: When you don't use a custom functio

[jira] [Updated] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Description:   When I have a mysql table, the example is as follows: ||*aid:long*||*gettime:date

[jira] [Updated] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Description:   When I have a mysql table, the example is as follows: ||*aid:long*||*gettime:date

[jira] [Updated] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Description:   When I have a mysql table, the example is as follows: ||*aid:long*||*gettime:date

[jira] [Commented] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522747#comment-17522747 ] itxiangkui commented on CALCITE-5094: - {code:java} JdbcSchema // code placeholder

[jira] [Updated] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Component/s: core jdbc-adapter > JdbcAdapter will report an error when iterating

[jira] [Updated] (CALCITE-5094) JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Summary: JdbcAdapter will "NumberOutOfRange" when iterating over the datetime column of mysql wit

[jira] [Updated] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Affects Version/s: 1.30.0 > JdbcAdapter will report an error when iterating over the datetime col

[jira] [Updated] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Labels: JDBC adapters (was: ) > JdbcAdapter will report an error when iterating over the datetim

[jira] [Updated] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Description:   When I have a mysql table, the example is as follows: ||*aid:long*||*gettime:date

[jira] [Updated] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Description:   When I have a mysql table, the example is as follows: ||*aid:long*||*gettime:date

[jira] [Updated] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5094: Description:   When I have a mysql table, the example is as follows: ||*aid:long*||*gettime:date

[jira] [Created] (CALCITE-5094) JdbcAdapter will report an error when iterating over the datetime column of mysql with function application

2022-04-15 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5094: --- Summary: JdbcAdapter will report an error when iterating over the datetime column of mysql with function application Key: CALCITE-5094 URL: https://issues.apache.org/jira/browse/CAL

[jira] [Comment Edited] (CALCITE-5039) View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env

2022-04-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17517329#comment-17517329 ] itxiangkui edited comment on CALCITE-5039 at 4/5/22 9:32 AM:

[jira] [Commented] (CALCITE-5039) View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env

2022-04-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17517329#comment-17517329 ] itxiangkui commented on CALCITE-5039: - Yes! [~wojustme]   My test case is the sam

[jira] [Commented] (CALCITE-5047) avatica-server integrated with spring-boot

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17516205#comment-17516205 ] itxiangkui commented on CALCITE-5047: - No one noticed this feature, so I closed it.

[jira] [Closed] (CALCITE-5047) avatica-server integrated with spring-boot

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui closed CALCITE-5047. --- Resolution: Fixed > avatica-server integrated with spring-boot > -

[jira] [Commented] (CALCITE-5039) View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17516204#comment-17516204 ] itxiangkui commented on CALCITE-5039: - Our DBAs are used to mysql's type system oft

[jira] [Commented] (CALCITE-5068) There are some problems with the use of catalog

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17516202#comment-17516202 ] itxiangkui commented on CALCITE-5068: - I understand the differences between catalog

[jira] [Closed] (CALCITE-5068) There are some problems with the use of catalog

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui closed CALCITE-5068. --- Resolution: Fixed > There are some problems with the use of catalog > -

[jira] [Updated] (CALCITE-5068) There are some problems with the use of catalog

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5068: Description: when i use under sqlline !schema !tables !metadata getSchemas When I wait for the

[jira] [Updated] (CALCITE-5068) There are some problems with the use of catalog

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5068: Description: when i use under sqlline !schema !tables !metadata getSchemas When I wait for the

[jira] [Updated] (CALCITE-5068) There are some problems with the use of catalog

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5068: Description: when i use under sqlline !schema !tables !metadata getSchemas When I wait for th

[jira] [Closed] (CALCITE-5071) Schema.getTableMap cannot handle tables with the same name in "Schema->SubSchema->Table" mode

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5071?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui closed CALCITE-5071. --- Resolution: Fixed > Schema.getTableMap cannot handle tables with the same name in > "Schema->SubSc

[jira] [Commented] (CALCITE-5071) Schema.getTableMap cannot handle tables with the same name in "Schema->SubSchema->Table" mode

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17516195#comment-17516195 ] itxiangkui commented on CALCITE-5071: - It's really not a good behavior to show all

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

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5080: Description: We have a data set stored in Tidb (a distributed mysql database), a field in the da

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

2022-04-01 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5080: Component/s: core jdbc-adapter jdbc-driver > jdbc adapter "zero

  1   2   >