SQLite Forum

Timeline
Login

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

50 events by user drh occurring around 2021-04-10 20:16:46.

2021-04-26
14:05 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 5b83b5c921 user: drh
14:00 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 123490e95b user: drh
12:38 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 25bd73d320 user: drh
2021-04-24
13:48 Reply: Getting error when pipe sql into sqlite3 utility artifact: b5a93aeb49 user: drh
10:58 Reply: Different results in SELECT DISTINCT artifact: 5ca5ad9aa9 user: drh
2021-04-23
13:11 Reply: sqlite.org/draft shows the same data as sqlite.org artifact: f3dd6edad1 user: drh
13:08 Reply: unqualified rowid as a SELECT column artifact: c12053d13c user: drh
2021-04-21
17:38 Reply: query plan for "is null" on column defined as "not null" artifact: fd9662783e user: drh
2021-04-20
12:00 Reply: Why no release announcement in this Forum anymore? artifact: 5fff4d8f52 user: drh
10:48 Edit reply: Why no release announcement in this Forum anymore? artifact: 9a0442c5b0 user: drh
10:47 Reply: V 3.35.5 artifact: 192864ae2e user: drh
10:46 Reply: Why no release announcement in this Forum anymore? artifact: 0d0ac5e99c user: drh
2021-04-19
13:20 Reply: SQLite doesn't use indexes for bitwise clauses? artifact: b4d48a923f user: drh
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