nix-4x new_passed

Segfault when already destroyed callback interface is used

bugs gh 8508

functional fkey cascade cascade recursive actions

Conversion Error with old.field in UPDATE OR INSERT

functional fkey cascade master pk delete if no cascade

Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables.

functional fkey cascade master pk on delete cascade

Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master pk on update cascade

Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.

functional fkey cascade master pk update if no cascade

Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used

functional fkey cascade master uk delete if no cascade

Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master uk on update cascade

Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master uk update if no cascade

Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used

functional fkey common dml in detail if no parent exists

Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey common non priv user access to child for cascade

FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null

functional fkey common non priv user access to child for set default

Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration.

functional fkey common non priv user access to child for set null

Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration.

functional fkey common prohibit change of key column types

Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration.

functional fkey common restrictions for default fk fields

Attempt to change type of any column involved in PK/FK constraints must fail.

functional fkey common restrictions for diff table types

FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed

functional fkey common restrictions for not null fk fields

Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound).

functional gtcs isql one line comments 01

FK definition: SET NULL clause should not lead FK-columns to have NULLs.

bug #781610 problems with one line comments (--)

Check ability to obtain non-ascii content from firebird.log and trace when use ON DISCONNECT trigger and exception with non-ascii names, charset = UTF8.

functional sqlancer arch 2312 17510 example 02

Check ability to obtain non-ascii content from firebird.log and trace when use ON DISCONNECT trigger and exception with non-ascii names, charset = UTF8.

functional sqlancer doi 10 1145 3428279 example 01

Bug in RIGHT JOIN

functional sqlancer doi 10 1145 3428279 example 02

predicate 0 = -0 to incorrectly evaluate to FALSE.

functional sqlancer doi 10 1145 3428279 example 04

Wrong result of UNION DISTINCT

functional sqlancer doi 10 1145 3428279 example 06

Wrong result of AVG evaluation as result of SUM / COUNT

functional sqlancer doi 10 1145 3428279 example 09

Failed to fetch a row from a view.

functional sqlancer doi 10 1145 3428279 example 10

GROUP BY ignores COLLATE with case insensitive attribute

functional sqlancer doi 10 1145 3428279 example 11

Unnexpectedly optimized VARIANCE(0) to FALSE

functional sqlancer doi 10 1145 3428279 example 17

Non-deterministic output when using MAX() function

functional sqlancer doi 10 1145 3428279 example 18

Conversion of character string to boolean value

functional sqlancer osdi20 rigger example 05

Comparison of string and numeric literals

functional sqlancer osdi20 rigger example 12

Incorrect result of LIKE.

functional sqlancer stonedb misc examples

Unexpected null value when index is used

functional sqlancer tidb 15844

Bugs Found in StoneDB by SQLancer

functional sqlancer tidb 16028

NATURAL RIGHT JOIN results in an unexpected "Unknown column" error

functional sqlancer tidb 35522

Incorrect result when comparing a FLOAT/DOUBLE UNSIGNED with a negative number

functional sqlancer tidb challenge 19

incorrect unresolved column when using natural join

functional sqlancer tidb challenge 48

Incorrect result for LEFT JOIN and CASE operator

functional tabloid 3123a5a0

UNIQUE constraint on DECIMAL/floating-point columns causes incorrect result for NULL in AND

functional tabloid ibp 124

Check ability to reuse internal connection by EXECUTE STATEMENT.

WHERE CURRENT OF <C> within block that has savepoint: statement #2 must see changes produced by statement #1

Test name

mode

median_ms

4.0.6.3189
2025.02.25

1a1a5

4.0.6.3184
2025.02.24

9388c

4.0.6.3183
2025.02.16

cf6ca

4.0.6.3169
2024.12.13

42cc1

4.0.6.3169
2024.12.08

50eb6

4.0.6.3168
2024.11.28

48149

4.0.6.3163
2024.10.16

2bb10

4.0.6.3163
2024.10.15

f387e

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.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.25

4b9c7

Test TITLE

bugs gh 8429

2145

2751

1540

Segfault when already destroyed callback interface is used

bugs gh 8508

603

Conversion Error with old.field in UPDATE OR INSERT

bugs gh 8508

functional fkey cascade cascade recursive actions

386

Conversion Error with old.field in UPDATE OR INSERT

854

Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables.

functional fkey cascade cascade recursive actions

700

Cyclic references between PK and FK (declared with 'ON ... CASCADE') must not cause infinite loop when records are deleted or updated in any of involved tables.

functional fkey cascade master pk delete if no cascade

678

Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master pk delete if no cascade

536

Attempt to delete record in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master pk on delete cascade

683

Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.

functional fkey cascade master pk on delete cascade

508

Deleting record in master must cause deletions in appropriate detail if FK references to PK and 'ON DELETE CASCADE' option is used.

functional fkey cascade master pk on update cascade

714

Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used

functional fkey cascade master pk on update cascade

513

Updating PK column(s) in master must cause changes in appropriate detail column(s) if FK references to PK and 'ON UPDATE CASCADE' option is used

functional fkey cascade master pk update if no cascade

594

Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master pk update if no cascade

518

Attempt to update PK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master uk delete if no cascade

692

Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master uk delete if no cascade

505

Attempt to delete record in master with UK must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master uk on update cascade

680

Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used

functional fkey cascade master uk on update cascade

485

Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used

functional fkey cascade master uk update if no cascade

642

Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey cascade master uk update if no cascade

501

Attempt to update UK column(s) in master must fail if there is FK record in detail and FK was declared without CASCADE option

functional fkey common dml in detail if no parent exists

662

FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null

functional fkey common dml in detail if no parent exists

501

FK-columns columns in the child table must either all be equal to appropriate columns in the parent or some/all of them must be null

functional fkey common non priv user access to child for cascade

1788

Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration.

functional fkey common non priv user access to child for cascade

1210

Child table must be updated even if current user has no privileges on it but 'CASCADE' present in FK declaration.

functional fkey common non priv user access to child for set default

1919

Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration.

functional fkey common non priv user access to child for set default

1203

Child table must be updated even if current user has no privileges on it but 'SET DEFAULT' present in FK declaration.

functional fkey common non priv user access to child for set null

1725

Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration.

functional fkey common non priv user access to child for set null

1223

Child table must be updated even if current user has no privileges on it but 'SET NULL' present in FK declaration.

functional fkey common prohibit change of key column types

643

Attempt to change type of any column involved in PK/FK constraints must fail.

functional fkey common prohibit change of key column types

470

Attempt to change type of any column involved in PK/FK constraints must fail.

functional fkey common restrictions for default fk fields

657

FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed

functional fkey common restrictions for default fk fields

526

FK definition: SET DEFAULT clause should not lead FK-columns to have their default values if parent record not yet exists or was removed

functional fkey common restrictions for diff table types

666

Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound).

functional fkey common restrictions for diff table types

481

Tables involved in referential integrity have to meet restrictions when their types differ (persistent vs GTT; connection-bound vs transaction-bound).

functional fkey common restrictions for not null fk fields

664

FK definition: SET NULL clause should not lead FK-columns to have NULLs.

functional fkey common restrictions for not null fk fields

487

FK definition: SET NULL clause should not lead FK-columns to have NULLs.

functional gtcs isql one line comments 01

556

bug #781610 problems with one line comments (--)

functional gtcs isql one line comments 01

353

bug #781610 problems with one line comments (--)

573

3835

656

682

691

545

517

524

506

573

Check ability to obtain non-ascii content from firebird.log and trace when use ON DISCONNECT trigger and exception with non-ascii names, charset = UTF8.