[jira] [Closed] (CALCITE-3230) Explicit CASTs by user are not applied.

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan closed CALCITE-3230. --- Assignee: Danny Chan > Explicit CASTs by user are not applied. > --

[jira] [Created] (CALCITE-3232) Add syntax for type in site reference page

2019-08-06 Thread Danny Chan (JIRA)
Danny Chan created CALCITE-3232: --- Summary: Add syntax for type in site reference page Key: CALCITE-3232 URL: https://issues.apache.org/jira/browse/CALCITE-3232 Project: Calcite Issue Type: Sub-

[jira] [Commented] (CALCITE-3231) Support ARRAY type for SqlDataTypeSpec

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901606#comment-16901606 ] Danny Chan commented on CALCITE-3231: - Sure, i have fired a new issue CALCITE-3213

[jira] [Comment Edited] (CALCITE-3231) Support ARRAY type for SqlDataTypeSpec

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901606#comment-16901606 ] Danny Chan edited comment on CALCITE-3231 at 8/7/19 1:28 AM:

[jira] [Commented] (CALCITE-3231) Support ARRAY type for SqlDataTypeSpec

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901667#comment-16901667 ] Danny Chan commented on CALCITE-3231: - Fixed in [3cff43a|https://github.com/apache

[jira] [Resolved] (CALCITE-3231) Support ARRAY type for SqlDataTypeSpec

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3231. - Resolution: Fixed > Support ARRAY type for SqlDataTypeSpec > --

[jira] [Created] (CALCITE-3233) Support Row type for SqlDataTypeSpec

2019-08-06 Thread Danny Chan (JIRA)
Danny Chan created CALCITE-3233: --- Summary: Support Row type for SqlDataTypeSpec Key: CALCITE-3233 URL: https://issues.apache.org/jira/browse/CALCITE-3233 Project: Calcite Issue Type: Sub-task

[jira] [Commented] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901684#comment-16901684 ] Danny Chan commented on CALCITE-2843: - [~mgelbana] Sure, please this branch  [https

[jira] [Comment Edited] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901684#comment-16901684 ] Danny Chan edited comment on CALCITE-2843 at 8/7/19 4:21 AM:

[jira] [Updated] (CALCITE-3128) Joining two tables producing only NULLs will return 0 rows

2019-08-06 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3128: Fix Version/s: 1.21.0 > Joining two tables producing only NULLs will return 0 rows >

[jira] [Commented] (CALCITE-2921) Allow NULL as argument to function calls

2019-08-07 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901891#comment-16901891 ] Danny Chan commented on CALCITE-2921: - [~julianhyde] [~pzw2018] I have reviewed the

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

2019-08-07 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16901950#comment-16901950 ] Danny Chan commented on CALCITE-482: Thanks, [~Chunwei Lei], how about we modify the

[jira] [Commented] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

2019-08-07 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902717#comment-16902717 ] Danny Chan commented on CALCITE-2843: - Thanks, [~mgelbana], i have dig a little and

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

2019-08-07 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902723#comment-16902723 ] Danny Chan commented on CALCITE-482: Yeah, the 2 style hints are both very useful, f

[jira] [Comment Edited] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

2019-08-08 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16902717#comment-16902717 ] Danny Chan edited comment on CALCITE-2843 at 8/8/19 12:18 PM: ---

[jira] [Commented] (CALCITE-3233) Support Row type for SqlDataTypeSpec

2019-08-08 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16903490#comment-16903490 ] Danny Chan commented on CALCITE-3233: - Thanks four your reminder, i would update re

[jira] [Comment Edited] (CALCITE-3233) Support Row type for SqlDataTypeSpec

2019-08-08 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16903490#comment-16903490 ] Danny Chan edited comment on CALCITE-3233 at 8/9/19 1:53 AM:

[jira] [Updated] (CALCITE-3233) Support Row type for SqlDataTypeSpec

