[jira] [Comment Edited] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668103#comment-16668103 ] Vladimir Sitnikov edited comment on CALCITE-2641 at 10/30/18 4:16 AM:

[jira] [Comment Edited] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668103#comment-16668103 ] Vladimir Sitnikov edited comment on CALCITE-2641 at 10/30/18 4:14 AM:

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668103#comment-16668103 ] Vladimir Sitnikov commented on CALCITE-2641: Just to clarify: typical flow is SqlNode

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668092#comment-16668092 ] Vladimir Sitnikov commented on CALCITE-2641: [~ptrbojko], now you've puzzled me. It seems

[jira] [Resolved] (CALCITE-2646) Support nullable struct type

2018-10-29 Thread Ted Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Xu resolved CALCITE-2646. - Resolution: Duplicate > Support nullable struct type > > >

[jira] [Created] (CALCITE-2647) In RelBuilder, add a groupKey method that assumes only one grouping set

2018-10-29 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2647: Summary: In RelBuilder, add a groupKey method that assumes only one grouping set Key: CALCITE-2647 URL: https://issues.apache.org/jira/browse/CALCITE-2647 Project:

[jira] [Updated] (CALCITE-1174) When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0)

2018-10-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1174: - Fix Version/s: 1.18.0 > When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0) >

[jira] [Updated] (CALCITE-1174) When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0)

2018-10-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1174: - Component/s: (was: core) jdbc-adapter > When generating SQL, translate

[jira] [Updated] (CALCITE-1174) When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0)

2018-10-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1174: - Description: JDBC adapter wrongly pushes SUM0 down to PostgreSQL. {code:java} select "rnum",

[jira] [Updated] (CALCITE-1174) When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0)

2018-10-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1174: - Summary: When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0) (was: JDBC adapter

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Piotr Bojko (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667843#comment-16667843 ] Piotr Bojko commented on CALCITE-2641: -- [~vladimirsitnikov] Thanks for clarification and hints!

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667830#comment-16667830 ] Vladimir Sitnikov commented on CALCITE-2641: [~ptrbojko], PR896 looks weird to me. I think

[jira] [Comment Edited] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Vladimir Sitnikov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667830#comment-16667830 ] Vladimir Sitnikov edited comment on CALCITE-2641 at 10/29/18 10:13 PM:

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Piotr Bojko (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667808#comment-16667808 ] Piotr Bojko commented on CALCITE-2641: -- I've created a pull request for this -

[jira] [Comment Edited] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667432#comment-16667432 ] Julian Hyde edited comment on CALCITE-2641 at 10/29/18 4:49 PM: Users -

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667432#comment-16667432 ] Julian Hyde commented on CALCITE-2641: -- Users - the people who write user-defined functions and

[jira] [Commented] (CALCITE-2641) DATE and TIMESTAMP arguments to user-defined table function

2018-10-29 Thread Piotr Bojko (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667331#comment-16667331 ] Piotr Bojko commented on CALCITE-2641: -- I would like to have a hint on this. I am willing to ship

[jira] [Commented] (CALCITE-2646) Support nullable struct type

2018-10-29 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16667187#comment-16667187 ] Stamatis Zampetakis commented on CALCITE-2646: -- The issue is a duplicate of

[jira] [Updated] (CALCITE-2646) Support nullable struct type

2018-10-29 Thread Ted Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Xu updated CALCITE-2646: Issue Type: Bug (was: Improvement) > Support nullable struct type > > >

[jira] [Created] (CALCITE-2646) Support nullable struct type

2018-10-29 Thread Ted Xu (JIRA)
Ted Xu created CALCITE-2646: --- Summary: Support nullable struct type Key: CALCITE-2646 URL: https://issues.apache.org/jira/browse/CALCITE-2646 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-2617) FilterProjectTransposeRule should allow filter conditions with correlated variables to be pushed down

2018-10-29 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1826#comment-1826 ] Stamatis Zampetakis commented on CALCITE-2617: -- Thanks for the review and the added tests