Generated 03.10.2023 05:23
Tested: FB50. Build: 5.0.0.1236; SS: 03.10.23 03:41:42 - 03.10.23 04:25:23; CS: 03.10.23 04:27:13 - 03.10.23 05:20:53;
OS and hardware info: Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb
QA-software: Python 3.10.9, virtual env; pytest: 7.2.1; firebird.driver: 1.8.0; Firebird.Qa: 0.17.2
Jump to LIST of unique test names from this report
NN | Test name | mode | 5.0.0.1236 2023-10-03 |
5.0.0.1235 2023-10-01 |
5.0.0.1233 2023-09-29 |
5.0.0.1229 2023-09-27 |
5.0.0.1227 2023-09-26 |
5.0.0.1225 2023-09-25 |
5.0.0.1216 2023-09-16 |
5.0.0.1215 2023-09-15 |
5.0.0.1211 2023-09-14 |
5.0.0.1209 2023-09-13 |
5.0.0.1204 2023-09-12 |
5.0.0.1202 2023-09-11 |
5.0.0.1201 2023-09-09 |
5.0.0.1200 2023-09-08 |
5.0.0.1194 2023-09-07 |
5.0.0.1190 2023-09-06 |
5.0.0.1184 2023-09-05 |
5.0.0.1182 2023-09-02 |
5.0.0.1181 2023-08-31 |
5.0.0.1180 2023-08-30 |
5.0.0.1177 2023-08-29 |
5.0.0.1176 2023-08-27 |
5.0.0.1170 2023-08-25 |
5.0.0.1169 2023-08-24 |
5.0.0.1167 2023-08-21 |
5.0.0.1164 2023-08-16 |
5.0.0.1163 2023-08-14 |
5.0.0.1161 2023-08-11 |
5.0.0.1160 2023-08-10 |
5.0.0.1159 2023-08-09 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Count ( DISTINCT ... ) is too slow |
|
2 | SS | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Compress Data over the Network |
|
3 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Query plan is missing for the long query |
|
4 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Query plan is missing for the long query |
|
5 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Tricky index names can defeat the parsing logic when generating a human readable plan |
|
6 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Tricky index names can defeat the parsing logic when generating a human readable plan |
|
7 | SS | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | F | P | F | F | F | F | Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction |
|
8 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT |
|
9 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow implicit conversion between boolean and string |
|
10 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Allow implicit conversion between boolean and string |
|
11 | SS | P | P | P | P | P | P | P | P | P | P | F | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work |
|
12 | CS | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
13 | SS | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
14 | CS | P | P | P | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Available indices are not used in some cases if ORDER BY expression is a filtered one |
|
15 | SS | P | P | P | P | P | P | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Available indices are not used in some cases if ORDER BY expression is a filtered one |
|
16 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Unclear gstat's diagnostic when damaged page in DB file appears encrypted |
|
17 | SS | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | Parse error when compiling a statement causes memory leak until attachment is disconnected |
|
18 | CS | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | ORDER BY on index can cause suboptimal index choices |
|
19 | SS | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | ORDER BY on index can cause suboptimal index choices |
|
20 | SS | P | P | P | P | P | P | F | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | A number of errors when database name is longer than 255 symbols |
|
21 | SS | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | Wire compression causes freezes |
|
22 | CS | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ability to query Firebird configuration using SQL |
|
23 | SS | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Ability to query Firebird configuration using SQL |
|
24 | CS | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | System table with keywords |
|
25 | SS | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | System table with keywords |
|
26 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | F | P | P | P | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
27 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
28 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | SQL SECURITY DEFINER does not affect the ownership of created DDL objects |
|
29 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | SQL SECURITY DEFINER does not affect the ownership of created DDL objects |
|
30 | CS | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | PSQL and SQL profiler |
|
31 | SS | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | PSQL and SQL profiler |
|
32 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress |
|
33 | CS | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | Cost-based choice between nested loop join and hash join |
|
34 | SS | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | P | P | P | P | Cost-based choice between nested loop join and hash join |
|
35 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | P | P | P | P | P | P | P | P | X | X | X | X | X | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
36 | SS | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | P | P | P | P | P | P | P | P | X | X | X | X | X | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
37 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | X | X | X | X | X | Add COMPILE trace events for procedures/functions/triggers |
|
38 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | X | X | X | X | X | Add COMPILE trace events for procedures/functions/triggers |
|
39 | CS | F | 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 | Improvement on procedures/triggers to recognize changes in a domain used in COALESCE |
|
40 | SS | F | 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 | Improvement on procedures/triggers to recognize changes in a domain used in COALESCE |
|
41 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
42 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | P | P | P | P | P | P | P | P | P | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
43 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | Firebird 5 profiler error with subselects |
|
44 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | Firebird 5 profiler error with subselects |
|
45 | CS | F | 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 | CASE statement different result compared to FB 2.5.9 |
|
46 | SS | F | 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 | CASE statement different result compared to FB 2.5.9 |
|
47 | CS | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
48 | SS | P | P | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | X | X | X | X | X | X | X | X | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
49 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | Applying full DDL from OLTP-EMUL test on master with further check replica |
|
50 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | F | P | P | F | Crash or hang while shutting down the replica database if segments are being applied |
|
51 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | F | P | P | F | Some updates can crash Firebird server on replica side |
|
52 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | F | P | P | F | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
|
53 | CS | P | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Allow computable but non-invariant lists to be used for index lookup |
|
54 | SS | P | P | P | P | P | P | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Allow computable but non-invariant lists to be used for index lookup |
|
55 | CS | P | P | P | P | 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 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
56 | CS | P | P | P | S | S | S | F | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | P | F | F | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
57 | SS | P | P | P | S | S | S | P | P | P | F | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | F | P | P | P | P | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
58 | CS | P | P | P | P | P | P | P | F | F | F | F | F | P | F | P | P | P | P | F | P | P | F | F | F | F | P | F | P | F | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
59 | SS | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
60 | CS | P | P | P | P | P | F | F | P | F | P | P | F | F | F | P | F | F | P | F | P | F | F | F | P | F | P | F | F | F | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
61 | SS | P | P | P | P | P | F | P | P | P | F | P | P | P | P | P | F | P | F | P | P | P | F | P | P | P | F | P | P | F | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
62 | CS | P | P | P | P | P | F | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
63 | CS | P | P | P | P | P | P | F | F | F | P | P | F | F | P | P | F | F | F | P | P | F | P | P | P | P | P | F | P | F | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
64 | SS | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | F | P | P | F | P | P | F | P | P | P | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
65 | CS | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
66 | SS | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
67 | CS | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
|
68 | SS | P | P | P | P | P | P | P | P | P | P | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | F | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
NN | Test name | mode | median_ms | 5.0.0.1236 2023-10-03 |
5.0.0.1235 2023-10-01 |
5.0.0.1233 2023-09-29 |
5.0.0.1229 2023-09-27 |
5.0.0.1227 2023-09-26 |
5.0.0.1225 2023-09-25 |
5.0.0.1216 2023-09-16 |
5.0.0.1215 2023-09-15 |
5.0.0.1211 2023-09-14 |
5.0.0.1209 2023-09-13 |
5.0.0.1204 2023-09-12 |
5.0.0.1202 2023-09-11 |
5.0.0.1201 2023-09-09 |
5.0.0.1200 2023-09-08 |
5.0.0.1194 2023-09-07 |
5.0.0.1190 2023-09-06 |
5.0.0.1184 2023-09-05 |
5.0.0.1182 2023-09-02 |
5.0.0.1181 2023-08-31 |
5.0.0.1180 2023-08-30 |
5.0.0.1177 2023-08-29 |
5.0.0.1176 2023-08-27 |
5.0.0.1170 2023-08-25 |
5.0.0.1169 2023-08-24 |
5.0.0.1167 2023-08-21 |
5.0.0.1164 2023-08-16 |
5.0.0.1163 2023-08-14 |
5.0.0.1161 2023-08-11 |
5.0.0.1160 2023-08-10 |
5.0.0.1159 2023-08-09 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SS | 3109 | 2393 | 2325 | 2369 | 2379 | 2383 | 2330 | 4141 | 2976 | 2830 | 2711 | 4925 | 4054 | 4316 | 4089 | 4295 | 2915 | 4852 | 2860 | 4903 | 2835 | 3108 | 2773 | 4875 | 3045 | 3124 | 4323 | 3140 | 3110 | 3371 | 4701 | Count ( DISTINCT ... ) is too slow |
|
2 | SS | 51726 | 31767 | 31851 | 32187 | 31090 | 31404 | 31124 | 59874 | 55128 | 58207 | 42827 | 49191 | 47672 | 57041 | 58712 | 57349 | 51899 | 59322 | 54517 | 48159 | 57059 | 48174 | 59590 | 50246 | 51554 | 56720 | 53903 | 46696 | 60717 | 48790 | 64797 | Compress Data over the Network |
|
3 | CS | 1023 | 465 | 465 | 437 | 456 | 476 | 453 | 609 | 637 | 571 | 553 | 526 | 602 | 632 | 537 | 1032 | 1095 | 1015 | 2267 | 2163 | 2312 | 2408 | 2431 | 2405 | 2507 | 2324 | 2261 | 2253 | 1984 | 2362 | 2409 | Query plan is missing for the long query |
|
4 | SS | 851 | 279 | 286 | 267 | 291 | 292 | 271 | 433 | 436 | 525 | 458 | 543 | 448 | 480 | 467 | 840 | 862 | 915 | 2431 | 2583 | 2439 | 2797 | 3184 | 2902 | 2829 | 3156 | 1719 | 2859 | 2560 | 3079 | 2785 | Query plan is missing for the long query |
|
5 | CS | 445 | 385 | 356 | 367 | 388 | 372 | 378 | 422 | 446 | 508 | 460 | 435 | 446 | 437 | 457 | 454 | 433 | 460 | 459 | 447 | 445 | 427 | 468 | 455 | 484 | 418 | 410 | 494 | 461 | 443 | 445 | Tricky index names can defeat the parsing logic when generating a human readable plan |
|
6 | SS | 371 | 212 | 224 | 235 | 229 | 227 | 234 | 394 | 387 | 347 | 432 | 359 | 359 | 373 | 410 | 356 | 386 | 358 | 409 | 379 | 359 | 356 | 340 | 414 | 427 | 408 | 454 | 369 | 381 | 379 | 427 | Tricky index names can defeat the parsing logic when generating a human readable plan |
|
7 | SS | 10447 | 252 | 253 | 251 | 260 | 251 | 265 | 10481 | 10467 | 10457 | 10470 | 10470 | 10436 | 10298 | 10381 | 10496 | 10494 | 10395 | 10473 | 10496 | 10466 | 10531 | 10430 | 10468 | 254 | 10441 | 235 | 10461 | 10526 | 10443 | 10451 | Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction |
|
8 | CS | 18637 | 18401 | 18126 | 18317 | 18080 | 18578 | 18103 | 18710 | 18498 | 18812 | 18649 | 18693 | 18501 | 18653 | 18454 | 18538 | 18640 | 19001 | 18888 | 18851 | 18881 | 18765 | 18471 | 18986 | 18657 | 18463 | 18573 | 18634 | 19257 | 18609 | 18650 | Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT |
|
9 | CS | 513 | 388 | 410 | 423 | 384 | 444 | 379 | 542 | 550 | 498 | 473 | 576 | 490 | 536 | 486 | 536 | 541 | 554 | 533 | 531 | 525 | 503 | 489 | 523 | 586 | 461 | 528 | 548 | 492 | 428 | 544 | Allow implicit conversion between boolean and string |
|
10 | SS | 263 | 255 | 280 | 262 | 258 | 245 | 255 | 265 | 230 | 256 | 279 | 237 | 247 | 263 | 355 | 269 | 396 | 261 | 268 | 264 | 250 | 434 | 258 | 265 | 335 | 425 | 301 | 233 | 266 | 275 | 247 | Allow implicit conversion between boolean and string |
|
11 | SS | 5465 | 5451 | 5440 | 5428 | 5450 | 5482 | 5438 | 5467 | 5461 | 5429 | 5652 | 5434 | 5461 | 5466 | 4525 | 5464 | 5748 | 5487 | 5492 | 5495 | 5570 | 5801 | 5724 | 5450 | 5528 | 5723 | 5443 | 5496 | 5457 | 5448 | 5472 | Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work |
|
12 | CS | 636 | 533 | 518 | 560 | 548 | 542 | 532 | 629 | 691 | 545 | 611 | 673 | 638 | 673 | 604 | 594 | 583 | 655 | 676 | 697 | 636 | 750 | 592 | 637 | 653 | 607 | 677 | 658 | 684 | 654 | 643 | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
13 | SS | 352 | 355 | 350 | 371 | 340 | 349 | 336 | 382 | 356 | 354 | 335 | 550 | 411 | 337 | 576 | 319 | 550 | 376 | 306 | 564 | 325 | 567 | 346 | 343 | 429 | 539 | 347 | 348 | 416 | 328 | 334 | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
|
14 | CS | 510 | 386 | 424 | 411 | 387 | 428 | 403 | 595 | 432 | 528 | 484 | 546 | 535 | 515 | 521 | 519 | 488 | 526 | 515 | 486 | 560 | 473 | 523 | 508 | 492 | 493 | 537 | 530 | 513 | 499 | 526 | Available indices are not used in some cases if ORDER BY expression is a filtered one |
|
15 | SS | 278 | 276 | 265 | 289 | 269 | 271 | 260 | 390 | 303 | 264 | 448 | 236 | 451 | 465 | 233 | 422 | 259 | 247 | 244 | 246 | 247 | 502 | 284 | 281 | 299 | 387 | 245 | 503 | 289 | 458 | 271 | Available indices are not used in some cases if ORDER BY expression is a filtered one |
|
16 | CS | 689 | 503 | 547 | 559 | 590 | 564 | 522 | 743 | 710 | 642 | 689 | 702 | 759 | 696 | 717 | 690 | 729 | 763 | 705 | 698 | 730 | 676 | 673 | 695 | 683 | 670 | 655 | 679 | 633 | 698 | 743 | Unclear gstat's diagnostic when damaged page in DB file appears encrypted |
|
17 | SS | 481 | 467 | 480 | 521 | 482 | 463 | 484 | 450 | 724 | 446 | 893 | 467 | 505 | 394 | 394 | 492 | 483 | 815 | 394 | 595 | 813 | 473 | 460 | 402 | 592 | 440 | 481 | 723 | 757 | 815 | 418 | Parse error when compiling a statement causes memory leak until attachment is disconnected |
|
18 | CS | 470 | 457 | 461 | 475 | 420 | 474 | 470 | 550 | 633 | 583 | 591 | 482 | 535 | 549 | 471 | 412 | 467 | 499 | 464 | 480 | 414 | 470 | 474 | 475 | 441 | 415 | 442 | 401 | 458 | 494 | 453 | ORDER BY on index can cause suboptimal index choices |
|
19 | SS | 288 | 286 | 266 | 276 | 250 | 263 | 267 | 283 | 288 | 262 | 450 | 304 | 236 | 327 | 369 | 288 | 242 | 433 | 298 | 444 | 352 | 386 | 413 | 242 | 272 | 230 | 278 | 385 | 398 | 362 | 362 | ORDER BY on index can cause suboptimal index choices |
|
20 | SS | 6276 | 5879 | 5898 | 5866 | 5821 | 5932 | 5876 | 7550 | 6044 | 6344 | 7763 | 10215 | 6078 | 6757 | 6044 | 10244 | 6122 | 6586 | 6156 | 6148 | 10495 | 6358 | 6022 | 6300 | 6881 | 8165 | 6847 | 6124 | 6298 | 6320 | 6255 | A number of errors when database name is longer than 255 symbols |
|
21 | SS | 54192 | 46010 | 46671 | 47066 | 44084 | 45605 | 44235 | 46504 | 54437 | 63960 | 58607 | 53947 | 49681 | 74093 | 53414 | 46727 | 73416 | 68807 | 56512 | 44539 | 53186 | 58024 | 13019 | 65666 | 70806 | 65349 | 70835 | 56967 | 43871 | 66935 | 68452 | Wire compression causes freezes |
|
22 | CS | 441 | 387 | 388 | 371 | 369 | 352 | 358 | 459 | 421 | 443 | 494 | 451 | 446 | 440 | 462 | 478 | 512 | 465 | 440 | 424 | 435 | 473 | 474 | 479 | 489 | 417 | 463 | 398 | 436 | 466 | 414 | Ability to query Firebird configuration using SQL |
|
23 | SS | 267 | 224 | 238 | 203 | 230 | 209 | 204 | 269 | 365 | 214 | 277 | 305 | 236 | 258 | 265 | 262 | 288 | 299 | 244 | 265 | 273 | 373 | 322 | 214 | 318 | 272 | 276 | 395 | 242 | 366 | 366 | Ability to query Firebird configuration using SQL |
|
24 | CS | 447 | 379 | 354 | 377 | 362 | 368 | 367 | 518 | 486 | 509 | 482 | 512 | 445 | 436 | 472 | 422 | 527 | 476 | 424 | 463 | 414 | 520 | 482 | 477 | 433 | 459 | 446 | 440 | 416 | 449 | 462 | System table with keywords |
|
25 | SS | 260 | 216 | 250 | 217 | 231 | 232 | 233 | 267 | 371 | 210 | 272 | 344 | 217 | 269 | 266 | 254 | 289 | 311 | 222 | 350 | 334 | 228 | 389 | 203 | 300 | 294 | 262 | 223 | 252 | 370 | 259 | System table with keywords |
|
26 | CS | 5468 | 4365 | 4189 | 4357 | 4156 | 4213 | 4253 | 5117 | 5640 | 5317 | 6031 | 5947 | 5938 | 4872 | 5168 | 5683 | 6341 | 5665 | 6112 | 6186 | 6428 | 5691 | 6276 | 5121 | 5440 | 5337 | 5756 | 5382 | 5497 | 5995 | 5167 | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
27 | SS | 5175 | 4229 | 3953 | 4034 | 4039 | 3947 | 4039 | 5159 | 6679 | 5086 | 4683 | 5816 | 5472 | 4780 | 6567 | 4804 | 6767 | 5295 | 5534 | 5719 | 5347 | 5593 | 4928 | 5997 | 4987 | 5192 | 4678 | 5666 | 5436 | 5581 | 5103 | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
28 | CS | 816 | 672 | 654 | 631 | 635 | 635 | 634 | 782 | 727 | 910 | 892 | 831 | 723 | 797 | 827 | 819 | 896 | 780 | 848 | 855 | 867 | 828 | 843 | 824 | 907 | 804 | 780 | 798 | 880 | 874 | 814 | SQL SECURITY DEFINER does not affect the ownership of created DDL objects |
|
29 | SS | 482 | 394 | 388 | 389 | 342 | 372 | 370 | 459 | 475 | 496 | 447 | 512 | 480 | 517 | 498 | 478 | 516 | 513 | 481 | 508 | 488 | 551 | 484 | 587 | 533 | 462 | 481 | 511 | 589 | 471 | 519 | SQL SECURITY DEFINER does not affect the ownership of created DDL objects |
|
30 | CS | 773 | 561 | 675 | 636 | 644 | 655 | 659 | 698 | 824 | 732 | 949 | 957 | 747 | 659 | 810 | 744 | 794 | 743 | 786 | 721 | 744 | 864 | 760 | 786 | 801 | 1104 | 969 | 1042 | 1039 | 1145 | 1031 | PSQL and SQL profiler |
|
31 | SS | 590 | 473 | 594 | 514 | 475 | 523 | 491 | 646 | 601 | 571 | 689 | 650 | 619 | 573 | 587 | 519 | 583 | 597 | 538 | 530 | 572 | 515 | 550 | 615 | 599 | 817 | 993 | 918 | 916 | 869 | 850 | PSQL and SQL profiler |
|
32 | CS | 3700 | 3455 | 3360 | 3315 | 3355 | 2557 | 3338 | 3879 | 3739 | 3759 | 2673 | 3818 | 2673 | 3592 | 3604 | 3829 | 3085 | 3704 | 3704 | 3813 | 3774 | 3765 | 3792 | 2909 | 3697 | 3804 | 3704 | 3791 | 3624 | 3823 | 2864 | DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress |
|
33 | CS | 1880 | 1618 | 1529 | 1541 | 1561 | 1532 | 1513 | 1806 | 1778 | 1872 | 1857 | 1906 | 1901 | 1688 | 1830 | 1810 | 1937 | 1945 | 2014 | 2005 | 2063 | 2011 | 1944 | 1674 | 1999 | 1837 | 1888 | 1998 | 1973 | 2086 | 1904 | Cost-based choice between nested loop join and hash join |
|
34 | SS | 1227 | 1078 | 1044 | 996 | 978 | 1201 | 984 | 1202 | 1235 | 1220 | 1263 | 1100 | 1361 | 1181 | 1155 | 1147 | 1220 | 1163 | 1352 | 1408 | 1368 | 1497 | 1355 | 1466 | 1399 | 1180 | 1292 | 1301 | 1431 | 1461 | 1456 | Cost-based choice between nested loop join and hash join |
|
35 | CS | 2878 | 2532 | 2552 | 2574 | 2526 | 2539 | 2551 | 2888 | 2914 | 2942 | 2874 | 2861 | 2891 | 2899 | 2874 | 2892 | 2910 | 2925 | 2878 | 2648 | 2610 | 2913 | 2883 | 2679 | 2899 | 2882 | 0 | 0 | 0 | 0 | 0 | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
36 | SS | 2433 | 2413 | 2404 | 2410 | 2422 | 2433 | 2410 | 2491 | 2452 | 2447 | 2487 | 2444 | 2448 | 2429 | 2394 | 2418 | 2456 | 2419 | 2451 | 2444 | 2457 | 2410 | 2432 | 2434 | 2433 | 2456 | 0 | 0 | 0 | 0 | 0 | Add COMPILE trace events - ability to see execution plan of every PSQL statement. |
|
37 | CS | 2877 | 2809 | 2802 | 2785 | 2776 | 2787 | 2792 | 2908 | 2904 | 2876 | 2854 | 3169 | 2885 | 2886 | 2913 | 2932 | 2841 | 2916 | 2856 | 2883 | 2888 | 2892 | 2935 | 2858 | 2845 | 2877 | 0 | 0 | 0 | 0 | 0 | Add COMPILE trace events for procedures/functions/triggers |
|
38 | SS | 2687 | 2399 | 2391 | 2417 | 2384 | 2388 | 2384 | 2709 | 2709 | 2717 | 2671 | 2715 | 2653 | 2687 | 2693 | 2701 | 2677 | 2682 | 2710 | 2670 | 2701 | 2710 | 2694 | 2697 | 2679 | 2711 | 0 | 0 | 0 | 0 | 0 | Add COMPILE trace events for procedures/functions/triggers |
|
39 | CS | 408 | 408 | 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 | Improvement on procedures/triggers to recognize changes in a domain used in COALESCE |
|
40 | SS | 229 | 229 | 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 | Improvement on procedures/triggers to recognize changes in a domain used in COALESCE |
|
41 | CS | 7855 | 6752 | 6671 | 6705 | 6654 | 7158 | 6923 | 7651 | 7870 | 7914 | 7685 | 7864 | 7662 | 7847 | 7571 | 7654 | 7801 | 7747 | 7784 | 8436 | 8492 | 8605 | 8877 | 8309 | 8637 | 8445 | 8558 | 8527 | 8582 | 8416 | 8516 | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
42 | SS | 5966 | 5098 | 5103 | 5041 | 5111 | 5228 | 5075 | 5951 | 6033 | 5981 | 5925 | 5621 | 5938 | 5944 | 5617 | 5873 | 5755 | 6010 | 5705 | 6434 | 6189 | 6244 | 6366 | 6546 | 6327 | 6178 | 6348 | 6359 | 6660 | 6428 | 6531 | SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset |
|
43 | CS | 757 | 643 | 648 | 652 | 670 | 661 | 646 | 826 | 790 | 852 | 962 | 1006 | 771 | 760 | 718 | 769 | 773 | 765 | 783 | 750 | 735 | 762 | 754 | 798 | 771 | 723 | 728 | 726 | 743 | 724 | 766 | Firebird 5 profiler error with subselects |
|
44 | SS | 492 | 423 | 458 | 430 | 416 | 472 | 433 | 561 | 534 | 525 | 563 | 607 | 531 | 527 | 478 | 491 | 493 | 467 | 466 | 473 | 544 | 492 | 468 | 531 | 544 | 406 | 523 | 537 | 497 | 531 | 461 | Firebird 5 profiler error with subselects |
|
45 | CS | 359 | 359 | 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 | CASE statement different result compared to FB 2.5.9 |
|
46 | SS | 237 | 237 | 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 | CASE statement different result compared to FB 2.5.9 |
|
47 | CS | 720 | 672 | 614 | 649 | 602 | 566 | 596 | 829 | 824 | 836 | 829 | 1035 | 712 | 713 | 746 | 718 | 786 | 735 | 722 | 749 | 700 | 725 | 661 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
48 | SS | 544 | 482 | 491 | 485 | 461 | 469 | 480 | 635 | 611 | 660 | 604 | 729 | 526 | 547 | 578 | 591 | 542 | 567 | 538 | 573 | 559 | 538 | 525 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW |
|
49 | CS | 47291 | 33191 | 33790 | 35692 | 33062 | 33888 | 32934 | 37459 | 37322 | 44759 | 49120 | 45463 | 36059 | 30609 | 30851 | 35949 | 33214 | 159464 | 157078 | 157589 | 156920 | 158003 | 157806 | 156695 | 157491 | 155633 | 158522 | 158270 | 160632 | 158861 | 160645 | Applying full DDL from OLTP-EMUL test on master with further check replica |
|
50 | CS | 13395 | 13995 | 13778 | 13970 | 13269 | 13521 | 13996 | 14265 | 13759 | 14139 | 14414 | 13917 | 16634 | 14104 | 16516 | 14067 | 14189 | 4915 | 4679 | 4700 | 4722 | 5008 | 4966 | 4653 | 4764 | 2309 | 4500 | 2461 | 4914 | 4680 | 2388 | Crash or hang while shutting down the replica database if segments are being applied |
|
51 | CS | 6163 | 6465 | 6540 | 6521 | 6526 | 6530 | 6533 | 6773 | 6854 | 6844 | 6723 | 6884 | 6779 | 6900 | 5862 | 6838 | 6863 | 1723 | 2730 | 2660 | 2741 | 1804 | 1743 | 1670 | 2714 | 624 | 1781 | 682 | 3815 | 1656 | 730 | Some updates can crash Firebird server on replica side |
|
52 | CS | 5584 | 6463 | 5453 | 6433 | 6475 | 6536 | 6486 | 5757 | 5788 | 5727 | 5769 | 5716 | 5825 | 5815 | 6931 | 5727 | 5778 | 1756 | 1771 | 1753 | 1724 | 1842 | 1731 | 1777 | 1690 | 177 | 1795 | 228 | 1676 | 1710 | 226 | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
|
53 | CS | 552 | 447 | 491 | 471 | 437 | 438 | 425 | 585 | 604 | 578 | 552 | 591 | 569 | 633 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Allow computable but non-invariant lists to be used for index lookup |
|
54 | SS | 289 | 281 | 285 | 280 | 249 | 244 | 277 | 330 | 289 | 317 | 389 | 312 | 323 | 334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Allow computable but non-invariant lists to be used for index lookup |
|
55 | CS | 4347 | 6744 | 6756 | 6777 | 6531 | 6760 | 3415 | 4369 | 4480 | 4337 | 4370 | 4366 | 4362 | 4313 | 4349 | 4334 | 4338 | 4292 | 4255 | 4332 | 4261 | 4334 | 4346 | 4320 | 4357 | 4357 | 4282 | 4343 | 4246 | 4359 | 4395 | READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01 |
|
56 | CS | 28887 | 47440 | 47607 | 46827 | 0 | 1910 | -1 | 29128 | 28943 | 29078 | 29065 | 29143 | 28874 | 28869 | 28885 | 28776 | 28832 | 28863 | 28910 | 28885 | 29010 | 29258 | 28867 | 29081 | 28576 | 28781 | 28093 | 28362 | 28890 | 28847 | 29232 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
57 | SS | 26513 | 42938 | 42914 | 43464 | 5922 | 1482 | 2 | 26539 | 26549 | 26893 | 26117 | 26488 | 26299 | 26652 | 26603 | 26579 | 26244 | 26626 | 26389 | 26077 | 26453 | 26716 | 26616 | 26983 | 26476 | 26034 | 26607 | 26266 | 26566 | 26010 | 26242 | READ CONSISTENCY. Maximal number of statement-level restarts must be 10. |
|
58 | CS | 3763 | 6762 | 6725 | 6670 | 6676 | 6706 | 1892 | 3855 | 3684 | 3669 | 3859 | 3769 | 3695 | 3844 | 3818 | 3748 | 3820 | 3836 | 3650 | 3643 | 3677 | 3798 | 3758 | 3592 | 3709 | 3698 | 3602 | 3681 | 3796 | 3736 | 3816 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
59 | SS | 3299 | 5935 | 5924 | 5945 | 5912 | 5952 | 1417 | 3266 | 3245 | 3368 | 3253 | 3353 | 3376 | 3259 | 3317 | 3282 | 3334 | 3164 | 3210 | 3312 | 3272 | 3239 | 3312 | 3290 | 3242 | 3162 | 3309 | 3244 | 3313 | 3266 | 3340 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04. |
|
60 | CS | 3723 | 6785 | 6645 | 6687 | 6647 | 6731 | 1859 | 3608 | 3740 | 3778 | 3528 | 3738 | 3696 | 3772 | 3784 | 3919 | 3630 | 3715 | 3666 | 3675 | 3725 | 3752 | 3722 | 3639 | 3629 | 3795 | 3642 | 3667 | 3692 | 3617 | 3782 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
61 | SS | 3310 | 5948 | 5973 | 5944 | 5959 | 5929 | 1481 | 3424 | 3283 | 3318 | 3323 | 3357 | 3328 | 3312 | 3173 | 3313 | 3308 | 3259 | 3305 | 3290 | 3326 | 3291 | 3261 | 3291 | 3259 | 3239 | 3228 | 3288 | 3253 | 3362 | 3313 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04. |
|
62 | CS | 3699 | 6682 | 6741 | 6754 | 6697 | 6734 | 7201237 | 2 | 3884 | 2 | 3763 | 3 | 7 | 0 | 7203016 | 3794 | 3672 | 3801 | 0 | 3727 | 0 | 8 | 3726 | 6 | 3609 | 5 | 1 | 3631 | 3669 | 0 | 2 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02. |
|
63 | CS | 3724 | 6725 | 6695 | 6639 | 6702 | 6700 | 6846 | 3778 | 3743 | 3676 | 3676 | 3704 | 3704 | 3722 | 3655 | 3717 | 3807 | 3774 | 3667 | 3689 | 3699 | 3726 | 3675 | 3767 | 3652 | 3684 | 3740 | 3778 | 3687 | 3738 | 3717 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
64 | SS | 3294 | 5892 | 5946 | 5872 | 5907 | 5900 | 5927 | 3273 | 3291 | 3384 | 3383 | 3250 | 3272 | 3294 | 3294 | 3309 | 3386 | 3248 | 3174 | 3262 | 3348 | 3382 | 3262 | 3309 | 3265 | 3241 | 3419 | 3272 | 3274 | 3267 | 3259 | READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04. |
|
65 | CS | 5643 | 5599 | 5555 | 5603 | 5612 | 5579 | 5584 | 5948 | 5905 | 5841 | 5836 | 5642 | 5645 | 5627 | 5761 | 5959 | 5624 | 5767 | 5681 | 5575 | 5622 | 5640 | 5664 | 5588 | 5652 | 5621 | 5615 | 5726 | 5683 | 5683 | 5848 | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
66 | SS | 5103 | 5034 | 5087 | 5069 | 5056 | 5066 | 5084 | 5237 | 5311 | 5141 | 5321 | 5160 | 5183 | 5138 | 5067 | 5078 | 5101 | 5065 | 5143 | 5125 | 5063 | 5089 | 4970 | 5127 | 5156 | 5078 | 5150 | 5109 | 5067 | 5105 | 5165 | ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration |
|
67 | CS | 3472 | 3339 | 3418 | 3372 | 3318 | 3341 | 3400 | 3754 | 3554 | 3695 | 3613 | 3498 | 3474 | 3494 | 3470 | 3510 | 3471 | 3501 | 3460 | 3403 | 3520 | 3484 | 3474 | 3483 | 3444 | 3419 | 3485 | 3458 | 3471 | 3432 | 3519 | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |
|
68 | SS | 2944 | 2876 | 2892 | 2902 | 2851 | 2925 | 2881 | 3022 | 3061 | 3061 | 3042 | 2975 | 3035 | 2960 | 2992 | 2933 | 2943 | 2877 | 2946 | 2986 | 2896 | 2973 | 2931 | 2908 | 2953 | 2917 | 2904 | 2874 | 2964 | 2979 | 2972 | ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true |