SQLite Forum

Timeline
Login

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

50 most recent forum posts by user drh

2022-05-26
12:45 Post: SQLite version 3.39.0 beta (artifact: 5cfd681451 user: drh)
2022-05-25
17:46 Reply: new CVE (CVE-2022-21227) not listed on Vulnerabilities page (artifact: 45f15db8a2 user: drh)
13:12 Reply: Log10(100) = 1.9999999999999998 ?!? (artifact: 7a36ebc5e0 user: drh)
12:50 Reply: Unexpected Result by WHERE/RIGHT JOIN (artifact: f6abb972c0 user: drh)
2022-05-24
16:06 Reply: Unexpected Result by WHERE when Joining Tables (artifact: 0d2d6f8aad user: drh)
13:54 Reply: Unexpected Result by WHERE when Joining Tables (artifact: c62e5bf190 user: drh)
11:25 Reply: SQLite doesn't complain about ambiguous column names in a `USING` clause (artifact: 1d2b7c88d7 user: drh)
00:00 Reply: SQLite Encryption Extension inquiries (artifact: 98d884f393 user: drh)
2022-05-23
23:20 Reply: SQLite Encryption Extension inquiries (artifact: 5020bfb338 user: drh)
21:02 Reply: Poor performance with bloom filter ? (artifact: bcb295fec1 user: drh)
19:57 Edit reply: Poor performance with bloom filter ? (artifact: 94a34930ec user: drh)
19:57 Reply: Poor performance with bloom filter ? (artifact: a70a955491 user: drh)
19:26 Reply: Poor performance with bloom filter ? (artifact: ae1a8858f0 user: drh)
13:01 Reply: Ambiguous Reference Error for Right Join (artifact: 522312cd8a user: drh)
12:36 Reply: Ambiguous Reference Error for Right Join (artifact: 19798c9973 user: drh)
12:15 Reply: Ambiguous Reference Error for Right Join (artifact: 95b5ff4949 user: drh)
2022-05-20
13:34 Reply: Memory leaking while using routine sqlite3_step function (artifact: 005416bfe6 user: drh)
13:27 Reply: Memory leaking while using routine sqlite3_step function (artifact: 0c414dccd8 user: drh)
13:23 Reply: Strategy for frequently updated rows (artifact: 5a3a92e4cc user: drh)
2022-05-19
21:13 Reply: SQLite version regression: query with rowid ends up with an error (artifact: 0e2e04c0be user: drh)
10:46 Reply: How to transfer the output of an SQLite query into a spreadsheet (Excel) (artifact: 90de26db2d user: drh)
2022-05-17
15:11 Reply: Expression or Constant in GroupBy Clause (artifact: b9388b9621 user: drh)
14:54 Reply: Expression or Constant in GroupBy Clause (artifact: 22ad68bd1a user: drh)
2022-05-15
17:20 Reply: Unexpected Result by Covering Index (artifact: 3c818f74f8 user: drh)
2022-05-14
20:47 Reply: Rows are Unexpectedly Filtered Out by DISTINCT in RIGHT JOIN (artifact: 3ad1828374 user: drh)
2022-05-13
21:04 Reply: An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN (artifact: f0b1f1f8ab user: drh)
18:23 Reply: An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN (artifact: fa63ae1e46 user: drh)
17:47 Reply: An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN (artifact: 46ec69f9e1 user: drh)
17:19 Reply: An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN (artifact: 9e2ad6a729 user: drh)
13:52 Reply: Auto-vacuuming and concurrency (artifact: 6453c201a2 user: drh)
2022-05-12
12:50 Reply: Possible endless loop in a non-CTE query in 3.39 (artifact: aa3f14797f user: drh)
12:12 Reply: An Inconsistent Result Depending on Parenthesization (artifact: ecb84f8873 user: drh)
2022-05-11
14:46 Reply: An Inconsistent Result Depending on Parenthesization (artifact: 2947f7c3a5 user: drh)
2022-05-06
19:07 Reply: Select statement generates OOM error (artifact: ad78dbbb36 user: drh)
2022-05-05
20:33 Reply: No such column when using schema in returning clause (artifact: 133a7f9d91 user: drh)
11:16 Reply: 3.38.4 on Win 8.1 fault with exit code: 3221225477 (artifact: ea00f5ea16 user: drh)
10:16 Reply: free(): invalid pointer (artifact: b95627cdde user: drh)
2022-05-04
21:39 Reply: Adding an index gives 2000× slowdown (artifact: f006037d61 user: drh)
19:57 Reply: Need help fix corrupted database db3 file (artifact: c0cdd92aca user: drh)
2022-05-03
13:17 Edit reply: Freeze/Hang/Infinite Loop in 3.38 (artifact: ae68d20661 user: drh)
13:12 Reply: Freeze/Hang/Infinite Loop in 3.38 (artifact: a83c843d13 user: drh)
12:43 Edit reply: Freeze/Hang/Infinite Loop in 3.38 (artifact: 6aedee3e8d user: drh)
12:42 Reply: Freeze/Hang/Infinite Loop in 3.38 (artifact: 80ea6dec7b user: drh)
2022-05-02
20:20 Reply: What is located in the SQLite Format at offset 100 (artifact: 67527182c7 user: drh)
2022-05-01
22:44 Reply: problem report: incorrect left join behavior (artifact: a63c9250bc user: drh)
22:22 Reply: SUM() of index values (artifact: d921d87320 user: drh)
2022-04-30
12:38 Reply: Crash found through fuzzing (artifact: ea6f2193cb user: drh)
2022-04-27
11:46 Reply: naming a table "order" is giving error (artifact: 4b2eb3d3d7 user: drh)
09:43 Reply: Possible bug with INNER JOIN in 3.38.2 (artifact: 9bea9683ad user: drh)
2022-04-25
11:13 Edit reply: Two crashes found through fuzzing (artifact: e755de2f5b user: drh)