[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-18 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954457#comment-16954457 ] benj commented on CALCITE-3402: --- I think the RANGE with compound may be problematic when the "" is an

[jira] [Updated] (CALCITE-3318) Preserving CAST of VARCHAR operand in binary comparison for BigQuery

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3318: Summary: Preserving CAST of VARCHAR operand in binary comparison for BigQuery (was: Preserving

[jira] [Created] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
jin xing created CALCITE-3428: - Summary: Refine RelMdColumnUniqueness for Filter by considering constant columns Key: CALCITE-3428 URL: https://issues.apache.org/jira/browse/CALCITE-3428 Project: Calcite

[jira] [Updated] (CALCITE-3427) some subquery correlated case isn't fully implemented

2019-10-18 Thread liuzonghao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liuzonghao updated CALCITE-3427: Description: {code:java} //代码占位符 // for correlated case queries such as // // select e.deptno,

[jira] [Commented] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954335#comment-16954335 ] Wang Yanlin commented on CALCITE-3424: -- The difference for *Object* and *List* lies in

[jira] [Assigned] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3423: Assignee: Wang Yanlin > Support using CAST operation and BOOLEAN type value in table

[jira] [Assigned] (CALCITE-3400) Implement left/right/semi/anti/full join in Interpreter

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3400: Assignee: Wang Yanlin > Implement left/right/semi/anti/full join in Interpreter >

[jira] [Assigned] (CALCITE-3408) Add support for Enumerable Intersect/Minus all

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3408: Assignee: Wang Yanlin > Add support for Enumerable Intersect/Minus all >

[jira] [Assigned] (CALCITE-3362) Implementation for some empty tests of Lattice

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3362: Assignee: Wang Yanlin > Implementation for some empty tests of Lattice >

[jira] [Assigned] (CALCITE-3378) AssertionError for checking RexNode implify

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3378: Assignee: Wang Yanlin > AssertionError for checking RexNode implify >

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954386#comment-16954386 ] Wang Yanlin commented on CALCITE-3402: -- Add this test case in *JdbcTest* to reproduce {code:java}

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954417#comment-16954417 ] Wang Yanlin commented on CALCITE-3402: -- I think you are right about "SQL03 7.10 Rule 11a". The

[jira] [Commented] (CALCITE-3425) Inconsistent behavior of MetadataProvider in RelOptCluster

2019-10-18 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954332#comment-16954332 ] Stamatis Zampetakis commented on CALCITE-3425: -- I also noticed this a while ago and I

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-18 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954354#comment-16954354 ] benj commented on CALCITE-3402: --- Yes of course, these 2 expressions are well equivalent * RANGE BETWEEN

[jira] [Commented] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954331#comment-16954331 ] Wang Yanlin commented on CALCITE-3424: -- Strange, that, if you define method *generateStrings2*

[jira] [Comment Edited] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-18 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954354#comment-16954354 ] benj edited comment on CALCITE-3402 at 10/18/19 8:05 AM: - Yes of course, these

[jira] [Commented] (CALCITE-3425) Inconsistent behavior of MetadataProvider in RelOptCluster

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954388#comment-16954388 ] Danny Chen commented on CALCITE-3425: - Thanks [~hyuan] for firing this issue, let's continue the

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

2019-10-18 Thread benj (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954409#comment-16954409 ] benj commented on CALCITE-3402: --- "SQL03 7.10 Rule 11a" is probably a reference of the SQL 2003 standard

[jira] [Comment Edited] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954220#comment-16954220 ] Wang Yanlin edited comment on CALCITE-3423 at 10/18/19 9:01 AM: But, I

[jira] [Created] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3429: Summary: Refinement for implementation of sql type factory Key: CALCITE-3429 URL: https://issues.apache.org/jira/browse/CALCITE-3429 Project: Calcite Issue

[jira] [Assigned] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3429: Assignee: Wang Yanlin > Refinement for implementation of sql type factory >

[jira] [Resolved] (CALCITE-3318) Preserving CAST of STRING operands in comparison operator

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3318. - Fix Version/s: 1.22.0 Assignee: Danny Chen Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

2019-10-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3424: Labels: pull-request-available (was: ) > AssertionError thrown for user-defined table

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3428: Labels: pull-request-available (was: ) > Refine RelMdColumnUniqueness for Filter by

[jira] [Updated] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3429: Labels: pull-request-available (was: ) > Refinement for implementation of sql type

[jira] [Comment Edited] (CALCITE-3318) Preserving CAST of VARCHAR operand in binary comparison for BigQuery

2019-10-18 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954453#comment-16954453 ] Danny Chen edited comment on CALCITE-3318 at 10/18/19 11:04 AM: Fixed

[jira] [Updated] (CALCITE-3429) Refinement for implementation of sql type factory

2019-10-18 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3429: - Description: 1. The SqlTypeName of data type created with subclass of Map should be

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select

[jira] [Commented] (CALCITE-3376) VolcanoPlanner CannotPlanException: best rel is null even though there is an option with non-infinite cost

2019-10-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954462#comment-16954462 ] Ruben Q L commented on CALCITE-3376: [~xndai], sorry for the late reply, I have checked the unit

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select

[jira] [Updated] (CALCITE-3425) Inconsistent behavior of MetadataProvider in RelOptCluster

2019-10-18 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3425: --- Description: To use customized metadata provider, we can do the following: {code:java}

[jira] [Created] (CALCITE-3430) JDBC adapter generates extra alias for VALUES when used in join

2019-10-18 Thread Jess Balint (Jira)
Jess Balint created CALCITE-3430: Summary: JDBC adapter generates extra alias for VALUES when used in join Key: CALCITE-3430 URL: https://issues.apache.org/jira/browse/CALCITE-3430 Project: Calcite

[jira] [Commented] (CALCITE-3376) VolcanoPlanner CannotPlanException: best rel is null even though there is an option with non-infinite cost

2019-10-18 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954710#comment-16954710 ] Xiening Dai commented on CALCITE-3376: -- Great to know. Thanks for checking. > VolcanoPlanner

[jira] [Updated] (CALCITE-3323) Handle arbitrary/unknown functions that have ordinary syntax

2019-10-18 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3323: Labels: pull-request-available (was: ) > Handle arbitrary/unknown functions that have

[jira] [Commented] (CALCITE-2757) DISTINCT not being handled correctly in RelToSqlConverter

2019-10-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954861#comment-16954861 ] Julian Hyde commented on CALCITE-2757: -- I took a look at this pull request, and rebased as 

[jira] [Commented] (CALCITE-2757) DISTINCT not being handled correctly in RelToSqlConverter

2019-10-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954874#comment-16954874 ] Julian Hyde commented on CALCITE-2757: -- By the way, [~Krishnakant A], I see a lot of activity

[jira] [Updated] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2019-10-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2970: - Summary: Performance issue when enabling abstract converter for EnumerableConvention (was:

[jira] [Commented] (CALCITE-2157) ClickHouse dialect implementation

2019-10-18 Thread Davor Poldrugo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16954983#comment-16954983 ] Davor Poldrugo commented on CALCITE-2157: - Yeah, we need this so we can put ClickHouse behind