search

nck-2 / test-rep

0 stars 0 forks source link

Implement fixed-point data type #1284

Closed githubmanticore closed 1 year ago

githubmanticore commented 1 year ago

We need a new data type that uses a fixed number of bits for integer and fractional parts (similar to DECIMAL in mysql). That would allow us to compare such values, use IN() function, store financial data (e.g. $3.55) etc. All of this doesnt work correctly with floating-point numbers.

githubmanticore commented 1 year ago

➤ Sergey Nikolaev commented:

What's the rough estimate for this change?

githubmanticore commented 1 year ago

➤ Ilya Kuznetsov commented:

At least one week, probably more. All operations on such a type must be replaced by special expressions. We don't have similar types now, that's why it's hard to esimate.

githubmanticore commented 1 year ago

➤ Adrian Nuta commented:

Seems quite some work - I wouldn't high prioritize this yet, the issue was brought only by a normal customer and there are workarounds for it.