[I] [Bug] Decimal cast bug: Arithmetic overflow [doris]

["Yulei-Yang (via GitHub)" <gi...@apache.org>]

Yulei-Yang opened a new issue, #30413:
URL: https://github.com/apache/doris/issues/30413

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   latest 2.0
   
   ### What's Wrong?
   
   ERROR 1105 (HY000): errCode = 2, detailMessage = (10.10.151.136)[CANCELLED][E-124][E-124] Arithmetic overflow
   
           0#  doris::Exception::Exception(int, std::basic_string_view<char, std::char_traits<char> >)
           1#  auto doris::vectorized::convert_decimal_cols<doris::vectorized::DataTypeDecimal<doris::vectorized::Decimal<int> >, doris::vectorized::DataTypeDecimal<doris::vectorized::Decimal<int> > >(doris::vectorized::ColumnDecimal<doris::vectorized::DataTypeDecimal<doris::vectorized::Decimal<int> >::FieldType>::Container::value_type
   
   ### What You Expected?
   
   Fix it
   
   ### How to Reproduce?
   
   create a hive table and insert some rows:
   
   create table  `test_decimal` (
     `id` bigint,
     `name` string,
     `price` decimal(7,2)
   )  STORED as parquet;
   insert into test_decimal values (1, 'rice', 10.51),(2, 'meat', null),(3, 'wheat', 1.63);
   
   then create a hive catalog and run sql in doris: select avg(price) from test_decimal;
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] Decimal cast bug: Arithmetic overflow [doris]

["Yulei-Yang (via GitHub)" <gi...@apache.org>]

Yulei-Yang closed issue #30413: [Bug] Decimal cast bug: Arithmetic overflow
URL: https://github.com/apache/doris/issues/30413


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org