[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Jesus Camacho Rodriguez (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16550032#comment-16550032 ] Jesus Camacho Rodriguez commented on CALCITE-2421: -- [~laurentgo], I did not mean to

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549986#comment-16549986 ] Julian Hyde commented on CALCITE-2421: -- I think you should add a parameter to simplifyList only if

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549975#comment-16549975 ] Laurent Goujon commented on CALCITE-2421: - I don't mind adding a parameter to

[jira] [Comment Edited] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549975#comment-16549975 ] Laurent Goujon edited comment on CALCITE-2421 at 7/19/18 10:54 PM: --- I

[jira] [Comment Edited] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Jesus Camacho Rodriguez (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549967#comment-16549967 ] Jesus Camacho Rodriguez edited comment on CALCITE-2421 at 7/19/18 10:48 PM:

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Jesus Camacho Rodriguez (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549967#comment-16549967 ] Jesus Camacho Rodriguez commented on CALCITE-2421: -- I believe moving the

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549963#comment-16549963 ] Julian Hyde commented on CALCITE-2421: -- [~kgyrtkirk], Thanks for chiming in. If [~laurentgo]'s

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Zoltan Haindrich (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549955#comment-16549955 ] Zoltan Haindrich commented on CALCITE-2421: --- I think I understand - and I agree; I've one

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549945#comment-16549945 ] Laurent Goujon commented on CALCITE-2421: - Here's a pull request:

[jira] [Assigned] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon reassigned CALCITE-2421: --- Assignee: Laurent Goujon (was: Julian Hyde) > RexSimplify#simplifyAnds foregoes

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549941#comment-16549941 ] Laurent Goujon commented on CALCITE-2421: - No worries, I am in the same boat: also spent a lot

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549935#comment-16549935 ] Julian Hyde commented on CALCITE-2421: -- Sorry, I was wrong. I don't know what I was thinking. As

[jira] [Updated] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon updated CALCITE-2421: Description: It looks like {{RexSimplify#simplifyAnds}} foregoes some comparison

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549930#comment-16549930 ] Laurent Goujon commented on CALCITE-2421: - Note that Calcite already simplify {{A = A}} into

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549926#comment-16549926 ] Laurent Goujon commented on CALCITE-2421: - why is it an incorrect simplification if NULL is

[jira] [Commented] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549907#comment-16549907 ] Julian Hyde commented on CALCITE-2421: -- If it simplifies "A=A and B=B" to "A is not null and B is

[jira] [Created] (CALCITE-2421) RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true

2018-07-19 Thread Laurent Goujon (JIRA)
Laurent Goujon created CALCITE-2421: --- Summary: RexSimplify#simplifyAnds foregoes some simplications if unknownAsFalse set to true Key: CALCITE-2421 URL: https://issues.apache.org/jira/browse/CALCITE-2421

[jira] [Commented] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549832#comment-16549832 ] Julian Hyde commented on CALCITE-2395: -- The meta answer is that you need to think of similar

[jira] [Commented] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

2018-07-19 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549816#comment-16549816 ] Enrico Olivelli commented on CALCITE-2395: -- I am worrying about the validator: how can I

[jira] [Commented] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549780#comment-16549780 ] Julian Hyde commented on CALCITE-2395: -- Can we defer that decision, until we know what people

[jira] [Commented] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

2018-07-19 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549688#comment-16549688 ] Enrico Olivelli commented on CALCITE-2395: -- Should be consider that the list of identifiers is

[jira] [Commented] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

2018-07-19 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549630#comment-16549630 ] Julian Hyde commented on CALCITE-2395: -- IBM DB2 also has an [update

[jira] [Commented] (CALCITE-2117) IllegalStateException when accessing data with type MAP ARRAY

2018-07-19 Thread Valerii Florov (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549460#comment-16549460 ] Valerii Florov commented on CALCITE-2117: - Hello Janislav This issue may be resolved at least

[jira] [Commented] (CALCITE-2395) Support SELECT xxx FROM TABLE FOR UPDATE syntax

2018-07-19 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16549397#comment-16549397 ] Enrico Olivelli commented on CALCITE-2395: -- Except from SQL92 standard I cannot find any

[jira] [Commented] (CALCITE-2420) Aggregate functions MIN/MAX does not work for Timestamp

2018-07-19 Thread Piotr Bojko (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16548939#comment-16548939 ] Piotr Bojko commented on CALCITE-2420: -- Thx, after changing to SqlType and switching to Long at