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