You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2020/03/23 12:09:11 UTC
[GitHub] [calcite] wenhuitang opened a new pull request #1867:
[CALCITE-3866] ReturnTypes.AGG_SUM may cause "numeric field overflow" on
PostgreSQL when generate the sql after using the rule
AggregateJoinTransposeRule.EXTENDED
wenhuitang opened a new pull request #1867: [CALCITE-3866] ReturnTypes.AGG_SUM may cause "numeric field overflow" on PostgreSQL when generate the sql after using the rule AggregateJoinTransposeRule.EXTENDED
URL: https://github.com/apache/calcite/pull/1867
Pull request for https://issues.apache.org/jira/browse/CALCITE-3866
As for aggregate function sum, most of the time, its return type is equal to its operand's type, but if its operand's type has precision, the precision of the result may be larger than the oeprans's type. So may be we can set precision to the Max value if the oeprand's type has precision, especially for the type decimal.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [calcite] XuQianJin-Stars commented on issue #1867: [CALCITE-3866]
ReturnTypes.AGG_SUM may cause "numeric field overflow" on PostgreSQL when
generate the sql after using the rule AggregateJoinTransposeRule.EXTENDED
Posted by GitBox <gi...@apache.org>.
XuQianJin-Stars commented on issue #1867: [CALCITE-3866] ReturnTypes.AGG_SUM may cause "numeric field overflow" on PostgreSQL when generate the sql after using the rule AggregateJoinTransposeRule.EXTENDED
URL: https://github.com/apache/calcite/pull/1867#issuecomment-602697507
LGTM +1
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services