| NN | Test name | mode |
4.0.7.3238
|
4.0.7.3237
|
4.0.7.3236
|
4.0.7.3235
|
4.0.7.3234
|
4.0.7.3233
|
4.0.7.3232
|
4.0.7.3231
|
4.0.7.3230
|
4.0.7.3229
|
4.0.6.3228
|
4.0.6.3227
|
4.0.6.3223
|
4.0.6.3222
|
4.0.6.3221
|
4.0.6.3220
|
4.0.6.3219
|
4.0.6.3215
|
4.0.6.3214
|
4.0.6.3213
|
4.0.6.3212
|
4.0.6.3208
|
4.0.6.3207
|
4.0.6.3206
|
4.0.6.3205
|
4.0.6.3204
|
4.0.6.3203
|
4.0.6.3200
|
4.0.6.3199
|
4.0.6.3198
|
4.0.6.3195
|
4.0.6.3194
|
4.0.6.3193
|
4.0.6.3192
|
4.0.6.3191
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ALL | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Postfix for #8113: UNION ALL optimization with constant false condition. |
|
| 2 | ALL | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Regression in 6.x: query with "... where <field> in ( <scalar_value> | <scalar_func>, null )" returns empty rowset instead of existing record |
|
| 3 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob. |
|
| 4 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
| 5 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
|
| 6 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Problem with replication of BLOB segments longer than 32KB |
|
| 7 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert |
|
| 8 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica |
|
| 9 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DDL-triggers must fire only on master DB |
|
| 10 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Disallow replication of RDB$BACKUP_HISTORY |
|
| 11 | CS | P | F | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Replicator could produce log segments with duplicated segment numbers |
|
| 12 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
|
| 13 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Failed DDL commands can be replicated |
|
| 14 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Generator values may not replicate after commit |
|
| 15 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DDL-Changes in replication does not set the correct grantor |
|
| 16 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
|
| 17 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Make asynchronous replica re-initialization reliable #8324 |
|
| 18 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Applying full DDL from OLTP-EMUL test on master with further check replica |
|
| 19 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Permission error with replication |
|
| 20 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Crash or hang while shutting down the replica database if segments are being applied |
|
| 21 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Some updates can crash Firebird server on replica side |
|
| 22 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
| NN | Test name | mode | median_ms |
4.0.7.3238
|
4.0.7.3237
|
4.0.7.3236
|
4.0.7.3235
|
4.0.7.3234
|
4.0.7.3233
|
4.0.7.3232
|
4.0.7.3231
|
4.0.7.3230
|
4.0.7.3229
|
4.0.6.3228
|
4.0.6.3227
|
4.0.6.3223
|
4.0.6.3222
|
4.0.6.3221
|
4.0.6.3220
|
4.0.6.3219
|
4.0.6.3215
|
4.0.6.3214
|
4.0.6.3213
|
4.0.6.3212
|
4.0.6.3208
|
4.0.6.3207
|
4.0.6.3206
|
4.0.6.3205
|
4.0.6.3204
|
4.0.6.3203
|
4.0.6.3200
|
4.0.6.3199
|
4.0.6.3198
|
4.0.6.3195
|
4.0.6.3194
|
4.0.6.3193
|
4.0.6.3192
|
4.0.6.3191
|
Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS | 633 | 633 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Postfix for #8113: UNION ALL optimization with constant false condition. |
|
| 2 | SS | 461 | 461 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Postfix for #8113: UNION ALL optimization with constant false condition. |
|
| 3 | CS | 662 | 662 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression in 6.x: query with "... where <field> in ( <scalar_value> | <scalar_func>, null )" returns empty rowset instead of existing record |
|
| 4 | SS | 465 | 465 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regression in 6.x: query with "... where <field> in ( <scalar_value> | <scalar_func>, null )" returns empty rowset instead of existing record |
|
| 5 | CS | 10001 | 8685 | 148021 | 10693 | 10949 | 8678 | 9699 | 10863 | 10977 | 9880 | 8530 | 9537 | 9700 | 9478 | 10445 | 10679 | 8620 | 10001 | 8525 | 8822 | 10665 | 10589 | 8773 | 10007 | 10210 | 9208 | 11002 | 10963 | 10933 | 9072 | 10020 | 10829 | 9637 | 11281 | 9495 | 9518 | Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob. |
|
| 6 | CS | 9202 | 9182 | 67938 | 9180 | 9137 | 9276 | 9181 | 9210 | 9432 | 9406 | 9202 | 9217 | 9271 | 9108 | 9195 | 9284 | 9284 | 9173 | 9025 | 9167 | 9246 | 9129 | 8699 | 8638 | 9483 | 9607 | 8360 | 8735 | 8681 | 9587 | 9130 | 9310 | 9230 | 8592 | 12918 | 12603 | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
| 7 | CS | 12369 | 12006 | 68105 | 12950 | 15036 | 12210 | 12363 | 12369 | 12662 | 12138 | 13119 | 12502 | 12170 | 11965 | 12485 | 12334 | 12176 | 11925 | 12602 | 12802 | 12260 | 12169 | 12236 | 12261 | 12106 | 12717 | 12712 | 13051 | 12642 | 11843 | 13101 | 12398 | 12995 | 12572 | 8443 | 9226 | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
|
| 8 | CS | 9141 | 7150 | 70008 | 9141 | 9755 | 9287 | 9818 | 8812 | 9229 | 6644 | 8726 | 8814 | 9569 | 6985 | 9191 | 8891 | 6791 | 9786 | 9062 | 8753 | 9472 | 9473 | 9333 | 9396 | 9785 | 8625 | 9670 | 8383 | 9349 | 9611 | 8817 | 9106 | 9072 | 9434 | 6831 | 5828 | Problem with replication of BLOB segments longer than 32KB |
|
| 9 | CS | 6515 | 5766 | 66556 | 5634 | 6409 | 6530 | 5560 | 6519 | 5593 | 6563 | 6535 | 6539 | 6515 | 6462 | 5626 | 6491 | 6488 | 6510 | 5615 | 6557 | 6608 | 6572 | 6794 | 6903 | 5753 | 6863 | 6728 | 6858 | 5805 | 6785 | 5755 | 6679 | 5588 | 6866 | 5979 | 5903 | Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert |
|
| 10 | CS | 5890 | 5911 | 67738 | 5700 | 6353 | 5699 | 6790 | 6650 | 6737 | 5558 | 5661 | 5612 | 5606 | 5540 | 6629 | 5722 | 5632 | 5764 | 6551 | 5614 | 5720 | 5617 | 5858 | 6066 | 5922 | 5945 | 5825 | 5927 | 5890 | 6019 | 6628 | 5794 | 6640 | 5847 | 6682 | 6525 | Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica |
|
| 11 | CS | 6546 | 6322 | 68494 | 7287 | 9502 | 7217 | 6258 | 6104 | 6287 | 6250 | 6226 | 7282 | 7287 | 6102 | 6222 | 7219 | 6074 | 7117 | 6111 | 7292 | 6113 | 7273 | 6556 | 6730 | 7558 | 6667 | 6546 | 6441 | 7520 | 6594 | 6198 | 6273 | 6201 | 6546 | 5877 | 6905 | DDL-triggers must fire only on master DB |
|
| 12 | CS | 5828 | 6619 | 67640 | 5664 | 6178 | 5497 | 5633 | 6556 | 5693 | 6726 | 6541 | 5624 | 5525 | 6410 | 6451 | 5605 | 6523 | 5507 | 6481 | 5584 | 6452 | 5547 | 6731 | 5828 | 5838 | 5842 | 5668 | 5827 | 5764 | 5723 | 5577 | 6628 | 5679 | 5826 | 9528 | 8710 | Disallow replication of RDB$BACKUP_HISTORY |
|
| 13 | CS | 6560 | 5598 | 67645 | 6560 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Replicator could produce log segments with duplicated segment numbers |
|
| 14 | CS | 9297 | 9430 | 67674 | 9298 | 9141 | 9421 | 9417 | 9129 | 9436 | 9364 | 9115 | 9210 | 9340 | 9060 | 9218 | 9188 | 8980 | 9297 | 9114 | 9081 | 9111 | 9194 | 8545 | 9478 | 8734 | 9578 | 9366 | 9538 | 9515 | 9478 | 9340 | 9422 | 9260 | 9789 | 5698 | 5824 | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
|
| 15 | CS | 6459 | 5711 | 67679 | 5670 | 6354 | 6687 | 6557 | 5500 | 5634 | 5606 | 6622 | 6717 | 6624 | 6365 | 5670 | 6572 | 6459 | 6524 | 5650 | 6499 | 6534 | 6526 | 6791 | 5839 | 6759 | 5769 | 5790 | 5837 | 5753 | 5899 | 6745 | 5714 | 6553 | 5747 | 6696 | 6797 | Failed DDL commands can be replicated |
|
| 16 | CS | 5718 | 6551 | 67561 | 5625 | 6127 | 5649 | 5511 | 6503 | 6597 | 6449 | 5383 | 5517 | 5385 | 6358 | 6362 | 5432 | 5380 | 5413 | 6344 | 5354 | 5379 | 5404 | 5678 | 5718 | 5564 | 6531 | 6589 | 6628 | 6781 | 5701 | 5582 | 6425 | 5542 | 6609 | 9632 | 9767 | Generator values may not replicate after commit |
|
| 17 | CS | 6857 | 6201 | 68072 | 7463 | 9486 | 7203 | 7038 | 6121 | 6019 | 6055 | 7075 | 6041 | 7028 | 5898 | 5991 | 6904 | 6791 | 6857 | 5951 | 7007 | 7202 | 6858 | 6534 | 6385 | 6381 | 6673 | 6444 | 6883 | 9734 | 6390 | 7239 | 6054 | 7273 | 6491 | 11926 | 12064 | DDL-Changes in replication does not set the correct grantor |
|
| 18 | CS | 12666 | 12809 | 135025 | 11733 | 12384 | 11668 | 12651 | 12610 | 12707 | 12730 | 12618 | 12651 | 12659 | 12630 | 12683 | 12638 | 12726 | 12632 | 13612 | 12666 | 12620 | 12780 | 12898 | 12985 | 12923 | 11871 | 12803 | 11858 | 12026 | 12892 | 11746 | 12705 | 12603 | 12842 | 103115 | 99915 | Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set |
|
| 19 | CS | 99573 | 100417 | 66625 | 103192 | 101024 | 99909 | 98694 | 99237 | 99621 | 99610 | 98670 | 99531 | 98619 | 99635 | 99527 | 98680 | 99232 | 98924 | 101846 | 98463 | 104920 | 98739 | 99573 | 100002 | 99700 | 100105 | 99808 | 99799 | 99488 | 99990 | 98954 | 99299 | 102467 | 101758 | 42217 | 45890 | Make asynchronous replica re-initialization reliable #8324 |
|
| 20 | CS | 37599 | 42514 | 104209 | 42150 | 54190 | 38896 | 35970 | 36251 | 38492 | 36059 | 35842 | 36159 | 35771 | 34767 | 34926 | 35661 | 35456 | 35986 | 37599 | 36173 | 35945 | 35916 | 39564 | 40224 | 40329 | 48985 | 46252 | 43136 | 42129 | 45921 | 36750 | 38623 | 43617 | 43585 | 7308 | 6333 | Applying full DDL from OLTP-EMUL test on master with further check replica |
|
| 21 | CS | 6185 | 6056 | 67923 | 7149 | 6986 | 5975 | 5969 | 6015 | 6150 | 6158 | 5794 | 5908 | 6085 | 6914 | 7104 | 6859 | 5971 | 5921 | 6920 | 5942 | 5875 | 5914 | 6160 | 6261 | 6185 | 6256 | 6280 | 6313 | 6223 | 6355 | 6023 | 7057 | 5978 | 6309 | 16766 | 16727 | Permission error with replication |
|
| 22 | CS | 14117 | 14511 | 16857 | 16653 | 17365 | 13773 | 13816 | 14200 | 13820 | 13725 | 14389 | 13952 | 14008 | 13685 | 13316 | 13787 | 14527 | 14535 | 16790 | 13877 | 14236 | 14110 | 14232 | 16708 | 14101 | 14391 | 14117 | 16729 | 14658 | 14089 | 13888 | 13678 | 14215 | 16471 | 6720 | 6657 | Crash or hang while shutting down the replica database if segments are being applied |
|
| 23 | CS | 6504 | 6499 | 67347 | 6485 | 7125 | 6482 | 6369 | 6504 | 6640 | 6581 | 6391 | 6496 | 6408 | 6474 | 6545 | 6439 | 6426 | 6528 | 6375 | 6412 | 6405 | 6475 | 6798 | 6724 | 6722 | 6776 | 6617 | 6655 | 6692 | 6698 | 6532 | 6539 | 6497 | 6825 | 5821 | 5636 | Some updates can crash Firebird server on replica side |
|
| 24 | CS | 6415 | 6542 | 67520 | 5539 | 6070 | 6517 | 6424 | 6401 | 6492 | 5518 | 6470 | 6423 | 6441 | 6607 | 6436 | 6466 | 6467 | 6448 | 6396 | 6457 | 6576 | 6415 | 5653 | 5647 | 5762 | 5695 | 5804 | 5617 | 5693 | 5700 | 6475 | 6525 | 6391 | 5733 | 722 | 714 | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |