On 2/16/22 13:49, Alex Peshkoff via Firebird-devel wrote:
On 2/16/22 12:54, Dmitry Yemanov wrote:
16.02.2022 12:19, Mark Rotteveel wrote:
However, that was not my main point. My main point was that it
sounds like an index format that was created for supporting
DECFLOAT(34), and that it is not suitable for the full range of
INT128 and NUMERIC/DECIMAL backed by INT128 (for the same reasons
the DOUBLE PRECISION format is not suitable for BIGINT and
NUMERIC/DECIMAL backed by BIGINT).
It looks so. Unless we miss something (Alex?),
This is possible way to fix a bug:
https://github.com/FirebirdSQL/firebird/commit/7dd832f32e9669bcb3007dc675b3ee7cca6f6b7d
New type of indexes is added and it works fine.
But I wonder - what to do with existing databases? Rebuilding affected
indexes is enough - but such database becomes unusable for previous
versions of engine. Normally we should increase ODS minor. But last time
when it was done in FB3 it gave serious negative feedback. Next,
upgrading ODS requires gbak/restore cycle, which is problematic with big
database.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel