[jira] [Commented] (CALCITE-2353) Allow user to override SqlSetOption in alterStatementParserMethods

2018-06-05 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16502770#comment-16502770 ] Andrew Pilloud commented on CALCITE-2353: - That is what I intended. I opened a PR that does

[jira] [Created] (CALCITE-2353) Allow user to override SqlSetOption in alterStatementParserMethods

2018-06-05 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2353: --- Summary: Allow user to override SqlSetOption in alterStatementParserMethods Key: CALCITE-2353 URL: https://issues.apache.org/jira/browse/CALCITE-2353 Project:

[jira] [Created] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-14 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2177: --- Summary: TUMBLE_START does not respect AS when SELECT and GROUP BY match Key: CALCITE-2177 URL: https://issues.apache.org/jira/browse/CALCITE-2177 Project:

[jira] [Updated] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-15 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud updated CALCITE-2177: Affects Version/s: 1.15.0 > TUMBLE_START does not respect AS when SELECT and GROUP BY

[jira] [Updated] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-15 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud updated CALCITE-2177: Fix Version/s: 1.15.0 > TUMBLE_START does not respect AS when SELECT and GROUP BY match >

[jira] [Commented] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-15 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16366380#comment-16366380 ] Andrew Pilloud commented on CALCITE-2177: - This is fixed in 1.15.0, should have updated first!

[jira] [Updated] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-15 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud updated CALCITE-2177: Affects Version/s: (was: 1.15.0) > TUMBLE_START does not respect AS when SELECT and

[jira] [Closed] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-15 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud closed CALCITE-2177. --- Resolution: Fixed > TUMBLE_START does not respect AS when SELECT and GROUP BY match >

[jira] [Created] (CALCITE-2529) linq4j should promote integer to floating point when generating function calls

2018-09-04 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2529: --- Summary: linq4j should promote integer to floating point when generating function calls Key: CALCITE-2529 URL: https://issues.apache.org/jira/browse/CALCITE-2529

[jira] [Commented] (CALCITE-2529) linq4j should promote integer to floating point when generating function calls

2018-09-04 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16603633#comment-16603633 ] Andrew Pilloud commented on CALCITE-2529: - Proposed fix is here: 

[jira] [Commented] (CALCITE-2394) Avatica applies calendar offset to timestamps when they should remain unchanged

2018-07-10 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16539259#comment-16539259 ] Andrew Pilloud commented on CALCITE-2394: - Looks like there is a config option in 

[jira] [Closed] (CALCITE-2248) Take advantage of Calcite DDL

2018-04-10 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud closed CALCITE-2248. --- Resolution: Invalid > Take advantage of Calcite DDL > - > >

[jira] [Created] (CALCITE-2248) Take advantage of Calcite DDL

2018-04-10 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2248: --- Summary: Take advantage of Calcite DDL Key: CALCITE-2248 URL: https://issues.apache.org/jira/browse/CALCITE-2248 Project: Calcite Issue Type: New

[jira] [Updated] (CALCITE-2248) Take advantage of Calcite DDL

2018-04-10 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud updated CALCITE-2248: Oops, wrong project. > Take advantage of Calcite DDL > - > >

[jira] [Commented] (CALCITE-2529) linq4j should promote integer to floating point when generating function calls

2018-10-04 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16638771#comment-16638771 ] Andrew Pilloud commented on CALCITE-2529: - Thanks for taking a look, I've cleaned up the code

[jira] [Created] (CALCITE-2612) Cassandra tests fork and crash maven in Java 1.8

2018-10-04 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2612: --- Summary: Cassandra tests fork and crash maven in Java 1.8 Key: CALCITE-2612 URL: https://issues.apache.org/jira/browse/CALCITE-2612 Project: Calcite

[jira] [Commented] (CALCITE-2529) linq4j should promote integer to floating point when generating function calls

2018-10-03 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16637478#comment-16637478 ] Andrew Pilloud commented on CALCITE-2529: - Hi Julian, are you the best person to review this or

[jira] [Commented] (CALCITE-2572) Calcite substring fails with a start position less than 1.

2018-09-19 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16621287#comment-16621287 ] Andrew Pilloud commented on CALCITE-2572: - I have updated the code to more closely match the

[jira] [Commented] (CALCITE-2571) TRIM does not match the behavior of most SQL implementations

2018-09-20 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16622806#comment-16622806 ] Andrew Pilloud commented on CALCITE-2571: - I rewrote the patch to only enable extended trim in

[jira] [Commented] (CALCITE-2571) TRIM does not match the behavior of most SQL implementations

2018-09-21 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16624205#comment-16624205 ] Andrew Pilloud commented on CALCITE-2571: - I couldn't figure out how to get at SqlConformance

[jira] [Created] (CALCITE-2571) TRIM does not match the behavior of most SQL implementations

2018-09-19 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2571: --- Summary: TRIM does not match the behavior of most SQL implementations Key: CALCITE-2571 URL: https://issues.apache.org/jira/browse/CALCITE-2571 Project:

[jira] [Commented] (CALCITE-2571) TRIM does not match the behavior of most SQL implementations

2018-09-19 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16620983#comment-16620983 ] Andrew Pilloud commented on CALCITE-2571: - Proposed fix:

[jira] [Created] (CALCITE-2572) Calcite substring fails with a start position less than 1.

