[jira] [Created] (CALCITE-2791) Add the JSON_TYPE function

2019-01-20 Thread xuqianjin (JIRA)
xuqianjin created CALCITE-2791: -- Summary: Add the JSON_TYPE function Key: CALCITE-2791 URL: https://issues.apache.org/jira/browse/CALCITE-2791 Project: Calcite Issue Type: Improvement

[jira] [Resolved] (CALCITE-2699) The bug of timestampadd handles time

2018-12-01 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin resolved CALCITE-2699. Resolution: Fixed > The bug of timestampadd handles time >

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-12-01 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- External issue URL: https://github.com/apache/calcite/pull/936 Fix Version/s: 1.17.0

[jira] [Comment Edited] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16697130#comment-16697130 ] xuqianjin edited comment on CALCITE-2699 at 11/23/18 1:28 PM: --

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Docs Text: https://github.com/apache/calcite/pull/936 External issue URL: (was:

[jira] [Comment Edited] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16697130#comment-16697130 ] xuqianjin edited comment on CALCITE-2699 at 11/23/18 4:24 PM: --

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Docs Text: (was: https://github.com/apache/calcite/pull/936) > The bug of timestampadd handles

[jira] [Commented] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16697317#comment-16697317 ] xuqianjin commented on CALCITE-2699: [~julianhyde] [~vlsi] I have submitted PR. Can you give me

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Description: Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed: #

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Description: Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed: #

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Description: Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed: #

[jira] [Commented] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16697130#comment-16697130 ] xuqianjin commented on CALCITE-2699: [~kgyrtkirk] Your conclusion is correct. Null is due to my

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Description: Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed: #

[jira] [Comment Edited] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16697317#comment-16697317 ] xuqianjin edited comment on CALCITE-2699 at 11/23/18 4:43 PM: --

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- External issue URL: https://github.com/apache/calcite/pull/936 > The bug of timestampadd handles

[jira] [Commented] (CALCITE-2699) The bug of timestampadd handles time

2018-11-23 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16696602#comment-16696602 ] xuqianjin commented on CALCITE-2699: [~kgyrtkirk] Yes, that's right. I think it makes sense to

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-22 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Description: Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed: #

[jira] [Commented] (CALCITE-2699) The bug of timestampadd handles time

2018-11-22 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16696474#comment-16696474 ] xuqianjin commented on CALCITE-2699: I want to try to fix it > The bug of timestampadd handles

[jira] [Created] (CALCITE-2699) The bug of timestampadd handles time

2018-11-22 Thread xuqianjin (JIRA)
xuqianjin created CALCITE-2699: -- Summary: The bug of timestampadd handles time Key: CALCITE-2699 URL: https://issues.apache.org/jira/browse/CALCITE-2699 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2699) The bug of timestampadd handles time

2018-11-22 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16696448#comment-16696448 ] xuqianjin commented on CALCITE-2699: I want to try and fix this > The bug of timestampadd handles

[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles time

2018-11-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2699: --- Description: Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed: #

[jira] [Created] (CALCITE-2810) Add the JSON_LENGTH function

2019-01-26 Thread xuqianjin (JIRA)
xuqianjin created CALCITE-2810: -- Summary: Add the JSON_LENGTH function Key: CALCITE-2810 URL: https://issues.apache.org/jira/browse/CALCITE-2810 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-2809) Add JSON_LENGTH function

2019-01-26 Thread xuqianjin (JIRA)
xuqianjin created CALCITE-2809: -- Summary: Add JSON_LENGTH function Key: CALCITE-2809 URL: https://issues.apache.org/jira/browse/CALCITE-2809 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-2810) Add the JSON_LENGTH function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2810: --- Description: {{JSON_LENGTH(*json_doc*[, *path*])}} Returns the length of a JSON document, or, if

[jira] [Updated] (CALCITE-2810) Add the JSON_LENGTH function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2810: --- Description: {{JSON_LENGTH(*json_doc*[, *path*])}} Returns the length of a JSON document, or, if

[jira] [Created] (CALCITE-2808) Add the JSON_LENGTH function

2019-01-26 Thread xuqianjin (JIRA)
xuqianjin created CALCITE-2808: -- Summary: Add the JSON_LENGTH function Key: CALCITE-2808 URL: https://issues.apache.org/jira/browse/CALCITE-2808 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753255#comment-16753255 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I've turned off the PR. best qianijn >

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753274#comment-16753274 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] Which multi-parameter is really a problem,

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753281#comment-16753281 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I really appreciate your review. Thank you

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-27 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753329#comment-16753329 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I hope you can spare your precious time to

[jira] [Comment Edited] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753253#comment-16753253 ] xuqianjin edited comment on CALCITE-2791 at 1/27/19 3:19 AM: - hi

[jira] [Comment Edited] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753253#comment-16753253 ] xuqianjin edited comment on CALCITE-2791 at 1/27/19 3:22 AM: - hi

[jira] [Issue Comment Deleted] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Comment: was deleted (was: hi [~zhztheplayer] I've turned off the PR. best qianijn) > Add the

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753265#comment-16753265 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I've turned off the PR. best qianjin >

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-26 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753253#comment-16753253 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] Thank you very much for your suggestion.

[jira] [Updated] (CALCITE-2791) Add the JSON_TYPE function

2019-01-27 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Description: The data in json can be =, <, <=, >, >=, <>,! =, and <=>. But the data types in json

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-28 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16754601#comment-16754601 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I have modified this PR. Can you spare some

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-29 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16754713#comment-16754713 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] Ok, I can understand. I am looking forward

[jira] [Updated] (CALCITE-2791) Add the JSON_TYPE function

2019-01-25 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Description: The data in json can be =, <, <=, >, >=, <>,! =, and <=>. But the data types in json

[jira] [Updated] (CALCITE-2791) Add the JSON_TYPE function

2019-01-25 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Description: The data in json can be =, <, <=, >, >=, <>,! =, and <=>. But the data types in json

[jira] [Updated] (CALCITE-2791) Add the JSON_TYPE function

2019-01-25 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Description: The data in json can be =, <, <=, >, >=, <>,! =, and <=>. But the data types in json

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-30 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16756821#comment-16756821 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I have modified this PR, can you take a

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-31 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757196#comment-16757196 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] I have modified this PR, can you take a

[jira] [Commented] (CALCITE-2791) Add the JSON_TYPE function

2019-01-31 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757200#comment-16757200 ] xuqianjin commented on CALCITE-2791: hi [~zhztheplayer] Some discussions about the adding of MySQL

[jira] [Comment Edited] (CALCITE-2791) Add the JSON_TYPE function

2019-01-31 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757200#comment-16757200 ] xuqianjin edited comment on CALCITE-2791 at 1/31/19 12:57 PM: -- hi

[jira] [Updated] (CALCITE-2791) Add the JSON_TYPE function

2019-01-25 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Labels: https://github.com/apache/calcite/pull/1013 (was: ) > Add the JSON_TYPE function >

[jira] [Updated] (CALCITE-2791) Add the JSON_TYPE function

2019-01-25 Thread xuqianjin (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuqianjin updated CALCITE-2791: --- Component/s: core > Add the JSON_TYPE function > -- > >