nix-5x has

Compress Data over the Network

bugs core 2668

Write note into log when automatic sweep is started

Natural is used to select instead of primary key index

Natural is used to select instead of primary key index

Inefficient optimization (regression)

Inefficient optimization (regression)

Choose the best matching index for navigation

Choose the best matching index for navigation

Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans

Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans

ORDER BY on index can cause suboptimal index choices

ORDER BY on index can cause suboptimal index choices

FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"

FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"

System table with keywords

System table with keywords

Query with SP doesn't accept explicit plan [CORE3451]

Query with SP doesn't accept explicit plan [CORE3451]

bugs gh 7200

DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress

Backup error for wide table

Backup error for wide table

FB5 uses PK for ordered plan even if less count of fields matching index exists

FB5 uses PK for ordered plan even if less count of fields matching index exists

System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES

System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES

False validation error for short unpacked records

False validation error for short unpacked records

Assertion (space > 0) failure during restore

Assertion (space > 0) failure during restore

Unexpected results when using CASE WHEN with RIGHT JOIN

Unexpected results when using CASE WHEN with RIGHT JOIN

Unexpected results after creating partial index

Unexpected results after creating partial index

Unexpected results when comparing integer with string containing value out of range of that integer datatype

Unexpected results when comparing integer with string containing value out of range of that integer datatype

Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0

Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0

"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause

"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause

(var)char variables/parameters assignments fail in Stored Procedures with subroutines

(var)char variables/parameters assignments fail in Stored Procedures with subroutines

SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected

SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected

Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked).

Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked).

Memory leak when executing a lot of different queries and StatementTimeout > 0

Memory leak when executing a lot of different queries and StatementTimeout > 0

IN predicate with string-type elements is evaluated wrongly against a numeric field

IN predicate with string-type elements is evaluated wrongly against a numeric field

bugs gh 8087

AV when preparing a query with IN list that contains both literals and sub-query

Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete

Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete

FULL OUTER JOIN, list all values

FULL OUTER JOIN, list all values

FULL OUTER JOIN, list all values, but filtered in WHERE clause

FULL OUTER JOIN, list all values, but filtered in WHERE clause

FULL OUTER JOIN, list all values, but filtered in WHERE clause

FULL OUTER JOIN, list all values, but filtered in WHERE clause

FULL OUTER JOIN, list all values, but filtered in WHERE clause

functional arno optimizer opt multi index selection 03

FULL OUTER JOIN, list all values, but filtered in WHERE clause

Best match index selection (multi segment)

functional arno optimizer opt multi index selection 03

Best match index selection (multi segment)

ORDER BY ASC using index (multi)

ORDER BY ASC using index (multi)

ORDER BY ASC using index (multi)

ORDER BY ASC using index (multi)

ORDER BY ASC using index (multi)

ORDER BY ASC using index (multi)

ORDER BY ASC using index (multi) and WHERE clause

functional replication blob characters garbled when conn charset differs

ORDER BY ASC using index (multi) and WHERE clause

Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different

functional replication blob characters garbled when conn charset differs

Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different

functional session ext conn pool 01

External Connections Pool, functionality test 01

Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range

functional transactions read consist sttm restart max limit

Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range

READ CONSISTENCY. Maximal number of statement-level restarts must be 10.

Test name

mode

median_ms

5.0.1.1398
2024-05-14

5.0.1.1392
2024-05-10

5.0.1.1386
2024-04-26

5.0.1.1378
2024-04-21

5.0.1.1346
2024-04-07

5.0.1.1340
2024-03-01

5.0.1.1325
2024-02-18

5.0.1.1318
2024-01-26

Test TITLE

bugs core 0733

49551

42041

72016

52126

56859

32896

49551

39803

Compress Data over the Network

bugs core 2668

5504

5500

5504

5488

5505

5669

5559

5316

Write note into log when automatic sweep is started

700

789

1081

560

540

545

963

700

Natural is used to select instead of primary key index

544

495

555

544

547

381

637

423

Natural is used to select instead of primary key index

617

730

885

484

494

851

478

617

Inefficient optimization (regression)

379

571

366

412

476

280

326

Inefficient optimization (regression)

738

921

567

626

654

1103

1201

738

Choose the best matching index for navigation

505

451

673

336

505

655

544

452

Choose the best matching index for navigation

700

803

1178

619

677

676

713

700

Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans

413

502

643

313

321

413

542

402

Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans

589

807

503

519

561

604

663

589

ORDER BY on index can cause suboptimal index choices

421

462

479

298

360

421

441

348

ORDER BY on index can cause suboptimal index choices

473

704

412

433

473

438

578

521

FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"

366

410

420

229

366

372

357

286

FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"

550

592

550

527

System table with keywords

336

374

336

309

System table with keywords

519

754

458

440

483

577

521

519

Query with SP doesn't accept explicit plan [CORE3451]

355

356

355

250

262

403

407

303

Query with SP doesn't accept explicit plan [CORE3451]

bugs gh 7200

6029

6480

8563

4777

5084

5386

6029

