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)==(jnSkip)' 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 `iColnCol' 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[] and sqlite3CtypeMap[] 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