SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

190 ticket changes by user mrigger

2022-02-01
15:23 New ticket [bd375c20] Potential bug in FTS5. (artifact: 4232ec86 user: mrigger)
2020-10-03
15:44 New ticket [e33ee625] Segfault using a CROSS JOIN on a table using the experimental trigram tokenizer. (artifact: 3b682278 user: mrigger)
2020-10-02
21:16 New ticket [95302bdb] WHERE clause that uses a NUMERIC cast influences the result type. (artifact: bd7d181b user: mrigger)
20:44 New ticket [2ba5930b] Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer. (artifact: 851e0fc3 user: mrigger)
20:04 New ticket [0f586dbe] FTS4 integrity-check fails for UTF16 encoding. (artifact: 7cccafc7 user: mrigger)
2020-10-01
11:35 New ticket [2d5a3163] Segmentation fault in CROSS JOIN and the rtree extension. (artifact: 2ee12a62 user: mrigger)
2020-09-30
17:18 New ticket [5c4e7aa7] Incorrect result for comparison with NULL. (artifact: c71d1ae4 user: mrigger)
12:47 New ticket [66e4b0e2] Incorrect result for LEFT JOIN. (artifact: 2d62d647 user: mrigger)
2020-08-26
14:12 New ticket [be31cf00] Unexpected result for % and '1E1'. (artifact: 3102412d user: mrigger)
2020-08-24
08:17 New ticket [f3ff1472] Incorrect result for IN expression with right-hand IS TRUE sub-expression. (artifact: 009010c0 user: mrigger)
2020-04-25
08:52 New ticket [45f4bf4e] UNION operator malfunctions in LEFT JOIN on view. (artifact: 5b488139 user: mrigger)
2020-03-10
09:33 New ticket [e0c2ad1a] GROUP BY causes unexpected conversion. (artifact: 08bec9f5 user: mrigger)
2020-03-05
16:37 New ticket [fa146dcf] Unexpected result for MIN on string that contains a null character. (artifact: 33ec6402 user: mrigger)
2020-03-04
22:56 New ticket [1b8d7264] MAX yields unexpected result for UTF-16. (artifact: f1ec275c user: mrigger)
2020-02-28
14:49 New ticket [e63b4d1a] Query on rtree unexpectedly yields 0 rather than 0.0. (artifact: 5e3591cf user: mrigger)
2020-01-29
10:10 Ticket [1dc432db] FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding status still Open with 3 other changes (artifact: 68d922e4 user: mrigger)
2020-01-08
10:37 New ticket [9eda2697] Incorrect result for COUNT(), UTF16be encoding and SUBSTR. (artifact: d39be4d2 user: mrigger)
2020-01-07
21:41 New ticket [82ac75ba] Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition. (artifact: f92e43ea user: mrigger)
2020-01-04
20:07 Ticket [a3713a5f] DBSTAT query computes incorrect result for stat.aggregate = 1 condition status still Closed with 3 other changes (artifact: c646048c user: mrigger)
19:26 Ticket [a3713a5f]: 3 changes (artifact: 2f01fa87 user: mrigger)
18:51 New ticket [a3713a5f]. (artifact: 57f82aaf user: mrigger)
16:09 New ticket [74a4c386] DBSTAT query computes incorrect result for name column. (artifact: 9d42cfce user: mrigger)
11:22 New ticket [727074e2] DBSTAT query computes incorrect result for aggregate column. (artifact: c7bce00a user: mrigger)
2020-01-01
22:29 New ticket [771fe617] FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR. (artifact: a3dd00c0 user: mrigger)
2019-12-31
21:57 New ticket [46fcd700] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed (2). (artifact: 78d95b91 user: mrigger)
10:12 Ticket [a0e88d8d] Inconsistent handling of subqueries in index expressions status still Open with 3 other changes (artifact: 9ba36ec0 user: mrigger)
2019-12-30
21:32 New ticket [a0e88d8d]. (artifact: ef13ac13 user: mrigger)
21:01 New ticket [892575cd] Debug assertion codeVectorCompare: Assertion `0' failed. (artifact: abf9d81f user: mrigger)
10:42 New ticket [7c0e06b1] NATURAL JOIN on virtual table results in "parse error in rank function". (artifact: 39d9de70 user: mrigger)
2019-12-29
17:14 New ticket [314cc133] Trigger on normal table causes the database disk image to become malformed. (artifact: 8d33e67d user: mrigger)
2019-12-27
22:11 New ticket [de4b0414] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed. (artifact: 26b61d4b user: mrigger)
20:51 New ticket [5fbc159e] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed. (artifact: b481e01e user: mrigger)
19:39 New ticket [36ffedcb] Debug assertion exprSrcCount: Assertion `0' failed. (artifact: 2e9f813b user: mrigger)
17:06 New ticket [37823501] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMempOp->p1)' failed.. (artifact: dbba73b4 user: mrigger)
11:08 New ticket [1dc432db] FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding. (artifact: 8029c858 user: mrigger)
00:26 New ticket [fb3b3024] Debug assertion assert_pager_state: Assertion `pPager->changeCountDone==0 || pPager->eLock>=RESERVED_LOCK' failed. (artifact: ea6d8c54 user: mrigger)
2019-12-26
22:44 New ticket [7c13db5c] Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed. (artifact: 0d7b74bc user: mrigger)
18:50 New ticket [ec8abb02] Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed. (artifact: cc3e141d user: mrigger)
2019-12-25
00:39 New ticket [d87336c8] Debug assertion sqlite3TableColumnAffinity: Assertion `iCol<pTab->nCol' failed.. (artifact: f12666a7 user: mrigger)
2019-12-24
23:26 New ticket [167b2aac] Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed. (artifact: 332c48da user: mrigger)
19:09 New ticket [752fdbf6] FTS database disk image is malformed for UTF-16 encoding and integrity check. (artifact: d933cba9 user: mrigger)
14:42 New ticket [df46a6f3] Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed. (artifact: a5edb195 user: mrigger)
2019-12-23
23:33 New ticket [cafeafe6] UPDATE with complex WHERE condition on rtree results in "database table is locked" error. (artifact: 8d3ce163 user: mrigger)
23:19 New ticket [b383b902] Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2). (artifact: ae0b5684 user: mrigger)
22:04 New ticket [d62981b7] FTS database disk image is malformed for special characters in table. (artifact: 9625949d user: mrigger)
20:03 New ticket [5eadca17] Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed. (artifact: 736d6825 user: mrigger)
13:36 New ticket [dfd66334] Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed. (artifact: e9d255c9 user: mrigger)
09:35 New ticket [3ab4a9f0] Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed. (artifact: 9719e574 user: mrigger)
00:08 New ticket [9d708e47] Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2). (artifact: 45ad4081 user: mrigger)
2019-12-22
23:43 New ticket [0911b5d1] Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed. (artifact: e85cfad5 user: mrigger)
23:06 Ticket [c62c5e58] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed (2) status still Open with 6 other changes (artifact: d2e6a4e7 user: mrigger)
23:05 New ticket [c62c5e58]. (artifact: f2e35331 user: mrigger)
21:53 New ticket [188f912b] Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed. (artifact: e375f380 user: mrigger)
17:53 New ticket [d9ed4ebe] SELECT on window function causes a segfault. (artifact: 87e12b7d user: mrigger)
17:09 New ticket [1b06916e] Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed. (artifact: 9911eeb5 user: mrigger)
10:47 New ticket [f00d096c] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed. (artifact: eab34638 user: mrigger)
10:26 New ticket [5ad2aa69] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed. (artifact: e3743aaf user: mrigger)
10:16 New ticket [7929c1ef] Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJoinTable!=pSrc->iCursor || pLoop->prereq!=0' failed. (artifact: ae5fa47a user: mrigger)
09:48 New ticket [b0cb8aff] Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed. (artifact: f6637b64 user: mrigger)
09:34 New ticket [9cb7d0ef] Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed. (artifact: 7a458c2a user: mrigger)
2019-12-21
23:28 Ticket [56a74875] UPDATE causes "database table is locked" for rtree table status still Closed with 3 other changes (artifact: 33d56bf5 user: mrigger)
13:35 Ticket [56a74875]: 3 changes (artifact: f255e4e2 user: mrigger)
2019-12-20
22:18 New ticket [cd3311e3] FTS database disk image is malformed for update on languageid. (artifact: beaa2f54 user: mrigger)
17:03 New ticket [e431c355] FTS database disk image is malformed for UTF-16 encoding. (artifact: f0d87f64 user: mrigger)
15:54 New ticket [e0a81205] Incorrect result for BETWEEN and generated column. (artifact: adb801d0 user: mrigger)
2019-12-19
23:08 New ticket [56a74875] UPDATE causes "database table is locked" for rtree table. (artifact: 9a7f78da user: mrigger)
2019-12-16
12:59 New ticket [3b84b429] LEFT JOIN malfunctions with generated column. (artifact: 73baa93d user: mrigger)
2019-12-14
16:37 New ticket [b439bfcf] REINDEX segfaults on table with generated columns. (artifact: c94b851f user: mrigger)
2019-12-11
18:06 New ticket [cf36cb4e] FTS database disk image is malformed for UTF-16 encoding after update. (artifact: 2faceff9 user: mrigger)
2019-12-09
21:40 New ticket [d7c3f125] REINDEX results in "UNIQUE constraint failed" for generated column. (artifact: 079c19d2 user: mrigger)
2019-12-08
00:23 New ticket [bd8c2806] PRAGMA integrity_check does not terminate on table with generated column. (artifact: 1f693d5e user: mrigger)
2019-12-07
14:11 New ticket [b92e5e8e] Query on table without rows and generated column results in "out of memory" error. (artifact: bb5affde user: mrigger)
11:12 Ticket [8bf76328] NOT NULL auxiliary column in rtree table malfunctions status still Fixed with 3 other changes (artifact: 72e38425 user: mrigger)
2019-12-06
11:17 New ticket [367a86e2] Incorrect result for predicate on rtree table. (artifact: 3c5c1528 user: mrigger)
09:39 Ticket [8bf76328] NOT NULL auxiliary column in rtree table malfunctions status still Fixed with 3 other changes (artifact: 4a116ea8 user: mrigger)
00:15 New ticket [8bf76328]. (artifact: 8ae69a63 user: mrigger)
2019-12-05
23:06 New ticket [aa573a78] Comparison on INT column in rtree table malfunctions. (artifact: 14375ff9 user: mrigger)
15:08 New ticket [f096d191] Row value comparison malfunctions with rtree table. (artifact: 6a830c85 user: mrigger)
14:20 New ticket [9fe487ba] Join on two rtree tables malfunctions. (artifact: 063de6e7 user: mrigger)
08:12 New ticket [30e2c183] column = NULL predicate evaluates to TRUE for rtree table. (artifact: a39e83af user: mrigger)
2019-12-04
22:53 New ticket [a55ab6d9] Incorrect result for TEXT comparison on rtree table. (artifact: c51da103 user: mrigger)
2019-11-30
17:51 New ticket [7f39060a] LEFT JOIN malfunctions with partial ISNULL index. (artifact: 302b34f7 user: mrigger)
2019-11-07
21:58 New ticket [7e59041f] DISTINCT malfunctions for VIEW with virtual table. (artifact: 3f8b5e74 user: mrigger)
10:12 New ticket [302027ba] VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column. (artifact: c77ece6b user: mrigger)
2019-11-06
23:10 New ticket [299b50ba] UPDATE on table with two generated columns and CHECK clause results in segfault. (artifact: 627b5554 user: mrigger)
15:41 New ticket [4fc08501] Segfault when inserting into table with generated columns. (artifact: 73daa54f user: mrigger)
15:16 New ticket [ce22a077] NULL WHERE condition unexpectedly results in row being fetched. (artifact: b13b7dce user: mrigger)
2019-11-05
22:31 New ticket [2399f598] REPLACE on table with generated NOT NULL column results in segfault. (artifact: c677a2c3 user: mrigger)
2019-11-04
21:30 New ticket [1cda8f4b] UNLIKELY in query causes row to not be fetched. (artifact: 8a94f363 user: mrigger)
2019-11-03
10:51 New ticket [02aa2bd0] Row value comparison malfunctions on view with left join. (artifact: 0d1dbe84 user: mrigger)
10:06 New ticket [3c9eadd2] PRAGMA integrity_check fails due to CHECK constraint even without records. (artifact: d58c01a9 user: mrigger)
2019-11-02
21:41 New ticket [623eff57] LEFT JOIN in view malfunctions with partial index on table. (artifact: 4a276959 user: mrigger)
08:22 New ticket [a9efb428] Incorrect result for GLOB operator. (artifact: 003e557e user: mrigger)
2019-11-01
08:00 New ticket [c28a01da] REPLACE causes segfault in table with generated column and foreign key. (artifact: baaa9dac user: mrigger)
2019-10-31
20:02 New ticket [b9befa4b] Segfault in table with generated column and foreign key. (artifact: 99d2ef1d user: mrigger)
09:42 New ticket [1d2a8efc] VACUUM on table with generated column that uses TYPEOF results in an error. (artifact: c4ece77a user: mrigger)
2019-10-29
09:24 New ticket [6484e6ce] VACUUM on table with generated column results in an error. (artifact: d41ad93d user: mrigger)
2019-10-28
22:13 New ticket [9621dd78] Segfault when updating table with generated columns. (artifact: 56e5d65e user: mrigger)
21:48 New ticket [166347c6] VACUUM issue on table with generated column. (artifact: 40b5189a user: mrigger)
2019-10-27
21:29 New ticket [91e86951] Segfault in table with generated columns. (artifact: 2061749a user: mrigger)
2019-10-26
21:26 Ticket [3ea17551] REINDEX causes "UNIQUE constraint failed" error for generated column status still Open with 3 other changes (artifact: bc78fd24 user: mrigger)
20:05 New ticket [3ea17551]. (artifact: b5cefca8 user: mrigger)
2019-10-25
08:28 New ticket [c1e19e12] Trigger causes query to compute incorrect result. (artifact: 2c9ab766 user: mrigger)
2019-10-24
19:44 New ticket [dd1f67bf] FTS integrity-check malfunctions nondeterministically with tokenize="ascii". (artifact: c0870c48 user: mrigger)
2019-10-23
16:46 New ticket [135c9da7] Comparison of row values with COLLATE NOCASE yields incorrect result. (artifact: ad3f184c user: mrigger)
2019-10-22
14:05 New ticket [6ef984af] Row value comparison yields incorrect result. (artifact: eb28040c user: mrigger)
10:43 Ticket [b47e3627] Comparison of row values results in incorrect result status still Fixed with 3 other changes (artifact: e283b6c1 user: mrigger)
2019-10-21
14:45 New ticket [b47e3627]. (artifact: fe31e259 user: mrigger)
11:26 New ticket [7fc8e5ff] INSERT into table with two triggers does not terminate. (artifact: db71d36d user: mrigger)
2019-10-17
13:56 New ticket [bf1aab89] FTS merge does not terminate. (artifact: 45345701 user: mrigger)
2019-10-16
13:18 New ticket [a8a4847a] Trigger inserts duplicate value in UNIQUE column. (artifact: 89dcc9a0 user: mrigger)
2019-10-10
22:22 New ticket [745f1abc] FTS integrity-check malfunctions for transaction and the prefix option. (artifact: c1f4fe86 user: mrigger)
21:47 New ticket [8a6fa2bb] FTS order=DESC results into integrity-check failing. (artifact: 1dabaa83 user: mrigger)
14:12 New ticket [c3103404] LEFT JOIN in view malfunctions with NOTNULL. (artifact: d51a8696 user: mrigger)
2019-10-09
21:28 New ticket [278ac142] FTS integrity_check fails when inserting x'00'. (artifact: fc89d33d user: mrigger)
20:33 New ticket [a976c487] LEFT JOIN in view malfunctions. (artifact: fea9a0bf user: mrigger)
17:21 New ticket [d392017c] FTS rebuild in combination with crisismerge results in error "database or disk is full". (artifact: 6582ea5b user: mrigger)
2019-10-08
17:33 New ticket [81a7f7b9] FTS integrity-check indicates that the database disk image is malformed. (artifact: e06f66e4 user: mrigger)
2019-10-07
21:07 New ticket [e258f008] FTS rebuild in transaction causes integrity-check to fail. (artifact: b0e44822 user: mrigger)
19:26 Ticket [265e935b] FTS pgsz option results in "database disk image is malformed" error status still Open with 6 other changes (artifact: 25127031 user: mrigger)
19:25 New ticket [265e935b]. (artifact: 8c4f9d9c user: mrigger)
2019-10-05
23:29 New ticket [8fe768e9] FTS integrity-check malfunctions. (artifact: ee642012 user: mrigger)
21:09 New ticket [b2d4edaf] Comparison on view malfunctions. (artifact: 8a9e27d7 user: mrigger)
2019-09-16
19:25 New ticket [587791f9] Row is not fetched when using WHERE clause with INSTR(). (artifact: aff07e7c user: mrigger)
2019-09-10
19:07 New ticket [c4130c33] DISTINCT malfunctions for VIEW. (artifact: 183f1b7c user: mrigger)
2019-09-09
21:02 New ticket [18458b1a] COLLATE issue in view. (artifact: 54e5ff4c user: mrigger)
2019-09-07
18:51 New ticket [a7debbe0] BETWEEN issue in view. (artifact: fea928c9 user: mrigger)
2019-09-03
18:23 New ticket [0f042809] GLOB unexpectedly does not match. (artifact: 6afdb361 user: mrigger)
08:25 New ticket [767a8cbc] COLLATE NOCASE string comparison yields incorrect result. (artifact: b41bd360 user: mrigger)
2019-09-02
19:22 New ticket [29f635e0] IS NULL unexpectedly evaluates to TRUE. (artifact: 34ebd7c7 user: mrigger)
2019-09-01
18:44 New ticket [2841e99d] Different rounding when converting TEXT to REAL. (artifact: 08df019d user: mrigger)
16:02 New ticket [57af00b6] Expression computed on row yields incorrect result. (artifact: ece608d0 user: mrigger)
2019-08-31
06:17 New ticket [d6a0fbc1] REINDEX causes "UNIQUE constraint failed" error when using TRIGGER. (artifact: 32d2e31d user: mrigger)
2019-08-30
20:28 New ticket [40812aea] Incorrect result for comparison of large number. (artifact: 8188b7b4 user: mrigger)
19:41 New ticket [5a3dba81] REINDEX causes "UNIQUE constraint failed" error. (artifact: a6172ac6 user: mrigger)
15:43 New ticket [f8f472cb] Partial index and BETWEEN issue. (artifact: bac71624 user: mrigger)
14:33 New ticket [fba33c8b] Partial index causes row to not be fetched in BETWEEN expression. (artifact: aa648476 user: mrigger)
11:33 New ticket [a6408d42] Partial index causes row to not be fetched. (artifact: ba5257e3 user: mrigger)
2019-08-29
13:46 New ticket [c0390363] Indexes causes row to not be fetched. (artifact: c8904367 user: mrigger)
2019-08-28
21:11 New ticket [51f5b6e4] Short-circuit evaluation issue. (artifact: 4fa98dbf user: mrigger)
2019-08-27
15:14 New ticket [dbaf8a68] Unexpected affinity conversion is performed for the IN operator. (artifact: 8542c61f user: mrigger)
2019-08-22
14:34 New ticket [7e07a3db] LIKELY() seems to cause unexpected affinity conversion for rowid. (artifact: ea40e09c user: mrigger)
09:44 New ticket [ac184eb5] Row with comparison on TEXT UNIQUE column is not fetched. (artifact: d99f1ffe user: mrigger)
2019-08-21
21:34 New ticket [d9f584e9] Row is not fetched in table with INTEGER PRIMARY KEY. (artifact: d7eaf033 user: mrigger)
11:50 New ticket [b8689402] DISTINCT malfunctions for IS NULL. (artifact: c70c47e7 user: mrigger)
2019-08-20
09:29 New ticket [f043b113] INDEXED BY results in row not being fetched. (artifact: 54e1cf0a user: mrigger)
2019-08-17
18:05 New ticket [c7a11719] WHERE clause erroneously influences value of fetched column from view. (artifact: a07a8bac user: mrigger)
14:43 New ticket [6710d2f7] LEFT JOIN fails to fetch row. (artifact: afe2e244 user: mrigger)
2019-08-14
19:47 New ticket [17db54d7] Unexpected error in DELETE with existing trigger. (artifact: f06e8c9d user: mrigger)
2019-08-09
23:00 New ticket [9080b622] Constant expression in partial index results in row not being fetched. (artifact: af49a21f user: mrigger)
2019-08-07
20:20 New ticket [f8a7060e] Incorrect result for query that uses MIN() and a CAST on rowid. (artifact: 99392c9c user: mrigger)
2019-08-06
20:43 New ticket [0a5e2c1d] Unexpected affinity conversion for view column in IN operator. (artifact: 4bce8b02 user: mrigger)
2019-08-05
21:56 New ticket [9f66f887] EXPLAIN PRAGMA executes PRAGMA. (artifact: 6c982a95 user: mrigger)
15:09 New ticket [61c85385] Row is not fetched in SELECT from VIEW. (artifact: 82f66d84 user: mrigger)
11:27 New ticket [d52a29a9] Unexpected affinity conversion in view. (artifact: c86e9f56 user: mrigger)
2019-08-02
22:32 New ticket [71e183ca] MIN() malfunctions for a query with ISNULL condition. (artifact: cb71fa4f user: mrigger)
16:11 New ticket [41866dc3] MIN() malfunctions for UNIQUE column. (artifact: 467863cb user: mrigger)
2019-07-29
22:42 New ticket [ced41c7c] Query with DISTINCT does not fetch all distinct rows. (artifact: 538cb2f4 user: mrigger)
09:28 New ticket [ccbe5759] ANALYZE causes DISTINCT to malfunction in CROSS JOIN. (artifact: 6749cb3c user: mrigger)
2019-07-28
22:32 New ticket [ba2f4585] Query with ORDER BY results in "database disk image is malformed" error. (artifact: be412e84 user: mrigger)
21:53 New ticket [18ab5da2] Issue with DISTINCT and COLLATE. (artifact: dd9a82ec user: mrigger)
2019-06-15
21:41 New ticket [e1e07ef2] COLLATE in BETWEEN expression is ignored. (artifact: 1c102a81 user: mrigger)
2019-06-14
11:03 New ticket [f1580ba1] Row is not fetched in WITHOUT ROWID table and a composite primary key. (artifact: 253e38a4 user: mrigger)
10:01 New ticket [ce8717f0] LIKE malfunctions for UNIQUE COLLATE NOCASE column. (artifact: 81eff856 user: mrigger)
2019-06-12
15:37 New ticket [b148fa61] CAST takes implicit COLLATE of its operand. (artifact: 985e96ae user: mrigger)
14:12 Ticket [674385ae] CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 status still Open with 3 other changes (artifact: e0c5eb96 user: mrigger)
12:58 New ticket [674385ae]. (artifact: 5ea2d3c3 user: mrigger)
12:41 New ticket [4d01eda8] IS TRUE operator malfunctions with COLLATE and REAL value. (artifact: 9726435c user: mrigger)
2019-06-11
19:24 New ticket [0c620df6] LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities. (artifact: f0e85800 user: mrigger)
14:06 New ticket [afdc5a29] Lossless conversion when casting a large TEXT number to NUMERIC is not performed. (artifact: 446e6ab3 user: mrigger)
11:50 New ticket [57353f82] COLLATE expression in the right side of an IN operator results in an affinity conversion. (artifact: 0e9aa5fa user: mrigger)
09:47 New ticket [1819598c] -'1.0' computes -1.0 rather than -1. (artifact: 20490a7c user: mrigger)
2019-06-10
21:58 Open ticket [533010b8]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: f065e4ab user: mrigger)
20:46 New ticket [d60b3cd7] COLLATE expression has an affinity. (artifact: 17666839 user: mrigger)
19:53 New ticket [412bba9b] CAST('.' AS NUMERIC) computes 0.0 rather than 0. (artifact: 27de8237 user: mrigger)
18:15 New ticket [533010b8] Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()". (artifact: 0aff6c3f user: mrigger)
11:28 New ticket [b1d8c793] LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column. (artifact: 899d46d1 user: mrigger)
00:14 New ticket [fd76310a] TEXT value interpreted as column name in an index with empty list in an IN expression. (artifact: 683171cb user: mrigger)
2019-06-08
21:31 New ticket [dd6bffbf] CAST to NUMERIC no longer converts to INTEGER. (artifact: f550c0f0 user: mrigger)
2019-05-26
09:53 New ticket [e8bedb2a] Incorrect result when subtracting a large integer number from a TEXT value. (artifact: 15289795 user: mrigger)
2019-05-25
10:06 New ticket [4c2d7639] CAST('-' AS NUMERIC) computes 0.0. (artifact: 25245da4 user: mrigger)
2019-05-21
10:20 Ticket [b5ca442a] "Malformed database schema" when creating a failing index within a transaction status still Open with 6 other changes (artifact: eba0221d user: mrigger)
10:04 New ticket [b5ca442a]. (artifact: 329bdfc0 user: mrigger)
2019-05-20
11:07 Ticket [d3e7f2ba] Nested boolean formula with IN operator computes an incorrect result status still Open with 3 other changes (artifact: b9e29307 user: mrigger)
2019-05-19
18:23 New ticket [d3e7f2ba]. (artifact: 972faf8c user: mrigger)
17:01 Ticket [787fa716] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes (artifact: 929aa109 user: mrigger)
09:44 New ticket [9b78184b] Index on non-existing column results in a fabricated value being fetched. (artifact: e26938aa user: mrigger)
2019-05-18
21:22 Ticket [787fa716] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes (artifact: fe9414e3 user: mrigger)
2019-05-17
12:48 New ticket [f4ec2509] Malformed image when using no journal mode, zero cache size, and failing when creating an index.. (artifact: 7c739489 user: mrigger)
2019-05-16
17:52 New ticket [3c27b97e] REAL rounding seems to depend on FROM clause. (artifact: e97acd84 user: mrigger)