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 04.11.2025 11:56
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 22375 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 579 579 0 0 0 0 0 0 0 0 0 0 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 240 240 0 0 0 0 0 0 0 0 0 0 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 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
Called procedure parameter changes during execution without assignment when deleting from updatable view
5
bugs gh 8794 
 tracker
 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
Called procedure parameter changes during execution without assignment when deleting from updatable view
6
functional gtcs cursors 
 CS 668 668 0 0 0 0 0 0 0 0 0 0 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 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
8
functional gtcs nested func 01 
 CS 1278 1278 0 0 0 0 0 0 0 0 0 0 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 801 801 0 0 0 0 0 0 0 0 0 0 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 1288 1288 0 0 0 0 0 0 0 0 0 0 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 807 807 0 0 0 0 0 0 0 0 0 0 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 1064 1064 0 0 0 0 0 0 0 0 0 0 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 658 658 0 0 0 0 0 0 0 0 0 0 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 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>
15
functional gtcs sql predicates 00 
 SS 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
Support for SINGULAR <subquery>
16
functional gtcs sql predicates 01 
 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 for NOT SINGULAR <subquery>
17
functional gtcs sql predicates 01 
 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 <subquery>
18
functional gtcs sql predicates 02 
 CS 814 814 0 0 0 0 0 0 0 0 0 0 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 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
Support for SINGULAR when subquery refers to another table
20
functional gtcs sql predicates 03 
 CS 801 801 0 0 0 0 0 0 0 0 0 0 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 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
Support for NOT SINGULAR when subquery refers to another table
22
functional gtcs sql predicates 04 
 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
Support for NOT SINGULAR when subquery refers to another table
23
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
24
functional gtcs sql predicates 05 
 CS 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
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 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
Support to multiple SINGULAR subqueries
27
functional gtcs sql predicates 06 
 SS 584 584 0 0 0 0 0 0 0 0 0 0 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 805 805 0 0 0 0 0 0 0 0 0 0 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 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
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 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
SINGULAR subquery applied to result of join
32
functional gtcs sql predicates 09 
 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
Applying SINGULAR to result of query with aggregate function
33
functional gtcs sql predicates 09 
 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
Applying SINGULAR to result of query with aggregate function
34
functional gtcs sql predicates 10 
 CS 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
Check result of DISTINCT when applying SINGULAR to result of query with aggregate function
35
functional gtcs sql predicates 10 
 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 result of DISTINCT when applying SINGULAR to result of query with aggregate function
36
functional gtcs sql predicates 11 
 CS 814 814 0 0 0 0 0 0 0 0 0 0 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 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 result of GROUP BY + ORDER BY when applying SINGULAR to result of query with aggregate function
38
functional gtcs sql predicates 16 
 CS 810 810 0 0 0 0 0 0 0 0 0 0 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 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
Check of applying SINGULAR to result produced by a VIEW
40
functional gtcs sql predicates 17 
 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
Check of applying SINGULAR to result produced by a JOIN of two views
41
functional gtcs sql predicates 17 
 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 JOIN of two views
42
functional gtcs sql predicates 18 
 CS 810 810 0 0 0 0 0 0 0 0 0 0 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 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
GROUP BY of result of SINGULAR which is applied to result of JOIN
44
functional gtcs sql predicates 19 
 CS 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
GROUP BY of result of SINGULAR which is applied to result of VIEWS JOIN
45
functional gtcs sql predicates 19 
 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
GROUP BY of result of SINGULAR which is applied to result of VIEWS JOIN
46
functional gtcs sql predicates 21 
 CS 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
SINGULAR - Subquery returning exactly one row.
47
functional gtcs sql predicates 21 
 SS 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
SINGULAR - Subquery returning exactly one row.
48
functional gtcs sql predicates 22 
 CS 871 871 0 0 0 0 0 0 0 0 0 0 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 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 uses CONTAINING
50
functional intfunc string substring 01 
 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
Positional SUBSTRING function
51
functional intfunc string substring 01 
 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
Positional SUBSTRING function
52
functional sqlite 002caede89 
 CS 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
LEFT JOIN with OR terms in WHERE clause causes assertion fault
53
functional sqlite 002caede89 
 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 with OR terms in WHERE clause causes assertion fault
54
functional sqlite 02a8e81d44 
 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
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
55
functional sqlite 02a8e81d44 
 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
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 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 use of index with LIKE operators when the LHS is a blob
58
functional sqlite 07d6a0453d 
 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