6105

DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress

1246

1423

1587

991

1024

1246

1359

1134

Backup error for wide table

771

860

735

748

771

741

1368

846

Backup error for wide table

2158

2054

3188

1812

1946

2369

2158

2343

FB5 uses PK for ordered plan even if less count of fields matching index exists

1717

1836

1535

1537

1717

1715

2100

1912

FB5 uses PK for ordered plan even if less count of fields matching index exists

505

708

762

438

470

501

538

505

System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES

229

380

201

229

216

236

222

310

System procedure/function inconsistency between ISQL SHOW FUNCTIONS and SHOW PROCEDURES

760

848

1016

631

605

634

1407

760

False validation error for short unpacked records

339

515

296

339

317

310

1119

405

False validation error for short unpacked records

1025

1200

1005

935

923

1046

1279

Assertion (space > 0) failure during restore

751

768

735

652

773

662

1109

Assertion (space > 0) failure during restore

498

723

403

457

446

539

587

Unexpected results when using CASE WHEN with RIGHT JOIN

248

378

190

250

246

267

216

Unexpected results when using CASE WHEN with RIGHT JOIN

547

675

405

473

597

551

544

Unexpected results after creating partial index

239

400

210

260

232

247

218

Unexpected results after creating partial index

502

698

432

498

506

Unexpected results when comparing integer with string containing value out of range of that integer datatype

275

398

231

289

262

Unexpected results when comparing integer with string containing value out of range of that integer datatype

453

690

421

447

459

Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0

229

343

197

252

207

Invalid result when string compared with indexed numeric(x,y) field where x > 18 and y != 0

585

889

575

595

485

"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause

376

546

362

391

227

"Too many temporary blobs" with blob_append when select a stored procedue using rows-clause

497

702

457

535

460

(var)char variables/parameters assignments fail in Stored Procedures with subroutines

287

367

207

370

208

(var)char variables/parameters assignments fail in Stored Procedures with subroutines

450

742

433

450

SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected

232

422

195

232

SIMILAR TO with constant pattern using '|', '*', '?' or '{0,N}' doesn't work as expected

475

699

475

472

Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked).

286

372

237

286

Partial index uniqueness violation (changes in columns participating in index filtering expression are not properly tracked).

18701

18766

18701

18538

Memory leak when executing a lot of different queries and StatementTimeout > 0

18494

18368

19095

Memory leak when executing a lot of different queries and StatementTimeout > 0

765

645

885

IN predicate with string-type elements is evaluated wrongly against a numeric field

340

456

224

IN predicate with string-type elements is evaluated wrongly against a numeric field

bugs gh 8087

738

792

606

AV when preparing a query with IN list that contains both literals and sub-query

2683

2177

3189

Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete

1865

2099

1631

Inefficient evaluation of expressions like rdb$db_key <= ? after mass delete

727

889

1138

611

640

700

811

727

FULL OUTER JOIN, list all values

378

497

527

378

312

336

367

471

FULL OUTER JOIN, list all values

783

947

1080

640

665

787

783

758

FULL OUTER JOIN, list all values, but filtered in WHERE clause

400

492

522

361

316

347

400

410

FULL OUTER JOIN, list all values, but filtered in WHERE clause

726

962

1080

636

633

726

716

734

FULL OUTER JOIN, list all values, but filtered in WHERE clause

358

554

529

358

337

351

349

452

FULL OUTER JOIN, list all values, but filtered in WHERE clause

746

913

1080

670

653

746

742

761

FULL OUTER JOIN, list all values, but filtered in WHERE clause

functional arno optimizer opt multi index selection 03

363

479

528

363

338

323

361

466

FULL OUTER JOIN, list all values, but filtered in WHERE clause

690

880

547

600

601

720

692

690

Best match index selection (multi segment)

functional arno optimizer opt multi index selection 03

362

505

397

338

320

340

362

406

Best match index selection (multi segment)

742

883

621

633

611

742

759

757

ORDER BY ASC using index (multi)

412

501

412

326

332

533

534

389

ORDER BY ASC using index (multi)

558

825

433

440

525

607

596

558

ORDER BY ASC using index (multi)

343

462

343

250

237

427

400

312

ORDER BY ASC using index (multi)

701

964

564

613

637

704

754

701

ORDER BY ASC using index (multi)

399

506

388

354

319

490

564

399

ORDER BY ASC using index (multi)

579

744

466

403

532

599

589

579

ORDER BY ASC using index (multi) and WHERE clause

functional replication blob characters garbled when conn charset differs

302

456

250

241

439

485

302

ORDER BY ASC using index (multi) and WHERE clause

9292

9188

9791

9189

9123

9395

10681

Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different

functional replication blob characters garbled when conn charset differs

9607

10252

9752

8322

9463

9363

10454

Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different

functional session ext conn pool 01

29533

29344

31459

29076

29223

29533

29842

29697

External Connections Pool, functionality test 01

1615

1620

2333

1290

1443

1558

1615

1640

Change error by warning in the case when isc_dpb_parallel_workers value is not at valid range