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 (132 rows)
11. All tests: outcomes for previous 35 runs (3507 rows)
12. Skipped: tests which was intentionally excluded from execution (254 rows)

Generated UTC 08.10.2025 12:53
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
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
4
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
5
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
6
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
7
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>
8
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>
9
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
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
18
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
19
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
20
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
21
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
22
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
23
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.
24
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
25
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
26
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
27
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
28
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
29
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
30
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
31
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
32
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.
33
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
34
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
35
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
36
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
37
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.
38
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
39
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.
40
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
41
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
42
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
43
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
44
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
45
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
46
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
47
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
48
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
49
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
50
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.
51
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
52
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
53
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
54
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
55
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
56
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
57
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
58
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
59
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
60
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.
61
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
62
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.
63
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
64
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
65
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
66
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
67
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.
68
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
69
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.
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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)
78
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
79
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
80
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
81
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
82
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
83
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
84
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
85
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
86
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
87
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
88
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.
89
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
90
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
91
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
92
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
93
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.
94
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
95
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
96
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
97
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
98
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
99
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
100
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
101
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
102
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
103
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
104
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
105
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
106
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
107
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
108
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.
109
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
110
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
111
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
112
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
113
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
114
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
115
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
116
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.
117
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
118
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
119
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
120
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
121
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.
122
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
123
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
124
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.
125
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
126
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.
127
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
128
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
129
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
130
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
131
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
132
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 22203 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 588 588 0 0 0 0 0 0 0 0 0 0 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 239 239 0 0 0 0 0 0 0 0 0 0 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
functional gtcs cursors 
 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
Test of CURSOR functionality
5
functional gtcs cursors 
 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
Test of CURSOR functionality
6
functional gtcs nested func 01 
 CS 1282 1282 0 0 0 0 0 0 0 0 0 0 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
7
functional gtcs nested func 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 FUNCTIONS functionality
8
functional gtcs nested proc 01 
 CS 1277 1277 0 0 0 0 0 0 0 0 0 0 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
9
functional gtcs nested proc 01 
 SS 818 818 0 0 0 0 0 0 0 0 0 0 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
10
functional gtcs select delete 
 CS 1359 1359 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11
functional gtcs select delete 
 SS 669 669 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12
functional gtcs sql predicates 00 
 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
Support for SINGULAR <subquery>
13
functional gtcs sql predicates 00 
 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
Support for SINGULAR <subquery>
14
functional gtcs sql predicates 01 
 CS 811 811 0 0 0 0 0 0 0 0 0 0 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>
15
functional gtcs sql predicates 01 
 SS 585 585 0 0 0 0 0 0 0 0 0 0 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>
16
functional gtcs sql predicates 02 
 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 SINGULAR when subquery refers to another table
17
functional gtcs sql predicates 02 
 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
Support for SINGULAR when subquery refers to another table
18
functional gtcs sql predicates 03 
 CS 804 804 0 0 0 0 0 0 0 0 0 0 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
19
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
20
functional gtcs sql predicates 04 
 CS 806 806 0 0 0 0 0 0 0 0 0 0 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 04 
 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
Support for NOT SINGULAR when subquery refers to another table
22
functional gtcs sql predicates 05 
 CS 838 838 0 0 0 0 0 0 0 0 0 0 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
23
functional gtcs sql predicates 05 
 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 to SINGULAR in nested subqueries
24
functional gtcs sql predicates 06 
 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
Support to multiple SINGULAR subqueries
25
functional gtcs sql predicates 06 
 SS 585 585 0 0 0 0 0 0 0 0 0 0 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
26
functional gtcs sql predicates 07 
 CS 813 813 0 0 0 0 0 0 0 0 0 0 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
27
functional gtcs sql predicates 07 
 SS 583 583 0 0 0 0 0 0 0 0 0 0 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
28
functional gtcs sql predicates 08 
 CS 817 817 0 0 0 0 0 0 0 0 0 0 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 08 
 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
SINGULAR subquery applied to result of join
30
functional gtcs sql predicates 09 
 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
Applying SINGULAR to result of query with aggregate function
31
functional gtcs sql predicates 09 
 SS 580 580 0 0 0 0 0 0 0 0 0 0 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
32
functional gtcs sql predicates 10 
 CS 857 857 0 0 0 0 0 0 0 0 0 0 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
33
functional gtcs sql predicates 10 
 SS 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
