[jira] [Updated] (CALCITE-5655) Intermediate table alias should be different to avoid wrong field reference lookup in subquery remove phase

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5655: Summary: Intermediate table alias should be different to avoid wrong field reference lookup in su

[jira] [Updated] (CALCITE-5663) [TestKit] RelOptFixture does not enforce the collation

[ https://issues.apache.org/jira/browse/CALCITE-5663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marieke Gueye updated CALCITE-5663: --- Description: In RelOptFixture, we currently change the traitsets to enforce  EnumerableCon

[jira] [Created] (CALCITE-5663) [TestKit] RelOptFixture does not enforce the collation

Marieke Gueye created CALCITE-5663: -- Summary: [TestKit] RelOptFixture does not enforce the collation Key: CALCITE-5663 URL: https://issues.apache.org/jira/browse/CALCITE-5663 Project: Calcite

[jira] [Resolved] (CALCITE-111) Support CONVERT function, for changing character sets

[ https://issues.apache.org/jira/browse/CALCITE-111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-111. - Resolution: Fixed Fixed in [b2917b33|https://github.com/apache/calcite/commit/b2917b33e8dda434d

[jira] [Comment Edited] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714398#comment-17714398 ] Dan Zou edited comment on CALCITE-5642 at 4/20/23 4:03 AM: --- [

[jira] [Comment Edited] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714398#comment-17714398 ] Dan Zou edited comment on CALCITE-5642 at 4/20/23 3:55 AM: --- [

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714398#comment-17714398 ] Dan Zou commented on CALCITE-5642: -- [~njiang] Thanks for the information, and I found

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714389#comment-17714389 ] Willem Jiang commented on CALCITE-5642: --- [~FrankZou] Please check out [handling c

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714378#comment-17714378 ] Dan Zou commented on CALCITE-5642: -- It seems that I have no permission to tag anyone a

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714373#comment-17714373 ] Dan Zou commented on CALCITE-5642: -- [~tanclary] I have opened a PR for this, please he

[jira] [Commented] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714355#comment-17714355 ] TJ Banghart commented on CALCITE-5449: -- We could keep these as custom time unit if

[jira] [Comment Edited] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714355#comment-17714355 ] TJ Banghart edited comment on CALCITE-5449 at 4/20/23 1:09 AM: --

[jira] [Commented] (CALCITE-4698) Respect input types and precision for datetime_plus and timestampadd

[ https://issues.apache.org/jira/browse/CALCITE-4698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714345#comment-17714345 ] Julian Hyde commented on CALCITE-4698: -- Re. your question, I don't have a strong o

[jira] [Commented] (CALCITE-5611) Show SQL query for failed tests for SqlOperatorTest

[ https://issues.apache.org/jira/browse/CALCITE-5611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714344#comment-17714344 ] Julian Hyde commented on CALCITE-5611: -- Looks good. Do you think there would be a

[jira] [Commented] (CALCITE-5543) Implement BigQuery functions for parsing DATE, TIME, TIMESTAMP, DATETIME

[ https://issues.apache.org/jira/browse/CALCITE-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714340#comment-17714340 ] TJ Banghart commented on CALCITE-5543: -- Took longer for me to get around to this t

[jira] [Comment Edited] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714335#comment-17714335 ] Oliver Lee edited comment on CALCITE-5662 at 4/19/23 11:13 PM: --

[jira] [Commented] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714335#comment-17714335 ] Oliver Lee commented on CALCITE-5662: - I've fixed the title of the JIRA ticket. I

[jira] [Updated] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5662: Description: Currently attempting to run {{SELECT CAST(BOOLEAN as INTEGER)}} will throw a {{Numb

[jira] [Updated] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5662: Labels: pull-request-available (was: ) > CAST(BOOLEAN as INTEGER) throws a NumberFormatE

[jira] [Commented] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714329#comment-17714329 ] Julian Hyde commented on CALCITE-5662: -- The current behavior is correct per the SQ

[jira] [Commented] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714326#comment-17714326 ] Julian Hyde commented on CALCITE-5449: -- If we did, we would probably want the 7 'W

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714324#comment-17714324 ] Julian Hyde commented on CALCITE-5646: -- You're right, I was getting confused about

[jira] [Updated] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5662: Description: Currently attempting to run {{SELECT CAST(BOOLEAN as INTEGER)}} will throw a {{Numb

[jira] [Updated] (CALCITE-5660) Implement BigQuery Array Subscript Operators

[ https://issues.apache.org/jira/browse/CALCITE-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5660: Labels: pull-request-available (was: ) > Implement BigQuery Array Subscript Operators >

[jira] [Comment Edited] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714124#comment-17714124 ] Leonid Chistov edited comment on CALCITE-5646 at 4/19/23 9:11 PM: ---

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714310#comment-17714310 ] Leonid Chistov commented on CALCITE-5646: -  Sorry, I don't really understand yo

[jira] [Comment Edited] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714124#comment-17714124 ] Leonid Chistov edited comment on CALCITE-5646 at 4/19/23 9:09 PM: ---

[jira] [Commented] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714306#comment-17714306 ] Tanner Clary commented on CALCITE-5449: --- [~julianhyde] As I revisit this, I am wo

[jira] [Updated] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5662: Description: Currently attempting to run {{SELECT CAST(BOOLEAN as INTEGER)}} will throw a {{Numb

[jira] [Updated] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5662: Description: Currently attempting to run {{SELECT CAST(BOOLEAN as INTEGER)}} will throw a {{Numb

[jira] [Updated] (CALCITE-5662) CAST(BOOLEAN as INTEGER) throws a NumberFormatException

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee updated CALCITE-5662: Summary: CAST(BOOLEAN as INTEGER) throws a NumberFormatException (was: Fix CAST(BOOLEAN as INTEG

[jira] [Commented] (CALCITE-5662) Fix CAST(BOOLEAN as INTEGER)

[ https://issues.apache.org/jira/browse/CALCITE-5662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714290#comment-17714290 ] Julian Hyde commented on CALCITE-5662: -- Never start a summary (or commit message)

[jira] [Commented] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714289#comment-17714289 ] Julian Hyde commented on CALCITE-5651: -- Calcite's type system should support syste

[jira] [Commented] (CALCITE-5390) RelDecorrelator throws NullPointerException

[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714269#comment-17714269 ] Julian Hyde commented on CALCITE-5390: -- The latter query (with "CASE") throws {nof

[jira] [Commented] (CALCITE-5638) Assertion Failure during planning correlated query with orderby

[ https://issues.apache.org/jira/browse/CALCITE-5638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714266#comment-17714266 ] Julian Hyde commented on CALCITE-5638: -- Same error as CALCITE-5429, and may be rel

[jira] [Commented] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714264#comment-17714264 ] Mihai Budiu commented on CALCITE-5651: -- My understanding was that "precision" is t

[jira] [Commented] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714261#comment-17714261 ] Mihai Budiu commented on CALCITE-5651: -- And a quote from the SQL92 standard (I don

[jira] [Commented] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714260#comment-17714260 ] Mihai Budiu commented on CALCITE-5651: -- Here are two quotes from the Postgres docu

[jira] [Comment Edited] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714258#comment-17714258 ] Julian Hyde edited comment on CALCITE-5642 at 4/19/23 6:34 PM: --

[jira] [Commented] (CALCITE-5642) Add SHA256, SHA512 functions

[ https://issues.apache.org/jira/browse/CALCITE-5642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714258#comment-17714258 ] Julian Hyde commented on CALCITE-5642: -- [~FrankZou]. I don't agree with your first

[jira] [Commented] (CALCITE-5651) Type system decimal scale in inferred types may exceed allowed scale

[ https://issues.apache.org/jira/browse/CALCITE-5651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714257#comment-17714257 ] Julian Hyde commented on CALCITE-5651: -- Some DBs may not allow it, but it is reaso

[jira] [Commented] (CALCITE-5631) Optimization to merge redundant joins

[ https://issues.apache.org/jira/browse/CALCITE-5631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714253#comment-17714253 ] Julian Hyde commented on CALCITE-5631: -- See [email thread "Rewrite rule to convert

[jira] [Created] (CALCITE-5662) Fix CAST(BOOLEAN as INTEGER)

Oliver Lee created CALCITE-5662: --- Summary: Fix CAST(BOOLEAN as INTEGER) Key: CALCITE-5662 URL: https://issues.apache.org/jira/browse/CALCITE-5662 Project: Calcite Issue Type: Bug Re

[jira] [Commented] (CALCITE-5309) Accept cursors as inputs of table functions

[ https://issues.apache.org/jira/browse/CALCITE-5309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714252#comment-17714252 ] Julian Hyde commented on CALCITE-5309: -- Many thanks for doing this research. I agr

[jira] [Commented] (CALCITE-5127) Support correlation variables in Project

[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714242#comment-17714242 ] Julian Hyde commented on CALCITE-5127: -- [~dmsysolyatin], Ok thanks. I wish you'd a

[jira] [Commented] (CALCITE-4771) Add TRY_CAST (MSSQL compatibility)

[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714239#comment-17714239 ] Julian Hyde commented on CALCITE-4771: -- Because I think type conversions are a mor

[jira] [Commented] (CALCITE-5653) expended casts are missing when IdentifierExpansion is false

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714238#comment-17714238 ] Julian Hyde commented on CALCITE-5653: -- I see. Can you change the summary and desc

[jira] [Commented] (CALCITE-5660) Implement BigQuery Array Subscript Operators

[ https://issues.apache.org/jira/browse/CALCITE-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714236#comment-17714236 ] Tanner Clary commented on CALCITE-5660: --- [~julianhyde] No I don't believe so eith

[jira] [Commented] (CALCITE-5659) Allow CAST in an INTERVAL definition

[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714235#comment-17714235 ] Julian Hyde commented on CALCITE-5659: -- {quote} What are the complications if we r

[jira] [Commented] (CALCITE-5660) Implement BigQuery Array Subscript Operators

[ https://issues.apache.org/jira/browse/CALCITE-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714233#comment-17714233 ] Julian Hyde commented on CALCITE-5660: -- FWIW, for {{SAFE_OFFSET}} and {{SAFE_ORDIN

[jira] [Commented] (CALCITE-5659) Allow CAST in an INTERVAL definition

[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714231#comment-17714231 ] Oliver Lee commented on CALCITE-5659: - That's a good point Julian. Based on the com

[jira] [Commented] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714230#comment-17714230 ] Julian Hyde commented on CALCITE-5661: -- If that doesn't work, also consider using

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714223#comment-17714223 ] Julian Hyde commented on CALCITE-5646: -- [~lchistov1987], {quote} I think that if

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714152#comment-17714152 ] Julian Hyde commented on CALCITE-5646: -- I wonder whether the solution is to make C

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714124#comment-17714124 ] Leonid Chistov commented on CALCITE-5646: - [~zabetak]  I think that if we know

[jira] [Assigned] (CALCITE-5650) Obtain typesystem from dialect in RelToSqlConverterTest

[ https://issues.apache.org/jira/browse/CALCITE-5650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-5650: Assignee: Mihai Budiu > Obtain typesystem from dialect in RelToSqlConver

[jira] [Updated] (CALCITE-5650) Obtain typesystem from dialect in RelToSqlConverterTest

[ https://issues.apache.org/jira/browse/CALCITE-5650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-5650: - Summary: Obtain typesystem from dialect in RelToSqlConverterTest (was: Sql.dia

[jira] [Resolved] (CALCITE-5650) Obtain typesystem from dialect in RelToSqlConverterTest

[ https://issues.apache.org/jira/browse/CALCITE-5650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-5650. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in https://github.com/a

[jira] [Commented] (CALCITE-5646) JoinDeriveIsNotNullFilterRule incorrectly handles COALESCE in join condition

[ https://issues.apache.org/jira/browse/CALCITE-5646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714066#comment-17714066 ] Stamatis Zampetakis commented on CALCITE-5646: -- {{Strong.isStrong}} is a s

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714053#comment-17714053 ] Stamatis Zampetakis commented on CALCITE-5615: -- I raised PR (https://githu

[jira] [Commented] (CALCITE-5630) Window with rows equivalence error in volcano planner

[ https://issues.apache.org/jira/browse/CALCITE-5630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714012#comment-17714012 ] Jiajun Xie commented on CALCITE-5630: - HepPlanner has same issue [https://github.c