CyberMaxRu

Changing plan of query when using 2 always TRUE conditions

2

SELECT RF.* FROM RDB$RELATIONS R INNER JOIN RDB$RELATION_FIELDS RF ON RF.RDB$RELATION_NAME = R.RDB$RELATION_NAME WHERE R.RDB$RELATION_NAME = 'RDB$RELATIONS' Plan: PLAN JOIN (RF INDEX (RDB$INDEX_4), R INDEX (RDB$INDEX_0)) SELECT RF.* FROM RDB$RELATIONS...

We recently updated to Firebird 4.0.2.2770. And we use our own replication on triggers. A few days after the restore on FB4, the slave base stopped during replication this table...

FB 4.3.2.2770. Character set - WIN1251. 1. Create exception: CREATE EXCEPTION EXC$CHECK_DATA 'Check data'; 2. Create procedure: CREATE OR ALTER PROCEDURE TEST_DO_EXCEPTION AS BEGIN EXCEPTION EXC$CHECK_DATA 'Исключение'; END 3. Throw...