| accfef3317 |
2024-09-16 23:34:11
|
Support_Request
|
Closed
|
Other
|
Unicode output from the CLI subprocess not displayed correctly on Windows.
|
| 16e5fb9e72 |
2024-08-21 14:49:22
|
Optimization
|
Open
|
|
order-by-subquery optimization not working on NATURAL JOIN
|
| 6e3ace1270 |
2024-06-04 18:53:34
|
Code_Defect
|
Fixed
|
Unknown
|
Table-valued functions with required parameters
|
| 8ff324e120 |
2024-05-28 00:20:25
|
Optimization
|
Fixed
|
Unknown
|
Unwarranted use of automatic index
|
| 667014c20b |
2023-04-08 20:07:55
|
Optimization
|
Closed
|
Unknown
|
Missed optimization when LHS of IN is an expression
|
| b50528af44 |
2023-03-30 11:42:18
|
Code_Defect
|
Fixed
|
Unknown
|
"WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows.
|
| 33aa4c0de8 |
2023-03-20 01:33:28
|
Code_Defect
|
Fixed
|
Utilities
|
Heap buffer overflow on SQL input
|
| 4f19d72774 |
2023-03-17 00:46:19
|
Incident
|
Fixed
|
Shell
|
Heap buffer overflow on SQL input (4)
|
| 2971fbe3f9 |
2023-03-17 00:45:50
|
Incident
|
Fixed
|
Shell
|
Heap buffer overflow on SQL input (3)
|
| b97e6c5e6a |
2023-03-17 00:45:10
|
Code_Defect
|
Fixed
|
Shell
|
Heap buffer overflow on SQL input (2)
|
| 89d259d45b |
2023-03-17 00:04:47
|
Code_Defect
|
Fixed
|
Code_Generator
|
Assertion fault on SQL input (2)
|
| d15b3a4ea9 |
2023-03-17 00:03:30
|
Code_Defect
|
Fixed
|
Code_Generator
|
Assertion fault on SQL input
|
| d6fd512f50 |
2023-03-16 21:03:12
|
Code_Defect
|
Fixed
|
Code_Generator
|
Segfault on SQL input (3)
|
| 4051a7f931 |
2023-03-16 21:02:36
|
Code_Defect
|
Fixed
|
Code_Generator
|
Segfault on SQL input (2)
|
| c36cdb4afd |
2023-03-16 21:01:12
|
Code_Defect
|
Fixed
|
Code_Generator
|
Segfault due to SQL inputs
|
| 0b75886e6d |
2023-02-24 16:04:18
|
Enhancement
|
Fixed
|
Unknown
|
Allow some sqlite3_config() calls after sqlite3_initialize().
|
| eaed8e36ce |
2023-02-22 21:47:14
|
Enhancement
|
Fixed
|
Unknown
|
Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default
|
| baa5bb76c3 |
2023-02-22 21:11:47
|
Optimization
|
Fixed
|
Unknown
|
UNION ALL view does not use a covering index
|
| a7f5b0856f |
2023-02-16 17:14:52
|
Optimization
|
Open
|
Unknown
|
Missed optimization for "constant IN (column1,column2)"
|
| 73ebbb3a3d |
2022-12-14 18:35:50
|
Feature_Request
|
Fixed
|
Code_Generator
|
View ought not be materialized
|
| 57c47526c3 |
2022-12-13 00:59:58
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect answer when flattening a UNION ALL compound
|
| 679ed6a282 |
2022-12-10 19:37:48
|
Code_Defect
|
Fixed
|
Code_Generator
|
Different affinities in CREATE VIEW depending if column names declared
|
| e8b6742419 |
2022-12-05 02:53:27
|
Performance_Issue
|
Fixed
|
Unknown
|
Query planner chooses an inefficient algorithm.
|
| 695a1a53de |
2022-11-28 19:43:06
|
Feature_Request
|
Fixed
|
Unknown
|
Better choice of indexes with covering indexes on expressions
|
| 9937817793 |
2022-11-25 16:12:23
|
Feature_Request
|
Fixed
|
Unknown
|
Use indexed expressions in an aggregate query
|
| 53043c9793 |
2022-11-19 00:08:48
|
Code_Defect
|
Fixed
|
Unknown
|
deserialized DB has a sqlite3_db_filename() contrary to docs
|
| ee4b2b48f5 |
2022-11-11 13:51:34
|
Feature_Request
|
Closed
|
Parser
|
Prepared statement cache
|
| 6c266900a2 |
2022-11-11 13:17:24
|
Feature_Request
|
Fixed
|
Shell
|
shell: The column mode (and width option) does not manage correctly UTF-8
|
| bd375c20c7 |
2022-02-01 16:45:51
|
Not_A_Bug
|
Closed
|
Unknown
|
Potential bug in FTS5
|
| 5981a8c041 |
2021-11-02 22:26:43
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect answer on a SeekScan query
|
| f2be158c57 |
2021-08-18 22:27:04
|
Code_Defect
|
Fixed
|
Unknown
|
ON CONFLICT on a PK column in a WITHOUT ROWID table does not work
|
| c88f3036a2 |
2021-07-23 23:49:07
|
Code_Defect
|
Fixed
|
Unknown
|
ALTER TABLE DROP COLUMN may corrupt data
|
| 6dcbfd11cf |
2021-06-25 14:49:38
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Incorrect query result due to the SeekScan optimization
|
| c66298e288 |
2021-04-23 13:43:15
|
Code_Defect
|
Closed
|
Unknown
|
Inconsistent iterations of WhereClause->nTerm
|
| de7db14784 |
2021-03-30 19:18:45
|
Code_Defect
|
Fixed
|
Unknown
|
subquery with limit clause fails as EXISTS operand
|
| 132994c8b1 |
2021-03-30 19:17:30
|
Code_Defect
|
Fixed
|
Code_Generator
|
RETURNING old.* seg-faults
|
| bb8a9fd4a9 |
2021-03-18 16:48:21
|
Code_Defect
|
Fixed
|
Unknown
|
Crash due to MATERIALIZED
|
| 2c6c8689fb |
2021-03-16 18:42:42
|
Code_Defect
|
Fixed
|
Unknown
|
Non-deterministic date/time function identified as deterministic.
|
| a753a8567d |
2021-03-16 12:36:18
|
Code_Defect
|
Fixed
|
Unknown
|
RENAME COLUMN incorrectly modifying column names in generated column expressions
|
| 1c24a659e6 |
2021-03-15 14:58:51
|
Code_Defect
|
Fixed
|
Code_Generator
|
DROP COLUMN leaves behind an index
|
| 22dea1cfdb |
2021-03-02 16:27:40
|
Portability
|
Fixed
|
Extensions
|
Misoptimization in ieee754func
|
| c0aeea67d5 |
2021-02-15 17:02:17
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect LIKE result
|
| ee51301f31 |
2021-01-27 19:15:22
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect optimization of IN operator.
|
| 95302bdb08 |
2020-10-05 03:24:28
|
Code_Defect
|
Fixed
|
Unknown
|
WHERE clause that uses a NUMERIC cast influences the result type
|
| e33ee62575 |
2020-10-03 17:08:21
|
Code_Defect
|
Closed
|
Extensions
|
Segfault using a CROSS JOIN on a table using the experimental trigram tokenizer
|
| 2ba5930b27 |
2020-10-03 14:37:40
|
Code_Defect
|
Closed
|
Extensions
|
Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer
|
| 0f586dbeb3 |
2020-10-02 20:19:24
|
Code_Defect
|
Closed
|
Unknown
|
FTS4 integrity-check fails for UTF16 encoding
|
| 2d5a316356 |
2020-10-01 14:36:36
|
Code_Defect
|
Fixed
|
Unknown
|
Segmentation fault in CROSS JOIN and the rtree extension
|
| 5c4e7aa793 |
2020-09-30 17:33:40
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result for comparison with NULL
|
| 66e4b0e271 |
2020-09-30 15:46:49
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect result for LEFT JOIN
|
| c51489c3b8 |
2020-09-29 11:52:53
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect result from WITH RECURSIVE using DISTINCT
|
| be31cf009c |
2020-08-27 13:33:54
|
Code_Defect
|
Closed
|
Unknown
|
Unexpected result for % and '1E1'
|
| f3ff147288 |
2020-08-24 10:53:55
|
Code_Defect
|
Closed
|
Unknown
|
Incorrect result for IN expression with right-hand IS TRUE sub-expression
|
| 3211687148 |
2020-06-25 03:17:25
|
Not_A_Bug
|
Closed
|
Unknown
|
Inconsistent result in sum
|
| 9c14a0c7ee |
2020-06-25 03:12:14
|
Not_A_Bug
|
Closed
|
Unknown
|
Another inconsistent result
|
| 8f157e8010 |
2020-06-15 13:56:11
|
Code_Defect
|
Fixed
|
Unknown
|
Heap Buffer Overflow in multiSelectOrderBy
|
| 9fb26d37ce |
2020-06-14 13:42:55
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Assertion `flags3==pIn3->flags' failed.
|
| e367f31901 |
2020-06-13 21:43:15
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `pExpr->pAggInfo==pAggInfo' failed.
|
| b706351ce2 |
2020-06-11 16:04:22
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in sqlite3Select
|
| 7c6d876f84 |
2020-06-09 23:50:53
|
Code_Defect
|
Fixed
|
Unknown
|
Use after free in resetAccumulator.
|
| f7d890858f |
2020-06-08 11:38:56
|
Code_Defect
|
Closed
|
Unknown
|
Segfault in moveToRoot
|
| e5504e987e |
2020-06-07 00:43:52
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in sqlite3VdbeCursorMoveto
|
| 1f6f353b68 |
2020-06-06 19:36:24
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in sqlite3VdbeExec
|
| 0899cf62f5 |
2020-06-06 14:44:48
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in sqlite3VdbeExec
|
| c8d3b9f0a7 |
2020-06-05 15:26:18
|
Code_Defect
|
Fixed
|
Unknown
|
Use after free in resetAccumulator.
|
| 810dc80388 |
2020-06-03 19:31:24
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
COMMIT command succeeds even though it didn't commit.
|
| 7a5279a25c |
2020-05-24 03:39:26
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in sqlite3ExprCodeTarget
|
| 23439ea582 |
2020-05-23 20:03:59
|
Code_Defect
|
Fixed
|
Utilities
|
Stack overflow in sqlite3_str_vappendf, caused by int overflow
|
| 45f4bf4eb4 |
2020-04-25 15:02:43
|
Code_Defect
|
Closed
|
Unknown
|
UNION operator malfunctions in LEFT JOIN on view
|
| 51166be015 |
2020-04-04 00:16:12
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `pC!=0' failed.
|
| fd1bda016d |
2020-04-03 20:08:33
|
Code_Defect
|
Closed
|
Unknown
|
Assertion `flags3==pIn3->flags' failed
|
| af4556bb5c |
2020-04-03 13:19:17
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault while trying to prepare a malformed window-function query
|
| a10a14e9b4 |
2020-04-03 12:05:21
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault while renaming a table.
|
| 4722bdab08 |
2020-04-03 11:26:37
|
Code_Defect
|
Fixed
|
Unknown
|
Another renameTokenCheckAll() fault
|
| 5829597ac4 |
2020-03-22 03:20:08
|
Code_Defect
|
Fixed
|
Unknown
|
SEGV in sqlite3.c:80685 sqlite3VdbeCursorMoveto
|
| 618156e3f6 |
2020-03-16 19:00:27
|
Code_Defect
|
Closed
|
Unknown
|
clearSelect: Assertion `p->pWin==0' failed.
|
| 82b588d342 |
2020-03-16 03:19:13
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `memIsValid(&r.aMem[ii])' failed.
|
| 3c9eadd2a6 |
2020-03-11 19:56:35
|
Code_Defect
|
Fixed
|
Unknown
|
PRAGMA integrity_check fails due to CHECK constraint even without records
|
| e0c2ad1aa8 |
2020-03-10 11:51:02
|
Code_Defect
|
Fixed
|
Unknown
|
GROUP BY causes unexpected conversion
|
| fa146dcfe6 |
2020-03-06 00:15:57
|
Documentation
|
Fixed
|
Unknown
|
Unexpected result for MIN on string that contains a null character
|
| 1b8d726456 |
2020-03-05 16:26:30
|
Code_Defect
|
Fixed
|
Unknown
|
MAX yields unexpected result for UTF-16
|
| c4c56482ce |
2020-03-03 20:49:32
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `(p->flags & ~(MEM_Null|MEM_Term|MEM_Subtype|MEM_FromBind |MEM_Dyn|MEM_Ephem|MEM_Static))==0' failed.
|
| d165ad781b |
2020-03-03 20:06:37
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `(mFlags&(MEM_Str|MEM_Blob))==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed.
|
| da5a09be6d |
2020-03-02 01:51:38
|
Code_Defect
|
Fixed
|
Unknown
|
UAF in sqlite3BlobCompare
|
| e12a0ae526 |
2020-03-02 01:30:39
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `memIsValid(&aMem[pOp->p1])' failed
|
| e63b4d1a65 |
2020-02-28 16:04:41
|
Code_Defect
|
Fixed
|
Unknown
|
Query on rtree unexpectedly yields 0 rather than 0.0
|
| f50af3e8a5 |
2020-02-23 17:38:04
|
Code_Defect
|
Fixed
|
Unknown
|
OOB memory access on a table rename
|
| aa43786930 |
2020-02-22 13:07:53
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3.c:87338: int sqlite3VdbeExec(Vdbe *): Assertion `sqlite3BtreeCursorIsValid(pCrsr)' failed.
|
| 4374860b29 |
2020-02-17 00:12:19
|
Code_Defect
|
Fixed
|
Unknown
|
Segmentation fault in isAuxiliaryVtabOperator
|
| 1dcb4d4496 |
2020-02-13 22:12:55
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect query result when redundant terms appears in WHERE clause
|
| 41c1456a6e |
2020-02-13 11:47:33
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `pColl1 && (pParse->nErr || pColl2)' failed.
|
| fb8c538a8f |
2020-02-12 13:02:45
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is constrained by an == with a different collation in the WHERE clause
|
| f07d71bb49 |
2020-02-04 03:01:46
|
Code_Defect
|
Fixed
|
Other
|
Assertion `pOp->p4type==P4_FUNCCTX' failed.
|
| 86ba67afaf |
2020-02-04 01:50:11
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect affinity for CHECK constraints
|
| 9d3666754a |
2020-02-04 01:49:44
|
Code_Defect
|
Fixed
|
Unknown
|
int sqlite3VdbeExec(Vdbe *): Assertion `memIsValid(pCtx->argv[i])' failed.
|
| 1dc432db3b |
2020-01-29 23:19:04
|
Code_Defect
|
Closed
|
Unknown
|
FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding
|
| b985f0bd16 |
2020-01-22 23:13:45
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `0' failed in sqlite3IsLikeFunction
|
| 830277d9db |
2020-01-18 21:35:33
|
Code_Defect
|
Closed
|
Unknown
|
Non-deterministic date/time functions allowed in CHECK constraints
|
| a08879a4a4 |
2020-01-15 16:20:28
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `pKeyInfo->enc==ENC(db)' failed.
|
| 614b25314c |
2020-01-12 22:20:23
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion (pTabItem[0].fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed
|
| 5c5a16ec29 |
2020-01-10 01:33:50
|
Not_A_Bug
|
Closed
|
Unknown
|
Test ticket
|
| a148d923bf |
2020-01-10 01:32:41
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `memIsValid(pCtx->argv[i])' failed.
|
| c45762c806 |
2020-01-10 01:13:12
|
Not_A_Bug
|
Closed
|
Unknown
|
Second test ticket
|
| 678ecf429f |
2020-01-09 20:21:41
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `pWin==pMWin || sqlite3WindowCompare(pParse,pWin,pMWin,0)==0' failed
|
| 9eda2697f5 |
2020-01-08 12:17:58
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result for COUNT(), UTF16be encoding and SUBSTR
|
| 82ac75ba00 |
2020-01-08 01:44:07
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition
|
| bbd55a97e6 |
2020-01-06 22:48:07
|
Code_Defect
|
Fixed
|
Unknown
|
Global heap over flow in sqlite3VdbeMemPrettyPrint
|
| 9c944882bf |
2020-01-06 17:47:59
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `pSub->pGroupBy==0' failed.
|
| 304017f5f0 |
2020-01-06 17:33:37
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion `j>=pLoop->u.btree.nEq || (pLoop->aLTerm[j]==0)==(j<pLoop->nSkip)' failed.
|
| a3713a5fca |
2020-01-04 20:07:58
|
Code_Defect
|
Closed
|
Unknown
|
DBSTAT query computes incorrect result for stat.aggregate = 1 condition
|
| 74a4c3860c |
2020-01-04 18:53:36
|
Code_Defect
|
Closed
|
Unknown
|
DBSTAT query computes incorrect result for name column
|
| 727074e2ae |
2020-01-04 15:23:30
|
Code_Defect
|
Fixed
|
Unknown
|
DBSTAT query computes incorrect result for aggregate column
|
| 771fe61761 |
2020-01-02 16:24:33
|
Code_Defect
|
Closed
|
Unknown
|
FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR
|
| 46fcd700b8 |
2019-12-31 23:17:53
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed (2)
|
| a0e88d8d7a |
2019-12-31 13:55:54
|
Feature_Request
|
Closed
|
Unknown
|
Inconsistent handling of subqueries in index expressions
|
| 892575cdba |
2019-12-30 23:50:34
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion codeVectorCompare: Assertion `0' failed
|
| 7c0e06b162 |
2019-12-30 14:32:38
|
Code_Defect
|
Closed
|
Unknown
|
NATURAL JOIN on virtual table results in "parse error in rank function"
|
| 314cc133e5 |
2019-12-29 22:09:31
|
Code_Defect
|
Fixed
|
Unknown
|
Trigger on normal table causes the database disk image to become malformed
|
| ec8abb025e |
2019-12-29 00:56:15
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed
|
| de4b04149b |
2019-12-28 01:53:00
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed
|
| 5fbc159eeb |
2019-12-28 00:37:19
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed
|
| 37823501c6 |
2019-12-28 00:37:03
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMem[pOp->p1])' failed.
|
| 36ffedcb9a |
2019-12-27 20:06:42
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion exprSrcCount: Assertion `0' failed
|
| fb3b3024ea |
2019-12-27 01:51:04
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion assert_pager_state: Assertion `pPager->changeCountDone==0 || pPager->eLock>=RESERVED_LOCK' failed
|
| 7c13db5c3b |
2019-12-26 23:40:46
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed
|
| 167b2aac34 |
2019-12-26 14:37:27
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed
|
| d87336c81c |
2019-12-25 23:54:39
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3TableColumnAffinity: Assertion `iCol<pTab->nCol' failed.
|
| 56a74875be |
2019-12-24 21:09:41
|
Feature_Request
|
Closed
|
Unknown
|
UPDATE causes "database table is locked" for rtree table
|
| 752fdbf6e7 |
2019-12-24 20:51:13
|
Code_Defect
|
Closed
|
Unknown
|
FTS database disk image is malformed for UTF-16 encoding and integrity check
|
| df46a6f38e |
2019-12-24 16:20:18
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed
|
| d62981b76d |
2019-12-24 15:04:50
|
Code_Defect
|
Fixed
|
Unknown
|
FTS database disk image is malformed for special characters in table
|
| cafeafe605 |
2019-12-24 02:36:52
|
Feature_Request
|
Closed
|
Extensions
|
UPDATE with complex WHERE condition on rtree results in "database table is locked" error
|
| b383b90278 |
2019-12-24 01:53:36
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2)
|
| 5eadca17c4 |
2019-12-23 20:42:05
|
Code_Defect
|
Fixed
|
Extensions
|
Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed
|
| bf1aab8978 |
2019-12-23 15:24:30
|
Code_Defect
|
Closed
|
Unknown
|
FTS merge does not terminate
|
| dfd66334cf |
2019-12-23 15:17:35
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed
|
| 3ab4a9f02c |
2019-12-23 14:36:55
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed
|
| d9ed4ebef1 |
2019-12-23 14:21:06
|
Code_Defect
|
Closed
|
Unknown
|
SELECT on window function causes a segfault
|
| 0911b5d161 |
2019-12-23 03:38:01
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed
|
| 9d708e4742 |
2019-12-23 02:50:50
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2)
|
| 5ad2aa6921 |
2019-12-23 02:33:16
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed
|
| c62c5e5852 |
2019-12-23 02:30:51
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed (2)
|
| 188f912b51 |
2019-12-22 23:48:45
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed
|
| 7929c1efb2 |
2019-12-22 20:03:44
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJoinTable!=pSrc->iCursor || pLoop->prereq!=0' failed
|
| b0cb8aff56 |
2019-12-22 18:55:38
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed
|
| 1b06916e01 |
2019-12-22 18:23:47
|
Code_Defect
|
Fixed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed
|
| f00d096cae |
2019-12-22 17:32:39
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed
|
| 9cb7d0ef44 |
2019-12-22 14:30:38
|
Code_Defect
|
Closed
|
Unknown
|
Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed
|
| cd3311e323 |
2019-12-21 20:43:50
|
Code_Defect
|
Closed
|
Unknown
|
FTS database disk image is malformed for update on languageid
|
| e0a8120553 |
2019-12-20 22:47:02
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect result for BETWEEN and generated column
|
| e431c35542 |
2019-12-20 19:41:31
|
Code_Defect
|
Closed
|
Unknown
|
FTS database disk image is malformed for UTF-16 encoding
|
| cf36cb4e02 |
2019-12-20 13:24:42
|
Code_Defect
|
Closed
|
Unknown
|
FTS database disk image is malformed for UTF-16 encoding after update
|
| 3b84b42943 |
2019-12-16 16:52:49
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN malfunctions with generated column
|
| b439bfcfb7 |
2019-12-14 17:44:36
|
Code_Defect
|
Fixed
|
Unknown
|
REINDEX segfaults on table with generated columns
|
| d7c3f125c9 |
2019-12-10 02:48:59
|
Code_Defect
|
Fixed
|
Unknown
|
REINDEX results in "UNIQUE constraint failed" for generated column
|
| bd8c280671 |
2019-12-09 15:52:20
|
Code_Defect
|
Fixed
|
Unknown
|
PRAGMA integrity_check does not terminate on table with generated column
|
| b92e5e8ec2 |
2019-12-08 00:06:54
|
Code_Defect
|
Fixed
|
Unknown
|
Query on table without rows and generated column results in "out of memory" error
|
| 8bf76328ac |
2019-12-07 12:15:01
|
Documentation
|
Fixed
|
Unknown
|
NOT NULL auxiliary column in rtree table malfunctions
|
| 367a86e288 |
2019-12-06 13:12:17
|
Feature_Request
|
Fixed
|
Unknown
|
Incorrect result for predicate on rtree table
|
| aa573a787b |
2019-12-06 01:38:39
|
Feature_Request
|
Fixed
|
Unknown
|
Comparison on INT column in rtree table malfunctions
|
| f096d191b6 |
2019-12-05 21:46:34
|
Code_Defect
|
Fixed
|
Unknown
|
Row value comparison malfunctions with rtree table
|
| 9fe487ba3c |
2019-12-05 14:42:46
|
Code_Defect
|
Fixed
|
Unknown
|
Join on two rtree tables malfunctions
|
| 30e2c183b6 |
2019-12-05 13:35:06
|
Code_Defect
|
Fixed
|
Unknown
|
column = NULL predicate evaluates to TRUE for rtree table
|
| a55ab6d97d |
2019-12-05 00:45:14
|
Code_Defect
|
Fixed
|
Extensions
|
Incorrect result for TEXT comparison on rtree table
|
| 7f39060a24 |
2019-11-30 19:29:44
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN malfunctions with partial ISNULL index
|
| 8fe768e9c9 |
2019-11-18 12:28:47
|
Code_Defect
|
Closed
|
Unknown
|
FTS integrity-check malfunctions
|
| 2ae0c599b7 |
2019-11-15 00:52:25
|
Code_Defect
|
Fixed
|
Unknown
|
Table-valued functions do not work as the right table of a LEFT JOIN
|
| 7e59041f9c |
2019-11-08 20:28:42
|
Code_Defect
|
Fixed
|
Unknown
|
DISTINCT malfunctions for VIEW with virtual table
|
| 302027baf1 |
2019-11-07 14:51:45
|
Code_Defect
|
Fixed
|
Unknown
|
VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column
|
| 299b50ba81 |
2019-11-07 02:33:14
|
Code_Defect
|
Fixed
|
Unknown
|
UPDATE on table with two generated columns and CHECK clause results in segfault
|
| 4fc08501f4 |
2019-11-06 22:20:33
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault when inserting into table with generated columns
|
| ce22a07731 |
2019-11-06 17:31:43
|
Code_Defect
|
Fixed
|
Unknown
|
NULL WHERE condition unexpectedly results in row being fetched
|
| 2399f59861 |
2019-11-06 14:50:01
|
Code_Defect
|
Fixed
|
Unknown
|
REPLACE on table with generated NOT NULL column results in segfault
|
| 1cda8f4b54 |
2019-11-05 13:04:18
|
Code_Defect
|
Closed
|
Unknown
|
UNLIKELY in query causes row to not be fetched
|
| 02aa2bd02f |
2019-11-04 02:06:14
|
Code_Defect
|
Fixed
|
Unknown
|
Row value comparison malfunctions on view with left join
|
| 623eff57e7 |
2019-11-03 00:07:56
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN in view malfunctions with partial index on table
|
| a9efb42811 |
2019-11-02 13:33:10
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result for GLOB operator
|
| c28a01da72 |
2019-11-01 15:19:51
|
Code_Defect
|
Fixed
|
Unknown
|
REPLACE causes segfault in table with generated column and foreign key
|
| b9befa4b83 |
2019-10-31 20:58:06
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in table with generated column and foreign key
|
| 1d2a8efc6c |
2019-10-31 13:16:40
|
Code_Defect
|
Fixed
|
Unknown
|
VACUUM on table with generated column that uses TYPEOF results in an error
|
| 6484e6ce67 |
2019-10-29 16:19:00
|
Code_Defect
|
Fixed
|
Unknown
|
VACUUM on table with generated column results in an error
|
| 166347c6fc |
2019-10-29 03:39:31
|
Code_Defect
|
Fixed
|
Unknown
|
VACUUM issue on table with generated column
|
| 9621dd78a0 |
2019-10-29 03:30:39
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault when updating table with generated columns
|
| 91e8695101 |
2019-10-27 22:22:42
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault in table with generated columns
|
| 3ea1755124 |
2019-10-26 23:52:24
|
Code_Defect
|
Fixed
|
Unknown
|
REINDEX causes "UNIQUE constraint failed" error for generated column
|
| c1e19e1204 |
2019-10-26 16:39:11
|
Code_Defect
|
Fixed
|
Unknown
|
Trigger causes query to compute incorrect result
|
| dd1f67bf25 |
2019-10-24 20:36:11
|
Code_Defect
|
Closed
|
Unknown
|
FTS integrity-check malfunctions nondeterministically with tokenize="ascii"
|
| 50c09fc2cf |
2019-10-24 19:37:01
|
Code_Defect
|
Fixed
|
Unknown
|
Crash on REPLACE INTO of a table with an AFTER DELETE trigger.
|
| 135c9da751 |
2019-10-23 18:09:50
|
Code_Defect
|
Fixed
|
Unknown
|
Comparison of row values with COLLATE NOCASE yields incorrect result
|
| 6ef984af89 |
2019-10-22 19:51:41
|
Code_Defect
|
Fixed
|
Unknown
|
Row value comparison yields incorrect result
|
| b47e3627ec |
2019-10-22 10:43:16
|
Code_Defect
|
Fixed
|
Unknown
|
Comparison of row values results in incorrect result
|
| 7fc8e5ff25 |
2019-10-21 13:35:17
|
Code_Defect
|
Closed
|
Unknown
|
INSERT into table with two triggers does not terminate
|
| a8a4847a2d |
2019-10-16 14:56:24
|
Code_Defect
|
Fixed
|
Unknown
|
Trigger inserts duplicate value in UNIQUE column
|
| 278ac14262 |
2019-10-11 17:26:14
|
Code_Defect
|
Fixed
|
Unknown
|
FTS integrity_check fails when inserting x'00'
|
| 745f1abcdc |
2019-10-11 15:33:29
|
Code_Defect
|
Closed
|
Unknown
|
FTS integrity-check malfunctions for transaction and the prefix option
|
| 8a6fa2bb22 |
2019-10-11 14:28:21
|
Code_Defect
|
Closed
|
Unknown
|
FTS order=DESC results into integrity-check failing
|
| c31034044b |
2019-10-10 17:10:18
|
Code_Defect
|
Closed
|
Unknown
|
LEFT JOIN in view malfunctions with NOTNULL
|
| 1079ad1999 |
2019-10-10 15:17:23
|
Code_Defect
|
Closed
|
Unknown
|
Crash in query with FILTER clause on normal aggregate that refers to a column of a subquery
|
| a976c487d1 |
2019-10-10 13:56:00
|
Code_Defect
|
Closed
|
Unknown
|
LEFT JOIN in view malfunctions
|
| d392017c8e |
2019-10-09 18:36:50
|
Code_Defect
|
Closed
|
Unknown
|
FTS rebuild in combination with crisismerge results in error "database or disk is full"
|
| 81a7f7b9e2 |
2019-10-09 15:27:54
|
Code_Defect
|
Closed
|
Unknown
|
FTS integrity-check indicates that the database disk image is malformed
|
| e258f008ce |
2019-10-08 13:35:03
|
Code_Defect
|
Closed
|
Unknown
|
FTS rebuild in transaction causes integrity-check to fail
|
| 265e935b26 |
2019-10-07 20:36:33
|
Code_Defect
|
Closed
|
Unknown
|
FTS pgsz option results in "database disk image is malformed" error
|
| b2d4edaffd |
2019-10-07 01:07:56
|
Code_Defect
|
Fixed
|
Unknown
|
Comparison on view malfunctions
|
| 99cd4807dc |
2019-09-23 11:55:45
|
Code_Defect
|
Fixed
|
Unknown
|
Scalar subquery with "LIMIT 0" should return NULL
|
| 587791f926 |
2019-09-17 13:30:42
|
Code_Defect
|
Fixed
|
Unknown
|
Row is not fetched when using WHERE clause with INSTR()
|
| 0f0428096f |
2019-09-16 18:20:06
|
Code_Defect
|
Fixed
|
Unknown
|
GLOB unexpectedly does not match
|
| 18458b1ad6 |
2019-09-11 11:30:28
|
Code_Defect
|
Closed
|
Unknown
|
COLLATE issue in view
|
| c4130c33be |
2019-09-10 19:46:38
|
Code_Defect
|
Closed
|
Unknown
|
DISTINCT malfunctions for VIEW
|
| a7debbe0ad |
2019-09-09 20:18:05
|
Code_Defect
|
Closed
|
Unknown
|
BETWEEN issue in view
|
| 767a8cbc6d |
2019-09-03 14:27:40
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE NOCASE string comparison yields incorrect result
|
| 29f635e0af |
2019-09-03 13:35:00
|
Code_Defect
|
Fixed
|
Unknown
|
IS NULL unexpectedly evaluates to TRUE
|
| 2841e99d10 |
2019-09-02 02:22:07
|
Code_Defect
|
Fixed
|
Unknown
|
Different rounding when converting TEXT to REAL
|
| 57af00b664 |
2019-09-02 00:58:56
|
Code_Defect
|
Fixed
|
Unknown
|
Expression computed on row yields incorrect result
|
| d6a0fbc14e |
2019-08-31 17:15:18
|
Code_Defect
|
Closed
|
Unknown
|
REINDEX causes "UNIQUE constraint failed" error when using TRIGGER
|
| 40812aea1f |
2019-08-30 23:56:45
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result for comparison of large number
|
| 5a3dba8104 |
2019-08-30 23:15:18
|
Code_Defect
|
Fixed
|
Unknown
|
REINDEX causes "UNIQUE constraint failed" error
|
| f8f472cbc7 |
2019-08-30 16:01:12
|
Code_Defect
|
Fixed
|
Unknown
|
Partial index and BETWEEN issue
|
| fba33c8b1d |
2019-08-30 15:11:19
|
Code_Defect
|
Fixed
|
Unknown
|
Partial index causes row to not be fetched in BETWEEN expression
|
| a6408d42b9 |
2019-08-30 13:07:27
|
Code_Defect
|
Fixed
|
Unknown
|
Partial index causes row to not be fetched
|
| c03903637b |
2019-08-29 15:07:20
|
Code_Defect
|
Closed
|
Unknown
|
Indexes causes row to not be fetched
|
| 51f5b6e427 |
2019-08-29 12:54:37
|
Feature_Request
|
Closed
|
Unknown
|
Short-circuit evaluation issue
|
| f8a7060ece |
2019-08-27 20:00:48
|
Code_Defect
|
Closed
|
Unknown
|
Incorrect result for query that uses MIN() and a CAST on rowid
|
| dbaf8a6820 |
2019-08-27 17:01:25
|
Code_Defect
|
Fixed
|
Unknown
|
Unexpected affinity conversion is performed for the IN operator
|
| ac8dd4a32b |
2019-08-27 10:09:08
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault when dropping a temp trigger on a database that has already been detached
|
| 78acc9d40f |
2019-08-26 14:19:30
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault in row-value UPDATE
|
| 7e07a3dbf5 |
2019-08-22 16:39:06
|
Code_Defect
|
Fixed
|
Unknown
|
LIKELY() seems to cause unexpected affinity conversion for rowid
|
| ac184eb571 |
2019-08-22 11:14:02
|
Code_Defect
|
Fixed
|
Unknown
|
Row with comparison on TEXT UNIQUE column is not fetched
|
| d9f584e936 |
2019-08-22 00:55:07
|
Code_Defect
|
Fixed
|
Unknown
|
Row is not fetched in table with INTEGER PRIMARY KEY
|
| b86894020e |
2019-08-21 14:55:33
|
Code_Defect
|
Closed
|
Unknown
|
DISTINCT malfunctions for IS NULL
|
| f043b1130b |
2019-08-20 11:45:21
|
Code_Defect
|
Closed
|
Unknown
|
INDEXED BY results in row not being fetched
|
| c7a1171907 |
2019-08-17 19:14:57
|
Code_Defect
|
Closed
|
Unknown
|
WHERE clause erroneously influences value of fetched column from view
|
| 6710d2f7a1 |
2019-08-17 17:11:14
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN fails to fetch row
|
| 256741a16b |
2019-08-15 14:36:11
|
Code_Defect
|
Fixed
|
Unknown
|
null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)
|
| e4598ecbdd |
2019-08-15 14:35:55
|
Code_Defect
|
Fixed
|
Unknown
|
Division by zero in the query planner.
|
| 17db54d744 |
2019-08-14 19:55:58
|
Code_Defect
|
Closed
|
Unknown
|
Unexpected error in DELETE with existing trigger
|
| 3cf9bb227e |
2019-08-12 18:26:57
|
Code_Defect
|
Fixed
|
Unknown
|
Database corruption caused by REPLACE
|
| 9080b6227f |
2019-08-10 15:06:29
|
Code_Defect
|
Fixed
|
Unknown
|
Constant expression in partial index results in row not being fetched
|
| 0a5e2c1dcb |
2019-08-06 23:28:25
|
Code_Defect
|
Fixed
|
Unknown
|
Unexpected affinity conversion for view column in IN operator
|
| 9f66f887d4 |
2019-08-06 17:05:23
|
Documentation
|
Fixed
|
Unknown
|
EXPLAIN PRAGMA executes PRAGMA
|
| 61c853857f |
2019-08-06 15:33:12
|
Code_Defect
|
Fixed
|
Unknown
|
Row is not fetched in SELECT from VIEW
|
| d52a29a9e6 |
2019-08-05 20:41:11
|
Code_Defect
|
Fixed
|
Unknown
|
Unexpected affinity conversion in view
|
| 71e183cab6 |
2019-08-03 16:51:24
|
Code_Defect
|
Closed
|
Unknown
|
MIN() malfunctions for a query with ISNULL condition
|
| 41866dc373 |
2019-08-02 19:40:53
|
Code_Defect
|
Closed
|
Unknown
|
MIN() malfunctions for UNIQUE column
|
| ced41c7c7d |
2019-07-30 01:17:23
|
Code_Defect
|
Fixed
|
Unknown
|
Query with DISTINCT does not fetch all distinct rows
|
| ccbe5759fb |
2019-07-29 15:54:51
|
Code_Defect
|
Closed
|
Unknown
|
ANALYZE causes DISTINCT to malfunction in CROSS JOIN
|
| ba2f4585cf |
2019-07-29 06:07:05
|
Code_Defect
|
Fixed
|
Unknown
|
Query with ORDER BY results in "database disk image is malformed" error
|
| 18ab5da2c0 |
2019-07-29 06:05:34
|
Not_A_Bug
|
Closed
|
Unknown
|
Issue with DISTINCT and COLLATE
|
| c52b09c7f3 |
2019-07-24 23:15:31
|
Performance_Issue
|
Fixed
|
Unknown
|
Assertion fault in the query planner on a deeply nested query
|
| 1be72aab92 |
2019-07-17 15:47:38
|
Code_Defect
|
Fixed
|
Unknown
|
CHECK constraint using COLLATE with CASE or BETWEEN
|
| fd3aec0c7e |
2019-07-17 13:10:33
|
Code_Defect
|
Fixed
|
Unknown
|
Valgrind warning if PK has more columns than the table.
|
| 9ece23d2ca |
2019-07-08 12:03:27
|
Code_Defect
|
Closed
|
Unknown
|
Default collation sequences and affinities lost when window function added to query
|
| 9cdc5c4662 |
2019-06-27 02:23:49
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from second execution of correlated scalar sub-query that uses a partial sort
|
| e1e07ef202 |
2019-06-16 14:57:07
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE in BETWEEN expression is ignored
|
| f1580ba1b5 |
2019-06-14 13:25:25
|
Code_Defect
|
Fixed
|
Unknown
|
Built-in RTRIM collating sequence yields incorrect comparisons
|
| ce8717f088 |
2019-06-14 12:29:07
|
Code_Defect
|
Fixed
|
Unknown
|
LIKE malfunctions for UNIQUE COLLATE NOCASE column
|
| 674385aeba |
2019-06-12 20:53:50
|
Code_Defect
|
Fixed
|
Unknown
|
CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0
|
| b148fa6105 |
2019-06-12 20:32:42
|
Documentation
|
Fixed
|
Unknown
|
CAST takes implicit COLLATE of its operand
|
| 4d01eda811 |
2019-06-12 13:50:44
|
Code_Defect
|
Closed
|
Unknown
|
IS TRUE operator malfunctions with COLLATE and REAL value
|
| 0c620df60b |
2019-06-11 21:02:25
|
Code_Defect
|
Fixed
|
Unknown
|
LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities
|
| 57353f8243 |
2019-06-11 18:08:06
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE expression in the right side of an IN operator results in an affinity conversion
|
| afdc5a29dc |
2019-06-11 16:02:57
|
Documentation
|
Closed
|
Unknown
|
Lossless conversion when casting a large TEXT number to NUMERIC is not performed
|
| 1819598c09 |
2019-06-11 13:43:09
|
Documentation
|
Fixed
|
Unknown
|
-'1.0' computes -1.0 rather than -1
|
| d60b3cd7cb |
2019-06-11 03:00:24
|
Documentation
|
Fixed
|
Unknown
|
COLLATE expression has an affinity
|
| 533010b8ca |
2019-06-11 02:43:44
|
Code_Defect
|
Fixed
|
Unknown
|
Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()"
|
| 412bba9b22 |
2019-06-10 23:45:20
|
Code_Defect
|
Fixed
|
Unknown
|
CAST('.' AS NUMERIC) computes 0.0 rather than 0
|
| 5e0423b058 |
2019-06-10 19:07:23
|
Documentation
|
Fixed
|
VFS
|
xAccess behaviour is not documented, changed in Windows 3.7.0
|
| 31c6e64ff9 |
2019-06-10 18:51:37
|
Code_Defect
|
Closed
|
Unknown
|
ALTER TABLE fails if a trigger references a non-existant table.
|
| dd6bffbfb6 |
2019-06-10 18:33:24
|
Code_Defect
|
Fixed
|
Unknown
|
CAST to NUMERIC no longer converts to INTEGER
|
| fd76310a5e |
2019-06-10 15:35:32
|
Code_Defect
|
Closed
|
Code_Generator
|
TEXT value interpreted as column name in an index with empty list in an IN expression
|
| b1d8c79314 |
2019-06-10 13:52:52
|
Code_Defect
|
Fixed
|
Code_Generator
|
LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column
|
| 4c2d7639f0 |
2019-06-07 22:26:55
|
Code_Defect
|
Fixed
|
Unknown
|
CAST('-' AS NUMERIC) computes 0.0
|
| e8bedb2a18 |
2019-06-07 22:26:40
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when subtracting a large integer number from a TEXT value
|
| c41afac34f |
2019-05-29 17:22:56
|
Code_Defect
|
Fixed
|
Unknown
|
LIMIT applied globally rather than locally
|
| ce82323194 |
2019-05-22 22:49:50
|
Code_Defect
|
Fixed
|
Unknown
|
Duplicate CTE name gives incorrect result
|
| b5ca442af9 |
2019-05-21 14:46:52
|
Code_Defect
|
Closed
|
Unknown
|
"Malformed database schema" when creating a failing index within a transaction
|
| 9b78184be2 |
2019-05-20 17:15:29
|
Code_Defect
|
Closed
|
Unknown
|
Index on non-existing column results in a fabricated value being fetched
|
| d3e7f2ba5b |
2019-05-20 12:35:18
|
Code_Defect
|
Fixed
|
Unknown
|
Nested boolean formula with IN operator computes an incorrect result
|
| 787fa716be |
2019-05-19 17:01:13
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault when multi-use subquery implemented by co-routine
|
| f4ec250930 |
2019-05-17 20:40:46
|
Code_Defect
|
Closed
|
Code_Generator
|
Malformed image when using no journal mode, zero cache size, and failing when creating an index.
|
| 3c27b97e31 |
2019-05-17 20:07:57
|
Code_Defect
|
Fixed
|
Unknown
|
REAL rounding seems to depend on FROM clause
|
| bba7b69f98 |
2019-05-14 00:43:27
|
Code_Defect
|
Fixed
|
Unknown
|
REINDEX on WITHOUT ROWID table with DESC PRIMARY KEY corrupts automatic UNIQUE index
|
| 8025674847 |
2019-05-11 13:05:10
|
Code_Defect
|
Closed
|
Unknown
|
Incorrect use of "WHERE x NOT NULL" index for query with a "WHERE x IS NOT ?" term
|
| 6c1d3febc0 |
2019-05-09 17:10:40
|
Code_Defect
|
Fixed
|
Unknown
|
REAL PRIMARY KEY leads to a missing entry in the index.
|
| a340eef47b |
2019-05-08 17:29:15
|
Code_Defect
|
Closed
|
Unknown
|
PRAGMA case_sensitive_like can corrupt some databases.
|
| 9cf6c9bb51 |
2019-05-08 14:03:50
|
Code_Defect
|
Closed
|
Unknown
|
"<" or "<=" comparison of rowid and non-numeric text value sometimes gets the wrong answer.
|
| e63cbcfd33 |
2019-05-07 20:06:59
|
Code_Defect
|
Fixed
|
Unknown
|
Database table/index contents mismatch (corruption) caused by FK processing
|
| 5c6955204c |
2019-05-04 17:34:15
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect result on a table scan of a partial index
|
| ae0f637bdd |
2019-05-01 19:01:39
|
Code_Defect
|
Fixed
|
Unknown
|
REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column
|
| 3be1295b26 |
2019-05-01 15:32:51
|
Code_Defect
|
Fixed
|
Unknown
|
Inconsistent behavior of a unique constraint on a boolean expression.
|
| 3182d38790 |
2019-04-29 13:50:29
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE nocase index on a WITHOUT ROWID table malfunctions
|
| f00d7b651a |
2019-04-19 18:23:36
|
Code_Defect
|
Fixed
|
Unknown
|
ALTER TABLE corrupts the schema for tables that start with "sqlite"
|
| 596d059af7 |
2019-03-15 16:28:24
|
Code_Defect
|
Closed
|
Code_Generator
|
Committing a transaction with a failed ALTER TABLE may subtly corrupt schema
|
| df46dfb631 |
2019-02-23 00:21:35
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault in self-join with a IN constraint
|
| 4feb3159c6 |
2019-02-22 21:35:59
|
Code_Defect
|
Fixed
|
Unknown
|
Crash due to misuse of window functions.
|
| 4e8e4857d3 |
2019-02-08 04:20:21
|
Code_Defect
|
Fixed
|
Unknown
|
Crash on query using an OR term in the WHERE clause
|
| 5948e09b8c |
2019-02-05 14:36:43
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from LEFT JOIN
|
| bb4bdb9f7f |
2019-01-25 20:09:23
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Zeroblob truncated by an index on an expression
|
| bc8d94f0fb |
2019-01-09 02:04:12
|
Code_Defect
|
Fixed
|
Unknown
|
RENAME COLUMN fails on tables with redundant UNIQUE constraints
|
| d0866b26f8 |
2019-01-01 18:03:21
|
Code_Defect
|
Fixed
|
Unknown
|
Window function in correlated subquery causes assertion fault
|
| 43ddc85a63 |
2018-12-26 15:17:23
|
Code_Defect
|
Closed
|
Unknown
|
ALTER TABLE fails when there is an INSTEAD-OF trigger on a VIEW
|
| e6f1f2e34d |
2018-12-22 01:13:33
|
Code_Defect
|
Fixed
|
Unknown
|
REPLACE can insert a default NULL into a NOT NULL column
|
| 50d2a6c292 |
2018-12-20 17:33:10
|
Code_Defect
|
Closed
|
Unknown
|
Foreign key malfunction when parent and child are the same WITHOUT ROWID table and parent key is not also PRIMARY KEY
|
| d96eba8769 |
2018-12-14 11:17:01
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect results for OR query where both OR terms are different indexed expressions
|
| 1d958d9059 |
2018-12-08 20:30:39
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result with NOT IN operator and partial index
|
| f09fcd1781 |
2018-12-07 01:56:46
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault when window functions are used.
|
| 1a84668dcf |
2018-11-05 13:42:03
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault due to malformed PRIMARY KEY
|
| 65eb38f6e4 |
2018-11-05 08:09:34
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect answer on LEFT JOIN when STAT4 is enabled
|
| cf5ed20fc8 |
2018-10-25 15:17:51
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect join result with duplicate WHERE clause constraint
|
| 69d642332d |
2018-09-27 20:20:10
|
Code_Defect
|
Fixed
|
Unknown
|
The typeof() and length() functions fail in some virtual tables.
|
| e8275b415a |
2018-09-27 13:02:41
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault from window function inside of recursive CTE
|
| f25d5ceebe |
2018-09-24 14:11:02
|
Code_Defect
|
Fixed
|
Unknown
|
INTEGER PRIMARY KEY WITHOUT ROWID virtual table crash
|
| 510cde2777 |
2018-09-17 15:30:05
|
Code_Defect
|
Fixed
|
Unknown
|
Endless loop on a query with window functions, ORDER BY, and LIMIT
|
| b41031ea2b |
2018-09-17 15:29:43
|
Code_Defect
|
Fixed
|
Unknown
|
ALTER TABLE returns an error on certain schemas
|
| 9936b2fa44 |
2018-09-10 14:49:04
|
Code_Defect
|
Fixed
|
Unknown
|
Infinite loop due to the ORDER BY LIMIT optimization
|
| c94369cae9 |
2018-09-10 12:41:21
|
Code_Defect
|
Fixed
|
Unknown
|
Wrong answer due to the LIKE optimization
|
| 908f001483 |
2018-08-14 15:13:06
|
Code_Defect
|
Fixed
|
Unknown
|
UPSERT does not work like PostgreSQL
|
| c694113e50 |
2018-07-24 22:02:30
|
Code_Defect
|
Fixed
|
Unknown
|
Unnecessary ABORT with unhelpful error message
|
| 79cad5e4b2 |
2018-07-11 13:37:14
|
Code_Defect
|
Fixed
|
Unknown
|
UPSERT results in a corrupt database
|
| c2432ef908 |
2018-06-11 18:07:17
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault due to column cache malfunction
|
| 7be932dfa6 |
2018-06-07 15:23:52
|
Code_Defect
|
Fixed
|
Unknown
|
Adverse interaction between .stats and .eqp in the CLI
|
| d8dc2b3a58 |
2018-05-23 17:53:50
|
Code_Defect
|
Fixed
|
Unknown
|
Crash when the schema for sqlite_sequence is corrupt
|
| e63a34a004 |
2018-05-08 23:20:44
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrectly formatted output for the ".fullschema" command in the CLI
|
| d85fffd6ff |
2018-04-26 15:50:20
|
Code_Defect
|
Fixed
|
Unknown
|
VDBE program uses an expired value
|
| 4ba5abf65c |
2018-04-24 17:34:13
|
Code_Defect
|
Fixed
|
Unknown
|
Index on expression leads to an incorrect LEFT JOIN
|
| 7fa8049685 |
2018-04-24 14:42:54
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result on a LEFT JOIN when using an index
|
| 1e39b966ae |
2018-04-10 12:20:56
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN strength reduction optimization causes an error.
|
| fac496b617 |
2018-04-10 12:20:16
|
Code_Defect
|
Fixed
|
Code_Generator
|
Over-aggressive LEFT JOIN optimization on virtual tables
|
| 2b8aed9f7c |
2018-04-09 15:58:07
|
Code_Defect
|
Fixed
|
Unknown
|
Misbehavior in the FTS5 xBestIndex method
|
| 093420fc0e |
2018-04-06 12:55:10
|
Code_Defect
|
Fixed
|
Unknown
|
Virtual Machine references an uninitialized register
|
| 36fae083b4 |
2018-02-26 15:28:06
|
Code_Defect
|
Fixed
|
Unknown
|
Inconsistent interpretation of truth
|
| f484b65f3d |
2018-02-13 19:16:00
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from row-value comparison in WHERE clause
|
| d6ec09eccf |
2018-02-13 16:35:22
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault in FTS4
|
| 343634942d |
2018-02-01 16:17:02
|
Code_Defect
|
Fixed
|
Unknown
|
Index on expression goes corrupt from valid SQL
|
| ec32177c99 |
2018-01-27 13:56:20
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result with complex OR-connected WHERE and STAT4
|
| 80177f0c22 |
2018-01-26 23:48:05
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when join condition uses a table-valued function
|
| 7310e2fb3d |
2018-01-23 18:00:58
|
Code_Defect
|
Fixed
|
Unknown
|
Valid row-value syntax is rejected
|
| 47b2581aa9 |
2018-01-16 13:50:15
|
Code_Defect
|
Fixed
|
Unknown
|
Infinite loop on UPDATE
|
| dc3f932f5a |
2018-01-02 18:11:20
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault doing a REPLACE with index on an expression.
|
| 3b44500725 |
2017-12-23 12:34:35
|
Code_Defect
|
Fixed
|
Unknown
|
Inconsistent column names
|
| 123c9ba321 |
2017-12-13 18:02:03
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when an index is used for an ordered join
|
| d4beea1633 |
2017-11-26 00:49:13
|
Code_Defect
|
Fixed
|
Unknown
|
DELETE with a LIMIT does not work for WITHOUT ROWID tables
|
| ef9318757b |
2017-11-23 00:48:00
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result due to the skip-ahead-distinct optimization
|
| aa98619ad0 |
2017-11-06 12:04:01
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on an IN operator using a constant index
|
| e651b13418 |
2017-10-10 13:37:36
|
Code_Defect
|
Fixed
|
Unknown
|
DROP TABLE fails for WITHOUT ROWID tables an SQLITE_OMIT_AUTOVACUUM
|
| cfa2c908f2 |
2017-09-11 23:55:47
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault in STAT4 on a double-negation
|
| b899b6042f |
2017-09-11 23:47:15
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on correlated subquery on the RHS of an IN operator in the WHERE clause
|
| 02f0f4c54f |
2017-08-28 11:13:08
|
Code_Defect
|
Fixed
|
Unknown
|
The ".dump" comman crashes following PRAGMA empty_result_callbacks=1
|
| 88af8923dc |
2017-08-24 14:25:41
|
Code_Defect
|
Closed
|
Unknown
|
|
| 7486aa54b9 |
2017-08-24 13:55:58
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault caused by sqlite3_result_pointer()
|
| e20dd54ab0 |
2017-08-18 13:25:46
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression
|
| be436a7f45 |
2017-08-17 14:48:10
|
Code_Defect
|
Fixed
|
Unknown
|
Use-after-free on schema change where RTREE is used inside of a trigger
|
| 8897054d95 |
2017-08-14 14:44:53
|
Code_Defect
|
Closed
|
Extensions
|
lsm1 does not overwrite values for duplicate keys
|
| cb91bf4290 |
2017-08-01 19:53:54
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault following PRAGMA reverse_unordered_selects=ON
|
| de3403bf5a |
2017-07-31 16:42:56
|
Code_Defect
|
Fixed
|
Unknown
|
Column name shift due to LEFT JOIN query flattening
|
| bc11554113 |
2017-07-31 11:26:16
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on a dodgy CREATE TABLE statement using WITHOUT ROWID
|
| ce68383bf6 |
2017-07-21 19:33:16
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect LEFT JOIN result with IS operator in WHERE clause and auto-index
|
| a4e06e75a9 |
2017-07-15 20:38:08
|
Code_Defect
|
Fixed
|
Unknown
|
False-positive from "PRAGMA integrity_check"
|
| b9f0101077 |
2017-06-27 23:36:53
|
Code_Defect
|
Fixed
|
Unknown
|
Violation of the Query Planner Stability Guarantee
|
| 892fc34f17 |
2017-06-20 18:13:44
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect query result when a LEFT JOIN subquery is flattened
|
| fda2210880 |
2017-06-08 13:10:05
|
Code_Defect
|
Fixed
|
Unknown
|
Corruption due to REPLACE in an auto-vacuumed database
|
| 7fde638e94 |
2017-05-25 16:28:42
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on a LEFT JOIN
|
| cad1ab4cb7 |
2017-05-23 19:16:33
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault due to LEFT JOIN flattening optimization
|
| f68dc596c4 |
2017-05-01 18:35:39
|
Code_Defect
|
Fixed
|
Unknown
|
Database corruption on REPLACE with a mix of NULL and non-NULL rowids.
|
| 61fe97454c |
2017-04-24 14:57:43
|
Code_Defect
|
Closed
|
Unknown
|
Duplicate result using an IN operator in the WHERE clause
|
| 981329adee |
2017-04-11 18:55:12
|
Code_Defect
|
Fixed
|
Unknown
|
Stack overflow while parsing deeply nested JSON
|
| 6c9b551407 |
2017-04-10 12:25:16
|
Code_Defect
|
Fixed
|
Unknown
|
JSON allows unescaped control characters in strings
|
| b93be8729a |
2017-04-08 18:18:32
|
Code_Defect
|
Fixed
|
Unknown
|
JSON extension accepts invalid numeric values
|
| 06796225f5 |
2017-03-24 19:14:17
|
Code_Defect
|
Fixed
|
Unknown
|
Crash in recursive invocation of a trigger that uses an ephemeral table
|
| 6097cb9274 |
2017-03-02 23:41:15
|
Code_Defect
|
Fixed
|
Unknown
|
Broken 'start of day' modifier on date/time functions
|
| eb703ba7b5 |
2017-02-11 14:58:42
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result using index on expression with collating function
|
| e6e962d6b0 |
2017-01-25 19:04:30
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3_blob_reopen() misbehavior on ALTER-ed table
|
| 7ffd1ca1d2 |
2017-01-16 18:10:28
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect affinity when using automatic indexes
|
| 25e335f802 |
2017-01-10 17:46:18
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when ON clause refers to table to the right
|
| 190c2507ee |
2017-01-05 17:38:31
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on a query against a view
|
| 30027b613b |
2017-01-05 14:23:37
|
Code_Defect
|
Fixed
|
Unknown
|
DELETE trigger on WITHOUT ROWID table not fired for REPLACE op
|
| 8c9458e703 |
2017-01-03 13:37:02
|
Code_Defect
|
Fixed
|
Unknown
|
row-value updates in triggers do not work.
|
| 2df0107bd2 |
2016-12-01 23:37:24
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from LEFT JOIN with a subquery on the LHS
|
| 1a68465637 |
2016-11-24 00:00:11
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on a conditional row-value expression
|
| da78413751 |
2016-11-23 23:59:54
|
Code_Defect
|
Fixed
|
Unknown
|
Query flattening causes bad byte-code for a vector IN operator
|
| 199df4168c |
2016-11-23 23:49:14
|
Code_Defect
|
Fixed
|
Unknown
|
Different answer with and without index on IN operator with type mismatch
|
| 2f1b168ab4 |
2016-11-11 03:40:01
|
Code_Defect
|
Fixed
|
Unknown
|
Crash following syntax error on DETACH
|
| fef4bb4bd9 |
2016-10-27 01:08:32
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from a LEFT JOIN with a row-value constraint
|
| 34a579141b |
2016-10-26 16:05:55
|
Code_Defect
|
Closed
|
Unknown
|
Incorrect results with OR terms in the ON clause of a LEFT JOIN
|
| 96c1454cbf |
2016-10-12 15:35:04
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result with ORDER BY DESC and LIMIT (again)
|
| 4766f44486 |
2016-10-10 14:38:24
|
Code_Defect
|
Closed
|
Unknown
|
ORDER BY handling with indexes on expressions
|
| 4baa464912 |
2016-10-10 14:18:13
|
Code_Defect
|
Fixed
|
Unknown
|
NULL handling for indexes on expressions
|
| 7b3328086a |
2016-10-03 02:59:42
|
Code_Defect
|
Fixed
|
Unknown
|
AUTOINCREMENT problem with the INSERT xfer optimization
|
| 1ec41379c9 |
2016-09-20 22:04:18
|
Code_Defect
|
Fixed
|
Unknown
|
Integer multiple fails to overflow to floating-point
|
| 0eab1ac759 |
2016-09-16 17:07:43
|
Code_Defect
|
Fixed
|
Unknown
|
O(N*N) behavior where it should be O(N)
|
| 0c4df46116 |
2016-09-07 01:56:06
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result with ORDER BY DESC and LIMIT
|
| ef36060112 |
2016-08-26 12:01:20
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect affinity transformations on DELETE
|
| a0bac8b3c3 |
2016-07-26 04:24:16
|
Code_Defect
|
Fixed
|
Unknown
|
CREATE INDEX changes the answer
|
| f68bf68513 |
2016-07-14 19:13:34
|
Code_Defect
|
Fixed
|
Unknown
|
ALTER TABLE corrupts DESC indexes
|
| e8d439c776 |
2016-07-01 20:12:54
|
Code_Defect
|
Fixed
|
Unknown
|
Crash on transitive WHERE constraint and undefined collation
|
| 16c9801ceb |
2016-05-06 16:49:58
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on DELETE with WHERE containing OR
|
| dc6ebeda93 |
2016-05-02 13:46:58
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect DELETE due to the one-pass optimization
|
| f7f8c97e97 |
2016-04-25 02:20:09
|
Code_Defect
|
Fixed
|
Unknown
|
Valid query fails to compile due to WHERE clause optimization
|
| 7d7525cb01 |
2016-04-18 15:58:37
|
Code_Defect
|
Fixed
|
Unknown
|
Compatibility break on INTEGER PRIMARY KEY columns.
|
| a306e56ff6 |
2016-04-09 17:20:31
|
Code_Defect
|
Fixed
|
Unknown
|
Failed DELETE with PRAGMA reverse_unordered_selects
|
| 7f7f8026ed |
2016-04-07 21:14:43
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault following heavy SAVEPOINT usage
|
| 5e3c886796 |
2016-03-09 15:09:32
|
Code_Defect
|
Fixed
|
Unknown
|
Correlated subquery on the RHS of an IN operator
|
| dc9b1c91db |
2016-02-19 18:55:55
|
Code_Defect
|
Closed
|
Unknown
|
One trigger may use auxdata belonging to another.
|
| d06a25c844 |
2016-02-09 14:12:17
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect result from a UNION with an ORDER BY
|
| ad2559db38 |
2016-02-04 10:28:59
|
Code_Defect
|
Fixed
|
Unknown
|
JSON does not properly escape control characters
|
| f45ac567ea |
2016-01-30 14:54:49
|
Code_Defect
|
Fixed
|
Unknown
|
Invalid JSON generated by json_group_array()
|
| 80369eddd5 |
2016-01-20 14:25:16
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect case folding in the LIKE operator
|
| cb3aa0641d |
2016-01-13 17:50:35
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from a subquery containing over-constrainted ORDER BY
|
| e5c6268dd8 |
2015-11-24 02:10:58
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on DISTINCT query containing a correlated aggregate.
|
| 73eba7ba5c |
2015-11-21 13:24:55
|
Code_Defect
|
Fixed
|
Unknown
|
Table-valued function syntax allowed for ordinary tables and views
|
| 38a97a87a6 |
2015-11-13 17:39:28
|
Code_Defect
|
Fixed
|
Unknown
|
Inaccurate int/float comparison results in corrupt index
|
| ac661962a2 |
2015-11-01 21:19:24
|
Code_Defect
|
Fixed
|
Unknown
|
Differing interpretation of historical schemas
|
| 8a2adec166 |
2015-10-24 20:34:52
|
Code_Defect
|
Closed
|
Unknown
|
Problem creating automatic-indexes on sub-queries in the FROM clause of correlated scalar sub-queries
|
| 57eec374ae |
2015-10-16 15:16:13
|
Code_Defect
|
Fixed
|
Unknown
|
JSON1 accepts form-feed (char(12)) as a white-space character
|
| b65cb2c8d9 |
2015-10-06 17:27:29
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect LIMIT on a UNION ALL query
|
| 1b266395d6 |
2015-09-30 14:06:49
|
Code_Defect
|
Fixed
|
Unknown
|
INSERT OR REPLACE with a foreign key constraint leads to assertion fault
|
| acd1299088 |
2015-09-09 13:28:24
|
Code_Defect
|
Fixed
|
Unknown
|
CREATE TABLE AS fails with a false report of database corruption
|
| c2a19d8165 |
2015-08-22 01:32:45
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect LEFT JOIN when FROM clause contains nested subqueries
|
| 8fd39115d8 |
2015-07-23 16:41:38
|
Code_Defect
|
Fixed
|
Unknown
|
assertion fault on WITHOUT ROWID query using the OR optimization
|
| 5f60b11fc8 |
2015-06-18 14:33:47
|
Code_Defect
|
Fixed
|
Unknown
|
likely() function in the ON clause of a LEFT JOIN results in incorrect result
|
| 873cae2b6e |
2015-06-16 16:39:22
|
Code_Defect
|
Fixed
|
Unknown
|
Schema corruption after aborted CREATE TABLE AS
|
| f2ad7de056 |
2015-05-20 17:36:43
|
Code_Defect
|
Fixed
|
Unknown
|
Corrupt table created by CREATE TABLE AS followed by compound SELECT
|
| 34cd55d68e |
2015-05-19 20:34:43
|
Code_Defect
|
Fixed
|
Unknown
|
Database corruption following INSERT with a TRIGGER that does an affinity change
|
| 7b4fee9f6c |
2015-04-11 11:45:45
|
Code_Defect
|
Closed
|
Unknown
|
Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only
|
| 05f43be8fd |
2015-03-07 13:57:01
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect use of index with LIKE operators when the LHS is a blob
|
| 2326c258d0 |
2015-02-24 20:21:03
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index
|
| 1c69be2daf |
2015-02-17 02:06:36
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect GROUP BY when input and output columns have the same name
|
| ca0d20b6cd |
2015-02-09 18:28:18
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE operator masked by function calls
|
| 2f7170d73b |
2015-02-09 18:28:04
|
Code_Defect
|
Fixed
|
Unknown
|
"misuse of aggregate" error if aggregate column from FROM subquery is used in correlated subquery
|
| 32b63d5424 |
2015-01-22 12:01:34
|
Code_Defect
|
Fixed
|
Unknown
|
Fuzzer induced crash
|
| f97c463710 |
2015-01-20 18:11:18
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect ordering with ORDER BY and LIMIT
|
| a59ae93ee9 |
2015-01-09 01:27:34
|
Code_Defect
|
Fixed
|
Unknown
|
Crashes due to fuzzed input
|
| e4a18565a3 |
2014-12-05 14:44:58
|
Code_Defect
|
Fixed
|
Unknown
|
Stale KeyInfo object used in shared-cache mode
|
| c5ea805691 |
2014-12-04 21:54:50
|
Code_Defect
|
Fixed
|
Unknown
|
Inverted sort order when using DISTINCT and a descending index
|
| 6f2222d550 |
2014-12-04 16:35:32
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect output on a LEFT JOIN
|
| db87229497 |
2014-11-14 18:02:19
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when RHS of IN operator contains DISTINCT and LIMIT
|
| 094d39a4c9 |
2014-11-05 15:57:49
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on CREATE TABLE ... AS SELECT ...
|
| 43107840f1 |
2014-11-05 15:45:09
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on UPDATE
|
| ba7cbfaedc |
2014-10-11 02:12:59
|
Code_Defect
|
Fixed
|
Unknown
|
Wrong output order when a DESC index and GROUP BY and ORDER BY.
|
| 8c32a33a53 |
2014-10-02 21:52:50
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on a syntax error involving the IS operator
|
| e3a290961a |
2014-10-01 12:02:20
|
Code_Defect
|
Closed
|
Unknown
|
out-of-bounds write when using non-default malloc implementation and SQLITE_DIRECT_OVERFLOW_READ
|
| 209d31e316 |
2014-09-29 15:00:26
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault when deleting a table out from under a SELECT
|
| 78c0c8c3c9 |
2014-09-24 13:20:35
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault when a DEFAULT value contains a bind parameter
|
| d11a6e908f |
2014-09-21 22:33:41
|
Code_Defect
|
Fixed
|
Unknown
|
Query planner fault on three-way nested join with compound inner SELECT
|
| 98d973b8f5 |
2014-08-27 17:41:38
|
Code_Defect
|
Fixed
|
Unknown
|
Partial index gives incorrect query result
|
| 369d57fb8e |
2014-08-21 15:57:30
|
Code_Defect
|
Fixed
|
Unknown
|
DELETE with TRIGGER causes an assertion fault
|
| 11d5aa455e |
2014-08-19 20:27:37
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3_trace() sometimes does not invoke its callback
|
| 3a88d85f36 |
2014-08-06 00:29:20
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault when a DEFAULT value contains an aggregate function
|
| 9a6daf340d |
2014-07-30 14:44:37
|
Code_Defect
|
Fixed
|
Unknown
|
UNIQUE not enforced on an index
|
| d2889096e7 |
2014-07-29 12:53:17
|
Code_Defect
|
Fixed
|
Unknown
|
Problem with rtree tables with IN() operators or as the inner loop of a join.
|
| b2fa5424e6 |
2014-06-30 18:58:01
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect STAT4 samples for WITHOUT ROWID tables
|
| 9a8b09f8e6 |
2014-06-27 02:23:36
|
Code_Defect
|
Fixed
|
Unknown
|
Affinity problem on "x IN (?)"
|
| e9654505cf |
2014-05-23 11:51:48
|
Code_Defect
|
Fixed
|
Unknown
|
Inifinite loop in INSERT statement.
|
| 55746f9e65 |
2014-05-07 17:19:35
|
Code_Defect
|
Fixed
|
Unknown
|
group_concat() returns NULL instead of an empty string
|
| f67b41381a |
2014-04-26 17:52:31
|
Code_Defect
|
Fixed
|
Unknown
|
"INSERT INTO tbl SELECT * FROM tbl2" statement may modify data if ALTER TABLE ADD COLUMN has been used on tbl2.
|
| 388d01d4bb |
2014-04-25 17:37:22
|
Code_Defect
|
Fixed
|
Unknown
|
Crash on join with a virtual table, DISTINCT, and ORDER BY.
|
| b75a9ca6b0 |
2014-04-21 13:39:44
|
Code_Defect
|
Fixed
|
Unknown
|
ORDER BY ignored if query has identical GROUP BY
|
| 14b9ffb67f |
2014-04-20 09:57:46
|
Code_Defect
|
Closed
|
Unknown
|
An ORDER BY clause with the same expressions as a GROUP BY clause may be ignored
|
| 264b970c43 |
2014-04-14 19:48:16
|
Code_Defect
|
Fixed
|
Unknown
|
Crash when calling sqlite_rename_parent() with NULL parameters.
|
| 2ea3e9fe63 |
2014-04-13 19:28:14
|
Code_Defect
|
Fixed
|
Unknown
|
Partial index causes assertion fault on UPDATE OR REPLACE
|
| 10fb063b11 |
2014-04-10 02:24:43
|
Code_Defect
|
Fixed
|
Unknown
|
Duplicate row output on an OR query
|
| 98825a79ce |
2014-04-03 16:57:11
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
|
| a8a0d2996a |
2014-03-24 15:02:18
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect column data type reported
|
| 07d6a0453d |
2014-03-21 18:16:34
|
Code_Defect
|
Fixed
|
Unknown
|
OFFSET ignored if there is no FROM clause
|
| e39d032577 |
2014-03-20 13:31:59
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on a query containing "x IN (?)"
|
| 0841d0f524 |
2014-03-11 13:20:51
|
Feature_Request
|
Closed
|
Unknown
|
Exclusive transactions do not work if same database multiply attached
|
| 13137dccf3 |
2014-03-11 13:20:19
|
Feature_Request
|
Closed
|
Extensions
|
FTS3 and last_insert_rowid()
|
| 084941461f |
2014-03-11 13:20:03
|
Code_Defect
|
Closed
|
Extensions
|
Some minor asyncvfs issues
|
| 25e09aa2ab |
2014-03-11 13:19:13
|
Feature_Request
|
Closed
|
Parser
|
Lint mode
|
| 5ac9b497de |
2014-03-11 13:18:44
|
Feature_Request
|
Fixed
|
Parser
|
Some issues with aliases, fully qualified identifiers, and *
|
| 030632f55b |
2014-03-11 13:18:26
|
Feature_Request
|
Closed
|
Unknown
|
make sqlite2 detect sqlite3
|
| 72b01a982a |
2014-03-11 13:18:08
|
Feature_Request
|
Closed
|
Unknown
|
Per page/region checksums
|
| 3671265894 |
2014-03-11 13:17:53
|
Feature_Request
|
Closed
|
Shell
|
No error reporting on file open failure
|
| af3450b763 |
2014-03-11 13:17:33
|
Feature_Request
|
Closed
|
Extensions
|
Recursive virtual tables
|
| c25aab7e7e |
2014-03-11 13:17:03
|
Feature_Request
|
Fixed
|
Shell
|
The ".import" command does not parse CSV correctly.
|
| f817a45752 |
2014-03-11 13:16:48
|
Feature_Request
|
Closed
|
VFS
|
CantOpen doesn't include name of file that can't be opened
|
| 775b39dd3c |
2014-03-11 13:15:56
|
Code_Defect
|
Fixed
|
Shell
|
Poor query planning with virtual tables, joins and ORDER BY.
|
| 2e047cbefa |
2014-03-11 13:15:26
|
Performance_Issue
|
Closed
|
Virtual_Machine
|
select DISTINCT performance could be better
|
| 23b2128201 |
2014-03-11 13:14:19
|
Feature_Request
|
Fixed
|
Virtual_Machine
|
Uninformative error message on check constraint failure
|
| 61d35ac210 |
2014-03-11 13:14:00
|
Feature_Request
|
Closed
|
Unknown
|
A way to tell if a journal should exist
|
| 33fdaab1a0 |
2014-03-11 13:13:26
|
Feature_Request
|
Closed
|
Virtual_Machine
|
Need to cancel an integrity check in progress with sqlite3_interrupt
|
| 293860ac26 |
2014-03-11 13:12:43
|
Feature_Request
|
Closed
|
Unknown
|
Allow triggers to reference other databases
|
| 65a1fd4bab |
2014-03-11 13:12:02
|
Feature_Request
|
Closed
|
Shell
|
Shell should call rl_readline_name
|
| bcff482dd6 |
2014-03-11 13:11:26
|
Feature_Request
|
Fixed
|
Unknown
|
Explicit extended error code for deadlock with sqlite_busy
|
| 5896edbe46 |
2014-03-11 13:11:05
|
Feature_Request
|
Closed
|
Unknown
|
List available SQL functions
|
| c276ee2e4e |
2014-03-11 13:10:44
|
Feature_Request
|
Closed
|
Unknown
|
null should not be allowed in primary key
|
| f711d5a937 |
2014-03-11 13:09:05
|
Feature_Request
|
Fixed
|
Unknown
|
Windows DLL should have versioninfo resource
|
| 4d5c039d12 |
2014-03-11 13:08:03
|
Feature_Request
|
Closed
|
Unknown
|
Truncated database not detected well
|
| de3ae967a0 |
2014-03-11 13:07:14
|
Feature_Request
|
Fixed
|
Parser
|
Insert multiple rows at once
|
| c060923a54 |
2014-03-11 13:06:54
|
Code_Defect
|
Closed
|
VFS
|
VFS filename truncation issues
|
| f6ee7c1986 |
2014-03-11 13:06:10
|
Feature_Request
|
Fixed
|
Shell
|
Negative widths should right justify
|
| ba7fdb568d |
2014-03-11 13:05:46
|
Feature_Request
|
Fixed
|
VFS
|
Page size should auto default to file system block size
|
| 08595ca456 |
2014-03-11 13:05:24
|
Code_Defect
|
Closed
|
Parser
|
INTERSECT operator should have higher precedence
|
| ed2ff2f4ef |
2014-03-11 13:04:34
|
Feature_Request
|
Closed
|
Virtual_Machine
|
Call progress callback while doing pragma integrity_check
|
| ebde3f66fc |
2014-03-11 13:04:06
|
Feature_Request
|
Closed
|
Virtual_Machine
|
Shared cache has different busy behaviour than non-shared
|
| d8fe6cef65 |
2014-03-11 13:03:38
|
Code_Defect
|
Closed
|
VFS
|
Error return from VFS xUnlock ignored
|
| 1c67bd6ce9 |
2014-03-11 13:02:13
|
Feature_Request
|
Closed
|
Shell
|
Shell Control-C (break) handling could be better
|
| 1a1790ca1a |
2014-03-11 13:00:31
|
Feature_Request
|
Closed
|
Virtual_Machine
|
No way to signal an error in collation callback
|
| 62359d6511 |
2014-03-11 13:00:09
|
Feature_Request
|
Closed
|
VFS
|
xGetLastError should be dumped
|
| efeeb90f2a |
2014-03-11 12:59:44
|
Feature_Request
|
Closed
|
Unknown
|
error messages should be per-thread not global
|
| 15e11a2c87 |
2014-03-11 12:59:14
|
Feature_Request
|
Closed
|
Unknown
|
IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings
|
| eaa105fe74 |
2014-03-11 12:58:48
|
Feature_Request
|
Closed
|
Code_Generator
|
(...) WHERE [col] IN (val1) not reflected in xBestIndex
|
| b803a45d50 |
2014-03-11 12:58:12
|
Feature_Request
|
Closed
|
Unknown
|
Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...)
|
| e33452c90f |
2014-03-11 12:56:59
|
Feature_Request
|
Closed
|
Unknown
|
Query plan doesn't use existing index
|
| 89f7b55854 |
2014-03-11 12:56:34
|
Feature_Request
|
Closed
|
Unknown
|
RFE - Documentation in PDF format?
|
| 2c5661c26a |
2014-03-11 12:56:01
|
Feature_Request
|
Closed
|
Other
|
Thread safety: does SQLite handle pthread_cancel cleanly?
|
| 1248e6cda8 |
2014-03-11 12:54:58
|
Code_Defect
|
Closed
|
Unknown
|
Insufficient precision of sqlite3_column_text16() for floating point values
|
| 36769f697d |
2014-03-11 12:50:03
|
Code_Defect
|
Closed
|
Extensions
|
termDataCmp in FTS3 should be __cdecl on Windows
|
| 8f81455baf |
2014-03-11 12:49:29
|
Code_Defect
|
Closed
|
Extensions
|
fts3GetVarint32 sets random number on error
|
| edb497982c |
2014-03-11 12:47:14
|
Code_Defect
|
Fixed
|
Unknown
|
FTS n-character prefix query returns incorrect results when using an n+1 character prefix index.
|
| f48b7da35c |
2014-03-11 12:46:40
|
Documentation
|
Closed
|
Documentation
|
Loadable extensions documentation bitrot
|
| 01b785eefa |
2014-03-11 12:45:49
|
Support_Request
|
Closed
|
Shell
|
sqlite3.exe - wrong parameter charset
|
| beba9cae63 |
2014-03-11 12:44:00
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on a valid query
|
| 4eb3a0bd32 |
2014-03-11 12:41:50
|
Code_Defect
|
Fixed
|
Unknown
|
Performance regression in Skrooge
|
| 31a19d11b9 |
2014-03-05 15:07:06
|
Code_Defect
|
Fixed
|
Unknown
|
Name resolution issue with compound SELECTs and Common Table Expressions
|
| 4ef7e3cfca |
2014-03-04 13:03:50
|
Code_Defect
|
Closed
|
Unknown
|
Name resolution problem in sub-selects within triggers
|
| 65bdeb9739 |
2014-02-26 02:26:29
|
Code_Defect
|
Fixed
|
Unknown
|
"ORDER BY random()" gets optimized out
|
| 8c63ff0eca |
2014-02-25 21:56:00
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect query result on a UNION ALL
|
| c34d0557f7 |
2014-02-12 14:43:48
|
Code_Defect
|
Fixed
|
Unknown
|
Name resolution issue with WITHOUT ROWID
|
| 4c86b126f2 |
2014-02-11 02:48:03
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect query result with SQLITE_ENABLE_STAT4
|
| fccbde530a |
2014-02-08 19:12:24
|
Code_Defect
|
Fixed
|
Unknown
|
DISTINCT thinks a zeroblob() and blob of all zeros are different
|
| 1a1a194d1e |
2014-01-20 19:56:28
|
Code_Defect
|
Closed
|
Unknown
|
Assertion fault on query of virtual table with cross-column constraints
|
| 520070ec7f |
2013-12-22 20:44:24
|
Code_Defect
|
Fixed
|
Unknown
|
Array overrun in the skip-scan optimization
|
| 4065ac8595 |
2013-11-12 12:31:31
|
Code_Defect
|
Closed
|
Unknown
|
LEFT JOIN with virtual table on left hand side may not return all rows
|
| c620261b5b |
2013-10-28 20:39:11
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result on query involving LEFT JOIN and transitive constraints
|
| a5c8ed66ca |
2013-10-04 00:07:13
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect count(*) when partial indices exist
|
| 9fb5cd7c76 |
2013-09-30 10:19:46
|
Code_Defect
|
Fixed
|
Unknown
|
"DELETE FROM tbl" statements do not obtain a shared-cache write-lock on table "tbl"
|
| be84e357c0 |
2013-09-03 14:03:54
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault during query involving LEFT JOIN column in the ORDER BY clause
|
| 9f2eb3abac |
2013-08-29 13:12:10
|
Code_Defect
|
Fixed
|
Unknown
|
A lookup on a primary key or unique index with more than 4 fields can cause a crash
|
| 2fd50fa665 |
2013-08-29 07:22:57
|
Feature_Request
|
Closed
|
VFS
|
cygwin-1.7 issues: winFullPathname and tempname
|
| bc878246ea |
2013-08-28 16:27:07
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from LEFT JOIN query
|
| d666d600a6 |
2013-08-21 13:09:44
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE operator on lhs of BETWEEN expression is ignored.
|
| f617ea3125 |
2013-08-15 22:42:19
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect ORDER BY with colliding input and output column names
|
| 406d3b2ef9 |
2013-07-18 18:45:58
|
Code_Defect
|
Fixed
|
Unknown
|
SQL function auxdata associated with parameters is not cleared
|
| 78588b938a |
2013-07-17 11:54:50
|
Code_Defect
|
Fixed
|
Unknown
|
Virtual Table Sync frees pVtab->zErrMsg without zeroing
|
| 83e9014ec2 |
2013-07-09 14:49:40
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from sqlite3_stmt_status with SQLITE_STMTSTATUS_FULLSCAN_STEP
|
| 5ed1772895 |
2013-07-09 14:49:14
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect ORDER BY on an indexed JOIN
|
| bc1aea7b72 |
2013-07-09 14:48:25
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
|
| 490a4b7235 |
2013-07-09 03:04:50
|
Code_Defect
|
Fixed
|
Unknown
|
"WHERE 0" on the first element of a UNION causes an assertion fault
|
| d805526eae |
2013-07-08 21:13:16
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect join result or assertion fault due to transitive constraints
|
| 868145d012 |
2013-07-01 17:27:33
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on double LEFT JOIN
|
| a589ec069e |
2013-06-27 17:40:44
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3_stmt_readonly() returns an incorrect value for come PRAGMAs
|
| e636a050b7 |
2013-05-15 18:21:44
|
Code_Defect
|
Fixed
|
Unknown
|
Database corruption in shared cache mode
|
| 0fc59f908b |
2013-05-15 17:58:20
|
Code_Defect
|
Fixed
|
Unknown
|
Missing COLLATE function does not result in an error
|
| f2369304e4 |
2013-05-09 14:20:19
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect results when OR is used in the ON clause of a LEFT JOIN
|
| 6709574d2a |
2013-05-08 16:58:10
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE clause in ORDER BY causes incorrect EXCEPT
|
| 2f96536e7f |
2013-05-06 20:29:01
|
Code_Defect
|
Fixed
|
Shell
|
.tables output is not redirected into .output file
|
| 5eaa61ea18 |
2013-05-06 18:49:42
|
Portability
|
Fixed
|
Unknown
|
sigbus on disk ful in WAL mode
|
| 0eb70d77cb |
2013-05-06 13:45:39
|
Code_Defect
|
Fixed
|
Unknown
|
Invalid pointer passed to the authorizer callback
|
| 19b44e3575 |
2013-04-30 14:26:35
|
Feature_Request
|
Fixed
|
Virtual_Machine
|
sqlite3_bind_text inconsistent with NULL pointers, zero length etc
|
| 28c6e830f2 |
2013-04-30 14:07:07
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault while parsing/compiling an SQL statement
|
| ba82a4a41e |
2013-04-22 22:29:50
|
Code_Defect
|
Fixed
|
Unknown
|
Query optimizer removes ORDER BY when it is needed
|
| f69b96e307 |
2013-04-18 02:55:56
|
Code_Defect
|
Fixed
|
Unknown
|
Over-aggressive optimization of ORDER BY using a virtual table with IN operator
|
| 2500cdb9be |
2013-04-14 23:51:40
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE in ORDER BY clause breaks name resolution
|
| 7ff3120e4f |
2013-04-12 12:09:20
|
Code_Defect
|
Fixed
|
VFS
|
Recovery race condition leads to database corruption on Windows
|
| 38b1ae018f |
2013-03-27 21:12:25
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on valid FTS4 query
|
| 6bfb98dfc0 |
2013-03-27 21:11:25
|
Code_Defect
|
Fixed
|
Unknown
|
False report of database corruption on an INSERT
|
| a179fe7465 |
2013-03-27 17:20:18
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect output order on a join with an ORDER BY
|
| 689137afb6 |
2013-03-20 12:45:58
|
Code_Defect
|
Fixed
|
Unknown
|
Casting UTF16 to numeric types fails
|
| 4dd95f6943 |
2013-03-13 00:13:54
|
Code_Defect
|
Fixed
|
Unknown
|
Inverted result order with ORDER BY DESC and a DESC index.
|
| fc7bd6358f |
2013-03-06 01:55:45
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect query result in a 3-way join due to affinity issues
|
| 7a31705a7e |
2013-03-01 17:43:37
|
Code_Defect
|
Fixed
|
Unknown
|
Name resolution fails when table name is a prefix of another table
|
| db4d96798d |
2013-01-29 23:55:55
|
Code_Defect
|
Fixed
|
Unknown
|
LIMIT does not work with nested views containing UNION ALL
|
| d58ccbb3f1 |
2013-01-28 19:00:28
|
Code_Defect
|
Fixed
|
Unknown
|
Segmentation fault on a valid query with "union"
|
| 7c6a01c6c5 |
2013-01-15 15:28:03
|
Performance_Issue
|
Closed
|
Unknown
|
Multi-column index is not used with IN operator
|
| c997b11c4d |
2013-01-09 14:43:29
|
Code_Defect
|
Fixed
|
Code_Generator
|
ORDER BY clause ignored in 3-way join query
|
| 0cfd98ee20 |
2012-12-21 16:16:53
|
Code_Defect
|
Closed
|
Pager
|
Potential corruption of backup db when backing up a db last written by sqlite<3.7.0
|
| a7b7803e8d |
2012-12-19 16:58:04
|
Code_Defect
|
Fixed
|
Code_Generator
|
crash when filtering twice by same predicate using aliases
|
| 71e333e7d2 |
2012-12-19 15:17:05
|
Code_Defect
|
Fixed
|
Unknown
|
COLLATE operator inside CHECK constraint fails in shared-cache mode
|
| dec444cd68 |
2012-12-19 12:46:56
|
Code_Defect
|
Closed
|
Unknown
|
rowid not usable in complex queries
|
| df678d738a |
2012-12-18 14:04:30
|
Code_Defect
|
Closed
|
Pager
|
Cache corruption following IO error on systems supporting atomic-write
|
| d6b36be38a |
2012-12-07 19:41:22
|
Code_Defect
|
Closed
|
Code_Generator
|
Sub-select in LIMIT clause may access db without locks.
|
| ae3c5670b6 |
2012-12-06 19:42:31
|
Code_Defect
|
Closed
|
Code_Generator
|
Bug caused by factoring of constants in trigger programs
|
| f46ca03b55 |
2012-11-29 14:27:13
|
Code_Defect
|
Closed
|
Extensions
|
The order of two operations in asyncLock()
|
| bfbf38e5e9 |
2012-11-02 23:55:29
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on a nested join
|
| d02e1406a5 |
2012-10-04 19:41:35
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN with an OR in the ON clause causes segfault
|
| c2ad16f997 |
2012-05-21 21:26:35
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on query involving deeply nested aggregate views
|
| cfe84e8683 |
2012-05-21 03:15:53
|
Code_Defect
|
Fixed
|
Unknown
|
The ".schema" command outputs nested VIEWS in the wrong order
|
| bdc6bbbb38 |
2012-05-10 17:59:02
|
Code_Defect
|
Closed
|
Unknown
|
Problem with FTS aux. functions when used with OR queries with enhanced query syntax enabled
|
| 385a5b56b9 |
2012-04-20 17:44:18
|
Code_Defect
|
Closed
|
Code_Generator
|
A DISTINCT SELECT optimized using a UNIQUE index may allow duplicate NULL values.
|
| 2a5629202f |
2012-04-20 17:43:46
|
Code_Defect
|
Closed
|
Code_Generator
|
Malfunctioning interaction between a multi-term ORDER BY clause and UNIQUE index containing NULL values
|
| 27ca74af3c |
2012-03-31 18:02:56
|
Code_Defect
|
Fixed
|
Unknown
|
Nested SAVEPOINT release causes pending query abort
|
| b7c8682cc1 |
2012-03-13 14:10:35
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result from LEFT JOIN with OR in the WHERE clause
|
| 3557ad65a0 |
2012-03-03 01:44:33
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect DISTINCT on an indexed query with IN
|
| ae6794effd |
2012-02-01 01:14:41
|
Code_Defect
|
Fixed
|
Unknown
|
ALTER TABLE RENAME fails for triggers that use the table name with a different case
|
| 5f41597f7c |
2012-01-30 18:41:08
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3_uri_boolean defaults to true, documented as false, is a mess
|
| 232637c465 |
2012-01-28 21:09:25
|
Code_Defect
|
Fixed
|
Shell
|
Dump code fails with 1002 columns
|
| c04a8b8a4f |
2012-01-28 21:09:09
|
Code_Defect
|
Fixed
|
Unknown
|
Trailing comments not stripped from views, invalid dumps
|
| ff5be73dee |
2012-01-14 15:35:02
|
Code_Defect
|
Fixed
|
Unknown
|
Database corruption following power-loss in WAL mode
|
| a1fa75cbdd |
2012-01-14 15:34:17
|
Code_Defect
|
Fixed
|
Pager
|
Database corruption following unlucky application crash in WAL mode with "PRAGMA journal_size_limit"
|
| ac0ff496b7 |
2011-12-22 02:11:23
|
Code_Defect
|
Fixed
|
Unknown
|
Database corruption due to integer overflow with SQLITE_DIRECT_OVERFLOW_READ
|
| 7bbfb7d442 |
2011-12-10 13:53:09
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Problem with using stale auto-indexes created on materialized sub-selects within trigger programs
|
| 3a77c9714e |
2011-12-06 14:02:51
|
Code_Defect
|
Fixed
|
Parser
|
Malfunction involving temporary registers and sub-queries implemented by vdbe sub-routines.
|
| 676bc02b87 |
2011-11-04 00:24:14
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect xfer optimization with INTERGER PRIMARY KEY ON CONFLICT REPLACE
|
| 8290242b2a |
2011-10-31 18:46:35
|
Code_Defect
|
Closed
|
Unknown
|
ALTER TABLE RENAME fails if the database encoding is not UTF8
|
| 3338b3fa19 |
2011-10-31 18:46:16
|
Code_Defect
|
Closed
|
Unknown
|
ambiguous column name when using multiple JOIN USING clauses and WHERE clause
|
| f1c2a689c6 |
2011-10-31 18:45:34
|
Build_Problem
|
Closed
|
Other
|
configure script ignores ``--with-tcl'' option when tclsh8.4 is installed.
|
| 92bd6eaf04 |
2011-10-31 18:44:47
|
Build_Problem
|
Closed
|
Makefile
|
Suggestion to revise clean rule in main.mk.
|
| 57c971fc74 |
2011-10-31 18:44:32
|
Code_Defect
|
Closed
|
Unknown
|
Some user defined string functions do not operate correctly on strings with embedded nuls
|
| 48f299634a |
2011-10-29 11:54:59
|
Code_Defect
|
Closed
|
Virtual_Machine
|
Crash in SAVEPOINT within a transaction that writes to then drops an FTS table
|
| d214d7b114 |
2011-10-13 18:26:33
|
Code_Defect
|
Closed
|
Extensions
|
FTS3 virtual table fails when names are quoted
|
| 9861b74ab9 |
2011-10-13 18:25:15
|
Code_Defect
|
Closed
|
Unknown
|
Fts3 offsets() function may report SQLITE_CORRUPT with empty string.
|
| 9fd058691b |
2011-10-13 17:34:50
|
Code_Defect
|
Closed
|
Extensions
|
Problem with updating an FTS table that contains a single row
|
| 4c9223e34e |
2011-10-13 16:32:26
|
Documentation
|
Closed
|
Documentation
|
Vacuum fails within transaction but also rolls it back
|
| ab7498f2f6 |
2011-10-13 16:07:15
|
Performance_Issue
|
Closed
|
Unknown
|
54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause
|
| 92af7da36b |
2011-10-13 16:02:27
|
Code_Defect
|
Fixed
|
Shell
|
shell won't import large files
|
| 0c80ff9f5a |
2011-10-13 15:56:12
|
Documentation
|
Fixed
|
Documentation
|
Quickstart missing include of stdlib.h
|
| fa7bf5ec94 |
2011-10-13 15:38:08
|
Code_Defect
|
Fixed
|
Unknown
|
String literal case confusion in aggregate query
|
| b2d64a52a0 |
2011-10-13 14:46:08
|
Build_Problem
|
Closed
|
Makefile
|
pkgIndex.tcl is being deleted by 'make clean' but it is not created by 'make'
|
| 6e1086fb2c |
2011-10-13 14:23:58
|
Code_Defect
|
Closed
|
Unknown
|
"create table as select" and "pragma *_column_names"
|
| 991789d9f3 |
2011-10-13 14:12:28
|
Code_Defect
|
Fixed
|
Extensions
|
ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8.
|
| 35c54c8749 |
2011-10-13 14:05:45
|
Code_Defect
|
Fixed
|
Unknown
|
Some os win symbols should be declared static
|
| aa92c76cd4 |
2011-10-13 13:53:26
|
Code_Defect
|
Fixed
|
Code_Generator
|
Problem with GROUP BY and the distinction between real and integer values
|
| 43d2aa29b9 |
2011-10-13 13:52:50
|
Documentation
|
Closed
|
Documentation
|
H13015 needs to be completed
|
| 4776dee07a |
2011-10-13 13:52:23
|
Documentation
|
Closed
|
Documentation
|
Documentation and code about registering functions
|
| ac55d88a33 |
2011-10-13 13:35:04
|
Documentation
|
Closed
|
Unknown
|
H10336 is no longer applicable
|
| 2466653295 |
2011-10-13 13:34:18
|
Code_Defect
|
Fixed
|
Shell
|
Various dump issues
|
| 517e206abd |
2011-10-13 13:25:17
|
Code_Defect
|
Fixed
|
Utilities
|
Fix sqlite3_analyzer
|
| 5483170346 |
2011-10-13 13:24:46
|
Documentation
|
Closed
|
Documentation
|
H35230 & H35240 refer incorrectly to H35230 - should be H35220
|
| cbd054fa6b |
2011-10-13 13:23:15
|
Code_Defect
|
Closed
|
Unknown
|
"out of memory" in ANALYZE with SQLITE_ENABLE_STAT2
|
| 9d68c88313 |
2011-10-13 13:22:24
|
Code_Defect
|
Fixed
|
Pager
|
Database corruption following OOM fault
|
| 26ff0c82d1 |
2011-10-13 13:21:53
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect result when using unnamed "?" bindings
|
| fc62af4523 |
2011-10-13 13:19:41
|
Code_Defect
|
Fixed
|
Pager
|
Executing "PRAGMA journal_mode" may delete journal file while it is in use.
|
| 54844eea3f |
2011-10-13 13:16:48
|
Code_Defect
|
Fixed
|
Code_Generator
|
Incorrect caching of sub-query results in the FROM clause of a scalar sub-query.
|
| e59bdf6116 |
2011-10-13 13:15:34
|
Code_Defect
|
Fixed
|
Unknown
|
Possible database corruption following EINTR on unix
|
| af95b8c609 |
2011-10-13 13:13:57
|
Code_Defect
|
Fixed
|
Utilities
|
Vacuuming a WAL database resets the file header read and write versions to 1.
|
| ee19e690ec |
2011-10-13 00:42:03
|
Code_Defect
|
Fixed
|
Shell
|
If shell is interrupted while dumping it still produces commit (and invalid dump)
|
| 7d32c69b50 |
2011-10-13 00:11:47
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3LoadExtension truncates file names
|
| 20f9d4fbbf |
2011-10-12 23:50:07
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3_overload_function ignores errors
|
| 0b803bff85 |
2011-10-12 23:14:14
|
Code_Defect
|
Fixed
|
VFS
|
Return (error code) of xCurrentTime is always ignored
|
| c48d99d690 |
2011-09-30 12:19:35
|
Code_Defect
|
Closed
|
Code_Generator
|
Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured
|
| d1d84037b9 |
2011-09-28 01:11:07
|
Feature_Request
|
Fixed
|
Shell
|
import doesn't work on attached databases due to unnecessary quoting
|
| bd484a090c |
2011-09-19 20:43:56
|
Code_Defect
|
Closed
|
Extensions
|
Date/time functions do not detect failure of localtime_r()
|
| 1a1308d253 |
2011-09-19 17:38:04
|
Code_Defect
|
Closed
|
Unknown
|
Nested correlated subquery fails when indices used
|
| 002caede89 |
2011-09-19 17:37:54
|
Code_Defect
|
Closed
|
Unknown
|
LEFT JOIN with OR terms in WHERE clause causes assertion fault
|
| d635236375 |
2011-09-19 17:37:47
|
Code_Defect
|
Closed
|
Unknown
|
Assertion fault on a join with a repeated column
|
| 6c14288a47 |
2011-09-19 17:37:38
|
Code_Defect
|
Closed
|
Unknown
|
Virtual tables do not handle IS NOT NULL correctly
|
| d6ddba6706 |
2011-09-19 17:37:30
|
Code_Defect
|
Closed
|
Unknown
|
Parser accepts invalid CREATE TRIGGER syntax
|
| 25ee812710 |
2011-09-19 17:37:21
|
Code_Defect
|
Closed
|
Unknown
|
PRAGMA case_sensitive_like=1 fails
|
| 91e2e8ba6f |
2011-09-19 17:37:12
|
Code_Defect
|
Closed
|
Unknown
|
Automatic indices cause undesirable type conversions
|
| 56be976859 |
2011-09-14 11:16:23
|
Code_Defect
|
Closed
|
Extensions
|
Buffer overrun in FTS prefix queries
|
| b1d3a2e531 |
2011-08-22 17:49:43
|
Code_Defect
|
Closed
|
Code_Generator
|
Erroneous FK constraint failure when dropping table.
|
| 534aa198e1 |
2011-07-14 11:38:10
|
Build_Problem
|
Closed
|
Unknown
|
Build error: missing manifest.uuid file in 3.7.4 downloadable source code
|
| 2d1a5c67df |
2011-05-19 01:28:33
|
Code_Defect
|
Fixed
|
Pager
|
Data loss on COMMIT in WAL mode
|
| 6284df89de |
2011-04-24 23:02:35
|
Code_Defect
|
Fixed
|
Unknown
|
INSERT INTO ... SELECT bypasses foreign key constraint checks
|
| bb3a86e890 |
2011-04-13 13:48:30
|
Code_Defect
|
Fixed
|
Unknown
|
SQLITE_FCNTL_SIZE_HINT overflows an array
|
| 83ea97620b |
2011-03-30 14:54:18
|
Code_Defect
|
Fixed
|
Unknown
|
ANALYZE on empty tables prevents the use of indices
|
| f7b4edece2 |
2011-03-19 02:04:24
|
Code_Defect
|
Fixed
|
Unknown
|
sqlite3_update_hook gives incorrect table name with shared cache
|
| b72787b1a7 |
2011-02-22 05:24:39
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Expiry mechanism causes incorrect collateral damage
|
| eebb8a2803 |
2011-02-21 18:41:30
|
Build_Problem
|
Closed
|
Other
|
Inconsistent amalgamation zip archive file names
|
| 752e1646fc |
2011-02-11 20:54:35
|
Code_Defect
|
Fixed
|
Unknown
|
Wrong result if DISTINCT used on subquery which uses ORDER BY.
|
| 89b8c9ac54 |
2011-02-10 19:24:13
|
Code_Defect
|
Fixed
|
B-Tree
|
False reports of corruption after writing db with two different versions (3.7 and 3.6).
|
| 77aa3b1e65 |
2011-02-10 19:23:56
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on automatic index using unknown collating function
|
| 9013e13dba |
2011-02-04 00:53:22
|
Code_Defect
|
Fixed
|
Unknown
|
ATTACH authorization fails when database name is not a literal
|
| 5d863f876e |
2011-01-27 14:33:00
|
Code_Defect
|
Fixed
|
Unknown
|
DB corruption following rollback-WAL-VACUUM-rollback
|
| 80ba201079 |
2010-12-07 15:10:31
|
Code_Defect
|
Fixed
|
Code_Generator
|
Bug involving subqueries and the OR optimization
|
| 860399cc40 |
2010-10-12 02:13:48
|
Code_Defect
|
Fixed
|
Unknown
|
Potential memory leak in sqlite3_bind_text()
|
| a04e42a3fc |
2010-10-11 18:53:54
|
Code_Defect
|
Fixed
|
Unknown
|
Memory leak in sqlite3_create_collation_v2()
|
| 0322cd49c0 |
2010-10-11 04:23:46
|
Feature_Request
|
Fixed
|
Virtual_Machine
|
create_function_v2 that takes destructor
|
| 38cb5df375 |
2010-10-06 19:14:07
|
Code_Defect
|
Fixed
|
Unknown
|
LIMIT ignored on compound query with subqueries
|
| 3998683a16 |
2010-09-30 17:34:38
|
Code_Defect
|
Fixed
|
Utilities
|
Some valid floating-point literals are not recognized.
|
| 8454a207b9 |
2010-09-30 14:48:22
|
Code_Defect
|
Fixed
|
Code_Generator
|
ALTER TABLE ADD COLUMN with negative DEFAULT value
|
| b351d95f9c |
2010-09-28 07:21:50
|
Code_Defect
|
Fixed
|
Code_Generator
|
Bug in "INSERT INTO ... SELECT" statements that use CASE
|
| 313723c356 |
2010-09-18 19:37:16
|
Code_Defect
|
Fixed
|
Pager
|
Database corruption following an I/O error on xShmLock
|
| 5e10420e8d |
2010-08-23 17:08:42
|
Code_Defect
|
Fixed
|
Unknown
|
Free-list corruption in incremental-vacuum mode
|
| e4b8a2ba6e |
2010-08-13 16:50:01
|
Code_Defect
|
Closed
|
Code_Generator
|
Problem with DISTINCT in sub-queries in a FROM clause.
|
| 13f033c865 |
2010-08-05 03:24:23
|
Code_Defect
|
Fixed
|
Code_Generator
|
Performance regression
|
| 51ae9cad31 |
2010-08-04 11:40:07
|
Code_Defect
|
Fixed
|
B-Tree
|
Database corruption by alternating writes from 3.7.0 and 3.6.23
|
| c38baa3d96 |
2010-08-03 13:09:19
|
Code_Defect
|
Fixed
|
Code_Generator
|
REPLACE on a CHECK constraint does not work as advertised
|
| 168d0f7176 |
2010-08-01 22:25:47
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault while reading database with a corrupt index
|
| ce7c133ea6 |
2010-07-31 20:55:02
|
Code_Defect
|
Fixed
|
Code_Generator
|
Foreign key constraint fails when it should succeed.
|
| f3e5abed55 |
2010-07-30 11:37:32
|
Code_Defect
|
Fixed
|
Unknown
|
Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction
|
| c43940c49b |
2010-07-29 10:08:14
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
sqlite3_profile gives milliseconds (was nanoseconds in earlier releases)
|
| 8011086c85 |
2010-07-28 02:53:54
|
Code_Defect
|
Fixed
|
Code_Generator
|
Query planner creates unnecessary and expensive automatic index
|
| 4711020446 |
2010-07-22 17:50:14
|
Feature_Request
|
Fixed
|
Unknown
|
should use collate nocase index even if column isn't declared nocase
|
| e090183531 |
2010-07-22 12:34:28
|
Feature_Request
|
Fixed
|
Unknown
|
like should use index when pattern has no wildcard
|
| 30349e0f68 |
2010-07-19 05:00:53
|
Code_Defect
|
Closed
|
Extensions
|
Yet more FTS3 symbols need to be made private
|
| 80e031a00f |
2010-07-14 18:24:26
|
Code_Defect
|
Fixed
|
Code_Generator
|
Result of IN should never be NULL if the RHS is empty
|
| d11f09d36e |
2010-06-26 19:03:53
|
Code_Defect
|
Closed
|
Pager
|
Cache corruption caused by ROLLBACK with synchronous=NORMAL
|
| f973c7ac31 |
2010-06-09 16:16:29
|
Code_Defect
|
Fixed
|
Unknown
|
Incorrect affinity for indexed range constraint
|
| dd08e5a988 |
2010-05-14 19:24:22
|
Code_Defect
|
Fixed
|
Unknown
|
Foreign key constraint fails to prevent consistency error.
|
| 51914f6acd |
2010-05-13 23:00:39
|
Performance_Issue
|
Fixed
|
Unknown
|
nRef and owner should be #ifdef SQLITE_DEBUG
|
| 3dbdcdb14e |
2010-04-30 21:03:59
|
Code_Defect
|
Fixed
|
Code_Generator
|
Assertion fault using indices with redundant columns
|
| c39ff61c43 |
2010-04-30 06:00:18
|
Code_Defect
|
Closed
|
Virtual_Machine
|
Erroneous FK constraint failure when reusing statement
|
| bb1977f6e9 |
2010-04-22 12:08:03
|
Code_Defect
|
Closed
|
Unknown
|
Concatenation can create very invalid strings
|
| 02a8e81d44 |
2010-04-15 23:26:14
|
Code_Defect
|
Fixed
|
Code_Generator
|
LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
|
| 883034dcb5 |
2010-03-31 15:11:24
|
Code_Defect
|
Closed
|
Code_Generator
|
Column cache problem with aggregate queries
|
| e063139eb3 |
2010-03-31 11:57:19
|
Build_Problem
|
Fixed
|
Makefile
|
Download .zip excludes shell but .tar includes it
|
| f3162063fd |
2010-03-30 13:43:33
|
Code_Defect
|
Closed
|
Code_Generator
|
Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers.
|
| 7d96113ff0 |
2010-03-27 16:52:27
|
Build_Problem
|
Fixed
|
Makefile
|
SQLite fails to build when TCL isn't installed
|
| 015d3820f2 |
2010-03-22 17:47:02
|
Code_Defect
|
Closed
|
Pager
|
Missing call to xSync() following rollback.
|
| dd3ba6063a |
2010-03-19 19:11:13
|
Code_Defect
|
Closed
|
Extensions
|
rtree module does not support last_insert_rowid()
|
| b1552d0fa7 |
2010-03-18 16:35:14
|
Code_Defect
|
Fixed
|
Extensions
|
Symbols not declared private that should be
|
| 170872f1c3 |
2010-03-15 20:53:18
|
Code_Defect
|
Fixed
|
Unknown
|
Unmatched double-quote causes problems for FTS3
|
| 42d45a693e |
2010-03-15 19:28:20
|
Code_Defect
|
Fixed
|
Unknown
|
Spurious log message from FTS3
|
| 9abd6aa831 |
2010-03-04 18:00:15
|
Code_Defect
|
Closed
|
Utilities
|
buffer overread in sqlite3_printf functions.
|
| ebdbadade5 |
2010-02-27 12:30:49
|
Code_Defect
|
Fixed
|
Unknown
|
LEFT JOIN incorrect when ON clause does not reference right table.
|
| d2f02d37f5 |
2010-02-24 15:11:51
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on UPDATE involving two virtual tables.
|
| da1151f97d |
2010-02-22 23:19:40
|
Code_Defect
|
Fixed
|
Unknown
|
Assertion fault on VACUUM in an auto_vacuumed database.
|
| e9a9fde1f4 |
2010-02-16 11:00:22
|
Code_Defect
|
Fixed
|
Extensions
|
rtree module malfunctions if db page-size is changed
|
| 13336e9c3c |
2010-02-15 18:05:25
|
Code_Defect
|
Fixed
|
Unknown
|
ALTER TABLE RENAME fails to update foreign key references
|
| 985771e116 |
2010-02-15 16:55:27
|
Code_Defect
|
Fixed
|
Unknown
|
CREATE TRIGGER confused by TEMP/MAIN table name overlap
|
| 8905af11a0 |
2010-02-02 20:53:40
|
Code_Defect
|
Closed
|
Unknown
|
NOT NULL interferes with ON CONFLICT REPLACE
|
| b80eeab588 |
2010-01-26 01:26:13
|
Feature_Request
|
Fixed
|
Unknown
|
Respect custom page size for temp tables, indices, etc
|
| 1258875e07 |
2010-01-21 23:13:44
|
Code_Defect
|
Fixed
|
Unknown
|
Undefined collating sequence on LIKE causes segfault
|
| eb620916be |
2010-01-18 18:16:31
|
Code_Defect
|
Fixed
|
Shell
|
Shell doesn't print header if multiple statements on one line
|
| eb942c64a1 |
2010-01-13 13:24:21
|
Code_Defect
|
Fixed
|
Unknown
|
PRAGMA reverse_unordered_selects causes schema parse to fail
|
| f51d950180 |
2010-01-13 08:26:00
|
Compiler_Warning
|
Closed
|
Unknown
|
memset warning with gcc 4.3.3
|
| 360c6073e1 |
2010-01-07 15:17:33
|
Code_Defect
|
Fixed
|
Code_Generator
|
Aggregate MAX() function with COLLATE clause
|
| 0d676cd6e6 |
2009-12-30 12:42:11
|
Code_Defect
|
Closed
|
Code_Generator
|
Triggers: new/old.oid is interpreted as the IPK, even if there is another column "oid"
|
| 34d2ae1c6d |
2009-12-29 23:39:46
|
Code_Defect
|
Fixed
|
Unknown
|
Overloaded column named "ROWID" mishandled in triggers.
|
| eb5548a849 |
2009-12-24 16:01:52
|
Code_Defect
|
Fixed
|
Unknown
|
CAST in WHERE clause causes inconsistent query results
|
| 356c885b0b |
2009-12-17 22:18:22
|
Code_Defect
|
Fixed
|
Other
|
sqlite3_complete() should return 0 on empty string
|
| 31338dca7e |
2009-12-16 22:11:58
|
Code_Defect
|
Fixed
|
Unknown
|
OR operator in WHERE clause gives wrong answer when indexed
|
| f74beaabde |
2009-12-09 18:23:30
|
Code_Defect
|
Fixed
|
Code_Generator
|
Problem with 3-way joins and the USING clause
|
| ff44d82f3b |
2009-12-09 05:31:06
|
Code_Defect
|
Closed
|
Extensions
|
fts3ReallocOrFree and fts3InitVtab are not marked static
|
| 4abd1e4c00 |
2009-12-08 14:43:11
|
Documentation
|
Fixed
|
Documentation
|
omitted.html still says recursive triggers are not supported
|
| 78e04e52ea |
2009-12-08 14:34:50
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Assertion failure dropping table with zero length name
|
| abe728bbc3 |
2009-12-08 13:46:27
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
Crash committing multi-file transaction including temp file
|
| 97214a34d8 |
2009-12-01 14:32:00
|
Code_Defect
|
Fixed
|
VFS
|
Use of os2MutexNotheld before their definition
|
| 16fbf14cb2 |
2009-11-23 21:24:42
|
Code_Defect
|
Fixed
|
Unknown
|
Faulty VDBE code generated for certain third-party virtual tables
|
| 564d412f15 |
2009-11-20 18:51:24
|
Code_Defect
|
Fixed
|
Unknown
|
OOM on autovacuum of in-memory database causes problems.
|
| 3211d778c0 |
2009-11-16 20:59:45
|
Feature_Request
|
Closed
|
Unknown
|
replace function works on blobs
|
| e123bd2242 |
2009-11-16 13:24:31
|
Feature_Request
|
Closed
|
VFS
|
File handles aren't always immediately released on sqlite3_close
|
| 6b00e0a34c |
2009-11-16 12:51:04
|
Code_Defect
|
Fixed
|
Code_Generator
|
The great OP_If bug
|
| 702bbe755b |
2009-11-16 12:47:18
|
Code_Defect
|
Closed
|
Code_Generator
|
Invalid VDBE program built if ORDER BY used
|
| 29ab7be99f |
2009-11-16 12:43:18
|
Code_Defect
|
Fixed
|
Code_Generator
|
Hitting NOT NULL constraint does not roll back statement transaction
|
| 58a75d62e0 |
2009-11-16 12:42:07
|
Incident
|
Closed
|
Unknown
|
encoding failure
|
| 98f156c79b |
2009-11-16 12:41:06
|
Incident
|
Closed
|
Unknown
|
|
| 60f26ed786 |
2009-11-16 12:27:46
|
Code_Defect
|
Closed
|
Unknown
|
Empty Title
|
| f5cb008a65 |
2009-11-11 04:17:15
|
Code_Defect
|
Fixed
|
Shell
|
Shell silently ignores extra parameters
|
| aeff892c57 |
2009-11-10 17:07:53
|
Code_Defect
|
Fixed
|
Shell
|
-batch mode not creating DB in CLI
|
| f12a9eeedc |
2009-11-06 17:22:36
|
Code_Defect
|
Fixed
|
Shell
|
Shell command argument parsing is lax
|
| 0bf974bdf9 |
2009-11-06 04:15:47
|
Code_Defect
|
Fixed
|
Extensions
|
backup api asserts with zero length source file
|
| aad47726e9 |
2009-10-28 18:23:20
|
Feature_Request
|
Closed
|
Unknown
|
Generator of sqlite3UpperToLower[] and sqlite3CtypeMap[] for single lang
|
| d82e3f3721 |
2009-10-26 08:30:31
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
VACUUM corrupts database when MAIN and TEMP table names overlap.
|
| 2cb66577f6 |
2009-10-24 02:06:16
|
Code_Defect
|
Fixed
|
Shell
|
Diagnostic message is unintentionally printed in batch mode
|
| 6da68f691b |
2009-10-24 02:00:11
|
Code_Defect
|
Fixed
|
Shell
|
tables says you provide a like pattern but it adds % in code
|
| 3fe897352e |
2009-10-24 01:48:05
|
Code_Defect
|
Fixed
|
Unknown
|
Malformed UTF16 leads to a 2-byte buffer overread
|
| f80d443a3b |
2009-10-23 12:22:27
|
Documentation
|
Closed
|
B-Tree
|
pragma cache size doesn report actual size (min is 10)
|
| beb2dd69ad |
2009-10-23 01:27:32
|
Code_Defect
|
Fixed
|
Shell
|
do_meta_command inconsistent return values
|
| bd770b2c52 |
2009-10-23 00:37:10
|
Code_Defect
|
Fixed
|
Shell
|
shell doesn't return error exit code on import errors
|
| 7b61b6c6ce |
2009-10-22 21:27:32
|
Code_Defect
|
Fixed
|
Shell
|
insert mode is incorrectly converting text to numbers
|
| 72adc99de9 |
2009-10-22 21:27:19
|
Code_Defect
|
Fixed
|
Shell
|
shell mode insert doesn't output blobs as blobs
|
| dc3a6e5b31 |
2009-10-21 14:09:03
|
Code_Defect
|
Fixed
|
Shell
|
Shell doesn't htmlify column headers
|
| 6f8b0c5855 |
2009-10-21 13:50:42
|
Code_Defect
|
Fixed
|
Shell
|
Some minor genfkey fixups
|
| 39c85e8a4e |
2009-10-21 03:56:00
|
Code_Defect
|
Fixed
|
VFS
|
FormatMessage incorrectly used (Windows VFS)
|
| 89668ca167 |
2009-10-21 03:55:40
|
Feature_Request
|
Fixed
|
Shell
|
shell can support .timer on Windows
|
| 43db771bb2 |
2009-10-21 03:55:12
|
Code_Defect
|
Fixed
|
Shell
|
Sqlite shell prints some error messages to stdout
|
| 8440a8e22f |
2009-10-20 18:13:01
|
Code_Defect
|
Closed
|
Unknown
|
LENGTH & QUOTE stop at first zero
|
| f9af981dd2 |
2009-10-20 15:28:27
|
Documentation
|
Fixed
|
Documentation
|
sqlite3_shutdown documentation needs to mention danger
|
| 1751725cd6 |
2009-10-20 14:24:28
|
Documentation
|
Fixed
|
Documentation
|
sqlite_close doc should qualify advice
|
| 8d510499cc |
2009-10-20 13:27:15
|
Code_Defect
|
Closed
|
Parser
|
Repreparation errors are always returned as SQLITE_SCHEMA
|
| b73fb0bd64 |
2009-10-19 21:05:11
|
Code_Defect
|
Fixed
|
Unknown
|
Natural self-join defect
|
| 897b96d49d |
2009-10-19 11:43:27
|
Code_Defect
|
Deferred
|
Extensions
|
SQLITE_CANTOPEN when using journal_mode=persist and async IO
|
| 94c04eaadb |
2009-10-19 10:04:01
|
Code_Defect
|
Closed
|
Extensions
|
Crash in asyncRead() with large (>2GB) database file
|
| f777251dc7 |
2009-10-16 20:55:03
|
Code_Defect
|
Fixed
|
B-Tree
|
Assertion fault following ROLLBACK with running queries
|
| 5ee23731f1 |
2009-10-13 15:44:37
|
Code_Defect
|
Fixed
|
Virtual_Machine
|
assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements
|
| 8550ecca70 |
2009-10-07 23:43:40
|
Code_Defect
|
Fixed
|
VFS
|
findLockInfo uses memcmp on non-zeroed, = assigned struct
|
| 668fe22637 |
2009-09-29 18:26:41
|
Feature_Request
|
Closed
|
Parser
|
pragma table_info doesn't accept database names
|
| cff1a52937 |
2009-09-26 14:20:52
|
Code_Defect
|
Closed
|
Unknown
|
sqlite3_get_table() returns wrong result when using where clause
|
| d77ffcd7a5 |
2009-09-26 13:57:05
|
Code_Defect
|
Closed
|
Shell
|
Memory leak on failing INSERT statements on tables with UNIQUE INDEX
|
| 860d129c15 |
2009-09-25 10:35:42
|
Build_Problem
|
Closed
|
Unknown
|
builds with sqlite 3.6.18 depends on tchsh
|
| f7e3d17a34 |
2009-09-25 02:01:35
|
Support_Request
|
Closed
|
Unknown
|
Memory accumulate without commit
|
| 4a03edc4c8 |
2009-09-24 18:42:02
|
Code_Defect
|
Fixed
|
Code_Generator
|
Index corruption following aggressive use of ON CONFLICT clause.
|
| c9394a56c7 |
2009-09-24 12:25:43
|
Support_Request
|
Closed
|
Parser
|
Sqlite reading all column data on selects.
|
| 0bc616a2c8 |
2009-09-22 13:32:09
|
Build_Problem
|
Closed
|
Other
|
In wince 6.0, I can not compile sqlite.
|
| a8b1e82b8f |
2009-09-22 13:00:57
|
Code_Defect
|
Closed
|
Unknown
|
CAST failing for numeric
|
| 56928bd084 |
2009-09-21 16:34:44
|
Build_Problem
|
Closed
|
Utilities
|
Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2
|
| c472df6c1c |
2009-09-21 16:14:51
|
Code_Defect
|
Closed
|
Unknown
|
Segmentation fault by instead of insert triggers
|
| 1ff6d29030 |
2009-09-21 16:08:20
|
Build_Problem
|
Closed
|
Utilities
|
Compile fails with SQLITE_OMIT_TRIGGER
|
| f76cabebfd |
2009-09-17 21:22:06
|
Feature_Request
|
Closed
|
Extensions
|
xBestIndex/xFilter slight interface improvement
|
| e25d9ea771 |
2009-09-17 00:47:07
|
Code_Defect
|
Fixed
|
Unknown
|
Cascading delete trigger fails.
|
| 832b2f3e6e |
2009-09-16 12:10:09
|
Code_Defect
|
Closed
|
Unknown
|
integrity_check error after backup restore
|
| 127c1c42ff |
2009-09-15 12:30:45
|
Build_Problem
|
Closed
|
Makefile
|
Build error "C compiler cannot create executables" on debian lenny host
|
| a696379c1f |
2009-09-15 00:03:19
|
Code_Defect
|
Fixed
|
Unknown
|
Access violation error trying to insert into triggered view
|
| 03b198a2fa |
2009-09-14 16:50:08
|
Compiler_Warning
|
Fixed
|
VFS
|
Getting several warnings when compiling in eVC++ 4
|
| 806f3be2d7 |
2009-09-14 15:35:28
|
Feature_Request
|
Closed
|
B-Tree
|
Proposal to inline some functions
|
| 8c743979c2 |
2009-09-12 16:29:19
|
Code_Defect
|
Closed
|
Unknown
|
SQLite version correction on LIKE operator + ORDER BY bug I reported earlier today
|
| 9a502b7a35 |
2009-09-12 04:06:08
|
Documentation
|
Fixed
|
Unknown
|
datetime function has year 54079 bug
|
| 65bbb65a47 |
2009-09-11 18:04:37
|
Build_Problem
|
Fixed
|
Unknown
|
'configure' file without +x permission in sqlite-3.6.18.tar.gz tarball
|
| 4b81075908 |
2009-09-09 14:31:32
|
Code_Defect
|
Closed
|
Unknown
|
In mult-thread that have a problem of updata lost
|
| 9fd0bc3663 |
2009-09-09 14:26:04
|
Feature_Request
|
Fixed
|
Unknown
|
Add a new open flag to enable shared cache for a single db connection
|
| 3350da7d35 |
2009-09-09 12:50:52
|
Code_Defect
|
Closed
|
Unknown
|
Error: malformed database schema - near "VIRTUAL": syntax error
|
| df2c3ad12a |
2009-09-07 14:43:17
|
Code_Defect
|
Fixed
|
Extensions
|
free() on unallocated memory when fts3 match phrase contains terms after "-" modifier
|
| cbb5a315df |
2009-09-06 00:56:01
|
Feature_Request
|
Closed
|
Parser
|
Concatenating strings should be possible with a plus '+' operator
|
| 2ea2425d34 |
2009-09-03 01:26:42
|
Code_Defect
|
Fixed
|
Code_Generator
|
Assertion fault: Text encoding mismatch on value comparison
|
| 44a1b817c3 |
2009-09-01 15:23:50
|
Incident
|
Closed
|
Unknown
|
Problem with Kaspersky Anti-Virus and SQLite
|
| d2b46cfc75 |
2009-08-24 12:17:14
|
Code_Defect
|
Closed
|
Pager
|
sqlite3BitvecClear will clear all bit in aHash when iSize>BITVEC_NBIT
|
| efc02f9779 |
2009-08-24 01:37:18
|
Code_Defect
|
Fixed
|
Unknown
|
Trigger creation order affects query correctness
|
| fc6f41426b |
2009-08-21 08:37:23
|
Incident
|
Closed
|
Unknown
|
update primary key failure
|
| 92c5deed07 |
2009-08-19 15:22:53
|
Code_Defect
|
Closed
|
Extensions
|
FTS3 bug with multiple terms for exclusion
|
| 93fb9f89d6 |
2009-08-19 15:21:05
|
Code_Defect
|
Fixed
|
Code_Generator
|
Index causes incorrect WHERE clause evaluation
|
| 2d401a9428 |
2009-08-18 16:13:02
|
Code_Defect
|
Fixed
|
Unknown
|
Segfault on unknown SQL function
|