[jira] [Commented] (CALCITE-2696) Filter containing IN clause not passed to Enumerable.scan

[ https://issues.apache.org/jira/browse/CALCITE-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701480#comment-16701480 ] Stamatis Zampetakis commented on CALCITE-2696: -- Hi [~julianhyde], I think [~dirk.mahler] 

[jira] [Resolved] (CALCITE-297) Processing a scalar sub-query as a Filter instead of a Join

[ https://issues.apache.org/jira/browse/CALCITE-297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-297. - Resolution: Works for Me As noted, Calcite already does the right thing (as long as you choose

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701073#comment-16701073 ] Julian Hyde commented on CALCITE-1935: -- Oracle 18c XE might be the answer. (XE, Express Edition is

[jira] [Created] (CALCITE-2712) Add rule to remove null-generating side of a Join

Julian Hyde created CALCITE-2712: Summary: Add rule to remove null-generating side of a Join Key: CALCITE-2712 URL: https://issues.apache.org/jira/browse/CALCITE-2712 Project: Calcite Issue

[jira] [Commented] (CALCITE-2712) Add rule to remove null-generating side of a Join

[ https://issues.apache.org/jira/browse/CALCITE-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701177#comment-16701177 ] Julian Hyde commented on CALCITE-2712: -- cc [~swtalbot] > Add rule to remove null-generating side

[jira] [Commented] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

[ https://issues.apache.org/jira/browse/CALCITE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701121#comment-16701121 ] Andrew Pilloud commented on CALCITE-2710: - Yes, I see that now. (Passing UDFs time in local

[jira] [Closed] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

[ https://issues.apache.org/jira/browse/CALCITE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud closed CALCITE-2710. --- Resolution: Invalid > Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

[jira] [Resolved] (CALCITE-2711) Upgrade SQLLine to 1.6.0

[ https://issues.apache.org/jira/browse/CALCITE-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-2711. -- Resolution: Fixed Fix Version/s: 1.18.0 Fixed in 

[jira] [Created] (CALCITE-2713) JDBC adapter may generate casts on PostgreSQL for VARCHAR type exceeding max length

Jesus Camacho Rodriguez created CALCITE-2713: Summary: JDBC adapter may generate casts on PostgreSQL for VARCHAR type exceeding max length Key: CALCITE-2713 URL:

[jira] [Commented] (CALCITE-2696) Filter containing IN clause not passed to Enumerable.scan

[ https://issues.apache.org/jira/browse/CALCITE-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701205#comment-16701205 ] Julian Hyde commented on CALCITE-2696: -- It's probably not documented. Sorry. Try calling

[jira] [Commented] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

[ https://issues.apache.org/jira/browse/CALCITE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701232#comment-16701232 ] Julian Hyde commented on CALCITE-2710: -- Yeah, it's very confusing. Sorry about that. The root

[jira] [Resolved] (CALCITE-2673) Default implementation of SqlDialect should not support pushing all functions

[ https://issues.apache.org/jira/browse/CALCITE-2673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-2673. -- Resolution: Fixed Thanks for the feedback [~julianhyde]. I have

[jira] [Updated] (CALCITE-2695) Simplify casts which are only widening nullability

[ https://issues.apache.org/jira/browse/CALCITE-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated CALCITE-2695: - Fix Version/s: 1.18.0 > Simplify casts which are only widening

[jira] [Commented] (CALCITE-2671) GeodeFilter change to transform multiple OR s to use IN SET OQL predicate to significantly improve query performance

[ https://issues.apache.org/jira/browse/CALCITE-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701379#comment-16701379 ] Andrei Sereda commented on CALCITE-2671: Merged as

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701402#comment-16701402 ] Julian Hyde commented on CALCITE-1935: -- [~zhenw] If you have time to write some tests in the next

[jira] [Resolved] (CALCITE-2687) Is distinct from could lead to Exceptions in ReduceExpressionRule

[ https://issues.apache.org/jira/browse/CALCITE-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-2687. -- Resolution: Fixed Fix Version/s: 1.18.0 Fixed in

[jira] [Commented] (CALCITE-2708) In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function come from a single pattern variable

[ https://issues.apache.org/jira/browse/CALCITE-2708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16700063#comment-16700063 ] Dawid Wysakowicz commented on CALCITE-2708: --- Hi [~julianhyde] It sounds like a good idea to

[jira] [Commented] (CALCITE-2632) Add hashCode and equals implementations to RexNode

[ https://issues.apache.org/jira/browse/CALCITE-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16700283#comment-16700283 ] Zoltan Haindrich commented on CALCITE-2632: --- proposed solution: * add hashCode/equals as

[jira] [Commented] (CALCITE-2632) Add hashCode and equals implementations to RexNode

[ https://issues.apache.org/jira/browse/CALCITE-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16700363#comment-16700363 ] Vladimir Sitnikov commented on CALCITE-2632: [~kgyrtkirk], could you please clarify how

[jira] [Commented] (CALCITE-2632) Add hashCode and equals implementations to RexNode

[ https://issues.apache.org/jira/browse/CALCITE-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16700394#comment-16700394 ] Zoltan Haindrich commented on CALCITE-2632: --- I think the goal is the same as CALCITE-1367...I

[jira] [Resolved] (CALCITE-1367) Implement equals and hashCode for all sub-classes of RexNode

[ https://issues.apache.org/jira/browse/CALCITE-1367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Haindrich resolved CALCITE-1367. --- Resolution: Duplicate dup of: CALCITE-2632 > Implement equals and hashCode for

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16700454#comment-16700454 ] zhen wang commented on CALCITE-1935: some of the 'oracle queries' I am looking at