OFFSET ignored if there is no FROM clause
59
functional sqlite 07d6a0453d 
 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
OFFSET ignored if there is no FROM clause
60
functional sqlite 0911b5d161 
 CS 697 697 0 0 0 0 0 0 0 0 0 0 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 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
62
functional sqlite 123c9ba321 
 CS 636 636 0 0 0 0 0 0 0 0 0 0 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 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 result when an index is used for an ordered join
64
functional sqlite 16c9801ceb 
 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
Segfault on DELETE with WHERE containing OR and redundant index exists.
65
functional sqlite 16c9801ceb 
 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
Segfault on DELETE with WHERE containing OR and redundant index exists.
66
functional sqlite 190c2507ee 
 CS 667 667 0 0 0 0 0 0 0 0 0 0 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 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 a query against a view
68
functional sqlite 199df4168c 
 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
Different answer with and without index on IN operator with type mismatch
69
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
70
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
71
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
72
functional sqlite 1c69be2daf 
 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 GROUP BY when input and output columns have the same name
73
functional sqlite 1c69be2daf 
 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 GROUP BY when input and output columns have the same name
74
functional sqlite 1e39b966ae 
 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
LEFT JOIN strength reduction optimization causes an error.
75
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.
76
functional sqlite 209d31e316 
 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 when deleting a table out from under a SELECT
77
functional sqlite 209d31e316 
 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
Assertion fault when deleting a table out from under a SELECT
78
functional sqlite 25e335f802 
 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
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 395 395 0 0 0 0 0 0 0 0 0 0 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 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 from LEFT JOIN with a subquery on the LHS
81
functional sqlite 2df0107bd2 
 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 result from LEFT JOIN with a subquery on the LHS
82
functional sqlite 2f7170d73b 
 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
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
83
functional sqlite 2f7170d73b 
 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
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
84
functional sqlite 31338dca7e 
 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
OR operator in WHERE clause gives wrong answer when indexed
85
functional sqlite 31338dca7e 
 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
OR operator in WHERE clause gives wrong answer when indexed
86
functional sqlite 31a19d11b9 
 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
Name resolution issue with compound SELECTs and Common Table Expressions
87
functional sqlite 31a19d11b9 
 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 issue with compound SELECTs and Common Table Expressions
88
functional sqlite 34a579141b 
 CS 666 666 0 0 0 0 0 0 0 0 0 0 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 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 results with OR terms in the ON clause of a LEFT JOIN
90
functional sqlite 34cd55d68e 
 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
Database corruption following INSERT with a TRIGGER that does an affinity change
91
functional sqlite 34cd55d68e 
 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
Database corruption following INSERT with a TRIGGER that does an affinity change
92
functional sqlite 3557ad65a0 
 CS 663 663 0 0 0 0 0 0 0 0 0 0 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 679 679 0 0 0 0 0 0 0 0 0 0 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 440 440 0 0 0 0 0 0 0 0 0 0 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 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
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 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
LIMIT ignored on compound query with subqueries
99
functional sqlite 38cb5df375 
 SS 462 462 0 0 0 0 0 0 0 0 0 0 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 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
Some valid floating-point literals are not recognized.
101
functional sqlite 3998683a16 
 SS 520 520 0 0 0 0 0 0 0 0 0 0 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 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
REAL rounding seems to depend on index presence
103
functional sqlite 3c27b97e31 
 SS 483 483 0 0 0 0 0 0 0 0 0 0 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 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
Assertion fault using indices with redundant columns
105
functional sqlite 3dbdcdb14e 
 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
Assertion fault using indices with redundant columns
106
functional sqlite 43107840f1 
 CS 677 677 0 0 0 0 0 0 0 0 0 0 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 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 UPDATE
108
functional sqlite 4766f44486 
 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
ORDER BY handling with indexes on expressions
109
functional sqlite 4766f44486 
 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 handling with indexes on expressions
110
functional sqlite 490a4b7235 
 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 when "WHERE 0" on the first element of a UNION present
111
functional sqlite 490a4b7235 
 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
Assertion when "WHERE 0" on the first element of a UNION present
112
functional sqlite 4ba5abf65c 
 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
Index on expression leads to an incorrect LEFT JOIN
113
functional sqlite 4ba5abf65c 
 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
Index on expression leads to an incorrect LEFT JOIN
114
functional sqlite 4baa464912 
 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
