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

2132

2725

1540

Segfault when already destroyed callback interface is used

bugs gh 8508

596

Conversion Error with old.field in UPDATE OR INSERT

bugs gh 8508

functional fkey cascade cascade recursive actions

414

Conversion Error with old.field in UPDATE OR INSERT

816

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

558

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

659

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

402

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

641

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

472

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

661

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

542

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

641

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

557

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

708

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

547

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

728

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

452

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

624

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

473

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

675

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

489

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

1719

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

1263

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

1724

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

1226

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

1705

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

1266

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

721

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

functional fkey common prohibit change of key column types

520

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

functional fkey common restrictions for default fk fields

733

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

550

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

652

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

507

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

689

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

functional fkey common restrictions for not null fk fields

508

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

functional gtcs isql one line comments 01

589

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

functional gtcs isql one line comments 01

416

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

573

3729

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.