01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
03. NEW FAILS: tests which failed for LAST run (4 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (10 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (0 rows)
[CURRENT] 06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (50 rows)
07. Has fails: tests with at least one fail for previous 30 runs (125 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (704 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (2 rows)
11. All tests: outcomes for previous 30 runs (3202 rows)
12. Skipped: tests which was intentionally excluded from execution (67 rows)

Generated UTC 20.11.2024 11:28
Tested: HQ40.   Build / date: 4.0.6.3163-832dbff1 / 2024.10.30;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.6; firebird.Qa: 0.19.3 
Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Performance slowdown for more than 5 recent runs - moving medians

At least 2 recent moving medians (window = 5) greater than "normal" for at least 1.33x. No more than 50 rows are shown, pre-filtered in descending order of ratio between latest and "normal" medians:
NN Test name mode Test last update Moving medians chart
4.0.6.3163
2024.10.30
832db
4.0.6.3163
2024.10.16
2bb10
4.0.6.3147
2024.09.10
a4d11
4.0.6.3147
2024.08.31
4655b
4.0.6.3140
2024.08.16
1dd8b
4.0.6.3140
2024.08.09
34747
4.0.5.3110
2024.08.06
f851c
4.0.5.3110
2024.07.30
c6527
4.0.5.3109
2024.06.11
6addf
4.0.5.3097
2024.05.09
27fa6
4.0.5.3091
2024.04.29
bd0aa
4.0.5.3089
2024.04.20
9eb9b
4.0.5.3083
2024.04.06
300f9
4.0.5.3052
2024.03.16
0f422
4.0.5.3052
2024.03.16
ce273
4.0.5.3052
2024.02.12
cd058
4.0.5.3052
2024.02.07
be290
4.0.5.3052
2024.02.07
6409b
4.0.5.3052
2024.02.02
bbc3f
4.0.5.3052
2024.01.26
48b7c
4.0.5.3052
2024.01.26
9a7b3
4.0.5.3049
2024.01.25
f6b9d
4.0.5.3049
2024.01.08
b67ce
4.0.5.3049
2024.01.08
97577
4.0.5.3049
2024.01.05
2d8b0
4.0.5.3049
2024.01.04
431e5
Test TITLE
1
bugs core 1859 
 tracker
 SS 2022.02.02 14:46
414 416 440 440 440 338 330 234 234 234 234 234 233 219 218 218 218 218 233 233 264 264 264 234 234 234
Arithmetic overflow or division by zero has occurred. in MAX function
2
bugs core 2200 
 tracker
 SS 2022.02.02 14:46
771 771 771 771 771 349 313 251 250 250 250 235 234 234 233 233 233 233 234 234 280 280 280 234 233 233
Extremely slow executing a cross join of 3 tables in Firebird 2.X
3
bugs core 2211 
 tracker
 SS 2022.02.02 14:46
709 694 678 629 599 496 364 282 266 266 266 250 249 249 249 249 249 249 249 249 296 296 296 249 249 249
Offset value for SUBSTRING from BLOB more than 32767 makes exception
4
bugs core 2416 
 tracker
 SS 2022.02.02 14:46
436 445 458 458 436 334 314 235 235 234 234 219 218 218 217 217 218 218 218 218 265 265 265 218 218 218
AV preparing a query with aggregate over derived table
5
bugs core 3000 
 tracker
 SS 2022.02.02 14:46
448 448 448 448 445 342 312 219 219 219 219 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
Error on delete user "ADMIN"
6
bugs core 3553 
 tracker
 SS 2022.04.08 11:16
426 426 439 439 439 333 315 235 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
7
bugs core 3925 
 tracker
 SS 2022.02.02 14:46
412 447 447 447 447 338 321 234 234 234 234 234 234 234 233 233 233 233 233 233 265 265 265 233 233 233
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
8
bugs core 3977 
 tracker
 SS 2023.12.12 17:11
1843 1843 1892 1892 1892 1775 1757 1626 1625 1625 1625 594 593 593 593 593 593 593 593 593 655 655 655 593 593 593
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
9
bugs core 4136 
 tracker
 SS 2022.02.02 14:46
417 426 435 435 435 331 318 235 235 234 234 233 233 233 234 234 234 234 234 234 264 264 264 234 234 234
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
10
bugs core 5028 
 tracker
 SS 2022.02.02 14:46
304 337 337 337 337 258 234 157 156 156 156 140 140 139 139 139 139 139 139 139 155 155 155 140 139 139
Report the remote port number in MON$ATTACHMENTS
11
bugs core 5064 
 tracker
 SS 2022.02.02 14:46
418 418 446 446 446 362 322 235 235 234 234 234 234 234 233 234 234 234 234 234 265 265 265 234 234 234
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
12
bugs core 5366 
 tracker
 SS 2022.02.02 14:46
419 428 438 438 438 357 321 235 235 235 234 234 234 234 234 234 234 234 234 234 264 264 264 234 234 233
Regression: could not use CASE expression with more than 255 conditions
13
bugs core 5533 
 tracker
 SS 2022.02.02 14:46
412 412 444 444 444 350 321 234 234 234 234 234 234 233 233 233 233 233 233 233 265 265 265 218 218 218
Crash on 3.0 and 4.0 when DB contains database-level trigger
14
bugs core 5700 
 tracker
 SS 2022.02.02 14:46
414 419 435 435 435 333 314 235 235 234 234 218 218 218 218 218 218 218 218 218 249 249 249 218 217 217
DECFLOAT underflow should yield zero instead of an error
15
bugs core 5705 
 tracker
 SS 2022.02.02 14:46
416 418 445 445 445 341 337 235 235 234 234 234 234 233 233 233 233 233 233 234 264 264 264 234 234 233
Store precision of DECFLOAT in RDB$FIELDS
16
bugs core 5957 
 tracker
 SS 2022.02.02 14:46
412 420 455 455 455 343 318 234 234 234 234 219 218 218 217 218 218 218 218 218 249 249 249 218 218 218
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset
17
bugs core 6504 
 tracker
 SS 2022.02.02 14:46
421 434 436 436 434 327 320 235 235 235 235 219 219 218 218 218 218 218 218 218 249 249 249 234 233 233
Provide same results for date arithmetics when date is changed by values near +/-max(bigint)
18
bugs gh 6874 
 tracker
 SS 2023.12.14 16:29
423 423 442 442 442 337 319 235 235 234 219 219 219 219 233 233 233 233 233 234 265 265 265 218 218 218
Literal 65536 (interpreted as int) can not be multiplied by itself w/o cast if result more than 2^63-1
19
bugs gh 6987 
 tracker
 SS 2023.12.14 16:30
443 443 449 443 443 349 322 234 234 234 234 234 219 218 218 218 218 218 218 218 265 265 265 234 218 218
DATEDIFF does not support fractional value for MILLISECOND
20
bugs gh 7092 
 tracker
 CS 2024.08.22 13:09
5358 5358 5358 2860 2852 2655 2569 2485 2406 2406 2391 2375 2328 2328 2327 2327 2327 2312 2312 2390 2468 2468 2468 2343 2343 2343
Improve performance of CURRENT_TIME
21
bugs gh 7092 
 tracker
 SS 2024.08.22 13:09
4993 4993 4963 2592 2577 2500 2346 2157 2141 2141 2141 2140 2140 2140 2126 2126 2077 2077 2077 2077 2108 2108 2108 2108 2139 2139
Improve performance of CURRENT_TIME
22
bugs gh 7108 
 tracker
 SS 2023.03.01 18:52
433 433 468 468 526 468 360 235 234 234 234 234 234 233 233 234 234 234 234 234 280 280 280 234 233 233
Firebird does not find an record when adding a foreign key
23
bugs gh 7638 
 tracker
 SS 2023.07.18 21:22
423 423 442 442 442 346 330 235 235 235 234 234 234 218 233 234 234 234 234 234 265 265 265 234 233 233
OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY
24
bugs gh 7727 
 tracker
 SS 2023.08.31 18:30
415 427 442 442 442 347 327 235 235 235 235 234 233 233 233 233 233 233 233 234 264 264 264 234 233 233
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
25
bugs gh 7795 
 tracker
 SS 2023.10.12 10:29
415 418 445 445 445 335 326 234 234 234 234 234 234 233 233 233 233 234 234 234 265 265 265 234 234 233
NOT IN <list> returns incorrect result if NULLs are present inside the value list
26
functional database alter 01 
 SS 2022.02.04 18:05
308 305 X 303 X 228 226 157 157 156 156 141 140 140 139 139 139 140 140 140 170 170 170 140 139 139
Alter database: adding a secondary file
27
functional database alter 02 
 SS 2022.02.04 18:05
318 305 X 300 X 226 219 156 156 140 140 140 140 139 124 124 124 124 124 140 171 171 171 140 140 140
Alter database: adding secondary file with alternate keyword
28
functional datatypes decfloat ordering rules 
 SS 2023.03.10 07:47
436 436 X 403 X 317 314 235 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 234 218 218
Test ordering of decfloat values
29
functional domain create 06 
 SS 2022.02.04 18:05
413 413 X 403 X 330 325 234 234 234 234 219 218 218 218 218 218 218 218 218 250 250 250 218 217 217
CREATE DOMAIN - DOUBLE PRECISION - ARRAY
30
functional domain create 07 
 SS 2022.02.04 18:05
423 423 X 414 X 327 314 235 235 235 234 219 218 218 218 218 218 218 218 218 233 233 233 218 218 218
CREATE DOMAIN - DATE
31
functional domain create 08 
 SS 2022.02.04 18:05
416 407 X 407 X 313 312 234 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
CREATE DOMAIN - TIME
32
functional domain create 10 
 SS 2022.02.04 18:05
420 408 X 407 X 316 315 234 234 234 234 219 218 218 218 218 218 218 218 233 249 249 249 218 218 218
CREATE DOMAIN - TIMESTAMP ARRAY
33
functional domain create 11 
 SS 2022.02.04 18:05
414 413 X 403 X 332 320 234 234 234 234 219 218 218 218 218 218 218 218 218 233 233 233 218 218 218
CREATE DOMAIN - DECIMAL
34
functional domain create 13 
 SS 2022.02.04 18:05
432 409 X 409 X 325 324 234 234 234 234 218 218 218 218 218 218 218 218 218 249 249 249 234 218 218
CREATE DOMAIN - NUMERIC
35
functional domain create 14 
 SS 2022.02.04 18:05
420 410 X 410 X 340 319 235 235 235 235 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
CREATE DOMAIN - NUMERIC ARRAY
36
functional domain create 23 
 SS 2022.02.04 18:05
422 422 X 403 X 343 322 235 234 234 234 234 218 218 218 218 218 218 218 218 249 249 249 218 218 218
CREATE DOMAIN - NATIONAL CHAR
37
functional domain create 37 
 SS 2023.10.07 07:50
451 451 X 451 X 348 339 250 250 250 250 249 249 249 249 249 249 249 249 249 265 265 265 249 249 249
CREATE DOMAIN - NOT NULL
38
functional domain drop 03 
 SS 2022.02.04 18:05
414 414 X 396 X 327 326 235 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
DROP DOMAIN - that doesn't exists
39
functional gtcs execute statement within procedure 
 SS 2022.02.04 18:05
421 421 X 401 X 329 326 235 235 234 234 234 233 233 233 233 233 233 233 233 264 264 264 234 233 233
EXECUTE STATEMENT within a stored procedure could lead to a problems
40
functional intfunc date dateadd 08 
 SS 2022.02.04 18:05
415 415 X 392 X 317 314 234 234 234 234 218 218 218 218 218 218 218 218 218 249 249 249 218 218 218
Dateadd milliseconds
41
functional intfunc date datediff 06 
 SS 2022.02.04 18:05
412 412 X 393 X 327 320 234 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
DATEDIFF
42
functional intfunc date datediff 07 
 SS 2022.02.04 18:05
419 419 X 396 X 338 330 235 235 235 235 233 219 218 218 218 218 217 218 218 249 249 249 218 218 218
DATEDIFF
43
functional intfunc math sign 01 
 SS 2022.02.04 18:05
419 413 X 397 X 319 315 235 235 234 234 218 218 218 218 218 218 218 218 218 249 249 249 218 218 218
SIGN( <number> )
44
functional intfunc math tan 01 
 SS 2022.02.04 18:05
417 417 X 413 X 331 312 234 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 233 218 218
TAN( <number> )
45
functional intfunc string left 01 
 SS 2022.02.04 18:05
417 417 X 408 X 315 314 235 235 234 234 218 218 218 218 217 217 218 218 218 249 249 249 218 218 218
LEFT function
46
functional intfunc string position 01 
 SS 2022.02.04 18:05
422 422 X 422 X 325 313 235 235 234 234 234 219 218 218 218 218 218 218 218 249 249 249 218 218 218
POSITION( <string> IN <string> )
47
functional intfunc string replace 01 
 SS 2022.02.04 18:05
424 424 X 413 X 315 313 235 234 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
REPLACE( <stringtosearch>, <findstring>, <replstring> )
48
functional intfunc string reverse 01 
 SS 2022.02.04 18:05
415 415 X 415 X 348 343 235 235 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
REVERSE( <value> )
49
functional intfunc string right 01 
 SS 2022.02.04 18:05
414 414 X 414 X 321 314 234 234 234 234 218 218 218 218 218 218 218 218 218 249 249 249 218 218 218
RIGHT( <string>, <number> )
50
functional tabloid core 3611 aux 
 SS 2022.02.04 18:05
425 409 X 393 X 328 320 235 235 234 234 219 218 218 218 218 218 218 218 218 249 249 249 218 218 218
Wrong data while retrieving from CTEs (or derived tables) with same column names

Elapsed time, milliseconds:

NN Test name mode Test last update
4.0.6.3163
2024.10.30
832db
4.0.6.3163
2024.10.16
2bb10
4.0.6.3147
2024.09.10
a4d11
4.0.6.3147
2024.08.31
4655b
4.0.6.3140
2024.08.16
1dd8b
4.0.6.3140
2024.08.09
34747
4.0.5.3110
2024.08.06
f851c
4.0.5.3110
2024.07.30
c6527
4.0.5.3109
2024.06.11
6addf
4.0.5.3097
2024.05.09
27fa6
4.0.5.3091
2024.04.29
bd0aa
4.0.5.3089
2024.04.20
9eb9b
4.0.5.3083
2024.04.06
300f9
4.0.5.3052
2024.03.16
0f422
4.0.5.3052
2024.03.16
ce273
4.0.5.3052
2024.02.12
cd058
4.0.5.3052
2024.02.07
be290
4.0.5.3052
2024.02.07
6409b
4.0.5.3052
2024.02.02
bbc3f
4.0.5.3052
2024.01.26
48b7c
4.0.5.3052
2024.01.26
9a7b3
4.0.5.3049
2024.01.25
f6b9d
4.0.5.3049
2024.01.08
b67ce
4.0.5.3049
2024.01.08
97577
4.0.5.3049
2024.01.05
2d8b0
4.0.5.3049
2024.01.04
431e5
4.0.5.3049
2024.01.04
e33b4
4.0.5.3049
2024.01.04
207ef
4.0.5.3034
2023.12.12
3a40e
4.0.5.3034
2023.12.12
c05ff
Test TITLE
1
bugs core 1859 
 tracker
 SS 2022.02.02 14:46 396 416 414 404 450 440 452 330 338 234 234 234 234 219 218 234 233 217 218 218 233 233 264 264 264 234 217 234 234 233
Arithmetic overflow or division by zero has occurred. in MAX function
2
bugs core 2200 
 tracker
 SS 2022.02.02 14:46 795 805 408 405 771 797 805 349 313 251 250 250 250 235 234 233 234 233 233 233 234 234 280 280 280 233 234 233 233 234
Extremely slow executing a cross join of 3 tables in Firebird 2.X
3
bugs core 2211 
 tracker
 SS 2022.02.02 14:46 714 709 723 694 678 496 629 599 364 266 282 266 266 250 249 249 249 249 249 249 249 249 296 296 296 249 249 249 249 249
Offset value for SUBSTRING from BLOB more than 32767 makes exception
4
bugs core 2416 
 tracker
 SS 2022.02.02 14:46 408 445 410 476 436 458 466 334 314 235 234 235 234 219 218 217 217 218 217 218 218 218 265 265 265 217 218 218 218 218
AV preparing a query with aggregate over derived table
5
bugs core 3000 
 tracker
 SS 2022.02.02 14:46 405 656 411 684 448 445 671 342 312 219 218 219 250 219 218 217 218 217 218 218 218 218 265 249 265 217 217 218 234 218
Error on delete user "ADMIN"
6
bugs core 3553 
 tracker
 SS 2022.04.08 11:16 600 426 391 392 474 444 439 315 333 234 235 234 234 219 218 217 218 218 218 218 218 217 265 249 249 218 218 218 218 218
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
7
bugs core 3925 
 tracker
 SS 2022.02.02 14:46 401 598 406 412 463 447 450 338 321 234 234 234 234 234 233 234 235 233 233 233 233 233 265 265 265 233 233 233 234 233
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
8
bugs core 3977 
 tracker
 SS 2023.12.12 17:11 1835 1834 1843 1843 1896 1892 1896 1757 1775 1626 1625 1625 1625 594 593 593 593 592 593 593 593 593 655 656 671 592 593 593 593 593
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
9
bugs core 4136 
 tracker
 SS 2022.02.02 14:46 405 417 401 426 442 435 445 331 318 235 234 235 234 219 233 233 234 234 235 233 234 233 265 265 264 234 233 233 234 234
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
10
bugs core 5028 
 tracker
 SS 2022.02.02 14:46 303 385 296 304 337 345 340 234 258 156 157 156 156 125 140 140 139 139 139 124 124 139 171 156 155 124 140 139 139 139
Report the remote port number in MON$ATTACHMENTS
11
bugs core 5064 
 tracker
 SS 2022.02.02 14:46 418 418 400 404 453 448 446 362 322 234 235 234 235 234 233 234 233 234 233 234 234 234 265 265 281 233 234 234 233 234
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
12
bugs core 5366 
 tracker
 SS 2022.02.02 14:46 401 428 402 419 451 442 438 357 321 235 235 235 234 234 233 233 234 234 234 234 233 233 264 265 264 233 234 234 233 233
Regression: could not use CASE expression with more than 255 conditions
13
bugs core 5533 
 tracker
 SS 2022.02.02 14:46 427 412 408 412 455 456 444 350 321 234 234 234 234 235 233 234 233 233 233 233 233 217 265 265 280 218 218 217 217 233
Crash on 3.0 and 4.0 when DB contains database-level trigger
14
bugs core 5700 
 tracker
 SS 2022.02.02 14:46 393 419 406 414 465 440 435 314 333 235 235 234 234 218 218 218 217 218 218 217 218 218 264 249 249 217 218 217 217 218
DECFLOAT underflow should yield zero instead of an error
15
bugs core 5705 
 tracker
 SS 2022.02.02 14:46 402 418 405 416 457 445 450 337 341 235 235 234 234 234 233 233 234 233 233 233 234 233 264 264 264 234 234 233 233 233
Store precision of DECFLOAT in RDB$FIELDS
16
bugs core 5957 
 tracker
 SS 2022.02.02 14:46 412 404 408 420 455 457 457 318 343 234 234 234 234 219 217 217 218 218 217 218 218 218 264 249 249 218 218 218 217 218
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset
17
bugs core 6504 
 tracker
 SS 2022.02.02 14:46 421 407 400 436 469 434 448 327 320 234 235 235 235 219 217 218 233 218 218 218 218 218 265 249 265 233 234 218 233 218
Provide same results for date arithmetics when date is changed by values near +/-max(bigint)
18
bugs gh 6874 
 tracker
 SS 2023.12.14 16:29 795 423 400 412 446 442 478 337 319 234 219 235 235 219 218 217 233 233 233 218 234 217 265 265 265 218 217 218 234 233
Literal 65536 (interpreted as int) can not be multiplied by itself w/o cast if result more than 2^63-1
19
bugs gh 6987 
 tracker
 SS 2023.12.14 16:30 591 409 461 404 443 449 457 349 322 234 234 234 234 219 218 234 217 218 217 218 218 217 265 265 265 234 217 218 218 234
DATEDIFF does not support fractional value for MILLISECOND
20
bugs gh 7092 
 tracker
 CS 2024.08.22 13:09 5128 5131 5442 5392 5358 2852 2860 2655 2569 2406 2485 2391 2375 2422 2328 2327 2327 2343 2280 2312 2390 2265 2483 2468 2468 2281 2281 2343 2390 2375
Improve performance of CURRENT_TIME
21
bugs gh 7092 
 tracker
 SS 2024.08.22 13:09 4881 4996 4993 4963 5498 2577 2500 2592 2346 2157 2141 2141 2141 2140 2125 2140 2140 2126 2062 2077 2077 2062 2124 2108 2139 2077 2061 2139 2171 2156
Improve performance of CURRENT_TIME
22
bugs gh 7108 
 tracker
 SS 2023.03.01 18:52 469 415 433 414 605 468 526 360 604 235 234 234 234 234 233 233 234 233 234 234 234 234 280 281 280 233 234 233 233 233
Firebird does not find an record when adding a foreign key
23
bugs gh 7638 
 tracker
 SS 2023.07.18 21:22 431 423 416 404 451 452 442 346 330 235 235 234 235 218 218 234 234 217 233 234 234 234 265 265 280 233 233 234 233 233
OVERRIDING USER VALUE should be allowed for GENERATED ALWAYS AS IDENTITY
24
bugs gh 7727 
 tracker
 SS 2023.08.31 18:30 409 415 407 427 453 457 442 347 327 235 235 234 235 235 233 233 233 233 233 233 233 234 265 264 281 233 218 234 218 233
Index for integer column cannot be used when INT128/DECFLOAT value is being searched
25
bugs gh 7795 
 tracker
 SS 2023.10.12 10:29 415 408 418 410 466 445 449 335 326 234 234 234 234 234 234 233 233 233 234 234 233 234 265 265 265 234 233 218 234 218
NOT IN <list> returns incorrect result if NULLs are present inside the value list
26
functional database alter 01 
 SS 2022.02.04 18:05 308 305 X 303 X 339 365 226 228 156 156 157 157 141 139 140 139 140 139 139 140 140 171 171 170 139 140 139 139 139
Alter database: adding a secondary file
27
functional database alter 02 
 SS 2022.02.04 18:05 318 305 X 300 X 348 338 226 219 156 156 140 140 140 124 139 140 124 124 124 140 124 171 171 171 124 140 140 140 140
Alter database: adding secondary file with alternate keyword
28
functional datatypes decfloat ordering rules 
 SS 2023.03.10 07:47 405 440 X 403 X 445 436 317 314 234 235 234 234 219 218 218 218 218 218 218 218 218 265 249 265 218 218 234 218 218
Test ordering of decfloat values
29
functional domain create 06 
 SS 2022.02.04 18:05 401 413 X 403 X 453 484 325 330 234 234 234 235 219 218 218 217 218 218 218 217 217 265 250 265 217 217 218 217 218
CREATE DOMAIN - DOUBLE PRECISION - ARRAY
30
functional domain create 07 
 SS 2022.02.04 18:05 414 423 X 414 X 456 450 327 314 235 235 235 234 219 218 218 218 218 217 218 218 218 265 233 265 218 218 217 218 218
CREATE DOMAIN - DATE
31
functional domain create 08 
 SS 2022.02.04 18:05 416 406 X 407 X 438 436 312 313 234 234 234 250 219 218 217 218 218 218 217 218 218 264 265 249 218 218 218 218 218
CREATE DOMAIN - TIME
32
functional domain create 10 
 SS 2022.02.04 18:05 420 408 X 407 X 456 445 315 316 234 234 234 234 219 218 218 217 218 218 218 233 218 265 249 264 217 218 218 217 218
CREATE DOMAIN - TIMESTAMP ARRAY
33
functional domain create 11 
 SS 2022.02.04 18:05 414 413 X 403 X 442 453 320 332 234 234 234 235 219 218 218 218 218 217 218 218 217 264 233 249 218 217 218 218 218
CREATE DOMAIN - DECIMAL
34
functional domain create 13 
 SS 2022.02.04 18:05 432 406 X 409 X 439 449 325 324 234 234 234 234 218 217 218 218 218 218 217 217 218 265 249 249 218 218 234 218 217
CREATE DOMAIN - NUMERIC
35
functional domain create 14 
 SS 2022.02.04 18:05 420 406 X 410 X 447 441 340 319 235 235 235 235 219 218 218 217 217 218 218 218 218 264 249 265 218 218 218 218 218
CREATE DOMAIN - NUMERIC ARRAY
36
functional domain create 23 
 SS 2022.02.04 18:05 409 422 X 403 X 438 441 343 322 235 234 234 234 218 218 234 218 233 217 217 218 218 265 249 265 218 218 218 218 234
CREATE DOMAIN - NATIONAL CHAR
37
functional domain create 37 
 SS 2023.10.07 07:50 423 439 X 455 X 451 461 339 348 250 250 250 250 234 249 249 249 242 249 249 249 249 280 265 281 249 249 249 249 249
CREATE DOMAIN - NOT NULL
38
functional domain drop 03 
 SS 2022.02.04 18:05 393 414 X 396 X 468 441 327 326 234 234 235 234 219 217 218 218 218 218 218 218 218 264 249 249 217 218 218 217 218
DROP DOMAIN - that doesn't exists
39
functional gtcs execute statement within procedure 
 SS 2022.02.04 18:05 419 421 X 401 X 459 838 326 329 234 235 235 234 234 233 233 233 234 234 233 233 233 265 264 265 234 233 233 233 233
EXECUTE STATEMENT within a stored procedure could lead to a problems
40
functional intfunc date dateadd 08 
 SS 2022.02.04 18:05 411 415 X 392 X 453 494 317 314 234 234 234 235 218 218 217 217 218 218 218 218 218 265 250 249 217 217 218 218 218
Dateadd milliseconds
41
functional intfunc date datediff 06 
 SS 2022.02.04 18:05 409 412 X 393 X 438 461 327 320 234 234 234 234 219 218 218 218 218 217 218 217 218 265 265 249 218 218 218 218 218
DATEDIFF
42
functional intfunc date datediff 07 
 SS 2022.02.04 18:05 403 419 X 396 X 439 496 330 338 235 235 235 235 219 218 233 218 217 218 217 218 217 265 249 249 218 218 217 217 218
DATEDIFF
43
functional intfunc math sign 01 
 SS 2022.02.04 18:05 419 413 X 397 X 443 489 315 319 234 235 234 235 218 217 218 218 218 218 218 218 218 264 249 249 217 218 218 217 218
SIGN( <number> )
44
functional intfunc math tan 01 
 SS 2022.02.04 18:05 410 417 X 413 X 455 453 312 331 234 234 234 234 219 218 218 218 218 218 218 218 218 265 249 249 233 218 218 218 218
TAN( <number> )
45
functional intfunc string left 01 
 SS 2022.02.04 18:05 407 417 X 408 X 443 477 315 314 235 234 235 234 218 218 217 217 233 218 217 217 218 264 265 249 217 217 218 218 218
LEFT function
46
functional intfunc string position 01 
 SS 2022.02.04 18:05 409 407 X 422 X 440 453 313 325 234 234 235 235 219 218 234 218 218 217 218 218 217 265 249 249 218 218 217 218 218
POSITION( <string> IN <string> )
47
functional intfunc string replace 01 
 SS 2022.02.04 18:05 407 424 X 413 X 439 462 315 313 234 235 234 234 219 218 218 218 218 218 217 217 218 265 249 249 217 217 218 218 218
REPLACE( <stringtosearch>, <findstring>, <replstring> )
48
functional intfunc string reverse 01 
 SS 2022.02.04 18:05 409 407 X 415 X 439 459 348 343 235 234 235 234 219 218 217 218 218 218 218 218 218 264 250 249 218 218 218 218 218
REVERSE( <value> )
49
functional intfunc string right 01 
 SS 2022.02.04 18:05 408 407 X 414 X 456 460 321 314 234 234 234 235 218 217 218 217 218 218 218 218 218 265 249 249 218 218 218 217 217
RIGHT( <string>, <number> )
50
functional tabloid core 3611 aux 
 SS 2022.02.04 18:05 425 409 X 393 X 442 454 320 328 235 235 234 234 219 218 217 218 218 218 217 218 217 264 249 249 218 218 218 218 217
Wrong data while retrieving from CTEs (or derived tables) with same column names

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1859
http://tracker.firebirdsql.org/browse/core-2200
http://tracker.firebirdsql.org/browse/core-2211
http://tracker.firebirdsql.org/browse/core-2416
http://tracker.firebirdsql.org/browse/core-3000
http://tracker.firebirdsql.org/browse/core-3553
http://tracker.firebirdsql.org/browse/core-3925
http://tracker.firebirdsql.org/browse/core-3977
http://tracker.firebirdsql.org/browse/core-4136
http://tracker.firebirdsql.org/browse/core-5028
http://tracker.firebirdsql.org/browse/core-5064
http://tracker.firebirdsql.org/browse/core-5366
http://tracker.firebirdsql.org/browse/core-5533
http://tracker.firebirdsql.org/browse/core-5700
http://tracker.firebirdsql.org/browse/core-5705
http://tracker.firebirdsql.org/browse/core-5957
http://tracker.firebirdsql.org/browse/core-6504
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/database/alter/test_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/database/alter/test_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_decfloat_ordering_rules.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_06.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_11.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_13.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_14.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_23.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/create/test_37.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/domain/drop/test_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_execute_statement_within_procedure.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_dateadd_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_datediff_06.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_datediff_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_sign_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_tan_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_left_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_position_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_replace_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_reverse_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_right_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/core_3611_aux_test.py
https://github.com/FirebirdSQL/firebird/issues/6874
https://github.com/FirebirdSQL/firebird/issues/6987
https://github.com/FirebirdSQL/firebird/issues/7092
https://github.com/FirebirdSQL/firebird/issues/7108
https://github.com/FirebirdSQL/firebird/issues/7638
https://github.com/FirebirdSQL/firebird/issues/7727
https://github.com/FirebirdSQL/firebird/issues/7795
=== end of list ===

Last commits information (all timestamps in UTC):