[jira] [Commented] (CALCITE-2615) When simplifying NOT-AND-OR, RexSimplify incorrectly applies predicates deduced for operands to the same operands

[ https://issues.apache.org/jira/browse/CALCITE-2615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16653845#comment-16653845 ] Julian Hyde commented on CALCITE-2615: -- May I suggest an alternative approach: put effort into

[jira] [Commented] (CALCITE-2623) Updating unparseCall() in SqlDialect(s) for dialect specifc SqlNode unparsing

[ https://issues.apache.org/jira/browse/CALCITE-2623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654638#comment-16654638 ] KrishnaKant Agrawal commented on CALCITE-2623: -- My Understanding is that all instances of

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Resolved] (CALCITE-2615) When simplifying NOT-AND-OR, RexSimplify incorrectly applies predicates deduced for operands to the same operands

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

[jira] [Created] (CALCITE-2630) Convert SqlInOperator to a IN-Function

pengzhiwei created CALCITE-2630: --- Summary: Convert SqlInOperator to a IN-Function Key: CALCITE-2630 URL: https://issues.apache.org/jira/browse/CALCITE-2630 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to a IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Summary: Convert SqlInOperator to a IN-Expression (was: Convert SqlInOperator to a IN-Function)

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Summary: Convert SqlInOperator to In-Expression (was: Convert SqlInOperator to IN-Expression)

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to a IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Summary: Convert SqlInOperator to IN-Expression (was: Convert SqlInOperator to a IN-Expression)

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Commented] (CALCITE-2625) ROW_NUMBER, RANK generating Invalid SQL

[ https://issues.apache.org/jira/browse/CALCITE-2625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654658#comment-16654658 ] KrishnaKant Agrawal commented on CALCITE-2625: -- Yeah, that flag It is being used only for

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to a IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to a IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Updated] (CALCITE-2625) ROW_NUMBER, RANK generating Invalid SQL

[ https://issues.apache.org/jira/browse/CALCITE-2625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] KrishnaKant Agrawal updated CALCITE-2625: - Summary: ROW_NUMBER, RANK generating Invalid SQL (was: Function Specific Sql

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to a IN-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Updated] (CALCITE-2630) Convert SqlInOperator to In-Expression

[ https://issues.apache.org/jira/browse/CALCITE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-2630: Description: Currently Calcite translate "IN" to "OR" expression when the count of  IN's

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654097#comment-16654097 ] Julian Hyde commented on CALCITE-2441: -- The workaround for CALCITE-1769 added in order to fix

[jira] [Comment Edited] (CALCITE-2619) Reduce string literal creation cost by removing charset check

[ https://issues.apache.org/jira/browse/CALCITE-2619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16652404#comment-16652404 ] Daniel Lemire edited comment on CALCITE-2619 at 10/17/18 7:43 PM: -- As

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654177#comment-16654177 ] Julian Hyde commented on CALCITE-2441: -- I'm working on this right now. I'm wrestling with the

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654328#comment-16654328 ] Julian Hyde commented on CALCITE-2441: -- The problem is "quite a lot of context". If we make

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654348#comment-16654348 ] Julian Hyde commented on CALCITE-2441: -- Even if it does, I'm not sure we should make RelBuilder

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654367#comment-16654367 ] Julian Hyde commented on CALCITE-2441: -- The problem is in requiring RelBuilder (which has a simple

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654505#comment-16654505 ] Julian Hyde commented on CALCITE-2441: -- I don't know. You're talking about requirements, I'm

[jira] [Commented] (CALCITE-2629) Unnecessary call to CatalogReader#getAllSchemaObjects in CatalogScope

[ https://issues.apache.org/jira/browse/CALCITE-2629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654404#comment-16654404 ] Laurent Goujon commented on CALCITE-2629: - let me give it a try. Meanwhile, I posted a PR:

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654324#comment-16654324 ] Andrei Sereda commented on CALCITE-2441: {quote} Should RelBuilder be able to expand views?

[jira] [Commented] (CALCITE-2629) Unnecessary call to CatalogReader#getAllSchemaObjects in CatalogScope

[ https://issues.apache.org/jira/browse/CALCITE-2629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654326#comment-16654326 ] Julian Hyde commented on CALCITE-2629: -- It seems that the {{schemaNames}} field was used until

[jira] [Commented] (CALCITE-2619) Reduce string literal creation cost by removing charset check

[ https://issues.apache.org/jira/browse/CALCITE-2619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654385#comment-16654385 ] Julian Hyde commented on CALCITE-2619: -- It's very possible that the "payload" of an NlsString

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654446#comment-16654446 ] Andrei Sereda commented on CALCITE-2441: I understand your argument, but what to do with cases

[jira] [Resolved] (CALCITE-1413) New CASE statement simplification

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

[jira] [Comment Edited] (CALCITE-1413) New CASE statement simplification

[ https://issues.apache.org/jira/browse/CALCITE-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654156#comment-16654156 ] Jesus Camacho Rodriguez edited comment on CALCITE-1413 at 10/17/18 8:33 PM:

[jira] [Commented] (CALCITE-1413) New CASE statement simplification

[ https://issues.apache.org/jira/browse/CALCITE-1413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654156#comment-16654156 ] Jesus Camacho Rodriguez commented on CALCITE-1413: -- Fixed in

[jira] [Resolved] (CALCITE-2620) Simplify "coalesce(null,x)" to "x"

[ https://issues.apache.org/jira/browse/CALCITE-2620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-2620. -- Resolution: Fixed Assignee: pengzhiwei (was: Julian

[jira] [Created] (CALCITE-2629) Unnecessary call to CatalogReader#getAllSchemaObjects in CatalogScope

Laurent Goujon created CALCITE-2629: --- Summary: Unnecessary call to CatalogReader#getAllSchemaObjects in CatalogScope Key: CALCITE-2629 URL: https://issues.apache.org/jira/browse/CALCITE-2629

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654333#comment-16654333 ] Andrei Sereda commented on CALCITE-2441: {{FrameworkConfig}} doesn't have enough context ? >

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

[ https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16654365#comment-16654365 ] Andrei Sereda commented on CALCITE-2441: Technically it already "depends" on