[jira] [Commented] (CALCITE-1582) RelToSqlConverter doesn't handle cartesian join (no join cond)

2017-01-23 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15834736#comment-15834736 ] Jess Balint commented on CALCITE-1582: -- PR submitted > RelToSqlConverter doesn't handle cartesian

[jira] [Commented] (CALCITE-1595) NPE in SqlTypeUtil

2017-01-26 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15840089#comment-15840089 ] Jess Balint commented on CALCITE-1595: -- Thanks Julian. Looks like a minor inconsistency in the

[jira] (CALCITE-1611) RelToSqlConverter not handling table alias reference correctly

2017-01-30 Thread Jess Balint (JIRA)
Title: Message Title Jess Balint commented on CALCITE-1611

[jira] (CALCITE-1611) RelToSqlConverter not handling table alias reference correctly

2017-01-30 Thread Jess Balint (JIRA)
Title: Message Title Jess Balint updated an issue

[jira] [Created] (CALCITE-1611) RelToSqlConverter not handling table alias reference correctly

2017-01-27 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1611: Summary: RelToSqlConverter not handling table alias reference correctly Key: CALCITE-1611 URL: https://issues.apache.org/jira/browse/CALCITE-1611 Project: Calcite

[jira] [Created] (CALCITE-1610) RelBuilder sort-combining optimization treats aliases incorrectly

2017-01-27 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1610: Summary: RelBuilder sort-combining optimization treats aliases incorrectly Key: CALCITE-1610 URL: https://issues.apache.org/jira/browse/CALCITE-1610 Project: Calcite

[jira] (CALCITE-1614) Add Lex.POSTGRESQL

2017-01-29 Thread Jess Balint (JIRA)
Title: Message Title Jess Balint created an issue

[jira] [Commented] (CALCITE-1595) NPE in SqlTypeUtil

2017-01-20 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15832460#comment-15832460 ] Jess Balint commented on CALCITE-1595: -- Thanks. I'll look for a way to validate it there. > NPE in

[jira] [Created] (CALCITE-1638) Simplify $x=$x to true

2017-02-15 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1638: Summary: Simplify $x=$x to true Key: CALCITE-1638 URL: https://issues.apache.org/jira/browse/CALCITE-1638 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-1636) JDBC adapter generates wrong SQL for self join with sub-query

2017-02-19 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15873748#comment-15873748 ] Jess Balint commented on CALCITE-1636: -- Fixed in

[jira] [Commented] (CALCITE-1625) add basic JDBC statistics

2017-02-09 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15860078#comment-15860078 ] Jess Balint commented on CALCITE-1625: -- I am talking about getting _primary_ keys and table

[jira] [Created] (CALCITE-1631) RelMdUniqueKeys doesn't handle TableScan

2017-02-13 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1631: Summary: RelMdUniqueKeys doesn't handle TableScan Key: CALCITE-1631 URL: https://issues.apache.org/jira/browse/CALCITE-1631 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-1631) RelMdUniqueKeys doesn't handle TableScan

2017-02-13 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15864705#comment-15864705 ] Jess Balint commented on CALCITE-1631: -- why not create an interface method {{getUniqueKeys()}} on

[jira] [Created] (CALCITE-1627) Statistics.of() instance doesn't acknowledge super sets of keys

2017-02-09 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1627: Summary: Statistics.of() instance doesn't acknowledge super sets of keys Key: CALCITE-1627 URL: https://issues.apache.org/jira/browse/CALCITE-1627 Project: Calcite

[jira] [Commented] (CALCITE-1625) add basic JDBC statistics

2017-02-09 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15859970#comment-15859970 ] Jess Balint commented on CALCITE-1625: -- I'm primarily interested in adding statistics under

[jira] [Commented] (CALCITE-1636) JDBC adapter generates wrong SQL when selft join with subquery when DB2 dialect used

2017-02-15 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15868015#comment-15868015 ] Jess Balint commented on CALCITE-1636: -- This is not specific to DB2. The problem is with references

