01. Total results for each kind of outcome and server mode, for previous 35 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (2 rows)
03. NEW FAILS: tests which failed for LAST run (3 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 (14 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (2 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (18 rows)
07. Has fails: tests with at least one fail for previous 35 runs (145 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (746 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 35 runs (2 rows)
[CURRENT] 10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (133 rows)
11. All tests: outcomes for previous 35 runs (3508 rows)
12. Skipped: tests which was intentionally excluded from execution (255 rows)

Generated UTC 02.11.2025 13:23
Tested: HQ40.   Build / date: 4.0.6.3223-970bec8a / 2025.08.18;
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: 2.0.2; firebird.Qa: 0.21.0 
Loading data. Please wait...

Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Tests with result = "PASSED" after previous outcome = FAIL/ERROR/SKIPPED or absent:

NN Test name mode
4.0.6.3223
2025.08.18
970be
4.0.6.3222
2025.07.22
685b7
4.0.6.3221
2025.07.15
0a02f
4.0.6.3189
2025.02.25
1a1a5
4.0.6.3184
2025.02.24
9388c
4.0.6.3183
2025.02.17
e4762
4.0.6.3169
2024.12.13
42cc1
4.0.6.3169
2024.12.08
50eb6
4.0.6.3168
2024.12.07
98d69
4.0.6.3168
2024.12.05
cee43
4.0.6.3168
2024.11.28
48149
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
Test TITLE
1
bugs core 0214 
 tracker
 CS P F P P P P P P P P P P P P P P F P P P P P P P P P P P P P P P P P P
Count (DISTINCT ...) is too slow
2
bugs gh 8554 
 tracker
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Firebird XDR Message Parsing NULL Pointer Dereference Denial-of-Service Vulnerability
3
bugs gh 8794 
 tracker
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Called procedure parameter changes during execution without assignment when deleting from updatable view
4
functional gtcs cursors 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Test of CURSOR functionality
5
functional gtcs nested func 01 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Test of NESTED FUNCTIONS functionality
6
functional gtcs nested proc 01 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Test of NESTED PROCEDURES functionality
7
functional gtcs select delete 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
8
functional gtcs sql predicates 00 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support for SINGULAR <subquery>
9
functional gtcs sql predicates 01 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support for NOT SINGULAR <subquery>
10
functional gtcs sql predicates 02 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support for SINGULAR when subquery refers to another table
11
functional gtcs sql predicates 03 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support for NOT SINGULAR when subquery refers to another table
12
functional gtcs sql predicates 04 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support for NOT SINGULAR when subquery refers to another table
13
functional gtcs sql predicates 05 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support to SINGULAR in nested subqueries
14
functional gtcs sql predicates 06 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Support to multiple SINGULAR subqueries
15
functional gtcs sql predicates 07 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
SINGULAR subquery applied to result of join
16
functional gtcs sql predicates 08 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
SINGULAR subquery applied to result of join
17
functional gtcs sql predicates 09 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Applying SINGULAR to result of query with aggregate function
18
functional gtcs sql predicates 10 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Check result of DISTINCT when applying SINGULAR to result of query with aggregate function
19
functional gtcs sql predicates 11 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Check result of GROUP BY + ORDER BY when applying SINGULAR to result of query with aggregate function
20
functional gtcs sql predicates 16 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Check of applying SINGULAR to result produced by a VIEW
21
functional gtcs sql predicates 17 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Check of applying SINGULAR to result produced by a JOIN of two views
22
functional gtcs sql predicates 18 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
GROUP BY of result of SINGULAR which is applied to result of JOIN
23
functional gtcs sql predicates 19 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
GROUP BY of result of SINGULAR which is applied to result of VIEWS JOIN
24
functional gtcs sql predicates 21 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
SINGULAR - Subquery returning exactly one row.
25
functional gtcs sql predicates 22 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
SINGULAR - subquery uses CONTAINING
26
functional intfunc string substring 01 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Positional SUBSTRING function
27
functional sqlite 002caede89 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LEFT JOIN with OR terms in WHERE clause causes assertion fault
28
functional sqlite 02a8e81d44 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
29
functional sqlite 05f43be8fd 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect use of index with LIKE operators when the LHS is a blob
30
functional sqlite 07d6a0453d 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
OFFSET ignored if there is no FROM clause
31
functional sqlite 0911b5d161 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion
32
functional sqlite 123c9ba321 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result when an index is used for an ordered join
33
functional sqlite 16c9801ceb 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Segfault on DELETE with WHERE containing OR and redundant index exists.
34
functional sqlite 190c2507ee 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault on a query against a view
35
functional sqlite 199df4168c 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Different answer with and without index on IN operator with type mismatch
36
functional sqlite 1b266395d6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
37
functional sqlite 1c69be2daf 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect GROUP BY when input and output columns have the same name
38
functional sqlite 1e39b966ae 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LEFT JOIN strength reduction optimization causes an error.
39
functional sqlite 209d31e316 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault when deleting a table out from under a SELECT
40
functional sqlite 25e335f802 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.
41
functional sqlite 2df0107bd2 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result from LEFT JOIN with a subquery on the LHS
42
functional sqlite 2f7170d73b 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
43
functional sqlite 31338dca7e 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
OR operator in WHERE clause gives wrong answer when indexed
44
functional sqlite 31a19d11b9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Name resolution issue with compound SELECTs and Common Table Expressions
45
functional sqlite 34a579141b 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect results with OR terms in the ON clause of a LEFT JOIN
46
functional sqlite 34cd55d68e 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Database corruption following INSERT with a TRIGGER that does an affinity change
47
functional sqlite 3557ad65a0 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect DISTINCT on an indexed query with IN
48
functional sqlite 360c6073e1 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Aggregate MAX() function with COLLATE clause
49
functional sqlite 38a97a87a6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Inaccurate int/float comparison results in corrupt index
50
functional sqlite 38cb5df375 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LIMIT ignored on compound query with subqueries
51
functional sqlite 3998683a16 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Some valid floating-point literals are not recognized.
52
functional sqlite 3c27b97e31 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
REAL rounding seems to depend on index presence
53
functional sqlite 3dbdcdb14e 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault using indices with redundant columns
54
functional sqlite 43107840f1 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault on UPDATE
55
functional sqlite 4766f44486 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
ORDER BY handling with indexes on expressions
56
functional sqlite 490a4b7235 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion when "WHERE 0" on the first element of a UNION present
57
functional sqlite 4ba5abf65c 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Index on expression leads to an incorrect LEFT JOIN
58
functional sqlite 4baa464912 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
NULL handling for indexes on expressions
59
functional sqlite 4e8e4857d3 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Crash on query using an OR term in the WHERE clause
60
functional sqlite 4ef7e3cfca 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Name resolution problem in sub-selects within triggers
61
functional sqlite 4feb3159c6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Crash due to misuse of window functions.
62
functional sqlite 510cde2777 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Endless loop on a query with window functions, ORDER BY, and LIMIT
63
functional sqlite 54844eea3f 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect caching of sub-query results in the FROM clause of a scalar sub-query.
64
functional sqlite 57c47526c3 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect answer when flattening a UNION ALL compound
65
functional sqlite 5e3c886796 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Correlated subquery on the RHS of an IN operator causes output of excessive rows
66
functional sqlite 5ed1772895 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect ORDER BY on an indexed JOIN
67
functional sqlite 65eb38f6e4 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect answer on LEFT JOIN when STAT4 is enabled
68
functional sqlite 6c1d3febc0 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
69
functional sqlite 6f2222d550 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect output on a LEFT JOIN
70
functional sqlite 752e1646fc 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Wrong result if DISTINCT used on subquery which uses ORDER BY.
71
functional sqlite 787fa716be 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault when multi-use subquery implemented by co-routine
72
functional sqlite 7a31705a7e 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Name resolution fails when table name is a prefix of another table
73
functional sqlite 7f7f8026ed 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Segfault following heavy SAVEPOINT usage
74
functional sqlite 7fa8049685 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result on a LEFT JOIN when using an index
75
functional sqlite 7fde638e94 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault on a LEFT JOIN
76
functional sqlite 80ba201079 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Bug involving subqueries and the OR optimization
77
functional sqlite 8454a207b9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
ALTER TABLE ADD COLUMN with negative DEFAULT value
78
functional sqlite 868145d012 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
79
functional sqlite 892fc34f17 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect query result when a LEFT JOIN subquery is flattened
80
functional sqlite 93fb9f89d6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Index causes incorrect WHERE clause evaluation
81
functional sqlite 96c1454cbf 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result with ORDER BY DESC and LIMIT
82
functional sqlite 98825a79ce 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
83
functional sqlite a179fe7465 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect output order on a join with an ORDER BY
84
functional sqlite a696379c1f 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Access violation error trying to insert into triggered view
85
functional sqlite ae3c5670b6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Bug caused by factoring of constants in trigger programs
86
functional sqlite afdc5a29dc 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
87
functional sqlite b148fa6105 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
CAST takes implicit COLLATE of its operand
88
functional sqlite b1d8c79314 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
89
functional sqlite b50528af44 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.
90
functional sqlite b5ca442af9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
"Malformed database schema" when creating a failing index within a transaction
91
functional sqlite b65cb2c8d9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect LIMIT on a UNION ALL query
92
functional sqlite b75a9ca6b0 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
ORDER BY ignored if query has identical GROUP BY
93
functional sqlite b7c8682cc1 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result from LEFT JOIN with OR in the WHERE clause
94
functional sqlite ba7cbfaedc 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Wrong output order when a DESC index and GROUP BY and ORDER BY.
95
functional sqlite bc1aea7b72 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
96
functional sqlite bc878246ea 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result from LEFT JOIN query
97
functional sqlite bc8d94f0fb 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
RENAME COLUMN fails on tables with redundant UNIQUE constraints
98
functional sqlite be84e357c0 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Segfault during query involving LEFT JOIN column in the ORDER BY clause
99
functional sqlite bfbf38e5e9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Segfault on a nested join
100
functional sqlite c2a19d8165 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect LEFT JOIN when FROM clause contains nested subqueries
101
functional sqlite c2ad16f997 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Segfault on query involving deeply nested aggregate views
102
functional sqlite c31034044b 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LEFT JOIN in view malfunctions with NOTNULL
103
functional sqlite c5ea805691 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Inverted sort order when using DISTINCT and a descending index
104
functional sqlite c620261b5b 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result on query involving LEFT JOIN and transitive constraints
105
functional sqlite c94369cae9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Wrong answer when use no-case collation due to the LIKE optimization
106
functional sqlite c997b11c4d 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
ORDER BY clause ignored in 3-way join query
107
functional sqlite ca0d20b6cd 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
COLLATE operator masked by function calls
108
functional sqlite cad1ab4cb7 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Segfault due to LEFT JOIN flattening optimization
109
functional sqlite ce7c133ea6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Foreign key constraint fails when it should succeed.
110
functional sqlite ce82323194 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Duplicate CTE name gives incorrect result
111
functional sqlite ce8717f088 
 SS P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LIKE malfunctions for UNIQUE COLLATE NOCASE column
112
functional sqlite d02e1406a5 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LEFT JOIN with an OR in the ON clause causes segfault
113
functional sqlite d06a25c844 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result from a UNION with an ORDER BY
114
functional sqlite d0866b26f8 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Window function in correlated subquery causes assertion fault
115
functional sqlite d11a6e908f 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Query planner fault on three-way nested join with compound inner SELECT
116
functional sqlite d3e7f2ba5b 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Nested boolean formula with IN operator computes an incorrect result
117
functional sqlite d666d600a6 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
COLLATE operator on lhs of BETWEEN expression is ignored.
118
functional sqlite d805526eae 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect join result or assertion fault due to transitive constraints
119
functional sqlite db4d96798d 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LIMIT does not work with nested views containing UNION ALL
120
functional sqlite db87229497 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result when RHS of IN operator contains DISTINCT and LIMIT
121
functional sqlite dc6ebeda93 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect DELETE due to the one-pass optimization
122
functional sqlite dd08e5a988 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Foreign key constraint fails to prevent consistency error.
123
functional sqlite e20dd54ab0 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
124
functional sqlite eb703ba7b5 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result using index on expression with collating function
125
functional sqlite ebdbadade5 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
LEFT JOIN incorrect when ON clause does not reference right table.
126
functional sqlite ec32177c99 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect result with complex OR-connected WHERE
127
functional sqlite f09fcd1781 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Assertion fault when window functions are used.
128
functional sqlite f2369304e4 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect results when OR is used in the ON clause of a LEFT JOIN
129
functional sqlite f617ea3125 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect ORDER BY with colliding input and output column names
130
functional sqlite f74beaabde 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Problem with 3-way joins and the USING clause
131
functional sqlite f7f8c97e97 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Valid query fails to compile due to WHERE clause optimization
132
functional sqlite f97c463710 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect ordering with ORDER BY and LIMIT
133
functional sqlite fc7bd6358f 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Incorrect query result in a 3-way join due to affinity issues

Elapsed time, milliseconds:

NN Test name mode median_ms
4.0.6.3223
2025.08.18
970be
4.0.6.3222
2025.07.22
685b7
4.0.6.3221
2025.07.15
0a02f
4.0.6.3189
2025.02.25
1a1a5
4.0.6.3184
2025.02.24
9388c
4.0.6.3183
2025.02.17
e4762
4.0.6.3169
2024.12.13
42cc1
4.0.6.3169
2024.12.08
50eb6
4.0.6.3168
2024.12.07
98d69
4.0.6.3168
2024.12.05
cee43
4.0.6.3168
2024.11.28
48149
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
Test TITLE
1
bugs core 0214 
 tracker
 CS 2257 21987 22464 21875 21838 21784 22574 22076 21746 21870 21768 22039 2586 2271 2226 2257 2311 2783 2465 2105 2361 1891 1969 1922 1938 1891 1874 1874 1874 1875 1874 1858 1890 1875 2050 2030
Count (DISTINCT ...) is too slow
2
bugs gh 8554 
 tracker
 CS 568 568 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Firebird XDR Message Parsing NULL Pointer Dereference Denial-of-Service Vulnerability
3
bugs gh 8554 
 tracker
 SS 244 244 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Firebird XDR Message Parsing NULL Pointer Dereference Denial-of-Service Vulnerability
4
bugs gh 8794 
 tracker
 CS 610 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Called procedure parameter changes during execution without assignment when deleting from updatable view
5
bugs gh 8794 
 tracker
 SS 414 414 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Called procedure parameter changes during execution without assignment when deleting from updatable view
6
functional gtcs cursors 
 CS 626 626 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Test of CURSOR functionality
7
functional gtcs cursors 
 SS 437 437 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Test of CURSOR functionality
8
functional gtcs nested func 01 
 CS 1312 1312 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Test of NESTED FUNCTIONS functionality
9
functional gtcs nested func 01 
 SS 839 839 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Test of NESTED FUNCTIONS functionality
10
functional gtcs nested proc 01 
 CS 1287 1287 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Test of NESTED PROCEDURES functionality
11
functional gtcs nested proc 01 
 SS 819 819 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Test of NESTED PROCEDURES functionality
12
functional gtcs select delete 
 CS 1057 1057 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13
functional gtcs select delete 
 SS 674 674 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14
functional gtcs sql predicates 00 
 CS 882 882 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for SINGULAR <subquery>
15
functional gtcs sql predicates 00 
 SS 581 581 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for SINGULAR <subquery>
16
functional gtcs sql predicates 01 
 CS 843 843 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for NOT SINGULAR <subquery>
17
functional gtcs sql predicates 01 
 SS 599 599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for NOT SINGULAR <subquery>
18
functional gtcs sql predicates 02 
 CS 850 850 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for SINGULAR when subquery refers to another table
19
functional gtcs sql predicates 02 
 SS 599 599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for SINGULAR when subquery refers to another table
20
functional gtcs sql predicates 03 
 CS 824 824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for NOT SINGULAR when subquery refers to another table
21
functional gtcs sql predicates 03 
 SS 596 596 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for NOT SINGULAR when subquery refers to another table
22
functional gtcs sql predicates 04 
 CS 855 855 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for NOT SINGULAR when subquery refers to another table
23
functional gtcs sql predicates 04 
 SS 589 589 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support for NOT SINGULAR when subquery refers to another table
24
functional gtcs sql predicates 05 
 CS 832 832 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support to SINGULAR in nested subqueries
25
functional gtcs sql predicates 05 
 SS 594 594 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support to SINGULAR in nested subqueries
26
functional gtcs sql predicates 06 
 CS 816 816 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support to multiple SINGULAR subqueries
27
functional gtcs sql predicates 06 
 SS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Support to multiple SINGULAR subqueries
28
functional gtcs sql predicates 07 
 CS 845 845 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR subquery applied to result of join
29
functional gtcs sql predicates 07 
 SS 597 597 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR subquery applied to result of join
30
functional gtcs sql predicates 08 
 CS 819 819 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR subquery applied to result of join
31
functional gtcs sql predicates 08 
 SS 599 599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR subquery applied to result of join
32
functional gtcs sql predicates 09 
 CS 821 821 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Applying SINGULAR to result of query with aggregate function
33
functional gtcs sql predicates 09 
 SS 595 595 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Applying SINGULAR to result of query with aggregate function
34
functional gtcs sql predicates 10 
 CS 828 828 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check result of DISTINCT when applying SINGULAR to result of query with aggregate function
35
functional gtcs sql predicates 10 
 SS 597 597 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check result of DISTINCT when applying SINGULAR to result of query with aggregate function
36
functional gtcs sql predicates 11 
 CS 822 822 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check result of GROUP BY + ORDER BY when applying SINGULAR to result of query with aggregate function
37
functional gtcs sql predicates 11 
 SS 598 598 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check result of GROUP BY + ORDER BY when applying SINGULAR to result of query with aggregate function
38
functional gtcs sql predicates 16 
 CS 826 826 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check of applying SINGULAR to result produced by a VIEW
39
functional gtcs sql predicates 16 
 SS 593 593 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check of applying SINGULAR to result produced by a VIEW
40
functional gtcs sql predicates 17 
 CS 812 812 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check of applying SINGULAR to result produced by a JOIN of two views
41
functional gtcs sql predicates 17 
 SS 595 595 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Check of applying SINGULAR to result produced by a JOIN of two views
42
functional gtcs sql predicates 18 
 CS 852 852 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
GROUP BY of result of SINGULAR which is applied to result of JOIN
43
functional gtcs sql predicates 18 
 SS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
GROUP BY of result of SINGULAR which is applied to result of JOIN
44
functional gtcs sql predicates 19 
 CS 844 844 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
GROUP BY of result of SINGULAR which is applied to result of VIEWS JOIN
45
functional gtcs sql predicates 19 
 SS 599 599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
GROUP BY of result of SINGULAR which is applied to result of VIEWS JOIN
46
functional gtcs sql predicates 21 
 CS 837 837 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR - Subquery returning exactly one row.
47
functional gtcs sql predicates 21 
 SS 593 593 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR - Subquery returning exactly one row.
48
functional gtcs sql predicates 22 
 CS 820 820 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR - subquery uses CONTAINING
49
functional gtcs sql predicates 22 
 SS 592 592 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SINGULAR - subquery uses CONTAINING
50
functional intfunc string substring 01 
 CS 620 620 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Positional SUBSTRING function
51
functional intfunc string substring 01 
 SS 418 418 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Positional SUBSTRING function
52
functional sqlite 002caede89 
 CS 609 609 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN with OR terms in WHERE clause causes assertion fault
53
functional sqlite 002caede89 
 SS 421 421 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN with OR terms in WHERE clause causes assertion fault
54
functional sqlite 02a8e81d44 
 CS 621 621 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
55
functional sqlite 02a8e81d44 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
56
functional sqlite 05f43be8fd 
 CS 654 654 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect use of index with LIKE operators when the LHS is a blob
57
functional sqlite 05f43be8fd 
 SS 425 425 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect use of index with LIKE operators when the LHS is a blob
58
functional sqlite 07d6a0453d 
 CS 635 635 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OFFSET ignored if there is no FROM clause
59
functional sqlite 07d6a0453d 
 SS 402 402 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OFFSET ignored if there is no FROM clause
60
functional sqlite 0911b5d161 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion
61
functional sqlite 0911b5d161 
 SS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion
62
functional sqlite 123c9ba321 
 CS 625 625 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result when an index is used for an ordered join
63
functional sqlite 123c9ba321 
 SS 416 416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result when an index is used for an ordered join
64
functional sqlite 16c9801ceb 
 CS 620 620 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault on DELETE with WHERE containing OR and redundant index exists.
65
functional sqlite 16c9801ceb 
 SS 421 421 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault on DELETE with WHERE containing OR and redundant index exists.
66
functional sqlite 190c2507ee 
 CS 641 641 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on a query against a view
67
functional sqlite 190c2507ee 
 SS 404 404 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on a query against a view
68
functional sqlite 199df4168c 
 CS 645 645 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Different answer with and without index on IN operator with type mismatch
69
functional sqlite 199df4168c 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Different answer with and without index on IN operator with type mismatch
70
functional sqlite 1b266395d6 
 CS 625 625 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
71
functional sqlite 1b266395d6 
 SS 409 409 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
72
functional sqlite 1c69be2daf 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect GROUP BY when input and output columns have the same name
73
functional sqlite 1c69be2daf 
 SS 404 404 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect GROUP BY when input and output columns have the same name
74
functional sqlite 1e39b966ae 
 CS 614 614 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN strength reduction optimization causes an error.
75
functional sqlite 1e39b966ae 
 SS 414 414 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN strength reduction optimization causes an error.
76
functional sqlite 209d31e316 
 CS 642 642 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault when deleting a table out from under a SELECT
77
functional sqlite 209d31e316 
 SS 421 421 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault when deleting a table out from under a SELECT
78
functional sqlite 25e335f802 
 CS 610 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.
79
functional sqlite 25e335f802 
 SS 405 405 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.
80
functional sqlite 2df0107bd2 
 CS 662 662 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN with a subquery on the LHS
81
functional sqlite 2df0107bd2 
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN with a subquery on the LHS
82
functional sqlite 2f7170d73b 
 CS 641 641 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
83
functional sqlite 2f7170d73b 
 SS 405 405 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
84
functional sqlite 31338dca7e 
 CS 670 670 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OR operator in WHERE clause gives wrong answer when indexed
85
functional sqlite 31338dca7e 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OR operator in WHERE clause gives wrong answer when indexed
86
functional sqlite 31a19d11b9 
 CS 609 609 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Name resolution issue with compound SELECTs and Common Table Expressions
87
functional sqlite 31a19d11b9 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Name resolution issue with compound SELECTs and Common Table Expressions
88
functional sqlite 34a579141b 
 CS 723 723 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect results with OR terms in the ON clause of a LEFT JOIN
89
functional sqlite 34a579141b 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect results with OR terms in the ON clause of a LEFT JOIN
90
functional sqlite 34cd55d68e 
 CS 675 675 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Database corruption following INSERT with a TRIGGER that does an affinity change
91
functional sqlite 34cd55d68e 
 SS 419 419 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Database corruption following INSERT with a TRIGGER that does an affinity change
92
functional sqlite 3557ad65a0 
 CS 628 628 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect DISTINCT on an indexed query with IN
93
functional sqlite 3557ad65a0 
 SS 405 405 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect DISTINCT on an indexed query with IN
94
functional sqlite 360c6073e1 
 CS 655 655 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Aggregate MAX() function with COLLATE clause
95
functional sqlite 360c6073e1 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Aggregate MAX() function with COLLATE clause
96
functional sqlite 38a97a87a6 
 CS 612 612 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inaccurate int/float comparison results in corrupt index
97
functional sqlite 38a97a87a6 
 SS 409 409 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inaccurate int/float comparison results in corrupt index
98
functional sqlite 38cb5df375 
 CS 630 630 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIMIT ignored on compound query with subqueries
99
functional sqlite 38cb5df375 
 SS 409 409 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIMIT ignored on compound query with subqueries
100
functional sqlite 3998683a16 
 CS 645 645 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Some valid floating-point literals are not recognized.
101
functional sqlite 3998683a16 
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Some valid floating-point literals are not recognized.
102
functional sqlite 3c27b97e31 
 CS 673 673 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
REAL rounding seems to depend on index presence
103
functional sqlite 3c27b97e31 
 SS 404 404 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
REAL rounding seems to depend on index presence
104
functional sqlite 3dbdcdb14e 
 CS 659 659 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault using indices with redundant columns
105
functional sqlite 3dbdcdb14e 
 SS 396 396 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault using indices with redundant columns
106
functional sqlite 43107840f1 
 CS 626 626 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on UPDATE
107
functional sqlite 43107840f1 
 SS 402 402 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on UPDATE
108
functional sqlite 4766f44486 
 CS 613 613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY handling with indexes on expressions
109
functional sqlite 4766f44486 
 SS 404 404 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY handling with indexes on expressions
110
functional sqlite 490a4b7235 
 CS 607 607 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion when "WHERE 0" on the first element of a UNION present
111
functional sqlite 490a4b7235 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion when "WHERE 0" on the first element of a UNION present
112
functional sqlite 4ba5abf65c 
 CS 612 612 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index on expression leads to an incorrect LEFT JOIN
113
functional sqlite 4ba5abf65c 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index on expression leads to an incorrect LEFT JOIN
114
functional sqlite 4baa464912 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NULL handling for indexes on expressions
115
functional sqlite 4baa464912 
 SS 428 428 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
NULL handling for indexes on expressions
116
functional sqlite 4e8e4857d3 
 CS 604 604 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash on query using an OR term in the WHERE clause
117
functional sqlite 4e8e4857d3 
 SS 418 418 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash on query using an OR term in the WHERE clause
118
functional sqlite 4ef7e3cfca 
 CS 626 626 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Name resolution problem in sub-selects within triggers
119
functional sqlite 4ef7e3cfca 
 SS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Name resolution problem in sub-selects within triggers
120
functional sqlite 4feb3159c6 
 CS 614 614 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash due to misuse of window functions.
121
functional sqlite 4feb3159c6 
 SS 391 391 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Crash due to misuse of window functions.
122
functional sqlite 510cde2777 
 CS 647 647 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Endless loop on a query with window functions, ORDER BY, and LIMIT
123
functional sqlite 510cde2777 
 SS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Endless loop on a query with window functions, ORDER BY, and LIMIT
124
functional sqlite 54844eea3f 
 CS 609 609 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect caching of sub-query results in the FROM clause of a scalar sub-query.
125
functional sqlite 54844eea3f 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect caching of sub-query results in the FROM clause of a scalar sub-query.
126
functional sqlite 57c47526c3 
 CS 647 647 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect answer when flattening a UNION ALL compound
127
functional sqlite 57c47526c3 
 SS 420 420 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect answer when flattening a UNION ALL compound
128
functional sqlite 5e3c886796 
 CS 604 604 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Correlated subquery on the RHS of an IN operator causes output of excessive rows
129
functional sqlite 5e3c886796 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Correlated subquery on the RHS of an IN operator causes output of excessive rows
130
functional sqlite 5ed1772895 
 CS 643 643 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ORDER BY on an indexed JOIN
131
functional sqlite 5ed1772895 
 SS 411 411 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ORDER BY on an indexed JOIN
132
functional sqlite 65eb38f6e4 
 CS 639 639 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect answer on LEFT JOIN when STAT4 is enabled
133
functional sqlite 65eb38f6e4 
 SS 422 422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect answer on LEFT JOIN when STAT4 is enabled
134
functional sqlite 6c1d3febc0 
 CS 611 611 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
135
functional sqlite 6c1d3febc0 
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
136
functional sqlite 6f2222d550 
 CS 646 646 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect output on a LEFT JOIN
137
functional sqlite 6f2222d550 
 SS 400 400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect output on a LEFT JOIN
138
functional sqlite 752e1646fc 
 CS 644 644 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result if DISTINCT used on subquery which uses ORDER BY.
139
functional sqlite 752e1646fc 
 SS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result if DISTINCT used on subquery which uses ORDER BY.
140
functional sqlite 787fa716be 
 CS 653 653 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault when multi-use subquery implemented by co-routine
141
functional sqlite 787fa716be 
 SS 455 455 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault when multi-use subquery implemented by co-routine
142
functional sqlite 7a31705a7e 
 CS 604 604 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Name resolution fails when table name is a prefix of another table
143
functional sqlite 7a31705a7e 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Name resolution fails when table name is a prefix of another table
144
functional sqlite 7f7f8026ed 
 CS 618 618 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault following heavy SAVEPOINT usage
145
functional sqlite 7f7f8026ed 
 SS 418 418 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault following heavy SAVEPOINT usage
146
functional sqlite 7fa8049685 
 CS 643 643 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on a LEFT JOIN when using an index
147
functional sqlite 7fa8049685 
 SS 411 411 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on a LEFT JOIN when using an index
148
functional sqlite 7fde638e94 
 CS 610 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on a LEFT JOIN
149
functional sqlite 7fde638e94 
 SS 411 411 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on a LEFT JOIN
150
functional sqlite 80ba201079 
 CS 614 614 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Bug involving subqueries and the OR optimization
151
functional sqlite 80ba201079 
 SS 404 404 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Bug involving subqueries and the OR optimization
152
functional sqlite 8454a207b9 
 CS 613 613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ALTER TABLE ADD COLUMN with negative DEFAULT value
153
functional sqlite 8454a207b9 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ALTER TABLE ADD COLUMN with negative DEFAULT value
154
functional sqlite 868145d012 
 CS 620 620 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
155
functional sqlite 868145d012 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
156
functional sqlite 892fc34f17 
 CS 605 605 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect query result when a LEFT JOIN subquery is flattened
157
functional sqlite 892fc34f17 
 SS 414 414 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect query result when a LEFT JOIN subquery is flattened
158
functional sqlite 93fb9f89d6 
 CS 610 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index causes incorrect WHERE clause evaluation
159
functional sqlite 93fb9f89d6 
 SS 416 416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index causes incorrect WHERE clause evaluation
160
functional sqlite 96c1454cbf 
 CS 626 626 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result with ORDER BY DESC and LIMIT
161
functional sqlite 96c1454cbf 
 SS 422 422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result with ORDER BY DESC and LIMIT
162
functional sqlite 98825a79ce 
 CS 607 607 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
163
functional sqlite 98825a79ce 
 SS 438 438 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
164
functional sqlite a179fe7465 
 CS 620 620 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect output order on a join with an ORDER BY
165
functional sqlite a179fe7465 
 SS 424 424 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect output order on a join with an ORDER BY
166
functional sqlite a696379c1f 
 CS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Access violation error trying to insert into triggered view
167
functional sqlite a696379c1f 
 SS 416 416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Access violation error trying to insert into triggered view
168
functional sqlite ae3c5670b6 
 CS 656 656 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Bug caused by factoring of constants in trigger programs
169
functional sqlite ae3c5670b6 
 SS 422 422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Bug caused by factoring of constants in trigger programs
170
functional sqlite afdc5a29dc 
 CS 612 612 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
171
functional sqlite afdc5a29dc 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
172
functional sqlite b148fa6105 
 CS 656 656 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CAST takes implicit COLLATE of its operand
173
functional sqlite b148fa6105 
 SS 422 422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CAST takes implicit COLLATE of its operand
174
functional sqlite b1d8c79314 
 CS 622 622 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
175
functional sqlite b1d8c79314 
 SS 420 420 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
176
functional sqlite b50528af44 
 CS 902 902 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.
177
functional sqlite b50528af44 
 SS 438 438 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.
178
functional sqlite b5ca442af9 
 CS 649 649 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"Malformed database schema" when creating a failing index within a transaction
179
functional sqlite b5ca442af9 
 SS 424 424 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"Malformed database schema" when creating a failing index within a transaction
180
functional sqlite b65cb2c8d9 
 CS 600 600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect LIMIT on a UNION ALL query
181
functional sqlite b65cb2c8d9 
 SS 409 409 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect LIMIT on a UNION ALL query
182
functional sqlite b75a9ca6b0 
 CS 623 623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY ignored if query has identical GROUP BY
183
functional sqlite b75a9ca6b0 
 SS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY ignored if query has identical GROUP BY
184
functional sqlite b7c8682cc1 
 CS 647 647 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN with OR in the WHERE clause
185
functional sqlite b7c8682cc1 
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN with OR in the WHERE clause
186
functional sqlite ba7cbfaedc 
 CS 618 618 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong output order when a DESC index and GROUP BY and ORDER BY.
187
functional sqlite ba7cbfaedc 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong output order when a DESC index and GROUP BY and ORDER BY.
188
functional sqlite bc1aea7b72 
 CS 605 605 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
189
functional sqlite bc1aea7b72 
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
190
functional sqlite bc878246ea 
 CS 611 611 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN query
191
functional sqlite bc878246ea 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN query
192
functional sqlite bc8d94f0fb 
 CS 615 615 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RENAME COLUMN fails on tables with redundant UNIQUE constraints
193
functional sqlite bc8d94f0fb 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
RENAME COLUMN fails on tables with redundant UNIQUE constraints
194
functional sqlite be84e357c0 
 CS 613 613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault during query involving LEFT JOIN column in the ORDER BY clause
195
functional sqlite be84e357c0 
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault during query involving LEFT JOIN column in the ORDER BY clause
196
functional sqlite bfbf38e5e9 
 CS 628 628 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault on a nested join
197
functional sqlite bfbf38e5e9 
 SS 426 426 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault on a nested join
198
functional sqlite c2a19d8165 
 CS 603 603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect LEFT JOIN when FROM clause contains nested subqueries
199
functional sqlite c2a19d8165 
 SS 402 402 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect LEFT JOIN when FROM clause contains nested subqueries
200
functional sqlite c2ad16f997 
 CS 605 605 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault on query involving deeply nested aggregate views
201
functional sqlite c2ad16f997 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault on query involving deeply nested aggregate views
202
functional sqlite c31034044b 
 CS 628 628 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN in view malfunctions with NOTNULL
203
functional sqlite c31034044b 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN in view malfunctions with NOTNULL
204
functional sqlite c5ea805691 
 CS 609 609 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inverted sort order when using DISTINCT and a descending index
205
functional sqlite c5ea805691 
 SS 412 412 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inverted sort order when using DISTINCT and a descending index
206
functional sqlite c620261b5b 
 CS 623 623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on query involving LEFT JOIN and transitive constraints
207
functional sqlite c620261b5b 
 SS 418 418 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on query involving LEFT JOIN and transitive constraints
208
functional sqlite c94369cae9 
 CS 632 632 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong answer when use no-case collation due to the LIKE optimization
209
functional sqlite c94369cae9 
 SS 425 425 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong answer when use no-case collation due to the LIKE optimization
210
functional sqlite c997b11c4d 
 CS 654 654 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY clause ignored in 3-way join query
211
functional sqlite c997b11c4d 
 SS 467 467 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY clause ignored in 3-way join query
212
functional sqlite ca0d20b6cd 
 CS 623 623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE operator masked by function calls
213
functional sqlite ca0d20b6cd 
 SS 429 429 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE operator masked by function calls
214
functional sqlite cad1ab4cb7 
 CS 607 607 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault due to LEFT JOIN flattening optimization
215
functional sqlite cad1ab4cb7 
 SS 416 416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault due to LEFT JOIN flattening optimization
216
functional sqlite ce7c133ea6 
 CS 624 624 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Foreign key constraint fails when it should succeed.
217
functional sqlite ce7c133ea6 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Foreign key constraint fails when it should succeed.
218
functional sqlite ce82323194 
 CS 645 645 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duplicate CTE name gives incorrect result
219
functional sqlite ce82323194 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duplicate CTE name gives incorrect result
220
functional sqlite ce8717f088 
 SS 424 424 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIKE malfunctions for UNIQUE COLLATE NOCASE column
221
functional sqlite d02e1406a5 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN with an OR in the ON clause causes segfault
222
functional sqlite d02e1406a5 
 SS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN with an OR in the ON clause causes segfault
223
functional sqlite d06a25c844 
 CS 660 660 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from a UNION with an ORDER BY
224
functional sqlite d06a25c844 
 SS 429 429 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from a UNION with an ORDER BY
225
functional sqlite d0866b26f8 
 CS 659 659 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Window function in correlated subquery causes assertion fault
226
functional sqlite d0866b26f8 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Window function in correlated subquery causes assertion fault
227
functional sqlite d11a6e908f 
 CS 637 637 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Query planner fault on three-way nested join with compound inner SELECT
228
functional sqlite d11a6e908f 
 SS 427 427 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Query planner fault on three-way nested join with compound inner SELECT
229
functional sqlite d3e7f2ba5b 
 CS 635 635 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Nested boolean formula with IN operator computes an incorrect result
230
functional sqlite d3e7f2ba5b 
 SS 432 432 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Nested boolean formula with IN operator computes an incorrect result
231
functional sqlite d666d600a6 
 CS 686 686 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE operator on lhs of BETWEEN expression is ignored.
232
functional sqlite d666d600a6 
 SS 422 422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE operator on lhs of BETWEEN expression is ignored.
233
functional sqlite d805526eae 
 CS 659 659 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect join result or assertion fault due to transitive constraints
234
functional sqlite d805526eae 
 SS 409 409 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect join result or assertion fault due to transitive constraints
235
functional sqlite db4d96798d 
 CS 623 623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIMIT does not work with nested views containing UNION ALL
236
functional sqlite db4d96798d 
 SS 429 429 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LIMIT does not work with nested views containing UNION ALL
237
functional sqlite db87229497 
 CS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result when RHS of IN operator contains DISTINCT and LIMIT
238
functional sqlite db87229497 
 SS 419 419 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result when RHS of IN operator contains DISTINCT and LIMIT
239
functional sqlite dc6ebeda93 
 CS 610 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect DELETE due to the one-pass optimization
240
functional sqlite dc6ebeda93 
 SS 433 433 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect DELETE due to the one-pass optimization
241
functional sqlite dd08e5a988 
 CS 616 616 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Foreign key constraint fails to prevent consistency error.
242
functional sqlite dd08e5a988 
 SS 443 443 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Foreign key constraint fails to prevent consistency error.
243
functional sqlite e20dd54ab0 
 CS 637 637 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
244
functional sqlite e20dd54ab0 
 SS 426 426 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
245
functional sqlite eb703ba7b5 
 CS 624 624 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result using index on expression with collating function
246
functional sqlite eb703ba7b5 
 SS 421 421 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result using index on expression with collating function
247
functional sqlite ebdbadade5 
 CS 651 651 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN incorrect when ON clause does not reference right table.
248
functional sqlite ebdbadade5 
 SS 405 405 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LEFT JOIN incorrect when ON clause does not reference right table.
249
functional sqlite ec32177c99 
 CS 633 633 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result with complex OR-connected WHERE
250
functional sqlite ec32177c99 
 SS 402 402 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result with complex OR-connected WHERE
251
functional sqlite f09fcd1781 
 CS 603 603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault when window functions are used.
252
functional sqlite f09fcd1781 
 SS 409 409 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault when window functions are used.
253
functional sqlite f2369304e4 
 CS 611 611 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect results when OR is used in the ON clause of a LEFT JOIN
254
functional sqlite f2369304e4 
 SS 402 402 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect results when OR is used in the ON clause of a LEFT JOIN
255
functional sqlite f617ea3125 
 CS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ORDER BY with colliding input and output column names
256
functional sqlite f617ea3125 
 SS 407 407 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ORDER BY with colliding input and output column names
257
functional sqlite f74beaabde 
 CS 639 639 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Problem with 3-way joins and the USING clause
258
functional sqlite f74beaabde 
 SS 422 422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Problem with 3-way joins and the USING clause
259
functional sqlite f7f8c97e97 
 CS 609 609 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Valid query fails to compile due to WHERE clause optimization
260
functional sqlite f7f8c97e97 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Valid query fails to compile due to WHERE clause optimization
261
functional sqlite f97c463710 
 CS 640 640 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ordering with ORDER BY and LIMIT
262
functional sqlite f97c463710 
 SS 406 406 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ordering with ORDER BY and LIMIT
263
functional sqlite fc7bd6358f 
 CS 615 615 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect query result in a 3-way join due to affinity issues
264
functional sqlite fc7bd6358f 
 SS 403 403 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect query result in a 3-way join due to affinity issues

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-214
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_cursors.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_nested_func_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_nested_proc_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_select_delete.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_00.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_06.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_09.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_11.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_16.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_17.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_18.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_19.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_21.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_sql_predicates_22.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_substring_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_002caede89.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_02a8e81d44.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_05f43be8fd.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_07d6a0453d.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_0911b5d161.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_123c9ba321.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_16c9801ceb.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_190c2507ee.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_199df4168c.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_1b266395d6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_1c69be2daf.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_1e39b966ae.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_209d31e316.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_25e335f802.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_2df0107bd2.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_2f7170d73b.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_31338dca7e.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_31a19d11b9.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_34a579141b.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_34cd55d68e.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_3557ad65a0.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_360c6073e1.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_38a97a87a6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_38cb5df375.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_3998683a16.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_3c27b97e31.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_3dbdcdb14e.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_43107840f1.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_4766f44486.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_490a4b7235.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_4ba5abf65c.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_4baa464912.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_4e8e4857d3.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_4ef7e3cfca.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_4feb3159c6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_510cde2777.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_54844eea3f.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_57c47526c3.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_5e3c886796.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_5ed1772895.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_65eb38f6e4.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_6c1d3febc0.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_6f2222d550.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_752e1646fc.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_787fa716be.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_7a31705a7e.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_7f7f8026ed.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_7fa8049685.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_7fde638e94.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_80ba201079.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_8454a207b9.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_868145d012.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_892fc34f17.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_93fb9f89d6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_96c1454cbf.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_98825a79ce.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_a179fe7465.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_a696379c1f.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ae3c5670b6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_afdc5a29dc.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b148fa6105.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b1d8c79314.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b50528af44.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b5ca442af9.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b65cb2c8d9.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b75a9ca6b0.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_b7c8682cc1.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ba7cbfaedc.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_bc1aea7b72.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_bc878246ea.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_bc8d94f0fb.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_be84e357c0.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_bfbf38e5e9.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c2a19d8165.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c2ad16f997.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c31034044b.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c5ea805691.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c620261b5b.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c94369cae9.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_c997b11c4d.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ca0d20b6cd.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_cad1ab4cb7.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ce7c133ea6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ce82323194.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ce8717f088.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d02e1406a5.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d06a25c844.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d0866b26f8.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d11a6e908f.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d3e7f2ba5b.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d666d600a6.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_d805526eae.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_db4d96798d.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_db87229497.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_dc6ebeda93.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_dd08e5a988.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_e20dd54ab0.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_eb703ba7b5.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ebdbadade5.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_ec32177c99.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f09fcd1781.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f2369304e4.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f617ea3125.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f74beaabde.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f7f8c97e97.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f97c463710.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_fc7bd6358f.py
https://github.com/FirebirdSQL/firebird/issues/8554
https://github.com/FirebirdSQL/firebird/issues/8794
=== end of list ===

Last commits information (all timestamps in UTC):