I've discovered something strange, seemingly isolated to MacOS, but independent of CPU architecture.
Creating unique constraints on medium sized tables (>2^17 records) fails and the connection is terminated. This applies to both Intel and AppleM1 chips, FireBird versions 3.0.7 and 3.0.8 tested on both platforms. It, of course, applies to indices (unique), primary keys and the works. I discovered it by trying to restore a database (gbak) which failed while activating indices.
Test script attached.
unique_test.sql.zip
power(2, 18) fails
power(2, 17) succeeds
There is nothing in firebird.log. isql doesn't give any error message. IBExpert shows:
SQLCODE: -902
SQLSTATE: 08006
GDSCODE: 335544726
Connection will be closed immediately
So not very many useful hints, I'm afraid.
I've discovered something strange, seemingly isolated to MacOS, but independent of CPU architecture.
Creating unique constraints on medium sized tables (>2^17 records) fails and the connection is terminated. This applies to both Intel and AppleM1 chips, FireBird versions 3.0.7 and 3.0.8 tested on both platforms. It, of course, applies to indices (unique), primary keys and the works. I discovered it by trying to restore a database (gbak) which failed while activating indices.
Test script attached.
unique_test.sql.zip
power(2, 18) fails
power(2, 17) succeeds
There is nothing in firebird.log. isql doesn't give any error message. IBExpert shows:
SQLCODE: -902
SQLSTATE: 08006
GDSCODE: 335544726
Connection will be closed immediately
So not very many useful hints, I'm afraid.