SQLite Forum

Timeline
Login

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

50 events by user drh occurring on or before 2021-05-12 22:04:59.

2021-05-12
22:04 Reply: Inconsistent results in the WHERE clause (artifact: 696eed8057 user: drh)
14:45 Reply: Index Btree (artifact: 54256d55d6 user: drh)
2021-05-11
10:24 Reply: Fast way to insert rows in SQLite (artifact: 6409f3be36 user: drh)
2021-05-07
22:43 Reply: Inconsistent behavior when using nth_value and COUNT (artifact: 10dcf43a6c user: drh)
14:48 Edit: Inconsistent behavior when using nth_value and COUNT (artifact: 5aad5527cb user: drh)
2021-05-06
10:55 Reply: Is dbsqlfuzz open source? (artifact: 73e1d482e2 user: drh)
2021-05-04
23:22 Reply: Bug report: equivalence transfer results in incorrect output (artifact: 54acbdc6ac user: drh)
18:31 Reply: Bug report: equivalence transfer results in incorrect output (artifact: 000320915c user: drh)
12:12 Reply: Possible inconsistent result when use EXISTS ( SELECT...) expression in a WHERE clause (artifact: 4d00cccc65 user: drh)
2021-05-03
18:14 Reply: License of SQLite pikchr RR diagrams (artifact: cb6fb48be1 user: drh)
2021-04-29
15:51 Reply: Confusion of some subquery results (artifact: 25720db54e user: drh)
11:56 Reply: Confusion of some subquery results (artifact: f004a24c57 user: drh)
10:42 Reply: Version 3.35.6 ?? (artifact: ab8fde48c0 user: drh)
2021-04-28
18:59 Reply: Version 3.35.6 ?? (artifact: 58cf889e5f user: drh)
17:59 Reply: Version 3.35.6 ?? (artifact: 28bd44184b user: drh)
2021-04-26
14:34 Reply: bug report : adding constant to GROUP BY leads to different output (artifact: 44a9c99a2c user: drh)
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)