Check result of DISTINCT when applying SINGULAR to result of query with aggregate function
34
functional gtcs sql predicates 11 
 CS 817 817 0 0 0 0 0 0 0 0 0 0 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
35
functional gtcs sql predicates 11 
 SS 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
Check result of GROUP BY + ORDER BY when applying SINGULAR to result of query with aggregate function
36
functional gtcs sql predicates 16 
 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
Check of applying SINGULAR to result produced by a VIEW
37
functional gtcs sql predicates 16 
 SS 601 601 0 0 0 0 0 0 0 0 0 0 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
38
functional gtcs sql predicates 17 
 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
Check of applying SINGULAR to result produced by a JOIN of two views
39
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
40
functional gtcs sql predicates 18 
 CS 838 838 0 0 0 0 0 0 0 0 0 0 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
41
functional gtcs sql predicates 18 
 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
GROUP BY of result of SINGULAR which is applied to result of JOIN
42
functional gtcs sql predicates 19 
 CS 836 836 0 0 0 0 0 0 0 0 0 0 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
43
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
44
functional gtcs sql predicates 21 
 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
SINGULAR - Subquery returning exactly one row.
45
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.
46
functional gtcs sql predicates 22 
 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 uses CONTAINING
47
functional gtcs sql predicates 22 
 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 uses CONTAINING
48
functional intfunc string substring 01 
 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
Positional SUBSTRING function
49
functional intfunc string substring 01 
 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
Positional SUBSTRING function
50
functional sqlite 002caede89 
 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
LEFT JOIN with OR terms in WHERE clause causes assertion fault
51
functional sqlite 002caede89 
 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
LEFT JOIN with OR terms in WHERE clause causes assertion fault
52
functional sqlite 02a8e81d44 
 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
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
53
functional sqlite 02a8e81d44 
 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
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
54
functional sqlite 05f43be8fd 
 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 use of index with LIKE operators when the LHS is a blob
55
functional sqlite 05f43be8fd 
 SS 423 423 0 0 0 0 0 0 0 0 0 0 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
56
functional sqlite 07d6a0453d 
 CS 591 591 0 0 0 0 0 0 0 0 0 0 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
57
functional sqlite 07d6a0453d 
 SS 388 388 0 0 0 0 0 0 0 0 0 0 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
58
functional sqlite 0911b5d161 
 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
59
functional sqlite 0911b5d161 
 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
60
functional sqlite 123c9ba321 
 CS 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
Incorrect result when an index is used for an ordered join
61
functional sqlite 123c9ba321 
 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 when an index is used for an ordered join
62
functional sqlite 16c9801ceb 
 CS 638 638 0 0 0 0 0 0 0 0 0 0 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.
63
functional sqlite 16c9801ceb 
 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
Segfault on DELETE with WHERE containing OR and redundant index exists.
64
functional sqlite 190c2507ee 
 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
Assertion fault on a query against a view
65
functional sqlite 190c2507ee 
 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 fault on a query against a view
66
functional sqlite 199df4168c 
 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
Different answer with and without index on IN operator with type mismatch
67
functional sqlite 199df4168c 
 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
Different answer with and without index on IN operator with type mismatch
68
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
69
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
70
functional sqlite 1c69be2daf 
 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 GROUP BY when input and output columns have the same name
71
functional sqlite 1c69be2daf 
 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 GROUP BY when input and output columns have the same name
72
functional sqlite 1e39b966ae 
 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 strength reduction optimization causes an error.
73
functional sqlite 1e39b966ae 
 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
LEFT JOIN strength reduction optimization causes an error.
74
functional sqlite 209d31e316 
 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
Assertion fault when deleting a table out from under a SELECT
75
functional sqlite 209d31e316 
 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
Assertion fault when deleting a table out from under a SELECT
76
functional sqlite 25e335f802 
 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
Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.
77
functional sqlite 25e335f802 
 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
Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.
78
functional sqlite 2df0107bd2 
 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 LEFT JOIN with a subquery on the LHS
79
functional sqlite 2df0107bd2 
 SS 394 394 0 0 0 0 0 0 0 0 0 0 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
80
functional sqlite 2f7170d73b 
 CS 631 631 0 0 0 0 0 0 0 0 0 0 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
81
functional sqlite 2f7170d73b 
 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
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
82
functional sqlite 31338dca7e 
 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
OR operator in WHERE clause gives wrong answer when indexed
83
functional sqlite 31338dca7e 
 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