[jira] [Commented] (CALCITE-1627) Statistics.of() instance doesn't acknowledge super sets of keys

2017-02-09 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15859904#comment-15859904 ] Jess Balint commented on CALCITE-1627: -- It appears that I read it wrong. My bad. You can close

[jira] [Commented] (CALCITE-1625) add basic JDBC statistics

2017-02-09 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1586#comment-1586 ] Jess Balint commented on CALCITE-1625: -- It is certainly related. I can push up the patch I have

[jira] [Created] (CALCITE-1640) SqlImplementor (RelToSql) doesn't handle join cond same as filter

2017-02-16 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1640: Summary: SqlImplementor (RelToSql) doesn't handle join cond same as filter Key: CALCITE-1640 URL: https://issues.apache.org/jira/browse/CALCITE-1640 Project: Calcite

[jira] [Updated] (CALCITE-1582) RelToSqlConverter doesn't handle cartesian join (no join cond)

2017-01-17 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1582: - Priority: Minor (was: Major) > RelToSqlConverter doesn't handle cartesian join (no join cond)

[jira] [Created] (CALCITE-1582) RelToSqlConverter doesn't handle cartesian join (no join cond)

2017-01-17 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1582: Summary: RelToSqlConverter doesn't handle cartesian join (no join cond) Key: CALCITE-1582 URL: https://issues.apache.org/jira/browse/CALCITE-1582 Project: Calcite

[jira] [Created] (CALCITE-1585) SqlPrettyWriter doesn't respect alwaysUseParentheses

2017-01-17 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1585: Summary: SqlPrettyWriter doesn't respect alwaysUseParentheses Key: CALCITE-1585 URL: https://issues.apache.org/jira/browse/CALCITE-1585 Project: Calcite

[jira] [Updated] (CALCITE-1585) SqlPrettyWriter doesn't respect alwaysUseParentheses

2017-01-17 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1585: - Affects Version/s: 1.11.0 > SqlPrettyWriter doesn't respect alwaysUseParentheses >

[jira] [Created] (CALCITE-1584) ProjectRemoveRule loses field names

2017-01-17 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1584: Summary: ProjectRemoveRule loses field names Key: CALCITE-1584 URL: https://issues.apache.org/jira/browse/CALCITE-1584 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-1584) ProjectRemoveRule loses field names

2017-01-18 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828731#comment-15828731 ] Jess Balint commented on CALCITE-1584: -- hey Julian, This is the same issue I brought up on the

[jira] [Updated] (CALCITE-1595) NPE in SqlTypeUtil