2019-08-08 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3233: Description: This is the grammar copied from SQL-2011: {code:sql} ::= ROW ::= [ { }...

[jira] [Commented] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

2019-08-09 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16903697#comment-16903697 ] Danny Chan commented on CALCITE-2843: - Thanks Julian, and sorry for my mistake [~mg

[jira] [Resolved] (CALCITE-3233) Support Row type for SqlDataTypeSpec

2019-08-09 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3233. - Resolution: Fixed Fixed in [5212d6c|https://github.com/apache/calcite/commit/5212d6c47e3699594

[jira] [Resolved] (CALCITE-3232) Add syntax for type in site reference page

2019-08-09 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3232. - Resolution: Won't Fix Cancel this issue because we better put the grammar and doc in one PR. >

[jira] [Created] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-09 Thread Danny Chan (JIRA)
Danny Chan created CALCITE-3238: --- Summary: Support Time Zone suffix of DateTime types for SqlDataTypeSpec Key: CALCITE-3238 URL: https://issues.apache.org/jira/browse/CALCITE-3238 Project: Calcite

[jira] [Assigned] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-09 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-3238: --- Assignee: Danny Chan > Support Time Zone suffix of DateTime types for SqlDataTypeSpec > --

[jira] [Updated] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-09 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3238: Description: This is the grammar copied from SQL-2011: {code:sql} ::= DATE | TIME []

[jira] [Updated] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-12 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3238: Description: This is the grammar copied from SQL-2011: {code:sql} ::= DATE | TIME []

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

2019-08-12 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905746#comment-16905746 ] Danny Chan commented on CALCITE-1935: - Nice job, [~julian.feinauer] ! Thanks for yo

[jira] [Commented] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-12 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905749#comment-16905749 ] Danny Chan commented on CALCITE-3238: - I agree with your point that we should first

[jira] [Comment Edited] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-12 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905749#comment-16905749 ] Danny Chan edited comment on CALCITE-3238 at 8/13/19 2:34 AM: ---

[jira] [Commented] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906118#comment-16906118 ] Danny Chan commented on CALCITE-3238: - [~julianhyde] I have did some refactoring fo

[jira] [Commented] (CALCITE-3242) RelToSqlConverter handling "NOT IN" incorrectly

2019-08-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906162#comment-16906162 ] Danny Chan commented on CALCITE-3242: - Hi, [~atharv.raj] Now Calcite would always t

[jira] [Assigned] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-3244: --- Assignee: Danny Chan > RelDecorrelator unable to decorrelate expression with filter and ag

[jira] [Updated] (CALCITE-3213) Support complex type expressions for SqlDataTypeSpec

2019-08-13 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3213: Description: We should support nested struct type like: {code:sql} ROW( foo NUMBER(5, 2) NOT NUL

[jira] [Resolved] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-14 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3238. - Resolution: Fixed Fix Version/s: 1.21.0 Fixed in [f25734a|https://github.com/apache/cal

[jira] [Created] (CALCITE-3250) Support nested collection type for SqlDataTypeSpec

2019-08-14 Thread Danny Chan (JIRA)
Danny Chan created CALCITE-3250: --- Summary: Support nested collection type for SqlDataTypeSpec Key: CALCITE-3250 URL: https://issues.apache.org/jira/browse/CALCITE-3250 Project: Calcite Issue T

[jira] [Commented] (CALCITE-3241) Calcite this is a very strange mistake

2019-08-14 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907044#comment-16907044 ] Danny Chan commented on CALCITE-3241: - [~1693294577] Thanks, can you summarize and

[jira] [Resolved] (CALCITE-3236) Handle issues found in static code analysis

2019-08-14 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3236. - Resolution: Fixed Fix Version/s: 1.21.0 Fixed in  [5c01713|https://github.com/apache/cal

[jira] [Commented] (CALCITE-3236) Handle issues found in static code analysis

2019-08-14 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907269#comment-16907269 ] Danny Chan commented on CALCITE-3236: - [~krisden] Does the plugin have performance

[jira] [Updated] (CALCITE-3250) Support nested collection type for SqlDataTypeSpec

2019-08-15 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3250: Fix Version/s: 1.21.0 > Support nested collection type for SqlDataTypeSpec > ---

[jira] [Resolved] (CALCITE-3250) Support nested collection type for SqlDataTypeSpec

2019-08-15 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3250. - Resolution: Fixed Fixed in  [705be27|https://github.com/apache/calcite/commit/705be2771f284533a

[jira] [Updated] (CALCITE-3250) Support nested collection type for SqlDataTypeSpec

2019-08-15 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3250: Affects Version/s: 1.20.0 Component/s: core > Support nested collection type for SqlDa

[jira] [Updated] (CALCITE-3238) Support Time Zone suffix of DateTime types for SqlDataTypeSpec

2019-08-15 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3238: Affects Version/s: 1.20.0 Component/s: core > Support Time Zone suffix of DateTime type

[jira] [Commented] (CALCITE-3250) Support nested collection type for SqlDataTypeSpec

2019-08-15 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908615#comment-16908615 ] Danny Chan commented on CALCITE-3250: - Thanks, Julian. I add the SqlTypeNameSpec#d

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-16 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908903#comment-16908903 ] Danny Chan commented on CALCITE-2302: - Thanks so much for your review [~hyuan] ! I

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-16 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908903#comment-16908903 ] Danny Chan edited comment on CALCITE-2302 at 8/16/19 9:45 AM: ---

[jira] [Commented] (CALCITE-3250) Support nested collection type for SqlDataTypeSpec

2019-08-16 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16909535#comment-16909535 ] Danny Chan commented on CALCITE-3250: - Indeed, very sorry about that, i should have

[jira] [Commented] (CALCITE-3255) CannotPlanException: There are not enough rules to produce a node with desired properties

2019-08-16 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16909539#comment-16909539 ] Danny Chan commented on CALCITE-3255: - Thanks, [~Water Cut Off], this is an expecte

[jira] [Resolved] (CALCITE-3255) CannotPlanException: There are not enough rules to produce a node with desired properties

2019-08-16 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3255. - Resolution: Invalid Assignee: Danny Chan > CannotPlanException: There are not enough rule

[jira] [Commented] (CALCITE-3213) Support complex type expressions for SqlDataTypeSpec

2019-08-16 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16909552#comment-16909552 ] Danny Chan commented on CALCITE-3213: - Let me summarize the broad changes: * Suppo

[jira] [Commented] (CALCITE-3261) Incorrect output field names from jdbc

2019-08-18 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910134#comment-16910134 ] Danny Chan commented on CALCITE-3261: - Thanks [~johnzh], the column name is "EXPR$1

[jira] [Commented] (CALCITE-3236) Handle issues found in static code analysis

2019-08-18 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910137#comment-16910137 ] Danny Chan commented on CALCITE-3236: - I agree, thanks for your clarification. > H

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-18 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910144#comment-16910144 ] Danny Chan commented on CALCITE-2302: - Thanks [~zabetak], most of the sql contexts

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-18 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910144#comment-16910144 ] Danny Chan edited comment on CALCITE-2302 at 8/19/19 2:52 AM: ---

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-18 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908903#comment-16908903 ] Danny Chan edited comment on CALCITE-2302 at 8/19/19 2:55 AM: ---

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-18 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910144#comment-16910144 ] Danny Chan edited comment on CALCITE-2302 at 8/19/19 2:59 AM: ---

[jira] [Created] (CALCITE-3269) Returns integer for VARCHAR and INT division of PostgreSql dialect

2019-08-19 Thread Danny Chan (Jira)
Danny Chan created CALCITE-3269: --- Summary: Returns integer for VARCHAR and INT division of PostgreSql dialect Key: CALCITE-3269 URL: https://issues.apache.org/jira/browse/CALCITE-3269 Project: Calcite

[jira] [Commented] (CALCITE-3213) Support complex type expressions for SqlDataTypeSpec

2019-08-19 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16910954#comment-16910954 ] Danny Chan commented on CALCITE-3213: - Thanks Julian, the change list you proposed

[jira] [Resolved] (CALCITE-3267) Remove method SqlDataTypeSpec#deriveType(RelDataTypefactory)

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3267. - Resolution: Fixed Fixed in [6b600e4|https://github.com/apache/calcite/commit/6b600e4bd13d130a4

[jira] [Resolved] (CALCITE-3251) BinaryExpression evaluate method support Long type.

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3251. - Fix Version/s: 1.21.0 Assignee: Danny Chan Resolution: Fixed Fixed in [5a42812

[jira] [Updated] (CALCITE-3265) Remove useless code in ExpressionTest

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3265: Summary: Remove useless code in ExpressionTest (was: remove useless code) > Remove useless code

[jira] [Resolved] (CALCITE-3265) Remove useless code in ExpressionTest

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3265. - Assignee: Danny Chan Resolution: Fixed Fixed in  [5a42812|https://github.com/apache/calci

[jira] [Updated] (CALCITE-3265) Remove useless code in ExpressionTest

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3265: Fix Version/s: 1.21.0 Affects Version/s: 1.20.0 > Remove useless code in ExpressionTest >

[jira] [Updated] (CALCITE-3251) BinaryExpression evaluate method support Long type.

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3251: Component/s: core Affects Version/s: 1.19.0 1.20.0 > BinaryExpre

[jira] [Created] (CALCITE-3271) TVF windowing and EMIT syntax support in Calcite

2019-08-20 Thread Danny Chan (Jira)
Danny Chan created CALCITE-3271: --- Summary: TVF windowing and EMIT syntax support in Calcite Key: CALCITE-3271 URL: https://issues.apache.org/jira/browse/CALCITE-3271 Project: Calcite Issue Type

[jira] [Updated] (CALCITE-3271) TVF windowing and EMIT syntax support in Calcite

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3271: Issue Type: Improvement (was: Bug) > TVF windowing and EMIT syntax support in Calcite >

[jira] [Resolved] (CALCITE-3213) Support complex type expressions for SqlDataTypeSpec

2019-08-20 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3213. - Resolution: Fixed > Support complex type expressions for SqlDataTypeSpec > ---

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-21 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16911987#comment-16911987 ] Danny Chan commented on CALCITE-2302: - [~julianhyde] Personally i propose to add th

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-21 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912839#comment-16912839 ] Danny Chan commented on CALCITE-2302: - For "9/2 returns 4.5", we indeed do the type

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-21 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912840#comment-16912840 ] Danny Chan commented on CALCITE-2302: - [~julianhyde] Does my reply answer your ques

[jira] [Commented] (CALCITE-3115) Cannot add JdbcRules which have different JdbcConvention to same VolcanoPlanner's RuleSet.

2019-08-21 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912928#comment-16912928 ] Danny Chan commented on CALCITE-3115: - Reviewing now .. > Cannot add JdbcRules whi

[jira] [Commented] (CALCITE-3282) make every SqlDialect parse their own data type

2019-08-22 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913252#comment-16913252 ] Danny Chan commented on CALCITE-3282: - Sounds reasonable, but i can not figure out

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-22 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913843#comment-16913843 ] Danny Chan commented on CALCITE-2302: - Thanks, [~julianhyde] I kind of agree with y

[jira] [Commented] (CALCITE-3282) Make every SqlDialect unparse their own data type

2019-08-22 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913878#comment-16913878 ] Danny Chan commented on CALCITE-3282: - The SqlTypeNameSpec is a component of SqlDat

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-22 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913843#comment-16913843 ] Danny Chan edited comment on CALCITE-2302 at 8/23/19 3:46 AM: ---

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-23 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16914070#comment-16914070 ] Danny Chan commented on CALCITE-2302: - I have made the latest change in commit  [7b

[jira] [Commented] (CALCITE-3282) Make every SqlDialect unparse their own data type

2019-08-23 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16914095#comment-16914095 ] Danny Chan commented on CALCITE-3282: - Add a new method SqlDialect#unparseDataType

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-23 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16914070#comment-16914070 ] Danny Chan edited comment on CALCITE-2302 at 8/24/19 2:31 AM: ---

[jira] [Commented] (CALCITE-3282) Make every SqlDialect unparse their own data type

2019-08-25 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915407#comment-16915407 ] Danny Chan commented on CALCITE-3282: - The key point is that we don't want the SqlT

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-25 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915414#comment-16915414 ] Danny Chan commented on CALCITE-2302: - [~julianhyde] Does the latest commit solve y

[jira] [Commented] (CALCITE-482) Implement sql and planner hints

2019-08-26 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915532#comment-16915532 ] Danny Chan commented on CALCITE-482: Thanks, [~hyuan] and [~Chunwei Lei] i have atta

[jira] [Resolved] (CALCITE-3210) JDBC adapter should generate "CAST(NULL AS type)" rather than "NULL"

2019-08-26 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3210. - Fix Version/s: (was: next) 1.21.0 Resolution: Fixed Fixed in [e8

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16916465#comment-16916465 ] Danny Chan commented on CALCITE-2973: - CALCITE-2302 and CALCITE-1581 are almost rea

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16916709#comment-16916709 ] Danny Chan commented on CALCITE-3244: - [~vvysotskyi] I have applied a patch to fix

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16914070#comment-16914070 ] Danny Chan edited comment on CALCITE-2302 at 8/28/19 1:32 AM: ---

[jira] [Issue Comment Deleted] (CALCITE-2302) Implicit type cast support

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-2302: Comment: was deleted (was: [~julianhyde] Does the latest commit solve your review objections ? I'

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917355#comment-16917355 ] Danny Chan commented on CALCITE-3244: - Thanks [~vvysotskyi], i have fixed the test

[jira] [Comment Edited] (CALCITE-2302) Implicit type cast support

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908903#comment-16908903 ] Danny Chan edited comment on CALCITE-2302 at 8/28/19 2:58 AM: ---

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-27 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917367#comment-16917367 ] Danny Chan commented on CALCITE-3244: - I haven't digged into the failing test case

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-28 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917560#comment-16917560 ] Danny Chan commented on CALCITE-3244: - Yes, it is the RelDecorrelator that cause th

[jira] [Commented] (CALCITE-3304) SqlValidatorException when use calcite view

2019-08-28 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917694#comment-16917694 ] Danny Chan commented on CALCITE-3304: - This is because you config the FrameworkConf

[jira] [Resolved] (CALCITE-3304) SqlValidatorException when use calcite view

2019-08-28 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3304. - Resolution: Not A Bug > SqlValidatorException when use calcite view > -

[jira] [Commented] (CALCITE-2302) Implicit type cast support

2019-08-29 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16918405#comment-16918405 ] Danny Chan commented on CALCITE-2302: - [~julianhyde] Thanks. There seems to be 2 s

[jira] [Resolved] (CALCITE-2325) Calcite can not verify a explicit cast column in some scenario

2019-08-29 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-2325. - Fix Version/s: 1.21.0 Assignee: Danny Chan Resolution: Fixed Fixed in  [01477c4

[jira] [Resolved] (CALCITE-2302) Implicit type cast support

2019-08-29 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-2302. - Resolution: Fixed Fixed in  [01477c4|https://github.com/apache/calcite/commit/01477c42ded991aaa

[jira] [Resolved] (CALCITE-2921) Allow NULL as argument to function calls

2019-08-29 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-2921. - Resolution: Fixed Fixed in [01477c4|https://github.com/apache/calcite/commit/01477c42ded991aaa

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plans

2019-08-29 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16918610#comment-16918610 ] Danny Chan commented on CALCITE-3122: - [~khaitran] Do you mean the Kerb Auth or som

[jira] [Resolved] (CALCITE-3269) Returns integer for VARCHAR and INT division of PostgreSql dialect

2019-08-29 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3269. - Resolution: Invalid As discussed in CALCITE-2302, we have chose the PostgreSQL style for binary

[jira] [Created] (CALCITE-3310) Approximate and exact aggregate calls are recognized as the same during sql-to-rel conversion

2019-08-30 Thread Danny Chan (Jira)
Danny Chan created CALCITE-3310: --- Summary: Approximate and exact aggregate calls are recognized as the same during sql-to-rel conversion Key: CALCITE-3310 URL: https://issues.apache.org/jira/browse/CALCITE-3310

[jira] [Commented] (CALCITE-3307) PigRelExTest fails on Windows

2019-08-30 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16919296#comment-16919296 ] Danny Chan commented on CALCITE-3307: - Thanks for the confirm, Ruben ! > PigRelExT

[jira] [Created] (CALCITE-3311) Add doc to site for implicit type coercion

2019-08-30 Thread Danny Chan (Jira)
Danny Chan created CALCITE-3311: --- Summary: Add doc to site for implicit type coercion Key: CALCITE-3311 URL: https://issues.apache.org/jira/browse/CALCITE-3311 Project: Calcite Issue Type: Sub-

[jira] [Commented] (CALCITE-3282) Make every SqlDialect unparse their own data type

2019-08-30 Thread Danny Chan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16919451#comment-16919451 ] Danny Chan commented on CALCITE-3282: - Let's just ignore unparsing the DDL first, C

<    1   2   3   4   5   6   >