OR operator in WHERE clause gives wrong answer when indexed
84
functional sqlite 31a19d11b9 
 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
Name resolution issue with compound SELECTs and Common Table Expressions
85
functional sqlite 31a19d11b9 
 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
Name resolution issue with compound SELECTs and Common Table Expressions
86
functional sqlite 34a579141b 
 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 results with OR terms in the ON clause of a LEFT JOIN
87
functional sqlite 34a579141b 
 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
Incorrect results with OR terms in the ON clause of a LEFT JOIN
88
functional sqlite 34cd55d68e 
 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
Database corruption following INSERT with a TRIGGER that does an affinity change
89
functional sqlite 34cd55d68e 
 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
Database corruption following INSERT with a TRIGGER that does an affinity change
90
functional sqlite 3557ad65a0 
 CS 631 631 0 0 0 0 0 0 0 0 0 0 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
91
functional sqlite 3557ad65a0 
 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 DISTINCT on an indexed query with IN
92
functional sqlite 360c6073e1 
 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
Aggregate MAX() function with COLLATE clause
93
functional sqlite 360c6073e1 
 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
Aggregate MAX() function with COLLATE clause
94
functional sqlite 38a97a87a6 
 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
Inaccurate int/float comparison results in corrupt index
95
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
96
functional sqlite 38cb5df375 
 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
LIMIT ignored on compound query with subqueries
97
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
98
functional sqlite 3998683a16 
 CS 629 629 0 0 0 0 0 0 0 0 0 0 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.
99
functional sqlite 3998683a16 
 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
Some valid floating-point literals are not recognized.
100
functional sqlite 3c27b97e31 
 CS 619 619 0 0 0 0 0 0 0 0 0 0 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
101
functional sqlite 3c27b97e31 
 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
REAL rounding seems to depend on index presence
102
functional sqlite 3dbdcdb14e 
 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
Assertion fault using indices with redundant columns
103
functional sqlite 3dbdcdb14e 
 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 fault using indices with redundant columns
104
functional sqlite 43107840f1 
 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
Assertion fault on UPDATE
105
functional sqlite 43107840f1 
 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 fault on UPDATE
106
functional sqlite 4766f44486 
 CS 601 601 0 0 0 0 0 0 0 0 0 0 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
107
functional sqlite 4766f44486 
 SS 413 413 0 0 0 0 0 0 0 0 0 0 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
108
functional sqlite 490a4b7235 
 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
Assertion when "WHERE 0" on the first element of a UNION present
109
functional sqlite 490a4b7235 
 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 when "WHERE 0" on the first element of a UNION present
110
functional sqlite 4ba5abf65c 
 CS 601 601 0 0 0 0 0 0 0 0 0 0 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
111
functional sqlite 4ba5abf65c 
 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
Index on expression leads to an incorrect LEFT JOIN
112
functional sqlite 4baa464912 
 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
NULL handling for indexes on expressions
113
functional sqlite 4baa464912 
 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
NULL handling for indexes on expressions
114
functional sqlite 4e8e4857d3 
 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
Crash on query using an OR term in the WHERE clause
115
functional sqlite 4e8e4857d3 
 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
Crash on query using an OR term in the WHERE clause
116
functional sqlite 4ef7e3cfca 
 CS 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
Name resolution problem in sub-selects within triggers
117
functional sqlite 4ef7e3cfca 
 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
Name resolution problem in sub-selects within triggers
118
functional sqlite 4feb3159c6 
 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
Crash due to misuse of window functions.
119
functional sqlite 4feb3159c6 
 SS 392 392 0 0 0 0 0 0 0 0 0 0 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.
120
functional sqlite 510cde2777 
 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
Endless loop on a query with window functions, ORDER BY, and LIMIT
121
functional sqlite 510cde2777 
 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
Endless loop on a query with window functions, ORDER BY, and LIMIT
122
functional sqlite 54844eea3f 
 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 caching of sub-query results in the FROM clause of a scalar sub-query.
123
functional sqlite 54844eea3f 
 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 caching of sub-query results in the FROM clause of a scalar sub-query.
124
functional sqlite 57c47526c3 
 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
Incorrect answer when flattening a UNION ALL compound
125
functional sqlite 57c47526c3 
 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 answer when flattening a UNION ALL compound
126
functional sqlite 5e3c886796 
 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