NULL handling for indexes on expressions
115
functional sqlite 4baa464912 
 SS 461 461 0 0 0 0 0 0 0 0 0 0 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 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
Crash on query using an OR term in the WHERE clause
117
functional sqlite 4e8e4857d3 
 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
Crash on query using an OR term in the WHERE clause
118
functional sqlite 4ef7e3cfca 
 CS 672 672 0 0 0 0 0 0 0 0 0 0 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 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
Name resolution problem in sub-selects within triggers
120
functional sqlite 4feb3159c6 
 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 due to misuse of window functions.
121
functional sqlite 4feb3159c6 
 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
Crash due to misuse of window functions.
122
functional sqlite 510cde2777 
 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
Endless loop on a query with window functions, ORDER BY, and LIMIT
123
functional sqlite 510cde2777 
 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
Endless loop on a query with window functions, ORDER BY, and LIMIT
124
functional sqlite 54844eea3f 
 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 caching of sub-query results in the FROM clause of a scalar sub-query.
125
functional sqlite 54844eea3f 
 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 caching of sub-query results in the FROM clause of a scalar sub-query.
126
functional sqlite 57c47526c3 
 CS 680 680 0 0 0 0 0 0 0 0 0 0 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 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 answer when flattening a UNION ALL compound
128
functional sqlite 5e3c886796 
 CS 636 636 0 0 0 0 0 0 0 0 0 0 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 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
Correlated subquery on the RHS of an IN operator causes output of excessive rows
130
functional sqlite 5ed1772895 
 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
Incorrect ORDER BY on an indexed JOIN
131
functional sqlite 5ed1772895 
 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 ORDER BY on an indexed JOIN
132
functional sqlite 65eb38f6e4 
 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
Incorrect answer on LEFT JOIN when STAT4 is enabled
133
functional sqlite 65eb38f6e4 
 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 on LEFT JOIN when STAT4 is enabled
134
functional sqlite 6c1d3febc0 
 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
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
135
functional sqlite 6c1d3febc0 
 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
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
136
functional sqlite 6f2222d550 
 CS 658 658 0 0 0 0 0 0 0 0 0 0 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 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 output on a LEFT JOIN
138
functional sqlite 752e1646fc 
 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
Wrong result if DISTINCT used on subquery which uses ORDER BY.
139
functional sqlite 752e1646fc 
 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
Wrong result if DISTINCT used on subquery which uses ORDER BY.
140
functional sqlite 787fa716be 
 CS 700 700 0 0 0 0 0 0 0 0 0 0 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 457 457 0 0 0 0 0 0 0 0 0 0 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 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
Name resolution fails when table name is a prefix of another table
143
functional sqlite 7a31705a7e 
 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
Name resolution fails when table name is a prefix of another table
144
functional sqlite 7f7f8026ed 
 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
Segfault following heavy SAVEPOINT usage
145
functional sqlite 7f7f8026ed 
 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
Segfault following heavy SAVEPOINT usage
146
functional sqlite 7fa8049685 
 CS 652 652 0 0 0 0 0 0 0 0 0 0 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 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 result on a LEFT JOIN when using an index
148
functional sqlite 7fde638e94 
 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
Assertion fault on a LEFT JOIN
149
functional sqlite 7fde638e94 
 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
Assertion fault on a LEFT JOIN
150
functional sqlite 80ba201079 
 CS 681 681 0 0 0 0 0 0 0 0 0 0 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 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
Bug involving subqueries and the OR optimization
152
functional sqlite 8454a207b9 
 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
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 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
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
155
functional sqlite 868145d012 
 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
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
156
functional sqlite 892fc34f17 
 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 query result when a LEFT JOIN subquery is flattened
157
functional sqlite 892fc34f17 
 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 when a LEFT JOIN subquery is flattened
158
functional sqlite 93fb9f89d6 
 CS 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
Index causes incorrect WHERE clause evaluation
159
functional sqlite 93fb9f89d6 
 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 causes incorrect WHERE clause evaluation
160
functional sqlite 96c1454cbf 
 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
Incorrect result with ORDER BY DESC and LIMIT
161
functional sqlite 96c1454cbf 
 SS 451 451 0 0 0 0 0 0 0 0 0 0 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 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
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
163
functional sqlite 98825a79ce 
 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 result from a DISTINCT + GROUP BY + ORDER BY query
164
functional sqlite a179fe7465 
 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
Incorrect output order on a join with an ORDER BY
165
functional sqlite a179fe7465 
 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 output order on a join with an ORDER BY