2017-01-20 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1595: - Description: I have some RelBuilder code building an expression something like {{\+(\+($0,

[jira] [Created] (CALCITE-1595) NPE in SqlTypeUtil

2017-01-20 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1595: Summary: NPE in SqlTypeUtil Key: CALCITE-1595 URL: https://issues.apache.org/jira/browse/CALCITE-1595 Project: Calcite Issue Type: Bug Components:

[jira] [Created] (CALCITE-1522) RelBuilder.union() hits assertion when arguments can't have a common row type

2016-12-01 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1522: Summary: RelBuilder.union() hits assertion when arguments can't have a common row type Key: CALCITE-1522 URL: https://issues.apache.org/jira/browse/CALCITE-1522

[jira] [Created] (CALCITE-1523) Add RelBuilder field() method to reference aliased relations not on top of stack

2016-12-01 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1523: Summary: Add RelBuilder field() method to reference aliased relations not on top of stack Key: CALCITE-1523 URL: https://issues.apache.org/jira/browse/CALCITE-1523

[jira] [Commented] (CALCITE-1523) Add RelBuilder field() method to reference aliased relations not on top of stack

2016-12-01 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15713502#comment-15713502 ] Jess Balint commented on CALCITE-1523: -- I don't see anything preventing conflicting alias names.

[jira] [Commented] (CALCITE-1551) RelBuilder's project() doesn't preserve alias

2016-12-29 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15785642#comment-15785642 ] Jess Balint commented on CALCITE-1551: -- bq. Pig requires that the name of the aggregate is

[jira] [Commented] (CALCITE-1551) RelBuilder's project() doesn't preserve alias

2016-12-27 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15780830#comment-15780830 ] Jess Balint commented on CALCITE-1551: -- Thanks. PR opened > RelBuilder's project() doesn't

[jira] [Commented] (CALCITE-1551) RelBuilder's project() doesn't preserve alias

2016-12-22 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15770365#comment-15770365 ] Jess Balint commented on CALCITE-1551: -- The difficulty that I'm facing is that it's not clear how

[jira] [Commented] (CALCITE-1551) RelBuilder's project() doesn't preserve alias

2016-12-22 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15770717#comment-15770717 ] Jess Balint commented on CALCITE-1551: -- you said: bq. at point 2 and point 3 there are two tables

[jira] [Commented] (CALCITE-1556) Window validation bug with order by agg

2017-03-30 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15949775#comment-15949775 ] Jess Balint commented on CALCITE-1556: -- Would this still not return 1 for every rank? > Window

[jira] [Updated] (CALCITE-1665) Aggregates and HAVING cannot be combined

2017-03-09 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1665: - Priority: Minor (was: Major) > Aggregates and HAVING cannot be combined >

[jira] [Updated] (CALCITE-1665) HAVING support in RelToSqlConverter

2017-03-09 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1665: - Summary: HAVING support in RelToSqlConverter (was: Aggregates and HAVING cannot be combined)

[jira] [Commented] (CALCITE-1665) HAVING support in RelToSqlConverter

2017-03-10 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15905162#comment-15905162 ] Jess Balint commented on CALCITE-1665: -- Fixed in

[jira] [Resolved] (CALCITE-1665) HAVING support in RelToSqlConverter

2017-03-10 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-1665. -- Resolution: Fixed > HAVING support in RelToSqlConverter > ---

[jira] [Commented] (CALCITE-1665) Aggregates and HAVING cannot be combined

2017-03-06 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15897769#comment-15897769 ] Jess Balint commented on CALCITE-1665: -- Thanks Zhiqiang He. I will review it. > Aggregates and

[jira] [Commented] (CALCITE-1665) Aggregates and HAVING cannot be combined

2017-03-01 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15891102#comment-15891102 ] Jess Balint commented on CALCITE-1665: -- The plan tree is probably a Filter with an Aggregate child.

[jira] [Commented] (CALCITE-1913) Include DB version in SqlDialect

2017-08-01 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16109704#comment-16109704 ] Jess Balint commented on CALCITE-1913: -- People may choose not to use a feature if it's buggy? This

[jira] [Created] (CALCITE-1891) NPE in RelBuilder.values() if types are not coercible

2017-07-14 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1891: Summary: NPE in RelBuilder.values() if types are not coercible Key: CALCITE-1891 URL: https://issues.apache.org/jira/browse/CALCITE-1891 Project: Calcite

[jira] [Commented] (CALCITE-1841) Create handlers for Jdbc dialect specific generated sql

2017-07-03 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16072936#comment-16072936 ] Jess Balint commented on CALCITE-1841: -- I would much prefer to have all DB-specific translations

[jira] [Created] (CALCITE-1869) NPE validating unbounded window functions

2017-07-03 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1869: Summary: NPE validating unbounded window functions Key: CALCITE-1869 URL: https://issues.apache.org/jira/browse/CALCITE-1869 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-1913) Include DB version in SqlDialect

2017-08-01 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1913: Summary: Include DB version in SqlDialect Key: CALCITE-1913 URL: https://issues.apache.org/jira/browse/CALCITE-1913 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-1913) Include DB version in SqlDialect

2017-08-01 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1913: - Priority: Minor (was: Major) > Include DB version in SqlDialect >

[jira] [Commented] (CALCITE-1913) Include DB version in SqlDialect

2017-08-01 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16109555#comment-16109555 ] Jess Balint commented on CALCITE-1913: -- You could argue the same for exposing the DB product from

[jira] [Commented] (CALCITE-1913) Include DB version in SqlDialect

2017-08-02 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111236#comment-16111236 ] Jess Balint commented on CALCITE-1913: -- What would you suggest at this point? > Include DB version

[jira] [Assigned] (CALCITE-1792) RelToSqlConverter doesn't handle cartesian join (join cond as TRUE)

2017-05-16 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-1792: Assignee: Jess Balint (was: Julian Hyde) > RelToSqlConverter doesn't handle cartesian

[jira] [Commented] (CALCITE-1792) RelToSqlConverter doesn't handle cartesian join (join cond as TRUE)

2017-05-16 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16013207#comment-16013207 ] Jess Balint commented on CALCITE-1792: -- Looks good. Was a small oversight in the original fix.

[jira] [Commented] (CALCITE-1841) Create handlers for Jdbc dialect specific generated sql

2017-06-14 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16049364#comment-16049364 ] Jess Balint commented on CALCITE-1841: -- Why not do this before unparsing by transforming the

[jira] [Updated] (CALCITE-1913) Include DB version in SqlDialect

2017-08-30 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-1913: - Fix Version/s: (was: 1.14.0) > Include DB version in SqlDialect >

[jira] [Commented] (CALCITE-1913) Include DB version in SqlDialect

2017-08-30 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16147964#comment-16147964 ] Jess Balint commented on CALCITE-1913: -- Removed version > Include DB version in SqlDialect >

[jira] [Updated] (CALCITE-782) Mongo Groups missing values

2018-04-11 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-782: Description: If you do something like: {code:sql} select count("collection"."_id") as "m0" ,

[jira] [Updated] (CALCITE-3192) Simplify OR incorrectly weaks condition

2019-07-12 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-3192: - Description: RexSimplify is transforming * {{OR(AND(>(999, $8), =($2, 'Franklin')), <(100,

[jira] [Commented] (CALCITE-3192) Simplify OR incorrectly weaks condition

2019-07-12 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16883918#comment-16883918 ] Jess Balint commented on CALCITE-3192: -- this seems to work but one new test failure arises which I

[jira] [Created] (CALCITE-3192) Simplify OR incorrectly weaks condition

2019-07-12 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-3192: Summary: Simplify OR incorrectly weaks condition Key: CALCITE-3192 URL: https://issues.apache.org/jira/browse/CALCITE-3192 Project: Calcite Issue Type: Bug

[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] [Created] (CALCITE-3342) sqltorelconverter adds extra fields with order by

2019-09-12 Thread Jess Balint (Jira)
Jess Balint created CALCITE-3342: Summary: sqltorelconverter adds extra fields with order by Key: CALCITE-3342 URL: https://issues.apache.org/jira/browse/CALCITE-3342 Project: Calcite Issue

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

2019-09-12 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-3342: - Summary: SqlToRelConverter adds extra fields with order by (was: sqltorelconverter adds extra

[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] [Updated] (CALCITE-3489) Cast to interval is ignored

2019-11-11 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-3489: - Summary: Cast to interval is ignored (was: Adding day interval to timestamp returns incorrect

[jira] [Updated] (CALCITE-3489) Cast to interval is ignored

2019-11-11 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-3489: - Description: -when adding day to timestamp, the day interval is not converted to ms, in the

[jira] [Created] (CALCITE-3489) Adding day interval to timestamp returns incorrect value

2019-11-09 Thread Jess Balint (Jira)
Jess Balint created CALCITE-3489: Summary: Adding day interval to timestamp returns incorrect value Key: CALCITE-3489 URL: https://issues.apache.org/jira/browse/CALCITE-3489 Project: Calcite

[jira] [Created] (CALCITE-3430) JDBC adapter generates extra alias for VALUES when used in join

2019-10-18 Thread Jess Balint (Jira)
Jess Balint created CALCITE-3430: Summary: JDBC adapter generates extra alias for VALUES when used in join Key: CALCITE-3430 URL: https://issues.apache.org/jira/browse/CALCITE-3430 Project: Calcite

[jira] [Updated] (CALCITE-3430) JDBC adapter generates extra alias for VALUES when used in join

2019-10-26 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-3430: - Description: For Postgres and other DBs which support this, the generated SQL is {{(values (1,

[jira] [Created] (CALCITE-3994) RexSimplify reduce concat calls with constant arguments

2020-05-12 Thread Jess Balint (Jira)
Jess Balint created CALCITE-3994: Summary: RexSimplify reduce concat calls with constant arguments Key: CALCITE-3994 URL: https://issues.apache.org/jira/browse/CALCITE-3994 Project: Calcite

[jira] [Commented] (CALCITE-3994) RexSimplify reduce concat calls with constant arguments

2020-05-15 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17108568#comment-17108568 ] Jess Balint commented on CALCITE-3994: -- that fixes it indeed. however it seems inconsistent with

[jira] [Closed] (CALCITE-3994) RexSimplify reduce concat calls with constant arguments

2020-05-18 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-3994. Resolution: Invalid > RexSimplify reduce concat calls with constant arguments >

[jira] [Created] (CALCITE-4245) Expression reduction regression

2020-09-10 Thread Jess Balint (Jira)
Jess Balint created CALCITE-4245: Summary: Expression reduction regression Key: CALCITE-4245 URL: https://issues.apache.org/jira/browse/CALCITE-4245 Project: Calcite Issue Type: Bug

[jira] [Resolved] (CALCITE-4968) Calcite generates invalid MS SQL queries for the query with the LIMIT statement

2022-01-02 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-4968. -- Fix Version/s: 1.30.0 Resolution: Fixed Fixed in 1.30.0:

[jira] [Comment Edited] (CALCITE-5064) Dialect factory returns ANSI SQL dialect for BigQuery

2022-03-27 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513056#comment-17513056 ] Jess Balint edited comment on CALCITE-5064 at 3/27/22, 9:01 PM: Fixed

[jira] [Comment Edited] (CALCITE-5064) Dialect factory returns ANSI SQL dialect for BigQuery

2022-03-27 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513056#comment-17513056 ] Jess Balint edited comment on CALCITE-5064 at 3/27/22, 9:00 PM: Fixed

[jira] [Resolved] (CALCITE-5064) Dialect factory returns ANSI SQL dialect for BigQuery

2022-03-27 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-5064. -- Fix Version/s: 1.31.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5013) JDBC adapter should retain parentheses if a query in a UNION has a LIMIT clause

2022-06-23 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-5013. -- Fix Version/s: 1.31.0 Resolution: Fixed Fixed in 1.31.0 *

[jira] [Commented] (CALCITE-5279) Firebolt does not support BETWEEN ASYMMETRIC

2023-01-05 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17655130#comment-17655130 ] Jess Balint commented on CALCITE-5279: -- {{ASYMMETRIC}} is the default for {{BETWEEN}} in SQL. Can

[jira] [Resolved] (CALCITE-5239) Site: JDBC Adapter's current limitations is incorrect

2022-11-17 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-5239. -- Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5217) Implement unparseSqlIntervalLiteral in the Firebolt dialect

2022-11-29 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-5217. -- Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5259) Add getParameterRowType method to Planner interface

2022-11-29 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint resolved CALCITE-5259. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-4512) GROUP BY expression with argument name same with SELECT field and alias causes validation error

2022-11-30 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint updated CALCITE-4512: - Description: {code:java} String sql = "select replace(name, 'a', 'b') as name from users group

[jira] [Assigned] (CALCITE-5428) Reduce minimum Guava version to 16.0.1

2023-01-25 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-5428: Assignee: Gian Merlino > Reduce minimum Guava version to 16.0.1 >

[jira] [Assigned] (CALCITE-5339) Use Method#getParameterCount rather than Method#getParameters to get length

2023-01-25 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-5339: Assignee: Sergey Nuyanzin > Use Method#getParameterCount rather than

[jira] [Assigned] (CALCITE-4351) RelMdUtil#numDistinctVals always returns 0 for large inputs

2023-01-25 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-4351: Assignee: Liya Fan > RelMdUtil#numDistinctVals always returns 0 for large inputs >

[jira] [Assigned] (CALCITE-5155) Custom time frames

2023-01-25 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-5155: Assignee: Julian Hyde > Custom time frames > -- > >

[jira] [Assigned] (CALCITE-5495) Allow WEEK and QUARTER in INTERVAL literals

2023-01-25 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-5495: Assignee: Tanner Clary > Allow WEEK and QUARTER in INTERVAL literals >

[jira] [Assigned] (CALCITE-5491) Allow TIME and DATE to be args for TIMESTAMPDIFF

2023-01-25 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-5491: Assignee: Tanner Clary > Allow TIME and DATE to be args for TIMESTAMPDIFF >

[jira] [Assigned] (CALCITE-5481) Release Calcite 1.33.0

2023-01-15 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint reassigned CALCITE-5481: Assignee: Jess Balint > Release Calcite 1.33.0 > -- > >

[jira] [Closed] (CALCITE-5481) Release Calcite 1.33.0

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5481. Resolution: Fixed > Release Calcite 1.33.0 > -- > > Key:

[jira] [Closed] (CALCITE-5374) Upgrade jackson version to 2.14.0

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5374. Resolved in release 1.33.0 (2023-02-06) > Upgrade jackson version to 2.14.0 >

[jira] [Closed] (CALCITE-5305) Character literals with C-style escapes

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5305. Resolved in release 1.33.0 (2023-02-06) > Character literals with C-style escapes >

[jira] [Closed] (CALCITE-5430) Implement IFNULL() for BigQuery dialect

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5430. Resolved in release 1.33.0 (2023-02-06) > Implement IFNULL() for BigQuery dialect >

[jira] [Closed] (CALCITE-5475) Improve test coverage accuracy by aggregating modules

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5475. Resolved in release 1.33.0 (2023-02-06) > Improve test coverage accuracy by aggregating modules >

[jira] [Closed] (CALCITE-5265) JDBC adapter sometimes adds unnecessary parentheses around SELECT in INSERT

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5265. Resolved in release 1.33.0 (2023-02-06) > JDBC adapter sometimes adds unnecessary parentheses

[jira] [Closed] (CALCITE-5280) Implement geometry aggregate functions

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5280. Resolved in release 1.33.0 (2023-02-06) > Implement geometry aggregate functions >

[jira] [Closed] (CALCITE-5404) Implement BigQuery's POW() and TRUNC() math functions

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5404. Resolved in release 1.33.0 (2023-02-06) > Implement BigQuery's POW() and TRUNC() math functions >

[jira] [Closed] (CALCITE-4351) RelMdUtil#numDistinctVals always returns 0 for large inputs

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-4351. Resolved in release 1.33.0 (2023-02-06) > RelMdUtil#numDistinctVals always returns 0 for large

[jira] [Closed] (CALCITE-5349) RelJson should support non-standard operators

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5349. Resolved in release 1.33.0 (2023-02-06) > RelJson should support non-standard operators >

[jira] [Closed] (CALCITE-5306) Remove JDK15/16 EOL non-LTS JDKs in CI

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5306. Resolved in release 1.33.0 (2023-02-06) > Remove JDK15/16 EOL non-LTS JDKs in CI >

[jira] [Closed] (CALCITE-5439) Validation of Pivot fails after creating a deep copy of SqlNode

2023-02-07 Thread Jess Balint (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jess Balint closed CALCITE-5439. Resolved in release 1.33.0 (2023-02-06) > Validation of Pivot fails after creating a deep copy of

  1   2   >