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 (14 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 (9 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (1 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 (166 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (730 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 (3 rows)
11. All tests: outcomes for previous 30 runs (3367 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 10.11.2024 09:11
Tested: HQ50.   Build/date: 5.0.2.1533 2024.10.23; latest GH: 0ec43313;
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
5.0.2.1533
2024.10.23
0ec43
5.0.2.1533
2024.10.22
8af7a
5.0.2.1532
2024.10.15
36dc0
5.0.2.1518
2024.10.04
259ba
5.0.2.1518
2024.09.26
703cd
5.0.2.1489
2024.08.31
994a6
5.0.2.1476
2024.08.09
843ea
5.0.1.1454
2024.08.08
30f9f
5.0.1.1453
2024.08.07
ebbc3
5.0.1.1453
2024.08.06
1b9d0
5.0.1.1453
2024.07.30
48044
5.0.1.1453
2024.07.28
8d956
5.0.1.1429
2024.07.19
8ee90
5.0.1.1428
2024.07.15
00392
5.0.1.1428
2024.06.30
67a31
5.0.1.1415
2024.06.12
f8731
5.0.1.1415
2024.06.11
31d74
5.0.1.1401
2024.06.05
f9b76
5.0.1.1398
2024.05.10
5e3ce
5.0.1.1397
2024.05.09
ee2ef
5.0.1.1392
2024.04.29
7dbc2
5.0.1.1386
2024.04.25
c0328
5.0.1.1386
2024.04.20
80571
5.0.1.1378
2024.04.07
5292b
5.0.1.1346
2024.03.16
fe320
5.0.1.1346
2024.03.02
da408
Test TITLE
1
bugs core 0694 
 tracker
 SS 2022.08.14 15:28
311 311 311 343 343 343 343 260 256 233 232 226 226 221 156 156 156 156 156 156 156 156 141 140 140 140
Support for time zones [CORE694]
2
bugs core 1554 
 tracker
 SS 2022.02.02 14:46
393 384 393 393 424 424 424 327 305 304 299 299 298 293 219 219 219 219 219 218 218 218 203 202 202 202
select ... where ... <> ALL (select ... join ...) bug
3
bugs core 1935 
 tracker
 SS 2022.02.02 14:46
392 390 390 390 424 424 424 334 314 313 312 311 297 294 219 219 219 219 219 219 219 219 218 202 202 202
SIMILAR TO character classes are incorrectly recognized
4
bugs core 1962 
 tracker
 SS 2022.02.02 14:46
389 387 389 389 425 425 425 323 311 301 311 301 296 296 219 219 219 218 219 219 219 218 203 203 203 202
Incorrect extraction of MILLISECONDs
5
bugs core 2038 
 tracker
 SS 2022.02.02 14:46
388 387 388 388 419 419 419 318 310 308 308 308 300 300 219 219 219 219 219 219 219 218 204 202 202 202
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
6
bugs core 2211 
 tracker
 SS 2022.02.02 14:46
798 786 786 719 675 675 675 627 524 349 346 346 345 344 250 250 250 250 250 250 250 250 249 233 233 233
Offset value for SUBSTRING from BLOB more than 32767 makes exception
7
bugs core 2216 
 tracker
 SS 2022.02.02 14:46
1045 1036 1065 1085 1122 1122 1122 1008 909 788 781 781 754 726 406 406 406 406 406 406 391 391 375 374 374 374
Nbackup as online dump
8
bugs core 2787 
 tracker
 SS 2022.02.02 14:46
396 396 411 416 412 412 412 312 303 300 300 298 298 296 219 219 219 219 219 219 219 218 204 202 202 202
Make rdb$system_flag not null
9
bugs core 3024 
 tracker
 SS 2022.02.02 14:46
303 303 303 308 345 345 345 272 240 229 229 224 224 222 157 157 157 157 171 172 171 157 156 156 156 155
Error "no current record for fetch operation" after ALTER VIEW
10
bugs core 3475 
 tracker
 SS 2023.12.11 11:27
390 390 390 390 422 422 422 324 313 309 309 309 309 300 219 219 219 219 219 219 219 219 204 202 202 202
Parameters inside the CAST function are described as not nullable
11
bugs core 3548 
 tracker
 SS 2022.02.02 14:46
376 380 381 388 404 404 404 327 318 299 298 296 291 282 203 203 203 203 203 203 203 203 203 203 203 203
GFIX returns an error after correctly shutting down a database
12
bugs core 4645 
 tracker
 SS 2022.02.02 14:46
860 860 485 500 500 485 485 407 403 403 384 384 384 378 313 313 313 313 313 312 313 312 312 312 311 311
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
13
bugs core 5028 
 tracker
 SS 2022.02.02 14:46
276 276 278 285 321 321 321 320 307 232 232 209 206 198 141 141 141 141 141 141 141 140 125 124 124 124
Report the remote port number in MON$ATTACHMENTS
14
bugs core 5153 
 tracker
 SS 2022.02.02 14:46
389 389 389 389 425 425 425 322 316 310 307 302 300 295 219 219 219 219 219 218 218 218 203 202 202 202
Regression: Server crashes when aggregate functions are used together with NOT IN predicate
15
bugs core 5165 
 tracker
 SS 2022.02.02 14:46
393 383 383 383 415 415 415 336 332 299 299 299 298 298 219 219 219 219 219 219 219 218 204 202 202 202
HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
16
bugs core 5408 
 tracker
 SS 2022.02.02 14:46
393 390 397 402 425 425 425 328 313 310 310 300 298 294 219 219 219 219 219 219 219 218 203 203 203 217
Result of boolean expression can not be concatenated with string literal
17
bugs core 5414 
 tracker
 SS 2022.02.02 14:46
388 388 388 396 418 418 418 318 309 298 298 298 297 297 219 219 219 219 219 219 219 219 203 203 203 202
Error restoring on FB 3.0 from FB 2.5: bugcheck 221 (cannot remap)
18
bugs core 5427 
 tracker
 SS 2022.02.02 14:46
390 379 391 395 428 428 428 341 315 301 298 301 301 296 219 219 219 219 219 219 218 218 203 203 203 202
Error on field concatenation of System tables
19
bugs core 5931 
 tracker
 SS 2022.02.02 14:46
391 384 384 384 419 419 419 325 307 304 302 302 300 300 219 219 219 219 219 219 219 219 218 203 203 203
SIMILAR TO does not return result when invalid pattern is used (with two adjacent special characters that should be escaped but aren't)
20
bugs core 5949 
 tracker
 SS 2022.02.02 14:46
314 314 314 332 346 346 346 264 245 237 234 234 234 230 172 157 157 157 172 172 172 156 156 156 156 156
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
21
bugs core 5957 
 tracker
 SS 2022.02.02 14:46
395 395 395 395 425 425 425 324 307 307 306 300 294 294 219 219 219 219 219 219 219 218 218 203 203 203
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset
22
bugs core 6403 
 tracker
 SS 2022.02.02 14:46
446 446 450 462 466 466 466 372 369 358 358 354 354 350 250 250 250 250 265 266 266 266 265 265 249 249
Some PSQL statements may lead to exceptions report wrong line/column
23
bugs gh 6790 
 tracker
 SS 2022.08.18 10:51
328 328 333 333 359 364 364 359 284 281 266 266 240 239 172 172 172 172 172 156 156 156 156 155 155 155
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
24
bugs gh 7092 
 tracker
 SS 2024.08.22 13:09
4841 4854 4920 4854 4854 2540 2375 2275 2275 2272 2252 2242 2240 2225 2063 2047 2032 2047 2047 2031 2031 2016 2015 2015 2014 2014
Improve performance of CURRENT_TIME
25
functional domain drop 03 
 SS 2022.02.04 18:05
393 395 398 398 398 X X 310 310 304 303 303 303 300 219 219 219 219 219 219 219 217 X X X X
DROP DOMAIN - that doesn't exists
26
functional intfunc cast 07 
 SS 2022.02.04 18:05
394 394 396 388 373 X X 307 307 297 307 307 300 297 219 219 219 219 219 219 219 203 X X X X
CAST CHAR -> INTEGER
27
functional intfunc cast 09 
 SS 2022.02.04 18:05
392 392 406 406 392 X X 312 304 303 300 300 297 297 219 218 218 219 219 218 218 218 X X X X
CAST CHAR -> DATE
28
functional intfunc cast 13 
 SS 2022.02.04 18:05
498 498 427 427 422 X X 338 316 311 309 309 309 302 219 219 219 219 219 219 219 203 X X X X
CAST CHAR -> TIMESTAM
29
functional intfunc date dateadd 08 
 SS 2022.02.04 18:05
391 392 399 399 399 X X 310 310 303 305 299 299 299 219 219 218 218 219 218 218 203 X X X X
Dateadd milliseconds
30
functional intfunc date datediff 03 
 SS 2022.02.04 18:05
391 391 392 391 378 X X 302 301 299 299 298 294 294 219 219 219 219 219 219 218 203 X X X X
DATEDIFF
31
functional intfunc date datediff 04 
 SS 2022.02.04 18:05
392 394 394 394 392 X X 311 305 299 299 300 299 297 219 219 219 219 219 219 219 218 X X X X
DATEDIFF
32
functional intfunc math acos 01 
 SS 2022.02.04 18:05
390 390 392 392 390 X X 309 309 309 309 301 301 300 219 219 219 219 219 219 219 218 X X X X
ACOS( <number> )
33
functional intfunc math asin 01 
 SS 2022.02.04 18:05
391 391 396 391 381 X X 331 302 302 301 298 296 295 219 219 218 218 218 218 218 204 X X X X
ASIN( <number> )
34
functional intfunc math atan 01 
 SS 2022.02.04 18:05
391 391 391 391 391 X X 303 303 303 299 300 300 299 219 219 219 219 219 219 219 217 X X X X
ATAN( <number> )
35
functional intfunc math cos 01 
 SS 2022.02.04 18:05
394 394 401 401 378 X X 308 308 307 307 308 307 299 219 219 219 219 219 219 218 203 X X X X
COS( <number>)
36
functional intfunc math cot 01 
 SS 2022.02.04 18:05
393 393 397 393 393 X X 309 303 303 299 299 299 297 219 219 219 219 219 219 219 219 X X X X
COT( <number> )
37
functional intfunc math floor 01 
 SS 2022.02.04 18:05
394 398 422 398 398 X X 309 308 308 308 306 300 298 219 219 219 219 219 219 219 203 X X X X
FLOOR( <number> )
38
functional intfunc math ln 01 
 SS 2022.02.04 18:05
395 395 401 401 382 X X 321 321 310 301 300 300 296 219 219 219 219 219 219 219 218 X X X X
LN( <number> )
39
functional intfunc math log 01 
 SS 2022.02.04 18:05
393 393 397 393 379 X X 302 300 300 299 299 297 296 219 219 219 219 219 219 218 203 X X X X
LOG( <number>, <number> )
40
functional intfunc math sin 01 
 SS 2022.02.04 18:05
390 390 391 391 390 X X 316 315 303 303 306 298 298 219 219 219 219 219 219 219 218 X X X X
SIN( <number> )
41
functional intfunc math trunc 01 
 SS 2022.02.04 18:05
391 391 398 398 398 X X 320 310 307 307 302 300 294 219 219 219 219 219 219 219 203 X X X X
TRUNC( <number> [, <number> ] )
42
functional intfunc string ascii 01 
 SS 2022.02.04 18:05
390 390 398 390 375 X X 329 308 306 306 300 299 296 219 219 219 219 219 219 219 203 X X X X
ASCII_CHAR( <number> )
43
functional monitoring 03 
 SS 2023.12.16 10:59
391 397 401 401 397 X X 311 309 304 302 302 298 296 219 219 219 219 219 219 218 217 X X X X
table MON$COMPILED_STATEMENTS and columns MON$STATEMENTS.MON$COMPILED_STATEMENT_ID and MON$CALL_STACK.MON$COMPILED_STATEMENT_ID
44
functional role create 01 
 SS 2022.02.04 18:05
393 393 393 381 381 X X 317 316 302 302 302 299 296 219 219 219 219 219 219 218 218 X X X X
CREATE ROLE
45
functional session alter session reset raise if open tx 
 SS 2022.05.17 12:50
283 283 283 283 276 X X 208 201 199 199 198 195 195 141 141 141 141 141 141 140 125 X X X X
ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection
46
functional session alter session reset remove context vars 
 SS 2022.02.04 18:05
412 413 413 413 383 X X 309 307 303 299 298 298 292 219 218 218 218 219 218 218 218 X X X X
ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace
47
functional syspriv change shutdown mode 
 SS 2022.05.23 14:24
2492 2439 2250 2250 2223 X X 2164 2149 2136 2136 2136 2133 2119 1375 1360 1360 1360 1360 1360 1359 1172 X X X X
Check ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges
48
functional tabloid core 3611 aux 
 SS 2022.02.04 18:05
404 404 404 404 404 X X 305 300 300 305 300 296 296 219 219 219 219 219 219 219 219 X X X X
Wrong data while retrieving from CTEs (or derived tables) with same column names
49
functional tabloid loose record when relief where expr 
 SS 2022.02.04 18:05
395 395 403 403 379 X X 316 316 308 308 303 302 300 219 219 219 219 219 219 219 219 X X X X
Uncomment of one part of OR'ed expression led to loose of record from resultset.
50
functional tabloid pg 13918 
 SS 2022.02.04 18:05
390 390 394 390 379 X X 331 314 300 299 296 295 294 219 219 219 219 219 219 219 218 X X X X
Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!)

Elapsed time, milliseconds:

NN Test name mode Test last update
5.0.2.1533
2024.10.23
0ec43
5.0.2.1533
2024.10.22
8af7a
5.0.2.1532
2024.10.15
36dc0
5.0.2.1518
2024.10.04
259ba
5.0.2.1518
2024.09.26
703cd
5.0.2.1489
2024.08.31
994a6
5.0.2.1476
2024.08.09
843ea
5.0.1.1454
2024.08.08
30f9f
5.0.1.1453
2024.08.07
ebbc3
5.0.1.1453
2024.08.06
1b9d0
5.0.1.1453
2024.07.30
48044
5.0.1.1453
2024.07.28
8d956
5.0.1.1429
2024.07.19
8ee90
5.0.1.1428
2024.07.15
00392
5.0.1.1428
2024.06.30
67a31
5.0.1.1415
2024.06.12
f8731
5.0.1.1415
2024.06.11
31d74
5.0.1.1401
2024.06.05
f9b76
5.0.1.1398
2024.05.10
5e3ce
5.0.1.1397
2024.05.09
ee2ef
5.0.1.1392
2024.04.29
7dbc2
5.0.1.1386
2024.04.25
c0328
5.0.1.1386
2024.04.20
80571
5.0.1.1378
2024.04.07
5292b
5.0.1.1346
2024.03.16
fe320
5.0.1.1346
2024.03.02
da408
5.0.1.1340
2024.02.17
08a71
5.0.1.1325
2024.02.06
c98fb
5.0.1.1325
2024.02.02
1d438
5.0.1.1325
2024.01.26
cffb6
Test TITLE
1
bugs core 0694 
 tracker
 SS 2022.08.14 15:28 314 307 311 305 311 343 344 343 372 260 256 225 232 233 221 226 156 156 156 157 156 156 156 156 141 140 140 140 140 140
Support for time zones [CORE694]
2
bugs core 1554 
 tracker
 SS 2022.02.02 14:46 406 384 403 393 372 382 425 424 438 327 305 304 298 293 299 319 219 218 219 219 218 219 218 218 203 202 202 202 217 203
select ... where ... <> ALL (select ... join ...) bug
3
bugs core 1935 
 tracker
 SS 2022.02.02 14:46 400 392 399 390 387 376 424 425 448 334 313 312 314 297 294 311 219 219 219 219 218 219 234 218 219 202 202 202 218 203
SIMILAR TO character classes are incorrectly recognized
4
bugs core 1962 
 tracker
 SS 2022.02.02 14:46 403 387 423 389 374 374 441 425 452 294 311 323 294 301 323 296 219 218 218 219 219 218 234 219 203 187 203 186 218 202
Incorrect extraction of MILLISECONDs
5
bugs core 2038 
 tracker
 SS 2022.02.02 14:46 390 378 404 375 388 387 419 427 444 298 318 310 298 308 300 311 218 219 218 219 219 218 219 219 204 202 202 202 218 202
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
6
bugs core 2211 
 tracker
 SS 2022.02.02 14:46 809 437 786 798 799 429 675 719 627 890 524 349 346 344 345 349 250 250 250 250 250 250 255 250 218 249 233 233 265 218
Offset value for SUBSTRING from BLOB more than 32767 makes exception
7
bugs core 2216 
 tracker
 SS 2022.02.02 14:46 1045 1026 1065 1036 1085 896 1122 1134 1140 909 1008 781 754 788 726 810 406 390 406 406 406 391 406 391 375 358 374 374 405 374
Nbackup as online dump
8
bugs core 2787 
 tracker
 SS 2022.02.02 14:46 376 396 411 416 380 379 429 432 412 297 312 297 303 300 298 296 218 219 219 219 235 219 219 218 204 202 202 202 217 186
Make rdb$system_flag not null
9
bugs core 3024 
 tracker
 SS 2022.02.02 14:46 308 323 303 302 302 308 362 363 345 272 240 229 229 224 224 222 157 156 156 172 171 157 172 172 156 156 156 155 155 155
Error "no current record for fetch operation" after ALTER VIEW
10
bugs core 3475 
 tracker
 SS 2023.12.11 11:27 375 699 493 390 378 385 423 426 422 324 313 308 309 300 677 315 219 218 219 218 234 219 219 219 204 202 202 202 217 186
Parameters inside the CAST function are described as not nullable
11
bugs core 3548 
 tracker
 SS 2022.02.02 14:46 372 380 376 376 381 388 422 404 410 318 327 296 299 282 298 291 203 203 203 203 203 203 203 203 218 203 202 202 218 217
GFIX returns an error after correctly shutting down a database
12
bugs core 4645 
 tracker
 SS 2022.02.02 14:46 453 1199 467 860 861 454 485 500 503 403 407 381 384 751 378 389 313 313 313 312 313 313 312 312 313 311 312 311 311 311
internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
13
bugs core 5028 
 tracker
 SS 2022.02.02 14:46 280 274 276 285 276 278 349 344 321 307 232 320 209 198 341 206 141 140 140 141 141 141 141 140 125 124 124 124 124 124
Report the remote port number in MON$ATTACHMENTS
14
bugs core 5153 
 tracker
 SS 2022.02.02 14:46 373 391 407 389 378 375 450 425 441 322 307 316 310 302 300 295 219 219 219 218 219 218 219 218 203 186 202 202 217 202
Regression: Server crashes when aggregate functions are used together with NOT IN predicate
15
bugs core 5165 
 tracker
 SS 2022.02.02 14:46 395 395 393 376 374 383 460 415 500 336 299 332 294 299 298 300 219 219 219 234 219 219 234 218 204 202 202 202 218 202
HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
16
bugs core 5408 
 tracker
 SS 2022.02.02 14:46 393 390 376 397 402 388 425 440 428 328 310 313 300 310 298 294 219 219 219 218 219 219 218 219 203 202 202 217 218 217
Result of boolean expression can not be concatenated with string literal
17
bugs core 5414 
 tracker
 SS 2022.02.02 14:46 379 402 388 380 396 375 424 437 418 318 298 309 294 297 299 298 219 218 219 219 235 219 235 219 203 202 203 202 218 202
Error restoring on FB 3.0 from FB 2.5: bugcheck 221 (cannot remap)
18
bugs core 5427 
 tracker
 SS 2022.02.02 14:46 390 377 379 395 391 376 428 437 429 341 297 298 315 301 296 302 219 219 219 219 219 218 218 219 203 202 202 218 218 202
Error on field concatenation of System tables
19
bugs core 5931 
 tracker
 SS 2022.02.02 14:46 394 391 395 375 372 384 419 420 433 325 304 307 298 300 302 310 219 219 219 218 235 219 234 219 218 186 203 203 218 202
SIMILAR TO does not return result when invalid pattern is used (with two adjacent special characters that should be escaped but aren't)
20
bugs core 5949 
 tracker
 SS 2022.02.02 14:46 307 333 314 332 314 307 351 346 350 264 231 245 237 234 230 234 157 157 172 157 172 156 172 172 156 156 155 156 170 155
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
21
bugs core 5957 
 tracker
 SS 2022.02.02 14:46 373 399 395 395 393 386 441 425 428 324 306 307 292 312 294 300 218 219 219 219 219 219 235 218 218 203 202 202 234 217
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset
22
bugs core 6403 
 tracker
 SS 2022.02.02 14:46 429 446 443 450 462 428 473 493 466 372 358 344 369 350 376 354 250 250 250 265 250 266 266 266 265 265 233 233 249 249
Some PSQL statements may lead to exceptions report wrong line/column
23
bugs gh 6790 
 tracker
 SS 2022.08.18 10:51 319 328 366 333 318 322 365 359 364 437 253 284 281 240 266 239 157 172 172 172 156 156 172 156 157 155 155 155 139 155
MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default
24
bugs gh 7092 
 tracker
 SS 2024.08.22 13:09 4804 4782 4920 4841 4854 5252 4999 2375 2540 2275 2272 2242 2281 2225 2252 2240 2032 2032 2063 2047 2031 2047 2031 2016 2000 2015 2015 1999 2014 1999
Improve performance of CURRENT_TIME
25
functional domain drop 03 
 SS 2022.02.04 18:05 384 393 390 395 398 X X 424 424 304 310 300 313 300 303 314 219 219 219 219 235 219 235 X 204 217 202 X X X
DROP DOMAIN - that doesn't exists
26
functional intfunc cast 07 
 SS 2022.02.04 18:05 397 394 396 388 373 X X 424 422 297 296 307 320 297 315 300 219 219 219 219 219 219 219 X 203 202 202 X X X
CAST CHAR -> INTEGER
27
functional intfunc cast 09 
 SS 2022.02.04 18:05 387 374 392 406 392 X X 420 420 312 304 303 294 297 300 313 218 218 219 218 219 219 218 X 204 218 202 X X X
CAST CHAR -> DATE
28
functional intfunc cast 13 
 SS 2022.02.04 18:05 375 498 380 507 505 X X 422 427 338 316 300 309 311 302 405 219 218 219 219 219 219 219 X 203 202 202 X X X
CAST CHAR -> TIMESTAM
29
functional intfunc date dateadd 08 
 SS 2022.02.04 18:05 391 379 376 392 399 X X 422 437 303 310 296 313 299 305 299 219 218 219 218 218 219 235 X 203 202 202 X X X
Dateadd milliseconds
30
functional intfunc date datediff 03 
 SS 2022.02.04 18:05 392 376 392 391 378 X X 425 424 301 299 302 299 294 298 294 219 219 219 219 218 219 219 X 203 187 202 X X X
DATEDIFF
31
functional intfunc date datediff 04 
 SS 2022.02.04 18:05 387 400 385 394 392 X X 426 428 311 296 305 299 297 302 300 219 218 218 219 219 219 235 X 203 218 203 X X X
DATEDIFF
32
functional intfunc math acos 01 
 SS 2022.02.04 18:05 389 379 390 392 390 X X 431 424 295 309 298 309 311 301 300 219 218 219 219 219 219 219 X 203 218 203 X X X
ACOS( <number> )
33
functional intfunc math asin 01 
 SS 2022.02.04 18:05 391 388 396 391 381 X X 423 424 331 302 302 301 298 296 295 219 219 218 218 218 219 218 X 204 187 202 X X X
ASIN( <number> )
34
functional intfunc math atan 01 
 SS 2022.02.04 18:05 412 392 387 389 391 X X 422 423 303 299 294 313 309 299 300 218 219 219 219 219 219 235 X 203 217 202 X X X
ATAN( <number> )
35
functional intfunc math cos 01 
 SS 2022.02.04 18:05 443 376 394 401 378 X X 437 426 296 304 308 309 307 299 312 219 219 218 219 218 219 234 X 203 202 202 X X X
COS( <number>)
36
functional intfunc math cot 01 
 SS 2022.02.04 18:05 393 375 397 391 393 X X 411 424 303 309 299 299 312 297 303 219 219 219 219 235 219 234 X 219 202 202 X X X
COT( <number> )
37
functional intfunc math floor 01 
 SS 2022.02.04 18:05 391 377 427 394 398 X X 430 422 309 308 306 308 300 321 298 219 218 219 219 219 219 234 X 203 202 202 X X X
FLOOR( <number> )
38
functional intfunc math ln 01 
 SS 2022.02.04 18:05 406 395 392 401 382 X X 432 423 321 310 298 321 300 301 296 219 219 219 219 219 218 219 X 219 218 202 X X X
LN( <number> )
39
functional intfunc math log 01 
 SS 2022.02.04 18:05 504 378 397 393 379 X X 418 430 300 295 302 299 307 297 296 218 219 219 219 234 219 218 X 203 202 202 X X X
LOG( <number>, <number> )
40
functional intfunc math sin 01 
 SS 2022.02.04 18:05 396 381 375 391 390 X X 439 423 298 303 316 315 298 298 306 219 219 218 219 219 219 234 X 204 218 202 X X X
SIN( <number> )
41
functional intfunc math trunc 01 
 SS 2022.02.04 18:05 407 377 391 378 398 X X 446 427 298 310 320 300 307 294 302 218 219 219 219 219 219 234 X 203 202 202 X X X
TRUNC( <number> [, <number> ] )
42
functional intfunc string ascii 01 
 SS 2022.02.04 18:05 395 379 398 390 375 X X 422 421 301 306 329 308 296 300 299 219 219 219 219 219 219 234 X 203 202 203 X X X
ASCII_CHAR( <number> )
43
functional monitoring 03 
 SS 2023.12.16 10:59 390 385 391 401 397 X X 434 421 304 311 309 302 296 298 303 219 219 219 234 219 218 235 X 203 217 202 X X X
table MON$COMPILED_STATEMENTS and columns MON$STATEMENTS.MON$COMPILED_STATEMENT_ID and MON$CALL_STACK.MON$COMPILED_STATEMENT_ID
44
functional role create 01 
 SS 2022.02.04 18:05 413 429 393 379 381 X X 428 423 317 316 302 299 296 319 316 219 219 219 219 219 219 218 X 203 218 203 X X X
CREATE ROLE
45
functional session alter session reset raise if open tx 
 SS 2022.05.17 12:50 311 296 283 283 276 X X 327 321 208 201 199 198 199 195 195 141 141 140 141 141 140 141 X 125 124 124 X X X
ALTER SESSION RESET: throw error (isc_ses_reset_err) if any open transaction exist in current connection
46
functional session alter session reset remove context vars 
 SS 2022.02.04 18:05 412 421 376 413 383 X X 433 423 309 307 296 303 298 299 292 218 218 219 218 218 219 234 X 203 218 202 X X X
ALTER SESSION RESET: remove all context variables in 'USER_SESSION' namespace
47
functional syspriv change shutdown mode 
 SS 2022.05.23 14:24 2493 2533 2211 2492 2439 X X 2250 2223 2136 2164 2136 2149 2133 2119 2146 1360 1375 1360 1360 1359 1360 1375 X 1172 1171 1155 X X X
Check ability to change database shutdown mode by non-sysdba user who is granted with necessary system privileges
48
functional tabloid core 3611 aux 
 SS 2022.02.04 18:05 407 412 382 377 404 X X 421 422 293 305 300 290 309 309 296 219 219 219 219 218 219 235 X 219 202 202 X X X
Wrong data while retrieving from CTEs (or derived tables) with same column names
49
functional tabloid loose record when relief where expr 
 SS 2022.02.04 18:05 409 395 379 403 379 X X 416 417 306 316 308 316 300 303 302 219 219 218 219 219 219 219 X 219 217 202 X X X
Uncomment of one part of OR'ed expression led to loose of record from resultset.
50
functional tabloid pg 13918 
 SS 2022.02.04 18:05 420 386 394 390 379 X X 423 423 314 300 331 299 296 294 295 219 218 219 219 219 219 219 X 204 218 203 X X X
Some _TRIVIAL_ queries allow to specify HAVING without group by, and for such case one may to get record from EMPTY source rowset(!)

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1554
http://tracker.firebirdsql.org/browse/core-1935
http://tracker.firebirdsql.org/browse/core-1962
http://tracker.firebirdsql.org/browse/core-2038
http://tracker.firebirdsql.org/browse/core-2211
http://tracker.firebirdsql.org/browse/core-2216
http://tracker.firebirdsql.org/browse/core-2787
http://tracker.firebirdsql.org/browse/core-3024
http://tracker.firebirdsql.org/browse/core-3475
http://tracker.firebirdsql.org/browse/core-3548
http://tracker.firebirdsql.org/browse/core-4645
http://tracker.firebirdsql.org/browse/core-5028
http://tracker.firebirdsql.org/browse/core-5153
http://tracker.firebirdsql.org/browse/core-5165
http://tracker.firebirdsql.org/browse/core-5408
http://tracker.firebirdsql.org/browse/core-5414
http://tracker.firebirdsql.org/browse/core-5427
http://tracker.firebirdsql.org/browse/core-5931
http://tracker.firebirdsql.org/browse/core-5949
http://tracker.firebirdsql.org/browse/core-5957
http://tracker.firebirdsql.org/browse/core-6403
http://tracker.firebirdsql.org/browse/core-694
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/intfunc/cast/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/cast/test_09.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/cast/test_13.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_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_datediff_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_acos_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_asin_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_atan_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_cos_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_cot_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_floor_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_ln_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_log_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_sin_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_trunc_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_ascii_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/monitoring/test_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/role/create/test_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/session/test_alter_session_reset_raise_if_open_tx.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/session/test_alter_session_reset_remove_context_vars.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/syspriv/test_change_shutdown_mode.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/core_3611_aux_test.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_loose_record_when_relief_where_expr.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_pg_13918.py
https://github.com/FirebirdSQL/firebird/issues/6790
https://github.com/FirebirdSQL/firebird/issues/7092
=== end of list ===

Last commits information (all timestamps in UTC):