[MDEV-30376] DECFLOAT data type Created: 2023-01-10 Updated: 2023-10-04 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data types |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Robert Palm | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
| Description |
|
I'd like to see the DECFLOAT (= Decimal floating-point) data type get implemented in MariaDB. The type offers base 10 floating point arithmetic. References:
|
| Comments |
| Comment by Sergei Golubchik [ 2023-02-03 ] | |||||||||||||
|
what for? | |||||||||||||
| Comment by Robert Palm [ 2023-02-08 ] | |||||||||||||
|
Thank you for asking back. In short I think it is the ideal type for base 10 calculations. Some quotes from Ref. 4:
| |||||||||||||
| Comment by Sergei Golubchik [ 2023-02-28 ] | |||||||||||||
|
MariaDB's DECIMAL type is doing base 10 calculations. Would that serve your needs? | |||||||||||||
| Comment by Robert Palm [ 2023-03-15 ] | |||||||||||||
|
Here a example on db2:
For C1 I can immediately see which number it is. For C2 I need to strengthen my eyes if there are only 0s after the last significant digit. It is a bit like someone asking for JSON and you ask back if you can do it with XML |