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 (0 rows)
03. NEW FAILS: tests which failed for LAST run (5 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 (0 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (0 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (7 rows)
07. Has fails: tests with at least one fail for previous 35 runs (57 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (2 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 35 runs (0 rows)
[CURRENT] 10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (75 rows)
11. All tests: outcomes for previous 35 runs (2938 rows)
12. Skipped: tests which was intentionally excluded from execution (169 rows)

Generated UTC 23.08.2025 01:12
Tested: FB60.   Build / date: 6.0.0.1244-ab7da954 / 2025.08.21;
Test machine: Linux 6.11.5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.11.5-1 (2024-10-27); logical CPUs: 2; RAM: 7 Gb 
QA software: Python: 3.11.9; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3 
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
6.0.0.1244
2025.08.21
ab7da
6.0.0.1232
2025.08.20
f69e8
6.0.0.1227
2025.08.19
2e9f0
6.0.0.1226
2025.08.18
58d28
6.0.0.1224
2025.08.17
b2381
6.0.0.1214
2025.08.16
99bbb
6.0.0.1212
2025.08.15
c96d5
6.0.0.1210
2025.08.14
6ab0c
6.0.0.1204
2025.08.11
d69d1
6.0.0.1203
2025.08.10
ec2be
6.0.0.1194
2025.08.08
c157a
6.0.0.1189
2025.08.07
7863e
6.0.0.1164
2025.08.06
c3e5d
6.0.0.1157
2025.08.05
c8def
6.0.0.1152
2025.08.04
ffb6d
6.0.0.1131
2025.08.03
87afd
6.0.0.1124
2025.08.02
1ccdf
6.0.0.1115
2025.08.01
ab0bd
6.0.0.1113
2025.07.30
8f46c
6.0.0.1103
2025.07.29
9f972
6.0.0.1093
2025.07.28
9a5e0
6.0.0.1092
2025.07.27
daed3
6.0.0.1089
2025.07.26
4f6fd
6.0.0.1077
2025.07.25
0fc99
6.0.0.1066
2025.07.24
6ac0a
6.0.0.1061
2025.07.23
81fa9
6.0.0.1052
2025.07.22
77feb
6.0.0.1050
2025.07.21
cee78
6.0.0.1046
2025.07.20
1c064
6.0.0.1045
2025.07.19
748a5
6.0.0.1042
2025.07.18
6e435
6.0.0.1039
2025.07.17
7a17f
6.0.0.1036
2025.07.16
00b3f
6.0.0.1020
2025.07.15
a8e98
6.0.0.983
2025.07.14
f02b3
Test TITLE
1
bugs gh 8711 
 tracker
 CS P F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Regression in FB 6.x for plan in legacy form: excessive comma (",") between items of <schema.index> list
2
bugs gh 8711 
 tracker
 SS P F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Regression in FB 6.x for plan in legacy form: excessive comma (",") between items of <schema.index> list
3
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
4
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
5
functional sqlite 05f43be8fd 
 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
Incorrect use of index with LIKE operators when the LHS is a blob
6
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
7
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
8
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
9
functional sqlite 1c69be2daf 
 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
Incorrect GROUP BY when input and output columns have the same name
10
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
11
functional sqlite 2326c258d0 
 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
Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index
12
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
13
functional sqlite 2ea3e9fe63 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Partial index causes assertion fault on UPDATE OR REPLACE
14
functional sqlite 2f7170d73b 
 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
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
15
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
16
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
17
functional sqlite 34cd55d68e 
 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
Database corruption following INSERT with a TRIGGER that does an affinity change
18
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
19
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
20
functional sqlite 38a97a87a6 
 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
Inaccurate int/float comparison results in corrupt index
21
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
22
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.
23
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
24
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
25
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
26
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
27
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.
28
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
29
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
30
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
31
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.
32
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
33
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
34
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
35
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
36
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)
37
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
38
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
39
functional sqlite 98d973b8f5 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Partial index gives incorrect query result
40
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
41
functional sqlite a5c8ed66ca 
 ALL P X X X X X X X X X X 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 count(*) when partial indices exist
42
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
43
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
44
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.
45
functional sqlite b65cb2c8d9 
 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
Incorrect LIMIT on a UNION ALL query
46
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
47
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
48
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.
49
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
50
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
51
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
52
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
53
functional sqlite c2a19d8165 
 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
Incorrect LEFT JOIN when FROM clause contains nested subqueries
54
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
55
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
56
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
57
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
58
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
59
functional sqlite ca0d20b6cd 
 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
COLLATE operator masked by function calls
60
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.
61
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
62
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
63
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.
64
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
65
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
66
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
67
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.
68
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.
69
functional sqlite ec32177c99 
 CS P F P X X X X X X X X 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
70
functional sqlite ec32177c99 
 SS P F P X X X X X X X X 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
71
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
72
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
73
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
74
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
75
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
6.0.0.1244
2025.08.21
ab7da
6.0.0.1232
2025.08.20
f69e8
6.0.0.1227
2025.08.19
2e9f0
6.0.0.1226
2025.08.18
58d28
6.0.0.1224
2025.08.17
b2381
6.0.0.1214
2025.08.16
99bbb
6.0.0.1212
2025.08.15
c96d5
6.0.0.1210
2025.08.14
6ab0c
6.0.0.1204
2025.08.11
d69d1
6.0.0.1203
2025.08.10
ec2be
6.0.0.1194
2025.08.08
c157a
6.0.0.1189
2025.08.07
7863e
6.0.0.1164
2025.08.06
c3e5d
6.0.0.1157
2025.08.05
c8def
6.0.0.1152
2025.08.04
ffb6d
6.0.0.1131
2025.08.03
87afd
6.0.0.1124
2025.08.02
1ccdf
6.0.0.1115
2025.08.01
ab0bd
6.0.0.1113
2025.07.30
8f46c
6.0.0.1103
2025.07.29
9f972
6.0.0.1093
2025.07.28
9a5e0
6.0.0.1092
2025.07.27
daed3
6.0.0.1089
2025.07.26
4f6fd
6.0.0.1077
2025.07.25
0fc99
6.0.0.1066
2025.07.24
6ac0a
6.0.0.1061
2025.07.23
81fa9
6.0.0.1052
2025.07.22
77feb
6.0.0.1050
2025.07.21
cee78
6.0.0.1046
2025.07.20
1c064
6.0.0.1045
2025.07.19
748a5
6.0.0.1042
2025.07.18
6e435
6.0.0.1039
2025.07.17
7a17f
6.0.0.1036
2025.07.16
00b3f
6.0.0.1020
2025.07.15
a8e98
6.0.0.983
2025.07.14
f02b3
Test TITLE
1
bugs gh 8711 
 tracker
 CS 815 879 752 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression in FB 6.x for plan in legacy form: excessive comma (",") between items of <schema.index> list
2
bugs gh 8711 
 tracker
 SS 442 318 566 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression in FB 6.x for plan in legacy form: excessive comma (",") between items of <schema.index> list
3
functional sqlite 002caede89 
 CS 783 783 0 0 0 0 0 0 0 0 0 0 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
4
functional sqlite 002caede89 
 SS 573 573 0 0 0 0 0 0 0 0 0 0 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
5
functional sqlite 02a8e81d44 
 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
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
6
functional sqlite 02a8e81d44 
 SS 544 544 0 0 0 0 0 0 0 0 0 0 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
7
functional sqlite 05f43be8fd 
 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
Incorrect use of index with LIKE operators when the LHS is a blob
8
functional sqlite 07d6a0453d 
 CS 775 775 0 0 0 0 0 0 0 0 0 0 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
9
functional sqlite 07d6a0453d 
 SS 546 546 0 0 0 0 0 0 0 0 0 0 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
10
functional sqlite 190c2507ee 
 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
Assertion fault on a query against a view
11
functional sqlite 190c2507ee 
 SS 576 576 0 0 0 0 0 0 0 0 0 0 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
12
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
13
functional sqlite 1c69be2daf 
 SS 559 559 0 0 0 0 0 0 0 0 0 0 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
14
functional sqlite 209d31e316 
 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
Assertion fault when deleting a table out from under a SELECT
15
functional sqlite 209d31e316 
 SS 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
Assertion fault when deleting a table out from under a SELECT
16
functional sqlite 2326c258d0 
 SS 590 590 0 0 0 0 0 0 0 0 0 0 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 a LEFT JOIN provides the qualifying constraint for a partial index
17
functional sqlite 2df0107bd2 
 CS 769 769 0 0 0 0 0 0 0 0 0 0 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
18
functional sqlite 2df0107bd2 
 SS 535 535 0 0 0 0 0 0 0 0 0 0 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
19
functional sqlite 2ea3e9fe63 
 CS 854 854 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Partial index causes assertion fault on UPDATE OR REPLACE
20
functional sqlite 2ea3e9fe63 
 SS 560 560 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Partial index causes assertion fault on UPDATE OR REPLACE
21
functional sqlite 2f7170d73b 
 SS 572 572 0 0 0 0 0 0 0 0 0 0 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
22
functional sqlite 31338dca7e 
 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
OR operator in WHERE clause gives wrong answer when indexed
23
functional sqlite 31338dca7e 
 SS 567 567 0 0 0 0 0 0 0 0 0 0 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
24
functional sqlite 31a19d11b9 
 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
Name resolution issue with compound SELECTs and Common Table Expressions
25
functional sqlite 31a19d11b9 
 SS 471 471 0 0 0 0 0 0 0 0 0 0 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
26
functional sqlite 34cd55d68e 
 SS 560 560 0 0 0 0 0 0 0 0 0 0 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
27
functional sqlite 3557ad65a0 
 CS 833 833 0 0 0 0 0 0 0 0 0 0 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
28
functional sqlite 3557ad65a0 
 SS 564 564 0 0 0 0 0 0 0 0 0 0 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
29
functional sqlite 360c6073e1 
 CS 876 876 0 0 0 0 0 0 0 0 0 0 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
30
functional sqlite 360c6073e1 
 SS 576 576 0 0 0 0 0 0 0 0 0 0 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
31
functional sqlite 38a97a87a6 
 SS 544 544 0 0 0 0 0 0 0 0 0 0 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
32
functional sqlite 38cb5df375 
 CS 868 868 0 0 0 0 0 0 0 0 0 0 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
33
functional sqlite 38cb5df375 
 SS 556 556 0 0 0 0 0 0 0 0 0 0 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
34
functional sqlite 3998683a16 
 CS 878 878 0 0 0 0 0 0 0 0 0 0 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.
35
functional sqlite 3998683a16 
 SS 508 508 0 0 0 0 0 0 0 0 0 0 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.
36
functional sqlite 3dbdcdb14e 
 CS 788 788 0 0 0 0 0 0 0 0 0 0 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
37
functional sqlite 3dbdcdb14e 
 SS 554 554 0 0 0 0 0 0 0 0 0 0 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
38
functional sqlite 43107840f1 
 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
Assertion fault on UPDATE
39
functional sqlite 43107840f1 
 SS 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
Assertion fault on UPDATE
40
functional sqlite 490a4b7235 
 CS 862 862 0 0 0 0 0 0 0 0 0 0 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
41
functional sqlite 490a4b7235 
 SS 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
Assertion when "WHERE 0" on the first element of a UNION present
42
functional sqlite 4ef7e3cfca 
 CS 771 771 0 0 0 0 0 0 0 0 0 0 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
43
functional sqlite 4ef7e3cfca 
 SS 571 571 0 0 0 0 0 0 0 0 0 0 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
44
functional sqlite 54844eea3f 
 CS 746 746 0 0 0 0 0 0 0 0 0 0 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.
45
functional sqlite 54844eea3f 
 SS 582 582 0 0 0 0 0 0 0 0 0 0 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.
46
functional sqlite 57c47526c3 
 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
Incorrect answer when flattening a UNION ALL compound
47
functional sqlite 57c47526c3 
 SS 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
Incorrect answer when flattening a UNION ALL compound
48
functional sqlite 5ed1772895 
 CS 777 777 0 0 0 0 0 0 0 0 0 0 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
49
functional sqlite 5ed1772895 
 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
Incorrect ORDER BY on an indexed JOIN
50
functional sqlite 6f2222d550 
 CS 827 827 0 0 0 0 0 0 0 0 0 0 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
51
functional sqlite 6f2222d550 
 SS 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
Incorrect output on a LEFT JOIN
52
functional sqlite 752e1646fc 
 CS 883 883 0 0 0 0 0 0 0 0 0 0 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.
53
functional sqlite 752e1646fc 
 SS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result if DISTINCT used on subquery which uses ORDER BY.
54
functional sqlite 7a31705a7e 
 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
Name resolution fails when table name is a prefix of another table
55
functional sqlite 7a31705a7e 
 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
Name resolution fails when table name is a prefix of another table
56
functional sqlite 7fde638e94 
 CS 859 859 0 0 0 0 0 0 0 0 0 0 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
57
functional sqlite 7fde638e94 
 SS 563 563 0 0 0 0 0 0 0 0 0 0 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
58
functional sqlite 80ba201079 
 CS 886 886 0 0 0 0 0 0 0 0 0 0 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
59
functional sqlite 80ba201079 
 SS 587 587 0 0 0 0 0 0 0 0 0 0 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
60
functional sqlite 8454a207b9 
 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
ALTER TABLE ADD COLUMN with negative DEFAULT value
61
functional sqlite 8454a207b9 
 SS 556 556 0 0 0 0 0 0 0 0 0 0 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
62
functional sqlite 868145d012 
 CS 850 850 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on double LEFT JOIN (after added support for transitive constraints)
63
functional sqlite 868145d012 
 SS 547 547 0 0 0 0 0 0 0 0 0 0 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)
64
functional sqlite 93fb9f89d6 
 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
Index causes incorrect WHERE clause evaluation
65
functional sqlite 93fb9f89d6 
 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
Index causes incorrect WHERE clause evaluation
66
functional sqlite 98825a79ce 
 CS 771 771 0 0 0 0 0 0 0 0 0 0 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
67
functional sqlite 98825a79ce 
 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
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
68
functional sqlite 98d973b8f5 
 CS 878 878 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Partial index gives incorrect query result
69
functional sqlite 98d973b8f5 
 SS 576 576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Partial index gives incorrect query result
70
functional sqlite a179fe7465 
 CS 754 754 0 0 0 0 0 0 0 0 0 0 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
71
functional sqlite a179fe7465 
 SS 648 648 0 0 0 0 0 0 0 0 0 0 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
72
functional sqlite a5c8ed66ca 
 CS 800 800 0 0 0 0 0 0 0 0 0 0 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 count(*) when partial indices exist
73
functional sqlite a5c8ed66ca 
 SS 575 575 0 0 0 0 0 0 0 0 0 0 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 count(*) when partial indices exist
74
functional sqlite a696379c1f 
 CS 824 824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Access violation error trying to insert into triggered view
75
functional sqlite a696379c1f 
 SS 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
Access violation error trying to insert into triggered view
76
functional sqlite ae3c5670b6 
 CS 878 878 0 0 0 0 0 0 0 0 0 0 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
77
functional sqlite ae3c5670b6 
 SS 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
Bug caused by factoring of constants in trigger programs
78
functional sqlite b50528af44 
 CS 1033 1033 0 0 0 0 0 0 0 0 0 0 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.
79
functional sqlite b50528af44 
 SS 755 755 0 0 0 0 0 0 0 0 0 0 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.
80
functional sqlite b65cb2c8d9 
 SS 656 656 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect LIMIT on a UNION ALL query
81
functional sqlite b75a9ca6b0 
 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
ORDER BY ignored if query has identical GROUP BY
82
functional sqlite b75a9ca6b0 
 SS 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
ORDER BY ignored if query has identical GROUP BY
83
functional sqlite b7c8682cc1 
 CS 906 906 0 0 0 0 0 0 0 0 0 0 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
84
functional sqlite b7c8682cc1 
 SS 582 582 0 0 0 0 0 0 0 0 0 0 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
85
functional sqlite ba7cbfaedc 
 CS 872 872 0 0 0 0 0 0 0 0 0 0 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.
86
functional sqlite ba7cbfaedc 
 SS 550 550 0 0 0 0 0 0 0 0 0 0 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.
87
functional sqlite bc1aea7b72 
 CS 824 824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
88
functional sqlite bc1aea7b72 
 SS 569 569 0 0 0 0 0 0 0 0 0 0 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
89
functional sqlite bc878246ea 
 CS 850 850 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN query
90
functional sqlite bc878246ea 
 SS 623 623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN query
91
functional sqlite be84e357c0 
 CS 803 803 0 0 0 0 0 0 0 0 0 0 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
92
functional sqlite be84e357c0 
 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
Segfault during query involving LEFT JOIN column in the ORDER BY clause
93
functional sqlite bfbf38e5e9 
 CS 918 918 0 0 0 0 0 0 0 0 0 0 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
94
functional sqlite bfbf38e5e9 
 SS 696 696 0 0 0 0 0 0 0 0 0 0 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
95
functional sqlite c2a19d8165 
 SS 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 LEFT JOIN when FROM clause contains nested subqueries
96
functional sqlite c2ad16f997 
 CS 860 860 0 0 0 0 0 0 0 0 0 0 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
97
functional sqlite c2ad16f997 
 SS 569 569 0 0 0 0 0 0 0 0 0 0 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
98
functional sqlite c31034044b 
 CS 787 787 0 0 0 0 0 0 0 0 0 0 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
99
functional sqlite c31034044b 
 SS 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
LEFT JOIN in view malfunctions with NOTNULL
100
functional sqlite c5ea805691 
 CS 830 830 0 0 0 0 0 0 0 0 0 0 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
101
functional sqlite c5ea805691 
 SS 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
Inverted sort order when using DISTINCT and a descending index
102
functional sqlite c620261b5b 
 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 result on query involving LEFT JOIN and transitive constraints
103
functional sqlite c620261b5b 
 SS 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 on query involving LEFT JOIN and transitive constraints
104
functional sqlite c997b11c4d 
 CS 850 850 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY clause ignored in 3-way join query
105
functional sqlite c997b11c4d 
 SS 554 554 0 0 0 0 0 0 0 0 0 0 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
106
functional sqlite ca0d20b6cd 
 SS 552 552 0 0 0 0 0 0 0 0 0 0 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
107
functional sqlite ce7c133ea6 
 CS 781 781 0 0 0 0 0 0 0 0 0 0 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.
108
functional sqlite ce7c133ea6 
 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
Foreign key constraint fails when it should succeed.
109
functional sqlite d02e1406a5 
 CS 840 840 0 0 0 0 0 0 0 0 0 0 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
110
functional sqlite d02e1406a5 
 SS 569 569 0 0 0 0 0 0 0 0 0 0 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
111
functional sqlite d11a6e908f 
 CS 835 835 0 0 0 0 0 0 0 0 0 0 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
112
functional sqlite d11a6e908f 
 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
Query planner fault on three-way nested join with compound inner SELECT
113
functional sqlite d666d600a6 
 CS 815 815 0 0 0 0 0 0 0 0 0 0 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.
114
functional sqlite d666d600a6 
 SS 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
COLLATE operator on lhs of BETWEEN expression is ignored.
115
functional sqlite d805526eae 
 CS 788 788 0 0 0 0 0 0 0 0 0 0 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
116
functional sqlite d805526eae 
 SS 586 586 0 0 0 0 0 0 0 0 0 0 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
117
functional sqlite db4d96798d 
 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
LIMIT does not work with nested views containing UNION ALL
118
functional sqlite db4d96798d 
 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
LIMIT does not work with nested views containing UNION ALL
119
functional sqlite db87229497 
 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
Incorrect result when RHS of IN operator contains DISTINCT and LIMIT
120
functional sqlite db87229497 
 SS 564 564 0 0 0 0 0 0 0 0 0 0 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
121
functional sqlite dd08e5a988 
 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
Foreign key constraint fails to prevent consistency error.
122
functional sqlite dd08e5a988 
 SS 549 549 0 0 0 0 0 0 0 0 0 0 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.
123
functional sqlite ebdbadade5 
 CS 794 794 0 0 0 0 0 0 0 0 0 0 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.
124
functional sqlite ebdbadade5 
 SS 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
LEFT JOIN incorrect when ON clause does not reference right table.
125
functional sqlite ec32177c99 
 CS 739 808 618 739 0 0 0 0 0 0 0 0 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
126
functional sqlite ec32177c99 
 SS 424 569 397 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
Incorrect result with complex OR-connected WHERE
127
functional sqlite f2369304e4 
 CS 850 850 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect results when OR is used in the ON clause of a LEFT JOIN
128
functional sqlite f2369304e4 
 SS 519 519 0 0 0 0 0 0 0 0 0 0 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
129
functional sqlite f617ea3125 
 CS 784 784 0 0 0 0 0 0 0 0 0 0 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
130
functional sqlite f617ea3125 
 SS 554 554 0 0 0 0 0 0 0 0 0 0 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
131
functional sqlite f74beaabde 
 CS 883 883 0 0 0 0 0 0 0 0 0 0 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
132
functional sqlite f74beaabde 
 SS 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
Problem with 3-way joins and the USING clause
133
functional sqlite f97c463710 
 CS 797 797 0 0 0 0 0 0 0 0 0 0 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
134
functional sqlite f97c463710 
 SS 575 575 0 0 0 0 0 0 0 0 0 0 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
135
functional sqlite fc7bd6358f 
 CS 951 951 0 0 0 0 0 0 0 0 0 0 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
136
functional sqlite fc7bd6358f 
 SS 547 547 0 0 0 0 0 0 0 0 0 0 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:


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_190c2507ee.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_209d31e316.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_2326c258d0.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_2ea3e9fe63.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_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_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_490a4b7235.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_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_5ed1772895.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_7a31705a7e.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_93fb9f89d6.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_98d973b8f5.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_a5c8ed66ca.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_b50528af44.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_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_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_ce7c133ea6.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_d11a6e908f.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_dd08e5a988.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_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_f97c463710.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_fc7bd6358f.py
https://github.com/FirebirdSQL/firebird/issues/8711
=== end of list ===

Last commits information (all timestamps in UTC):