Correlated subquery on the RHS of an IN operator causes output of excessive rows
127
functional sqlite 5e3c886796 
 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
Correlated subquery on the RHS of an IN operator causes output of excessive rows
128
functional sqlite 5ed1772895 
 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 on an indexed JOIN
129
functional sqlite 5ed1772895 
 SS 413 413 0 0 0 0 0 0 0 0 0 0 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
130
functional sqlite 65eb38f6e4 
 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
Incorrect answer on LEFT JOIN when STAT4 is enabled
131
functional sqlite 65eb38f6e4 
 SS 401 401 0 0 0 0 0 0 0 0 0 0 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
132
functional sqlite 6c1d3febc0 
 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
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
133
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.
134
functional sqlite 6f2222d550 
 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
Incorrect output on a LEFT JOIN
135
functional sqlite 6f2222d550 
 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 output on a LEFT JOIN
136
functional sqlite 752e1646fc 
 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
Wrong result if DISTINCT used on subquery which uses ORDER BY.
137
functional sqlite 752e1646fc 
 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
Wrong result if DISTINCT used on subquery which uses ORDER BY.
138
functional sqlite 787fa716be 
 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
Assertion fault when multi-use subquery implemented by co-routine
139
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
140
functional sqlite 7a31705a7e 
 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
Name resolution fails when table name is a prefix of another table
141
functional sqlite 7a31705a7e 
 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
Name resolution fails when table name is a prefix of another table
142
functional sqlite 7f7f8026ed 
 CS 650 650 0 0 0 0 0 0 0 0 0 0 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
143
functional sqlite 7f7f8026ed 
 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
Segfault following heavy SAVEPOINT usage
144
functional sqlite 7fa8049685 
 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
Incorrect result on a LEFT JOIN when using an index
145
functional sqlite 7fa8049685 
 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 result on a LEFT JOIN when using an index
146
functional sqlite 7fde638e94 
 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
Assertion fault on a LEFT JOIN
147
functional sqlite 7fde638e94 
 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 fault on a LEFT JOIN
148
functional sqlite 80ba201079 
 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
Bug involving subqueries and the OR optimization
149
functional sqlite 80ba201079 
 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
Bug involving subqueries and the OR optimization
150
functional sqlite 8454a207b9 
 CS 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
ALTER TABLE ADD COLUMN with negative DEFAULT value
151
functional sqlite 8454a207b9 
 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
ALTER TABLE ADD COLUMN with negative DEFAULT value
152
functional sqlite 868145d012 
 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
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
153
functional sqlite 868145d012 
 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
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
154
functional sqlite 892fc34f17 
 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
Incorrect query result when a LEFT JOIN subquery is flattened
155
functional sqlite 892fc34f17 
 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 query result when a LEFT JOIN subquery is flattened
156
functional sqlite 93fb9f89d6 
 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
Index causes incorrect WHERE clause evaluation
157
functional sqlite 93fb9f89d6 
 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
Index causes incorrect WHERE clause evaluation
158
functional sqlite 96c1454cbf 
 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 with ORDER BY DESC and LIMIT
159
functional sqlite 96c1454cbf 
 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 with ORDER BY DESC and LIMIT
160
functional sqlite 98825a79ce 
 CS 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
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
161
functional sqlite 98825a79ce 
 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 result from a DISTINCT + GROUP BY + ORDER BY query
162
functional sqlite a179fe7465 
 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 output order on a join with an ORDER BY
163
functional sqlite a179fe7465 
 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 output order on a join with an ORDER BY
164
functional sqlite a696379c1f 
 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
Access violation error trying to insert into triggered view
165
functional sqlite a696379c1f 
 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
Access violation error trying to insert into triggered view
166
functional sqlite ae3c5670b6 
 CS 665 665 0 0 0 0 0 0 0 0 0 0 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
167
functional sqlite ae3c5670b6 
 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
Bug caused by factoring of constants in trigger programs
168
functional sqlite afdc5a29dc 
 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
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
169
functional sqlite afdc5a29dc 
 SS 399 399 0 0 0 0 0 0 0 0 0 0 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
170
functional sqlite b148fa6105 
 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
CAST takes implicit COLLATE of its operand
171
functional sqlite b148fa6105 
 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
CAST takes implicit COLLATE of its operand
172
functional sqlite b1d8c79314 
 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
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
173
functional sqlite b1d8c79314 
 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
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
174
functional sqlite b50528af44 
 CS 899 899 0 0 0 0 0 0 0 0 0 0 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.