2018-09-19 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2572: --- Summary: Calcite substring fails with a start position less than 1. Key: CALCITE-2572 URL: https://issues.apache.org/jira/browse/CALCITE-2572 Project: Calcite

[jira] [Commented] (CALCITE-2572) Calcite substring fails with a start position less than 1.

2018-09-19 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16621014#comment-16621014 ] Andrew Pilloud commented on CALCITE-2572: - Proposed fix:

[jira] [Commented] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

2018-11-27 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701121#comment-16701121 ] Andrew Pilloud commented on CALCITE-2710: - Yes, I see that now. (Passing UDFs time in local

[jira] [Closed] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

2018-11-27 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud closed CALCITE-2710. --- Resolution: Invalid > Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

[jira] [Created] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

2018-11-26 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2710: --- Summary: Some SqlFunctions use LOCAL_TZ constant instead of using timeZone() Key: CALCITE-2710 URL: https://issues.apache.org/jira/browse/CALCITE-2710 Project:

[jira] [Commented] (CALCITE-2710) Some SqlFunctions use LOCAL_TZ constant instead of using timeZone()

2018-11-26 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16699679#comment-16699679 ] Andrew Pilloud commented on CALCITE-2710: - I think this is just a plumbing issue, I plan to

[jira] [Created] (CALCITE-2783) Null checks incorrectly optimized by RexSimplfy.simplifyBooleanCase.

2019-01-10 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2783: --- Summary: Null checks incorrectly optimized by RexSimplfy.simplifyBooleanCase. Key: CALCITE-2783 URL: https://issues.apache.org/jira/browse/CALCITE-2783

[jira] [Closed] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-05-09 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud closed CALCITE-3040. --- > Avatica drops exception messages starting in 1.14.0 >

[jira] [Commented] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-05-09 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836502#comment-16836502 ] Andrew Pilloud commented on CALCITE-3040: - Verified with all the clients. > Avatica drops

[jira] [Created] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-04-30 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-3040: --- Summary: Avatica drops exception messages starting in 1.14.0 Key: CALCITE-3040 URL: https://issues.apache.org/jira/browse/CALCITE-3040 Project: Calcite

[jira] [Commented] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-04-30 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16830670#comment-16830670 ] Andrew Pilloud commented on CALCITE-3040: - This is not a SQLLine specific issue. It occurs with

[jira] [Commented] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-04-30 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16830674#comment-16830674 ] Andrew Pilloud commented on CALCITE-3040: - SQuirreL SQL before:   {code:java} Error: Error

[jira] [Updated] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-04-30 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Pilloud updated CALCITE-3040: Environment: Beam 2.13.0-SNAPSHOT Avatica 1.14.0

[jira] [Commented] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-05-01 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16831091#comment-16831091 ] Andrew Pilloud commented on CALCITE-3040: - Thanks for turning this around so quickly! Sorry I

[jira] [Commented] (CALCITE-3040) Avatica drops exception messages starting in 1.14.0

2019-05-01 Thread Andrew Pilloud (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16831089#comment-16831089 ] Andrew Pilloud commented on CALCITE-3040: - Our tests are replicating the behavior of common

[jira] [Commented] (CALCITE-3472) SESSION_END returns same value as SESSION_START

2019-11-04 Thread Andrew Pilloud (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16966865#comment-16966865 ] Andrew Pilloud commented on CALCITE-3472: - [~amaliujia] wrote a nice description of this

[jira] [Created] (CALCITE-3714) BitString.createFromBytes reverses order of the bits in each byte

2020-01-06 Thread Andrew Pilloud (Jira)
Andrew Pilloud created CALCITE-3714: --- Summary: BitString.createFromBytes reverses order of the bits in each byte Key: CALCITE-3714 URL: https://issues.apache.org/jira/browse/CALCITE-3714 Project:

[jira] [Commented] (CALCITE-4051) SESSION TVF Optimizations

2020-06-08 Thread Andrew Pilloud (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17128725#comment-17128725 ] Andrew Pilloud commented on CALCITE-4051: - Did you mean to file this on Beam? > SESSION TVF

[jira] [Commented] (CALCITE-4408) Implement Oracle SUBSTR function

2020-11-24 Thread Andrew Pilloud (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17238393#comment-17238393 ] Andrew Pilloud commented on CALCITE-4408: - I believe CALCITE-2572 was implemented to the

[jira] [Created] (CALCITE-4759) JoinPushThroughJoinRule does not match two joins

2021-08-30 Thread Andrew Pilloud (Jira)
Andrew Pilloud created CALCITE-4759: --- Summary: JoinPushThroughJoinRule does not match two joins Key: CALCITE-4759 URL: https://issues.apache.org/jira/browse/CALCITE-4759 Project: Calcite

[jira] [Commented] (CALCITE-5553) Calcite RelStructuredTypeFlattener produces bad plan for single field structs

2023-03-06 Thread Andrew Pilloud (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697172#comment-17697172 ] Andrew Pilloud commented on CALCITE-5553: - I think I have a workable fix now, which involves

[jira] [Created] (CALCITE-5553) Calcite RelStructuredTypeFlattener produces bad plan for single field structs

2023-03-02 Thread Andrew Pilloud (Jira)
Andrew Pilloud created CALCITE-5553: --- Summary: Calcite RelStructuredTypeFlattener produces bad plan for single field structs Key: CALCITE-5553 URL: https://issues.apache.org/jira/browse/CALCITE-5553