166
functional sqlite a696379c1f 
 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
Access violation error trying to insert into triggered view
167
functional sqlite a696379c1f 
 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
Access violation error trying to insert into triggered view
168
functional sqlite ae3c5670b6 
 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
Bug caused by factoring of constants in trigger programs
169
functional sqlite ae3c5670b6 
 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
Bug caused by factoring of constants in trigger programs
170
functional sqlite afdc5a29dc 
 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
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
171
functional sqlite afdc5a29dc 
 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
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
172
functional sqlite b148fa6105 
 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
CAST takes implicit COLLATE of its operand
173
functional sqlite b148fa6105 
 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
CAST takes implicit COLLATE of its operand
174
functional sqlite b1d8c79314 
 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
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
175
functional sqlite b1d8c79314 
 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
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
176
functional sqlite b50528af44 
 CS 930 930 0 0 0 0 0 0 0 0 0 0 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 456 456 0 0 0 0 0 0 0 0 0 0 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 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
"Malformed database schema" when creating a failing index within a transaction
179
functional sqlite b5ca442af9 
 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
"Malformed database schema" when creating a failing index within a transaction
180
functional sqlite b65cb2c8d9 
 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
Incorrect LIMIT on a UNION ALL query
181
functional sqlite b65cb2c8d9 
 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 LIMIT on a UNION ALL query
182
functional sqlite b75a9ca6b0 
 CS 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
ORDER BY ignored if query has identical GROUP BY
183
functional sqlite b75a9ca6b0 
 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
ORDER BY ignored if query has identical GROUP BY
184
functional sqlite b7c8682cc1 
 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 from LEFT JOIN with OR in the WHERE clause
185
functional sqlite b7c8682cc1 
 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 result from LEFT JOIN with OR in the WHERE clause
186
functional sqlite ba7cbfaedc 
 CS 668 668 0 0 0 0 0 0 0 0 0 0 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 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
Wrong output order when a DESC index and GROUP BY and ORDER BY.
188
functional sqlite bc1aea7b72 
 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
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
189
functional sqlite bc1aea7b72 
 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 result on LEFT JOIN with OR constraints and an ORDER BY clause
190
functional sqlite bc878246ea 
 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
Incorrect result from LEFT JOIN query
191
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
192
functional sqlite bc8d94f0fb 
 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
RENAME COLUMN fails on tables with redundant UNIQUE constraints
193
functional sqlite bc8d94f0fb 
 SS 417 417 0 0 0 0 0 0 0 0 0 0 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 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
Segfault during query involving LEFT JOIN column in the ORDER BY clause
195
functional sqlite be84e357c0 
 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
Segfault during query involving LEFT JOIN column in the ORDER BY clause
196
functional sqlite bfbf38e5e9 
 CS 658 658 0 0 0 0 0 0 0 0 0 0 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 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
Segfault on a nested join
198
functional sqlite c2a19d8165 
 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 LEFT JOIN when FROM clause contains nested subqueries
199
functional sqlite c2a19d8165 
 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
Incorrect LEFT JOIN when FROM clause contains nested subqueries
200
functional sqlite c2ad16f997 
 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
Segfault on query involving deeply nested aggregate views
201
functional sqlite c2ad16f997 
 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
Segfault on query involving deeply nested aggregate views
202
functional sqlite c31034044b 
 CS 636 636 0 0 0 0 0 0 0 0 0 0 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 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 in view malfunctions with NOTNULL
204
functional sqlite c5ea805691 
 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
Inverted sort order when using DISTINCT and a descending index
205
functional sqlite c5ea805691 
 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
Inverted sort order when using DISTINCT and a descending index
206
functional sqlite c620261b5b 
 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 result on query involving LEFT JOIN and transitive constraints
207
functional sqlite c620261b5b 
 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 result on query involving LEFT JOIN and transitive constraints
208
functional sqlite c94369cae9 
 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
Wrong answer when use no-case collation due to the LIKE optimization
209
functional sqlite c94369cae9 
 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
Wrong answer when use no-case collation due to the LIKE optimization
210
functional sqlite c997b11c4d 
 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
ORDER BY clause ignored in 3-way join query
211
functional sqlite c997b11c4d 
 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 clause ignored in 3-way join query
212
functional sqlite ca0d20b6cd 
 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
COLLATE operator masked by function calls
213
functional sqlite ca0d20b6cd 
 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
COLLATE operator masked by function calls
214
functional sqlite cad1ab4cb7 
 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