175
functional sqlite b50528af44 
 SS 452 452 0 0 0 0 0 0 0 0 0 0 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.
176
functional sqlite b5ca442af9 
 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
"Malformed database schema" when creating a failing index within a transaction
177
functional sqlite b5ca442af9 
 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
"Malformed database schema" when creating a failing index within a transaction
178
functional sqlite b65cb2c8d9 
 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 LIMIT on a UNION ALL query
179
functional sqlite b65cb2c8d9 
 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 LIMIT on a UNION ALL query
180
functional sqlite b75a9ca6b0 
 CS 631 631 0 0 0 0 0 0 0 0 0 0 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
181
functional sqlite b75a9ca6b0 
 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
ORDER BY ignored if query has identical GROUP BY
182
functional sqlite b7c8682cc1 
 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 LEFT JOIN with OR in the WHERE clause
183
functional sqlite b7c8682cc1 
 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
Incorrect result from LEFT JOIN with OR in the WHERE clause
184
functional sqlite ba7cbfaedc 
 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
Wrong output order when a DESC index and GROUP BY and ORDER BY.
185
functional sqlite ba7cbfaedc 
 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 output order when a DESC index and GROUP BY and ORDER BY.
186
functional sqlite bc1aea7b72 
 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
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
187
functional sqlite bc1aea7b72 
 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 result on LEFT JOIN with OR constraints and an ORDER BY clause
188
functional sqlite bc878246ea 
 CS 602 602 0 0 0 0 0 0 0 0 0 0 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
189
functional sqlite bc878246ea 
 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 result from LEFT JOIN query
190
functional sqlite bc8d94f0fb 
 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
RENAME COLUMN fails on tables with redundant UNIQUE constraints
191
functional sqlite bc8d94f0fb 
 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
RENAME COLUMN fails on tables with redundant UNIQUE constraints
192
functional sqlite be84e357c0 
 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
Segfault during query involving LEFT JOIN column in the ORDER BY clause
193
functional sqlite be84e357c0 
 SS 394 394 0 0 0 0 0 0 0 0 0 0 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
194
functional sqlite bfbf38e5e9 
 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
Segfault on a nested join
195
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
196
functional sqlite c2a19d8165 
 CS 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
Incorrect LEFT JOIN when FROM clause contains nested subqueries
197
functional sqlite c2a19d8165 
 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
Incorrect LEFT JOIN when FROM clause contains nested subqueries
198
functional sqlite c2ad16f997 
 CS 638 638 0 0 0 0 0 0 0 0 0 0 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
199
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
200
functional sqlite c31034044b 
 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 in view malfunctions with NOTNULL
201
functional sqlite c31034044b 
 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
LEFT JOIN in view malfunctions with NOTNULL
202
functional sqlite c5ea805691 
 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
Inverted sort order when using DISTINCT and a descending index
203
functional sqlite c5ea805691 
 SS 394 394 0 0 0 0 0 0 0 0 0 0 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
204
functional sqlite c620261b5b 
 CS 634 634 0 0 0 0 0 0 0 0 0 0 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
205
functional sqlite c620261b5b 
 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 query involving LEFT JOIN and transitive constraints
206
functional sqlite c94369cae9 
 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
Wrong answer when use no-case collation due to the LIKE optimization
207
functional sqlite c94369cae9 
 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
Wrong answer when use no-case collation due to the LIKE optimization
208
functional sqlite c997b11c4d 
 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
ORDER BY clause ignored in 3-way join query
209
functional sqlite c997b11c4d 
 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
ORDER BY clause ignored in 3-way join query
210
functional sqlite ca0d20b6cd 
 CS 617 617 0 0 0 0 0 0 0 0 0 0 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
211
functional sqlite ca0d20b6cd 
 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
COLLATE operator masked by function calls
212
functional sqlite cad1ab4cb7 
 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
Segfault due to LEFT JOIN flattening optimization
213
functional sqlite cad1ab4cb7 
 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
Segfault due to LEFT JOIN flattening optimization
214
functional sqlite ce7c133ea6 
 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
Foreign key constraint fails when it should succeed.
215
functional sqlite ce7c133ea6 
 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
Foreign key constraint fails when it should succeed.
216
functional sqlite ce82323194 
 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
Duplicate CTE name gives incorrect result
217
functional sqlite ce82323194 
 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
