[jira] [Updated] (CALCITE-3368) 'is null' expression in SQL may be optimized incorrectly in the underlying implementation

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Summary: 'is null' expression in SQL may be optimized incorrectly in the underlying

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Description: When I test a Fink sql to check overflow situation like  {code:java} select

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Description: When I test a Fink sql to check overflow situation  {code:java} select case

[jira] [Commented] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937422#comment-16937422 ] Leonard Xu commented on CALCITE-3368: - [~julianhyde]  Sorry for the confused tile. How about the

[jira] [Resolved] (CALCITE-3370) Emulate NULL direction for MSSQL

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3370. -- Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

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

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3323. -- Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3370) Emulate NULL direction for MSSQL

2019-09-24 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3370: Labels: pull-request-available (was: ) > Emulate NULL direction for MSSQL >

[jira] [Assigned] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-3368: --- Assignee: Danny Chan > Nonequivalent simplification happens in RexSimplify >

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3368: - Fix Version/s: (was: 1.22.0) > Nonequivalent simplification happens in RexSimplify >

[jira] [Commented] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937340#comment-16937340 ] Julian Hyde commented on CALCITE-3368: -- I have removed the 'fix version', unless someone is

[jira] [Comment Edited] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937338#comment-16937338 ] Julian Hyde edited comment on CALCITE-3368 at 9/25/19 2:09 AM: --- A SQL

[jira] [Commented] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937338#comment-16937338 ] Julian Hyde commented on CALCITE-3368: -- A SQL user would not understand what "Nonequivalent

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Description: when I test a Fink sql to check overflow situation like   {code:java} select

[jira] [Commented] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937324#comment-16937324 ] Leonard Xu commented on CALCITE-3368: - [~julianhyde] Thank you for your reply,I have updated the

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Description: when I test a Fink sql to check overflow situation like   {code:java} select

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Description: I found that Calcite's simplification logic of isNull expression will convert 

[jira] [Commented] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937206#comment-16937206 ] Julian Hyde commented on CALCITE-3368: -- Please change the description so that it makes sense to

[jira] [Created] (CALCITE-3370) Emulate NULL direction for MSSQL

2019-09-24 Thread Justin Swett (Jira)
Justin Swett created CALCITE-3370: - Summary: Emulate NULL direction for MSSQL Key: CALCITE-3370 URL: https://issues.apache.org/jira/browse/CALCITE-3370 Project: Calcite Issue Type: Task

[jira] [Assigned] (CALCITE-3369) In LatticeSuggester, recommend lattices based on UNION queries

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3369: Assignee: Julian Hyde > In LatticeSuggester, recommend lattices based on UNION queries

[jira] [Updated] (CALCITE-3369) In LatticeSuggester, recommend lattices based on UNION queries

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3369: - Fix Version/s: 1.22.0 > In LatticeSuggester, recommend lattices based on UNION queries >

[jira] [Created] (CALCITE-3369) In LatticeSuggester, recommend lattices based on UNION queries

2019-09-24 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-3369: Summary: In LatticeSuggester, recommend lattices based on UNION queries Key: CALCITE-3369 URL: https://issues.apache.org/jira/browse/CALCITE-3369 Project: Calcite

[jira] [Resolved] (CALCITE-3365) Don't require use of JdbcSchema in QuerySqlStatisticProvider

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3365. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3340) Make TUMBLE be accepted as an operand for "FROM TABLE()" in validator

2019-09-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937076#comment-16937076 ] Rui Wang commented on CALCITE-3340: --- I see. OK, so I will try more ideas to see if I can keep both

[jira] [Commented] (CALCITE-3365) Don't require use of JdbcSchema in QuerySqlStatisticProvider

2019-09-24 Thread Lindsey Meyer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937068#comment-16937068 ] Lindsey Meyer commented on CALCITE-3365: Looks good to me, thank you [~julianhyde]!! > Don't

[jira] [Commented] (CALCITE-3340) Make TUMBLE be accepted as an operand for "FROM TABLE()" in validator

2019-09-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937060#comment-16937060 ] Julian Hyde commented on CALCITE-3340: -- I really don't know. > Make TUMBLE be accepted as an

[jira] [Comment Edited] (CALCITE-3340) Make TUMBLE be accepted as an operand for "FROM TABLE()" in validator

2019-09-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937044#comment-16937044 ] Rui Wang edited comment on CALCITE-3340 at 9/24/19 5:49 PM: I can see many

[jira] [Comment Edited] (CALCITE-3340) Make TUMBLE be accepted as an operand for "FROM TABLE()" in validator

2019-09-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937044#comment-16937044 ] Rui Wang edited comment on CALCITE-3340 at 9/24/19 5:45 PM: I can see many

[jira] [Commented] (CALCITE-3340) Make TUMBLE be accepted as an operand for "FROM TABLE()" in validator

2019-09-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16937044#comment-16937044 ] Rui Wang commented on CALCITE-3340: --- I can see many of the functions are coded into parser (e.g.

[jira] [Updated] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonard Xu updated CALCITE-3368: Description: I found that Calcite's simplification logic of isNull expression will convert 

[jira] [Created] (CALCITE-3368) Nonequivalent simplification happens in RexSimplify

2019-09-24 Thread Leonard Xu (Jira)
Leonard Xu created CALCITE-3368: --- Summary: Nonequivalent simplification happens in RexSimplify Key: CALCITE-3368 URL: https://issues.apache.org/jira/browse/CALCITE-3368 Project: Calcite Issue

[jira] [Resolved] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

2019-09-24 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3159. - Assignee: Danny Chan (was: Julian Hyde) Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

2019-09-24 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3159: Fix Version/s: 1.21.0 > Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions >

[jira] [Updated] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

2019-09-24 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3159: Affects Version/s: 1.20.0 > Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate

[jira] [Commented] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

2019-09-24 Thread Kurt Young (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16936517#comment-16936517 ] Kurt Young commented on CALCITE-3159: - Seems this issue had been fixed in 1.21.0, could you please

[jira] [Resolved] (CALCITE-3239) Calc#accept(RexShuttle shuttle) does not update rowType

2019-09-24 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3239. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-24 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3367: -- Description: This Jira proposes to add AntiJoinRule to convert project-filter-join-aggregate into

[jira] [Updated] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-24 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3367: -- Description: This Jira proposes to add AntiJoinRule to convert project-filter-join-aggregate into