Segfault due to LEFT JOIN flattening optimization
215
functional sqlite cad1ab4cb7 
 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
Segfault due to LEFT JOIN flattening optimization
216
functional sqlite ce7c133ea6 
 CS 668 668 0 0 0 0 0 0 0 0 0 0 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 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
Foreign key constraint fails when it should succeed.
218
functional sqlite ce82323194 
 CS 672 672 0 0 0 0 0 0 0 0 0 0 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 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
Duplicate CTE name gives incorrect result
220
functional sqlite ce8717f088 
 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
LIKE malfunctions for UNIQUE COLLATE NOCASE column
221
functional sqlite d02e1406a5 
 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
LEFT JOIN with an OR in the ON clause causes segfault
222
functional sqlite d02e1406a5 
 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
LEFT JOIN with an OR in the ON clause causes segfault
223
functional sqlite d06a25c844 
 CS 678 678 0 0 0 0 0 0 0 0 0 0 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 397 397 0 0 0 0 0 0 0 0 0 0 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 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
Window function in correlated subquery causes assertion fault
226
functional sqlite d0866b26f8 
 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
Window function in correlated subquery causes assertion fault
227
functional sqlite d11a6e908f 
 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
Query planner fault on three-way nested join with compound inner SELECT
228
functional sqlite d11a6e908f 
 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
Query planner fault on three-way nested join with compound inner SELECT
229
functional sqlite d3e7f2ba5b 
 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
Nested boolean formula with IN operator computes an incorrect result
230
functional sqlite d3e7f2ba5b 
 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
Nested boolean formula with IN operator computes an incorrect result
231
functional sqlite d666d600a6 
 CS 1365 1365 0 0 0 0 0 0 0 0 0 0 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 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
COLLATE operator on lhs of BETWEEN expression is ignored.
233
functional sqlite d805526eae 
 CS 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
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 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
LIMIT does not work with nested views containing UNION ALL
236
functional sqlite db4d96798d 
 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 does not work with nested views containing UNION ALL
237
functional sqlite db87229497 
 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 result when RHS of IN operator contains DISTINCT and LIMIT
238
functional sqlite db87229497 
 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 result when RHS of IN operator contains DISTINCT and LIMIT
239
functional sqlite dc6ebeda93 
 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
Incorrect DELETE due to the one-pass optimization
240
functional sqlite dc6ebeda93 
 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 DELETE due to the one-pass optimization
241
functional sqlite dd08e5a988 
 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
Foreign key constraint fails to prevent consistency error.
242
functional sqlite dd08e5a988 
 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 to prevent consistency error.
243
functional sqlite e20dd54ab0 
 CS 717 717 0 0 0 0 0 0 0 0 0 0 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 440 440 0 0 0 0 0 0 0 0 0 0 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 742 742 0 0 0 0 0 0 0 0 0 0 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 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 result using index on expression with collating function
247
functional sqlite ebdbadade5 
 CS 657 657 0 0 0 0 0 0 0 0 0 0 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 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
LEFT JOIN incorrect when ON clause does not reference right table.
249
functional sqlite ec32177c99 
 CS 668 668 0 0 0 0 0 0 0 0 0 0 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 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 with complex OR-connected WHERE
251
functional sqlite f09fcd1781 
 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
Assertion fault when window functions are used.
252
functional sqlite f09fcd1781 
 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
Assertion fault when window functions are used.
253
functional sqlite f2369304e4 
 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
Incorrect results when OR is used in the ON clause of a LEFT JOIN
254
functional sqlite f2369304e4 
 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 results when OR is used in the ON clause of a LEFT JOIN
255
functional sqlite f617ea3125 
 CS 714 714 0 0 0 0 0 0 0 0 0 0 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 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 with colliding input and output column names
257
functional sqlite f74beaabde 
 CS 667 667 0 0 0 0 0 0 0 0 0 0 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 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
Problem with 3-way joins and the USING clause
259
functional sqlite f7f8c97e97 
 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
Valid query fails to compile due to WHERE clause optimization
260
functional sqlite f7f8c97e97 
 SS 397 397 0 0 0 0 0 0 0 0 0 0 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 744 744 0 0 0 0 0 0 0 0 0 0 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 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 ordering with ORDER BY and LIMIT
263
functional sqlite fc7bd6358f 
 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
Incorrect query result in a 3-way join due to affinity issues
264
functional sqlite fc7bd6358f 
 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 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):