[jira] [Comment Edited] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2020-12-30 Thread JIasen Sheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256823#comment-17256823 ] JIasen Sheng edited comment on CALCITE-4188 at 12/31/20, 7:46 AM: -- I

[jira] [Comment Edited] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2020-12-30 Thread JIasen Sheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256823#comment-17256823 ] JIasen Sheng edited comment on CALCITE-4188 at 12/31/20, 7:34 AM: -- I

[jira] [Comment Edited] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2020-12-30 Thread JIasen Sheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256823#comment-17256823 ] JIasen Sheng edited comment on CALCITE-4188 at 12/31/20, 7:33 AM: -- I

[jira] [Commented] (CALCITE-4434) Cannot implement 'CASE row WHEN row ...'

2020-12-30 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256849#comment-17256849 ] Rui Wang commented on CALCITE-4434: --- [~julianhyde] Thanks for your suggestions. I probably should

[jira] [Commented] (CALCITE-4349) Support GROUP_CONCAT aggregate function for MySQL

2020-12-30 Thread Zhen Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256837#comment-17256837 ] Zhen Wang commented on CALCITE-4349: want some discussion here, the overall implementation would be

[jira] [Commented] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2020-12-30 Thread JIasen Sheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256823#comment-17256823 ] JIasen Sheng commented on CALCITE-4188: --- I tried to convert correlate to sqlDynamicParam

[jira] [Created] (CALCITE-4452) The query column is allowed not in the group by in MySQL

2020-12-30 Thread Quan Chao (Jira)
Quan Chao created CALCITE-4452: -- Summary: The query column is allowed not in the group by in MySQL Key: CALCITE-4452 URL: https://issues.apache.org/jira/browse/CALCITE-4452 Project: Calcite

[jira] [Resolved] (CALCITE-4367) Incorrect documentation for Avatica JSON request/response signatures

2020-12-30 Thread Josh Elser (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser resolved CALCITE-4367. - Fix Version/s: avatica-1.18.0 Resolution: Fixed > Incorrect documentation for Avatica

[jira] [Created] (CALCITE-4451) Group by is always case sensitive， but in mysql some Collate like *_ci is case insensitive

2020-12-30 Thread Quan Chao (Jira)
Quan Chao created CALCITE-4451: -- Summary: Group by is always case sensitive， but in mysql some Collate like *_ci is case insensitive Key: CALCITE-4451 URL: https://issues.apache.org/jira/browse/CALCITE-4451

[jira] [Updated] (CALCITE-4450) ElasticSearch query with varchar literal projection fails with JsonParseException

2020-12-30 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4450: Labels: pull-request-available (was: ) > ElasticSearch query with varchar literal

[jira] [Updated] (CALCITE-4450) ElasticSearch query with varchar literal projection fails with JsonParseException

2020-12-30 Thread Vova Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vova Vysotskyi updated CALCITE-4450: Summary: ElasticSearch query with varchar literal projection fails with

[jira] [Updated] (CALCITE-4448) Use TableMacro user-defined table functions with QueryableTable

2020-12-30 Thread Vova Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vova Vysotskyi updated CALCITE-4448: Fix Version/s: 1.27.0 > Use TableMacro user-defined table functions with QueryableTable

[jira] [Updated] (CALCITE-4450) Query on ElasticSearch table that projects varchar literal fails with JsonParseException

2020-12-30 Thread Vova Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vova Vysotskyi updated CALCITE-4450: Fix Version/s: 1.27.0 > Query on ElasticSearch table that projects varchar literal fails

[jira] [Created] (CALCITE-4450) Query on ElasticSearch table that projects varchar literal fails with JsonParseException

2020-12-30 Thread Vova Vysotskyi (Jira)
Vova Vysotskyi created CALCITE-4450: --- Summary: Query on ElasticSearch table that projects varchar literal fails with JsonParseException Key: CALCITE-4450 URL: https://issues.apache.org/jira/browse/CALCITE-4450

[jira] [Comment Edited] (CALCITE-4446) Implement three-valued logic for SEARCH operator

2020-12-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256678#comment-17256678 ] Julian Hyde edited comment on CALCITE-4446 at 12/30/20, 7:24 PM: - After

[jira] [Commented] (CALCITE-4446) Implement three-valued logic for SEARCH operator

2020-12-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256678#comment-17256678 ] Julian Hyde commented on CALCITE-4446: -- After this change, there will be 3 special Sarg values

[jira] [Commented] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2020-12-30 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256638#comment-17256638 ] Stamatis Zampetakis commented on CALCITE-4188: -- You opted to model correlated variables as

[jira] [Commented] (CALCITE-4434) Cannot implement 'CASE row WHEN row ...'

2020-12-30 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256580#comment-17256580 ] Julian Hyde commented on CALCITE-4434: -- It doesn’t have to be a new PR. In fact it’s better to use

[jira] [Commented] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2020-12-30 Thread JIasen Sheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17256379#comment-17256379 ] JIasen Sheng commented on CALCITE-4188: --- Hey [~zabetak] , When assigning values to dynamic