[Bug] Urgent: The Decimal precision of Doris cannot support the storage of numbers corresponding to IPv6 addresses #21986
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
All version, include v1.2.4/v1.2.6/v2.0beta...
What's Wrong?
At present, the maximum number of Decimal type integers supported by Doris can only be 38. We hope to store the digital form of IPv6 addresses through Doris (the data type in Java language is BigInteger), which will cause the data to be stored incorrectly.
After browsing the Decimal type of the ClickHouse database, the Decimal type can support up to Decimal256(S), which can effectively solve the storage problem when the value is large.
This problem affects many functions related to this precision, please help to fix and solve it as soon as possible!
Thank you very much.
What You Expected?
The precision of the integer part of Decimal can at least support the length of the number corresponding to the IPv6 address.
How to Reproduce?
Documentation about Decimal type and practice have confirmed that when the Decimal precision is specified as DECIMAL(38, 0), the value corresponding to the IPv6 address (2409:8087:574C:14:1000::49) cannot be saved.
Anything Else?
NA
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct