[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3423: Labels: pull-request-available (was: ) > Support using CAST operation and BOOLEAN type v

[jira] [Commented] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954220#comment-16954220 ] Wang Yanlin commented on CALCITE-3423: -- But, I can only find [JavaToSqlTypeConver

[jira] [Commented] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954219#comment-16954219 ] Wang Yanlin commented on CALCITE-3423: -- I was hesitate about this test cast. {cod

[jira] [Updated] (CALCITE-3427) some subquery correlated case isn't fully implemented

[ https://issues.apache.org/jira/browse/CALCITE-3427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liuzonghao updated CALCITE-3427: Description: {code:java} //代码占位符 // for correlated case queries such as // // select e.deptno, e.

[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Description: Currently, using bool type or cast operation in table macro, got exception. Add t

[jira] [Commented] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954213#comment-16954213 ] Danny Chen commented on CALCITE-3412: - Thanks for the fixing, Julian ~ > FLOOR(tim

[jira] [Commented] (CALCITE-2303) In EXTRACT function, support MICROSECONDS, MILLISECONDS, EPOCH, ISODOW, ISOYEAR and DECADE time units

[ https://issues.apache.org/jira/browse/CALCITE-2303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954211#comment-16954211 ] Danny Chen commented on CALCITE-2303: - Thanks for the fixing, Julian ~ > In EXTRAC

[jira] [Commented] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954208#comment-16954208 ] Wang Yanlin commented on CALCITE-3423: -- Sure. Jira and PR updated. > Support usi

[jira] [Created] (CALCITE-3427) some subquery correlated case isn't fully implemented

liuzonghao created CALCITE-3427: --- Summary: some subquery correlated case isn't fully implemented Key: CALCITE-3427 URL: https://issues.apache.org/jira/browse/CALCITE-3427 Project: Calcite Issue

[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Description: Currently, using bool type or cast operation in table macro, got exception. Add t

[jira] [Updated] (CALCITE-3423) Support using CAST operation and BOOLEAN type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Summary: Support using CAST operation and BOOLEAN type value in table macro (was: Support usin

[jira] [Updated] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3412: Description: Floor timestamp to week exist error: The start day of the week is not Sunday or Mon

[jira] [Updated] (CALCITE-3426) compensate validConstant type in RexLiteral.

[ https://issues.apache.org/jira/browse/CALCITE-3426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3426: Labels: pull-request-available (was: ) > compensate validConstant type in RexLiteral. >

[jira] [Created] (CALCITE-3426) compensate validConstant type in RexLiteral.

xzh_dz created CALCITE-3426: --- Summary: compensate validConstant type in RexLiteral. Key: CALCITE-3426 URL: https://issues.apache.org/jira/browse/CALCITE-3426 Project: Calcite Issue Type: Wish

[jira] [Resolved] (CALCITE-3421) Reuse relMetadataQuery.

[ https://issues.apache.org/jira/browse/CALCITE-3421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3421. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Created] (CALCITE-3425) Inconsistent behavior of MetadataProvider in RelOptCluster

Haisheng Yuan created CALCITE-3425: -- Summary: Inconsistent behavior of MetadataProvider in RelOptCluster Key: CALCITE-3425 URL: https://issues.apache.org/jira/browse/CALCITE-3425 Project: Calcite

[jira] [Commented] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954132#comment-16954132 ] Igor Guzenko commented on CALCITE-3424: --- Hello [~julianhyde], yes, original inte

[jira] [Commented] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954100#comment-16954100 ] Julian Hyde commented on CALCITE-3412: -- Fixed in Avatica in [72bbbfc9|https://git

[jira] [Resolved] (CALCITE-3199) DateTimeUtils.unixDateCeil should not return the same value as unixDateFloor

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

[jira] [Commented] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954089#comment-16954089 ] Julian Hyde commented on CALCITE-3402: -- Maybe "{{RANGE BETWEEN unbounded PRECEDING

[jira] [Commented] (CALCITE-3423) Support using CAST operation and bool type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954066#comment-16954066 ] Julian Hyde commented on CALCITE-3423: -- The type is called BOOLEAN. Can you adjust

[jira] [Resolved] (CALCITE-2792) Stackoverflow while evaluating filter with large number of OR conditions

[ https://issues.apache.org/jira/browse/CALCITE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2792. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

[ https://issues.apache.org/jira/browse/CALCITE-3424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953997#comment-16953997 ] Julian Hyde commented on CALCITE-3424: -- Is your intention to define a function wit

[jira] [Created] (CALCITE-3424) AssertionError thrown for user-defined table function with array argument

Igor Guzenko created CALCITE-3424: - Summary: AssertionError thrown for user-defined table function with array argument Key: CALCITE-3424 URL: https://issues.apache.org/jira/browse/CALCITE-3424 Project

[jira] [Resolved] (CALCITE-3380) implement power method in Expressions.

[ https://issues.apache.org/jira/browse/CALCITE-3380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3380. -- Resolution: Won't Fix Closing as "won't fix". This method goes against the philosophy of the

[jira] [Commented] (CALCITE-3407) Implement Minus and Intersect relational operators in the interpreter

[ https://issues.apache.org/jira/browse/CALCITE-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953910#comment-16953910 ] Haisheng Yuan commented on CALCITE-3407: Not necessary. I think it is just a co

[jira] [Updated] (CALCITE-3423) Support using CAST operation and bool type value in table macro

[ https://issues.apache.org/jira/browse/CALCITE-3423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3423: - Description: Currently, using bool type or cast operation in table macro, got exception. Add t

[jira] [Created] (CALCITE-3423) Support using CAST operation and bool type value in table macro

Wang Yanlin created CALCITE-3423: Summary: Support using CAST operation and bool type value in table macro Key: CALCITE-3423 URL: https://issues.apache.org/jira/browse/CALCITE-3423 Project: Calcite

[jira] [Comment Edited] (CALCITE-3402) Allow RANGE with compoud ORDER BY clause

[ https://issues.apache.org/jira/browse/CALCITE-3402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16952633#comment-16952633 ] benj edited comment on CALCITE-3402 at 10/17/19 12:47 PM: -- Wit

[jira] [Comment Edited] (CALCITE-3415) Cannot parse REGEXP_SUBSTR in BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16952631#comment-16952631 ] Pranay Parmar edited comment on CALCITE-3415 at 10/17/19 12:19 PM: --

[jira] [Commented] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953562#comment-16953562 ] Wang Weidong commented on CALCITE-3300: --- [~danny0405] Thanks for you suggestions

[jira] [Comment Edited] (CALCITE-3300) Add a star identifier as operand to "SqlCountAggFunction" if no operands given while in the method "createCall"

[ https://issues.apache.org/jira/browse/CALCITE-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16924714#comment-16924714 ] Wang Weidong edited comment on CALCITE-3300 at 10/17/19 9:33 AM:

[jira] [Updated] (CALCITE-3400) Implement left/right/semi/anti/full join in Interpreter

[ https://issues.apache.org/jira/browse/CALCITE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3400: - Summary: Implement left/right/semi/anti/full join in Interpreter (was: Add support for interpr

[jira] [Comment Edited] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953504#comment-16953504 ] Julian Hyde edited comment on CALCITE-3412 at 10/17/19 8:34 AM: -

[jira] [Assigned] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3412: Assignee: Julian Hyde > FLOOR(timestamp TO WEEK) gives wrong result > --

[jira] [Updated] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3412: - Environment: (was: mac,linux) > FLOOR(timestamp TO WEEK) gives wrong result > -

[jira] [Updated] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3412: - Flags: (was: Important) > FLOOR(timestamp TO WEEK) gives wrong result > -

[jira] [Commented] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953504#comment-16953504 ] Julian Hyde commented on CALCITE-3412: -- I agree with [~kofiori] that {{FLOOR(times

[jira] [Updated] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3412: - Fix Version/s: 1.22.0 > FLOOR(timestamp TO WEEK) gives wrong result > -

[jira] [Commented] (CALCITE-3407) Implement Minus and Intersect relational operators in the interpreter

[ https://issues.apache.org/jira/browse/CALCITE-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953496#comment-16953496 ] Wang Yanlin commented on CALCITE-3407: -- OK. Is it a convention for checking sql w

[jira] [Updated] (CALCITE-3199) DateTimeUtils.unixDateCeil should not return the same value as unixDateFloor

[ https://issues.apache.org/jira/browse/CALCITE-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3199: - Summary: DateTimeUtils.unixDateCeil should not return the same value as unixDateFloor (was: Da

[jira] [Updated] (CALCITE-3412) FLOOR(timestamp TO WEEK) gives wrong result

[ https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3412: - Summary: FLOOR(timestamp TO WEEK) gives wrong result (was: Response Error for FLOOR TIMESTAMP

[jira] [Resolved] (CALCITE-3407) Implement Minus and Intersect relational operators in the interpreter

[ https://issues.apache.org/jira/browse/CALCITE-3407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3407. -- Fix Version/s: 1.22.0 Resolution: Fixed Fixed in [ec9947ad|https://github.com/apache/