SQLite Forum

Timeline
Login

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

50 events by user drh occurring around 2021-04-05 12:33:37.

2021-04-19
11:51 Reply: SQLite doesn't use indexes for bitwise clauses? artifact: e27ae565f5 user: drh
2021-04-15
21:19 Reply: Question About Command Line Backup of Locked DB artifact: a252371d80 user: drh
12:09 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: f8941a24a8 user: drh
12:07 Reply: programming sqlite bytecode directly ? artifact: 7313ba5cb6 user: drh
2021-04-14
14:03 Reply: usage of SHA-1 artifact: d225ef5b13 user: drh
2021-04-13
23:44 Edit reply: Regression: Mixing AND with OR results in no rows returned artifact: 9cb906da7f user: drh
18:43 Reply: Regression: Mixing AND with OR results in no rows returned artifact: d36426225c user: drh
18:25 Edit reply: Regression: Mixing AND with OR results in no rows returned artifact: d23189d7c0 user: drh
2021-04-12
11:34 Reply: How to get the last row_id in a table without inserting anything artifact: a1cfd66c76 user: drh
11:31 Reply: find in b+-tree node artifact: b303800549 user: drh
11:26 Reply: UNION Sorts on First Field artifact: 3b5f4b47a7 user: drh
2021-04-10
20:16 Edit reply: order of INSERT affects the output artifact: 25aa4c922b user: drh
20:08 Reply: order of INSERT affects the output artifact: af82695760 user: drh
2021-04-07
22:22 Reply: Query triggers Segmentation Fault artifact: 5c67692e78 user: drh
14:31 Reply: segfault in sqlite3 (3.35.4) artifact: d9fce1a89b user: drh
01:28 Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 35ae1aabfd user: drh
00:05 Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 42aa1084fe user: drh
2021-04-06
23:33 Reply: Extra values outputted, with Partial Index and DISTINCT constraints applied artifact: aeb94dc8a1 user: drh
17:11 Reply: Growing WAL-File artifact: 8b3260059a user: drh
13:25 Reply: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: 24768f1c8f user: drh
10:14 Reply: Lemon - Unexpected frees artifact: a541bbce8c user: drh
2021-04-05
19:24 Reply: issue with fossil in source code README.md artifact: 3e886eac4f user: drh
16:52 Reply: Views with UNION ALL artifact: d0e459fc3d user: drh
12:34 Edit reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: b1a4a2852e user: drh
12:33 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 57b2db7195 user: drh
2021-04-02
16:31 Reply: Command Line Shell set parameter as date artifact: 0aeaf586ce user: drh
16:30 Edit: Command Line Shell set parameter as date artifact: d063c04504 user: drh
2021-04-01
11:14 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 291e6dedac user: drh
2021-03-31
23:57 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: f594815f94 user: drh
16:17 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 85aef8bc01 user: drh
2021-03-30
22:30 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 12517fa2be user: drh
14:30 Reply: What is the point of a lone SELECT statement in an SQLite trigger? artifact: c0381ab451 user: drh
02:02 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 6fa9839334 user: drh
00:54 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 7dbf046041 user: drh
2021-03-25
13:02 Reply: R*Tree table constraints artifact: 7d06015a9e user: drh
13:01 Reply: Database Independent Queries artifact: 9f8e6f923c user: drh
13:00 Reply: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: ede3a9b22f user: drh
12:43 Reply: CVE-2021-20227 / Flaw in SQLite's Select Query functionality artifact: 30497fb626 user: drh
2021-03-24
11:07 Reply: Maybe fossil problem ? artifact: b18fe14da3 user: drh
11:05 Reply: 3.25 math functions vs. extension-functions.c artifact: 06eec0a736 user: drh
2021-03-23
12:30 Edit reply: Strange CLI .exit issue artifact: 415b921383 user: drh
12:29 Reply: Strange CLI .exit issue artifact: a002b17ac0 user: drh
2021-03-22
12:40 Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 60ce420d42 user: drh
12:09 Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 16c9a950ae user: drh
2021-03-21
18:25 Reply: Bug? Inside sqlite3CreateIndex. Maybe there is an incorrect code to move all REPLACE indexes to the end of the list. artifact: 95d105b4bc user: drh
13:17 Edit: Bug? Inside sqlite3CreateIndex. Maybe there is an incorrect code to move all REPLACE indexes to the end of the list. artifact: ceb51d83f7 user: drh
2021-03-19
17:59 Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 50695123e7 user: drh
15:12 Reply: Bug ? Same query that works in shell produces constraint violation when run by a C program with sqlite3_{prepare,bind,step} artifact: 88e2bfa443 user: drh
2021-03-18
16:58 Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 6e2b05ad62 user: drh
2021-03-17
18:59 Reply: sqlite 3.35 stalls tracker-miner-fs-3 artifact: 737cf80ece user: drh