[jira] [Commented] (CALCITE-3318) Preserving CAST of STRING operands in comparison operator

2019-09-13 Thread Soma Mondal (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929094#comment-16929094 ] Soma Mondal commented on CALCITE-3318: -- Hi [~danny0405], After going through the code changes for

[jira] [Updated] (CALCITE-2959) Support collation on struct fields

2019-09-13 Thread Ruben Quesada Lopez (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-2959: - Description: Currently, the class {{RelFieldCollation}} is used to define

[jira] [Closed] (CALCITE-3342) SqlToRelConverter adds extra fields with order by

2019-09-13 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-3342. Resolution: Won't Fix thanks i'll look there > SqlToRelConverter adds extra fields with order

[jira] [Assigned] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3344: Assignee: Julian Hyde > In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and

[jira] [Updated] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3344: - Description: In JDBC adapter, generate "SELECT TOP(n)" for Microsoft SQL Server (MSSQL) 2008

[jira] [Created] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier

2019-09-13 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-3344: Summary: In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier Key: CALCITE-3344 URL: https://issues.apache.org/jira/browse/CALCITE-3344 Project:

[jira] [Updated] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3344: - Description: In JDBC adapter, generate "SELECT TOP\(n)" for Microsoft SQL Server (MSSQL) 2008

[jira] [Commented] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929668#comment-16929668 ] Julian Hyde commented on CALCITE-3344: -- Do any versions of Sybase ASE support FETCH? > In JDBC

[jira] [Commented] (CALCITE-3344) In JDBC adapter, generate "SELECT TOP(n)" for MSSQL 2008 and earlier

2019-09-13 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929666#comment-16929666 ] Jess Balint commented on CALCITE-3344: -- this will also improve compatibility with Sybase ASE which

[jira] [Resolved] (CALCITE-2166) Cumulative cost of RelSubset.best RelNode is increased after calling RelSubset.propagateCostImprovements() for input RelNodes

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

[jira] [Commented] (CALCITE-3343) Improve LogicalTableFunctionScan to match table function windowing

2019-09-13 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929434#comment-16929434 ] Rui Wang commented on CALCITE-3343: --- Also, maybe we just use rexCall to save the signature of table

[jira] [Updated] (CALCITE-3343) Improve LogicalTableFunctionScan to match table function windowing

2019-09-13 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated CALCITE-3343: -- Description:

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

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929597#comment-16929597 ] Julian Hyde commented on CALCITE-3340: -- I think you need new TUMBLE and HOP functions. Is it

[jira] [Commented] (CALCITE-3272) TUMBLE Table Value Function

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929595#comment-16929595 ] Julian Hyde commented on CALCITE-3272: -- Let's aim to support the following:{code} SELECT * FROM

[jira] [Commented] (CALCITE-3343) Improve LogicalTableFunctionScan to match table function windowing

2019-09-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16929593#comment-16929593 ] Julian Hyde commented on CALCITE-3343: -- I think adding arguments to {{RexCall}} is a better