Duplicate CTE name gives incorrect result
218
functional sqlite ce8717f088 
 SS 413 413 0 0 0 0 0 0 0 0 0 0 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
219
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
220
functional sqlite d02e1406a5 
 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 with an OR in the ON clause causes segfault
221
functional sqlite d06a25c844 
 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 result from a UNION with an ORDER BY
222
functional sqlite d06a25c844 
 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 a UNION with an ORDER BY
223
functional sqlite d0866b26f8 
 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
Window function in correlated subquery causes assertion fault
224
functional sqlite d0866b26f8 
 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
Window function in correlated subquery causes assertion fault
225
functional sqlite d11a6e908f 
 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
Query planner fault on three-way nested join with compound inner SELECT
226
functional sqlite d11a6e908f 
 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
Query planner fault on three-way nested join with compound inner SELECT
227
functional sqlite d3e7f2ba5b 
 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
Nested boolean formula with IN operator computes an incorrect result
228
functional sqlite d3e7f2ba5b 
 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
Nested boolean formula with IN operator computes an incorrect result
229
functional sqlite d666d600a6 
 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
COLLATE operator on lhs of BETWEEN expression is ignored.
230
functional sqlite d666d600a6 
 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
COLLATE operator on lhs of BETWEEN expression is ignored.
231
functional sqlite d805526eae 
 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 join result or assertion fault due to transitive constraints
232
functional sqlite d805526eae 
 SS 442 442 0 0 0 0 0 0 0 0 0 0 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
233
functional sqlite db4d96798d 
 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
LIMIT does not work with nested views containing UNION ALL
234
functional sqlite db4d96798d 
 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
LIMIT does not work with nested views containing UNION ALL
235
functional sqlite db87229497 
 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 when RHS of IN operator contains DISTINCT and LIMIT
236
functional sqlite db87229497 
 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 when RHS of IN operator contains DISTINCT and LIMIT
237
functional sqlite dc6ebeda93 
 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 DELETE due to the one-pass optimization
238
functional sqlite dc6ebeda93 
 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 DELETE due to the one-pass optimization
239
functional sqlite dd08e5a988 
 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
Foreign key constraint fails to prevent consistency error.
240
functional sqlite dd08e5a988 
 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
Foreign key constraint fails to prevent consistency error.
241
functional sqlite e20dd54ab0 
 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
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
242
functional sqlite e20dd54ab0 
 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
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
243
functional sqlite eb703ba7b5 
 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
Incorrect result using index on expression with collating function
244
functional sqlite eb703ba7b5 
 SS 430 430 0 0 0 0 0 0 0 0 0 0 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
245
functional sqlite ebdbadade5 
 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
LEFT JOIN incorrect when ON clause does not reference right table.
246
functional sqlite ebdbadade5 
 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
LEFT JOIN incorrect when ON clause does not reference right table.
247
functional sqlite ec32177c99 
 CS 638 638 0 0 0 0 0 0 0 0 0 0 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
248
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
249
functional sqlite f09fcd1781 
 CS 602 602 0 0 0 0 0 0 0 0 0 0 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.
250
functional sqlite f09fcd1781 
 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 when window functions are used.
251
functional sqlite f2369304e4 
 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 results when OR is used in the ON clause of a LEFT JOIN
252
functional sqlite f2369304e4 
 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 when OR is used in the ON clause of a LEFT JOIN
253
functional sqlite f617ea3125 
 CS 601 601 0 0 0 0 0 0 0 0 0 0 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
254
functional sqlite f617ea3125 
 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 ORDER BY with colliding input and output column names
255
functional sqlite f74beaabde 
 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
Problem with 3-way joins and the USING clause
256
functional sqlite f74beaabde 
 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
Problem with 3-way joins and the USING clause
257
functional sqlite f7f8c97e97 
 CS 638 638 0 0 0 0 0 0 0 0 0 0 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
258
functional sqlite f7f8c97e97 
 SS 394 394 0 0 0 0 0 0 0 0 0 0 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
259
functional sqlite f97c463710 
 CS 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
Incorrect ordering with ORDER BY and LIMIT
260
functional sqlite f97c463710 
 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 ordering with ORDER BY and LIMIT
261
functional sqlite fc7bd6358f 
 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 query result in a 3-way join due to affinity issues
262
functional sqlite fc7bd6358f 
 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 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
=== end of list ===

Last commits information (all timestamps in UTC):