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 (1 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 (20 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (4 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 (62 rows)
11. All tests: outcomes for previous 35 runs (2814 rows)
12. Skipped: tests which was intentionally excluded from execution (167 rows)

Generated UTC 22.08.2025 05:12
Tested: FB50.   Build / date: 5.0.4.1703-bd5ab06b / 2025.08.20;
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: 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
5.0.4.1703
2025.08.20
bd5ab
5.0.4.1701
2025.08.07
27cb4
5.0.4.1697
2025.08.06
f63a8
5.0.4.1696
2025.08.04
c784c
5.0.3.1693
2025.07.30
8da78
5.0.3.1690
2025.07.28
19167
5.0.3.1689
2025.07.24
57f39
5.0.3.1686
2025.07.23
981c0
5.0.3.1684
2025.07.23
cf760
5.0.3.1684
2025.07.19
e451f
5.0.3.1683
2025.07.12
e98c3
5.0.3.1681
2025.07.11
5a438
5.0.3.1679
2025.07.09
88943
5.0.3.1676
2025.07.01
88ba7
5.0.3.1675
2025.06.27
1bb2c
5.0.3.1674
2025.06.26
d366d
5.0.3.1673
2025.06.25
f0e1f
5.0.3.1668
2025.06.21
b8e22
5.0.3.1667
2025.06.15
4374a
5.0.3.1666
2025.06.14
97178
5.0.3.1665
2025.06.11
d8b62
5.0.3.1661
2025.06.10
cfcf0
5.0.3.1660
2025.06.07
db691
5.0.3.1659
2025.05.28
f4c0f
5.0.3.1658
2025.05.27
e3aa4
5.0.3.1657
2025.05.22
a6c19
5.0.3.1656
2025.05.12
37a12
5.0.3.1654
2025.05.11
789ca
5.0.3.1653
2025.05.07
8e48a
5.0.3.1652
2025.05.06
1de2f
5.0.3.1651
2025.05.05
c8191
5.0.3.1650
2025.04.23
41dca
5.0.3.1649
2025.04.18
da7bd
5.0.3.1648
2025.04.17
a54ad
5.0.3.1647
2025.04.14
8993a
Test TITLE
1
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
2
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
3
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
4
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
5
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
6
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.
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 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
9
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
10
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
11
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.
12
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
13
functional sqlite 2326c258d0 
 ALL P X X X X X X X X X X 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
14
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.
15
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
16
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
17
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
18
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
19
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
20
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
21
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
22
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
23
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
24
functional sqlite 47b2581aa9 
 ALL P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Infinite loop on UPDATE
25
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
26
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
27
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
28
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
29
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
30
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
31
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
32
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
33
functional sqlite 80369eddd5 
 ALL P X X X X X X X X X X 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 case in the LIKE operator when comparing unicode characters belonging to "Other Letter" category
34
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
35
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
36
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
37
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
38
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
39
functional sqlite aa98619ad0 
 ALL P X X X X X X X X X X 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 an IN operator using a computed-by index
40
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
41
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
42
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.
43
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
44
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
45
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
46
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
47
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
48
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
49
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
50
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
51
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
52
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
53
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
54
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.
55
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
56
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
57
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
58
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
59
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
60
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
61
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
62
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

Elapsed time, milliseconds:

NN Test name mode median_ms
5.0.4.1703
2025.08.20
bd5ab
5.0.4.1701
2025.08.07
27cb4
5.0.4.1697
2025.08.06
f63a8
5.0.4.1696
2025.08.04
c784c
5.0.3.1693
2025.07.30
8da78
5.0.3.1690
2025.07.28
19167
5.0.3.1689
2025.07.24
57f39
5.0.3.1686
2025.07.23
981c0
5.0.3.1684
2025.07.23
cf760
5.0.3.1684
2025.07.19
e451f
5.0.3.1683
2025.07.12
e98c3
5.0.3.1681
2025.07.11
5a438
5.0.3.1679
2025.07.09
88943
5.0.3.1676
2025.07.01
88ba7
5.0.3.1675
2025.06.27
1bb2c
5.0.3.1674
2025.06.26
d366d
5.0.3.1673
2025.06.25
f0e1f
5.0.3.1668
2025.06.21
b8e22
5.0.3.1667
2025.06.15
4374a
5.0.3.1666
2025.06.14
97178
5.0.3.1665
2025.06.11
d8b62
5.0.3.1661
2025.06.10
cfcf0
5.0.3.1660
2025.06.07
db691
5.0.3.1659
2025.05.28
f4c0f
5.0.3.1658
2025.05.27
e3aa4
5.0.3.1657
2025.05.22
a6c19
5.0.3.1656
2025.05.12
37a12
5.0.3.1654
2025.05.11
789ca
5.0.3.1653
2025.05.07
8e48a
5.0.3.1652
2025.05.06
1de2f
5.0.3.1651
2025.05.05
c8191
5.0.3.1650
2025.04.23
41dca
5.0.3.1649
2025.04.18
da7bd
5.0.3.1648
2025.04.17
a54ad
5.0.3.1647
2025.04.14
8993a
Test TITLE
1
functional intfunc string substring 01 
 CS 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
Positional SUBSTRING function
2
functional intfunc string substring 01 
 SS 384 384 0 0 0 0 0 0 0 0 0 0 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
3
functional sqlite 05f43be8fd 
 CS 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
Incorrect use of index with LIKE operators when the LHS is a blob
4
functional sqlite 05f43be8fd 
 SS 385 385 0 0 0 0 0 0 0 0 0 0 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
5
functional sqlite 07d6a0453d 
 CS 603 603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OFFSET ignored if there is no FROM clause
6
functional sqlite 07d6a0453d 
 SS 378 378 0 0 0 0 0 0 0 0 0 0 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
7
functional sqlite 0911b5d161 
 CS 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
Assertion
8
functional sqlite 0911b5d161 
 SS 383 383 0 0 0 0 0 0 0 0 0 0 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
9
functional sqlite 123c9ba321 
 CS 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 an index is used for an ordered join
10
functional sqlite 123c9ba321 
 SS 373 373 0 0 0 0 0 0 0 0 0 0 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
11
functional sqlite 16c9801ceb 
 CS 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
Segfault on DELETE with WHERE containing OR and redundant index exists.
12
functional sqlite 16c9801ceb 
 SS 379 379 0 0 0 0 0 0 0 0 0 0 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.
13
functional sqlite 190c2507ee 
 CS 578 578 0 0 0 0 0 0 0 0 0 0 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
14
functional sqlite 190c2507ee 
 SS 372 372 0 0 0 0 0 0 0 0 0 0 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
15
functional sqlite 199df4168c 
 CS 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
Different answer with and without index on IN operator with type mismatch
16
functional sqlite 199df4168c 
 SS 377 377 0 0 0 0 0 0 0 0 0 0 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
17
functional sqlite 1b266395d6 
 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
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
18
functional sqlite 1b266395d6 
 SS 384 384 0 0 0 0 0 0 0 0 0 0 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
19
functional sqlite 1c69be2daf 
 CS 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 GROUP BY when input and output columns have the same name
20
functional sqlite 1c69be2daf 
 SS 380 380 0 0 0 0 0 0 0 0 0 0 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
21
functional sqlite 1e39b966ae 
 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
LEFT JOIN strength reduction optimization causes an error.
22
functional sqlite 1e39b966ae 
 SS 372 372 0 0 0 0 0 0 0 0 0 0 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.
23
functional sqlite 209d31e316 
 CS 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
Assertion fault when deleting a table out from under a SELECT
24
functional sqlite 209d31e316 
 SS 373 373 0 0 0 0 0 0 0 0 0 0 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
25
functional sqlite 2326c258d0 
 CS 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
Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index
26
functional sqlite 2326c258d0 
 SS 377 377 0 0 0 0 0 0 0 0 0 0 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
27
functional sqlite 25e335f802 
 CS 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
Query "<A> left join <B> inner join <C> on <b_c_expr> on <a_b_expr>" caused left join behave like inner join.
28
functional sqlite 25e335f802 
 SS 380 380 0 0 0 0 0 0 0 0 0 0 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.
29
functional sqlite 2df0107bd2 
 CS 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 result from LEFT JOIN with a subquery on the LHS
30
functional sqlite 2df0107bd2 
 SS 375 375 0 0 0 0 0 0 0 0 0 0 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
31
functional sqlite 2ea3e9fe63 
 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
Partial index causes assertion fault on UPDATE OR REPLACE
32
functional sqlite 2ea3e9fe63 
 SS 376 376 0 0 0 0 0 0 0 0 0 0 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
33
functional sqlite 2f7170d73b 
 CS 581 581 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error "misuse of aggregate" raising if aggregate column in FROM subquery presents in the correlated subquery
34
functional sqlite 2f7170d73b 
 SS 372 372 0 0 0 0 0 0 0 0 0 0 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
35
functional sqlite 31a19d11b9 
 CS 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
Name resolution issue with compound SELECTs and Common Table Expressions
36
functional sqlite 31a19d11b9 
 SS 377 377 0 0 0 0 0 0 0 0 0 0 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
37
functional sqlite 34a579141b 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect results with OR terms in the ON clause of a LEFT JOIN
38
functional sqlite 34a579141b 
 SS 389 389 0 0 0 0 0 0 0 0 0 0 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
39
functional sqlite 34cd55d68e 
 CS 616 616 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Database corruption following INSERT with a TRIGGER that does an affinity change
40
functional sqlite 34cd55d68e 
 SS 399 399 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Database corruption following INSERT with a TRIGGER that does an affinity change
41
functional sqlite 38a97a87a6 
 CS 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
Inaccurate int/float comparison results in corrupt index
42
functional sqlite 38a97a87a6 
 SS 391 391 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inaccurate int/float comparison results in corrupt index
43
functional sqlite 43107840f1 
 CS 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
Assertion fault on UPDATE
44
functional sqlite 43107840f1 
 SS 396 396 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Assertion fault on UPDATE
45
functional sqlite 4766f44486 
 CS 619 619 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY handling with indexes on expressions
46
functional sqlite 4766f44486 
 SS 379 379 0 0 0 0 0 0 0 0 0 0 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
47
functional sqlite 47b2581aa9 
 CS 581 581 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Infinite loop on UPDATE
48
functional sqlite 47b2581aa9 
 SS 388 388 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Infinite loop on UPDATE
49
functional sqlite 4ba5abf65c 
 CS 581 581 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Index on expression leads to an incorrect LEFT JOIN
50
functional sqlite 4ba5abf65c 
 SS 390 390 0 0 0 0 0 0 0 0 0 0 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
51
functional sqlite 4baa464912 
 CS 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
NULL handling for indexes on expressions
52
functional sqlite 4baa464912 
 SS 377 377 0 0 0 0 0 0 0 0 0 0 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
53
functional sqlite 4ef7e3cfca 
 CS 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
Name resolution problem in sub-selects within triggers
54
functional sqlite 4ef7e3cfca 
 SS 374 374 0 0 0 0 0 0 0 0 0 0 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
55
functional sqlite 5e3c886796 
 CS 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
Correlated subquery on the RHS of an IN operator causes output of excessive rows
56
functional sqlite 5e3c886796 
 SS 377 377 0 0 0 0 0 0 0 0 0 0 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
57
functional sqlite 6f2222d550 
 CS 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 output on a LEFT JOIN
58
functional sqlite 6f2222d550 
 SS 372 372 0 0 0 0 0 0 0 0 0 0 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
59
functional sqlite 7f7f8026ed 
 CS 613 613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault following heavy SAVEPOINT usage
60
functional sqlite 7f7f8026ed 
 SS 374 374 0 0 0 0 0 0 0 0 0 0 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
61
functional sqlite 7fa8049685 
 CS 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 on a LEFT JOIN when using an index
62
functional sqlite 7fa8049685 
 SS 373 373 0 0 0 0 0 0 0 0 0 0 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
63
functional sqlite 7fde638e94 
 CS 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
Assertion fault on a LEFT JOIN
64
functional sqlite 7fde638e94 
 SS 371 371 0 0 0 0 0 0 0 0 0 0 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
65
functional sqlite 80369eddd5 
 CS 574 574 0 0 0 0 0 0 0 0 0 0 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 case in the LIKE operator when comparing unicode characters belonging to "Other Letter" category
66
functional sqlite 80369eddd5 
 SS 381 381 0 0 0 0 0 0 0 0 0 0 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 case in the LIKE operator when comparing unicode characters belonging to "Other Letter" category
67
functional sqlite 892fc34f17 
 CS 588 588 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect query result when a LEFT JOIN subquery is flattened
68
functional sqlite 892fc34f17 
 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 query result when a LEFT JOIN subquery is flattened
69
functional sqlite 96c1454cbf 
 CS 626 626 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result with ORDER BY DESC and LIMIT
70
functional sqlite 96c1454cbf 
 SS 387 387 0 0 0 0 0 0 0 0 0 0 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
71
functional sqlite 98825a79ce 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
72
functional sqlite 98825a79ce 
 SS 376 376 0 0 0 0 0 0 0 0 0 0 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
73
functional sqlite 98d973b8f5 
 CS 606 606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Partial index gives incorrect query result
74
functional sqlite 98d973b8f5 
 SS 375 375 0 0 0 0 0 0 0 0 0 0 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
75
functional sqlite a5c8ed66ca 
 CS 615 615 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect count(*) when partial indices exist
76
functional sqlite a5c8ed66ca 
 SS 378 378 0 0 0 0 0 0 0 0 0 0 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
77
functional sqlite aa98619ad0 
 CS 577 577 0 0 0 0 0 0 0 0 0 0 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 an IN operator using a computed-by index
78
functional sqlite aa98619ad0 
 SS 378 378 0 0 0 0 0 0 0 0 0 0 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 an IN operator using a computed-by index
79
functional sqlite b65cb2c8d9 
 CS 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 LIMIT on a UNION ALL query
80
functional sqlite b65cb2c8d9 
 SS 375 375 0 0 0 0 0 0 0 0 0 0 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 615 615 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ORDER BY ignored if query has identical GROUP BY
82
functional sqlite b75a9ca6b0 
 SS 382 382 0 0 0 0 0 0 0 0 0 0 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 ba7cbfaedc 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong output order when a DESC index and GROUP BY and ORDER BY.
84
functional sqlite ba7cbfaedc 
 SS 386 386 0 0 0 0 0 0 0 0 0 0 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.
85
functional sqlite bc878246ea 
 CS 613 613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN query
86
functional sqlite bc878246ea 
 SS 392 392 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result from LEFT JOIN query
87
functional sqlite be84e357c0 
 CS 578 578 0 0 0 0 0 0 0 0 0 0 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
88
functional sqlite be84e357c0 
 SS 379 379 0 0 0 0 0 0 0 0 0 0 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
89
functional sqlite c2a19d8165 
 CS 601 601 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect LEFT JOIN when FROM clause contains nested subqueries
90
functional sqlite c2a19d8165 
 SS 369 369 0 0 0 0 0 0 0 0 0 0 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
91
functional sqlite c31034044b 
 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
LEFT JOIN in view malfunctions with NOTNULL
92
functional sqlite c31034044b 
 SS 379 379 0 0 0 0 0 0 0 0 0 0 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
93
functional sqlite c5ea805691 
 CS 585 585 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inverted sort order when using DISTINCT and a descending index
94
functional sqlite c5ea805691 
 SS 370 370 0 0 0 0 0 0 0 0 0 0 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
95
functional sqlite c620261b5b 
 CS 583 583 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result on query involving LEFT JOIN and transitive constraints
96
functional sqlite c620261b5b 
 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 result on query involving LEFT JOIN and transitive constraints
97
functional sqlite c94369cae9 
 CS 619 619 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong answer when use no-case collation due to the LIKE optimization
98
functional sqlite c94369cae9 
 SS 416 416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong answer when use no-case collation due to the LIKE optimization
99
functional sqlite ca0d20b6cd 
 CS 622 622 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE operator masked by function calls
100
functional sqlite ca0d20b6cd 
 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
COLLATE operator masked by function calls
101
functional sqlite cad1ab4cb7 
 CS 620 620 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Segfault due to LEFT JOIN flattening optimization
102
functional sqlite cad1ab4cb7 
 SS 382 382 0 0 0 0 0 0 0 0 0 0 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
103
functional sqlite d06a25c844 
 CS 578 578 0 0 0 0 0 0 0 0 0 0 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
104
functional sqlite d06a25c844 
 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 result from a UNION with an ORDER BY
105
functional sqlite d11a6e908f 
 CS 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
Query planner fault on three-way nested join with compound inner SELECT
106
functional sqlite d11a6e908f 
 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
Query planner fault on three-way nested join with compound inner SELECT
107
functional sqlite d666d600a6 
 CS 597 597 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE operator on lhs of BETWEEN expression is ignored.
108
functional sqlite d666d600a6 
 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
COLLATE operator on lhs of BETWEEN expression is ignored.
109
functional sqlite db87229497 
 CS 578 578 0 0 0 0 0 0 0 0 0 0 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
110
functional sqlite db87229497 
 SS 375 375 0 0 0 0 0 0 0 0 0 0 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
111
functional sqlite dc6ebeda93 
 CS 577 577 0 0 0 0 0 0 0 0 0 0 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
112
functional sqlite dc6ebeda93 
 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 DELETE due to the one-pass optimization
113
functional sqlite e20dd54ab0 
 CS 611 611 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
114
functional sqlite e20dd54ab0 
 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
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
115
functional sqlite eb703ba7b5 
 CS 605 605 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect result using index on expression with collating function
116
functional sqlite eb703ba7b5 
 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 using index on expression with collating function
117
functional sqlite ec32177c99 
 CS 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
Incorrect result with complex OR-connected WHERE
118
functional sqlite ec32177c99 
 SS 389 389 0 0 0 0 0 0 0 0 0 0 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
119
functional sqlite f617ea3125 
 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
Incorrect ORDER BY with colliding input and output column names
120
functional sqlite f617ea3125 
 SS 375 375 0 0 0 0 0 0 0 0 0 0 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
121
functional sqlite f7f8c97e97 
 CS 622 622 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Valid query fails to compile due to WHERE clause optimization
122
functional sqlite f7f8c97e97 
 SS 372 372 0 0 0 0 0 0 0 0 0 0 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
123
functional sqlite f97c463710 
 CS 608 608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect ordering with ORDER BY and LIMIT
124
functional sqlite f97c463710 
 SS 378 378 0 0 0 0 0 0 0 0 0 0 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

List of tests in this report:


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_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_2326c258d0.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_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_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_38a97a87a6.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_47b2581aa9.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_4ef7e3cfca.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_6f2222d550.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_80369eddd5.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_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_98d973b8f5.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_aa98619ad0.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_ba7cbfaedc.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_c2a19d8165.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_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_d06a25c844.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_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_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_ec32177c99.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_f7f8c97e97.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_f97c463710.py
=== end of list ===

Last commits information (all timestamps in UTC):