SQLite Forum

Timeline
Login

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

59 events for the month beginning 2023-03-01 by user drh

Following month ↑
2023-03-29
18:37 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 (artifact: 7d52ca565b user: drh)
2023-03-28
15:24 Reply: Order of rows in RTree query (artifact: fb9fb42f51 user: drh)
11:57 Reply: Is this an incorrect optimization? (artifact: 2de0e50db1 user: drh)
11:37 Reply: Is this an incorrect optimization? (artifact: f2a7f4ee5c user: drh)
11:24 Reply: Assertion failure in sqlite3WhereEnd function (artifact: e7a13d3885 user: drh)
10:13 Reply: Is this an optimization in ORDER BY clause with a PRIMARY column (artifact: e9a44cabe6 user: drh)
2023-03-27
11:52 Reply: Incorrect results produced by last trunk version (artifact: 582d89bfde user: drh)
10:12 Reply: The craziest thing I ever used SQLite for: partial file deduplication (artifact: a09abd748c user: drh)
2023-03-25
23:59 Reply: Assertion failure in Indexed Expression (2) (artifact: 9afc4dd96e user: drh)
18:39 Reply: Assertion failure in ANALYZE for STAT4 (artifact: 5804aaf406 user: drh)
02:09 Reply: Assertion failure in cursor (artifact: c82394ce83 user: drh)
2023-03-24
19:22 Reply: Assertion failure in RIGHT JOIN (artifact: cde0cc9d5b user: drh)
17:03 Reply: Assertion failure when enable/disable optimizations (artifact: ff89f08c13 user: drh)
15:26 Edit reply: wrong result from PRAGMA foreign_key_list? (artifact: 26093a2cee user: drh)
15:25 Reply: wrong result from PRAGMA foreign_key_list? (artifact: 5925a07863 user: drh)
12:26 Reply: Stable / latest download links? (artifact: b4a56200f7 user: drh)
11:51 Reply: Stable / latest download links? (artifact: 641602627b user: drh)
2023-03-23
15:31 Edit reply: sqlite 3.41: major performance regression in views selecting from a TEXT column and a literal (artifact: f9346b11a6 user: drh)
15:30 Reply: sqlite 3.41: major performance regression in views selecting from a TEXT column and a literal (artifact: acaa188004 user: drh)
15:26 Reply: Performance regression in version 3.40.2 using views on indexed tables (artifact: c3ef454d06 user: drh)
12:19 Reply: Changes in json since 3.39.0? (artifact: 37c04f7330 user: drh)
11:37 Reply: Changes in json since 3.39.0? (artifact: 8bac5d0655 user: drh)
2023-03-22
15:08 Reply: Release history typo (artifact: 3aa7ec7aec user: drh)
11:40 Reply: WHERE queries matchang Type failing since 3.41.0 (artifact: fc829614d8 user: drh)
2023-03-20
23:45 Reply: Incorrect results caused by IN clause for different COLLATION (artifact: 65c76fe270 user: drh)
15:32 Reply: PRAGMA reverse_unordered_selects cause different results (artifact: 8fce2b17c4 user: drh)
02:00 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers (artifact: de5bffaa2f user: drh)
2023-03-19
23:20 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers (artifact: a79f0c29ee user: drh)
2023-03-17
20:38 Reply: How to use VACUUM INTO? (artifact: c2a67c5270 user: drh)
16:00 Reply: VACUUM changing ROWID on tables without an index (artifact: 9d2d4796c1 user: drh)
14:09 Reply: macos vs Linux using sqlite3_column_text (artifact: e6181c41ff user: drh)
12:32 Reply: macos vs Linux using sqlite3_column_text (artifact: 9681fb3200 user: drh)
12:11 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers (artifact: 84b2597014 user: drh)
12:03 Reply: Incorrect updated valued caused by subquery in the set list (artifact: 33151fde55 user: drh)
00:53 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers (artifact: c23afee308 user: drh)
2023-03-16
20:36 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers (artifact: c99d6e0329 user: drh)
10:32 Reply: Incorrect update caused by subquery in where clause (artifact: a74872d875 user: drh)
2023-03-15
18:31 Reply: Incorrect deletion caused by subquery in where clause (artifact: f07fb593f9 user: drh)
18:23 Reply: OR-by-UNION vs INDEXED BY (artifact: 50b75b52e9 user: drh)
16:53 Reply: Incorrect deletion caused by subquery in where clause (artifact: 9e3594e8b0 user: drh)
02:04 Reply: ANALYZE causes incorrect query results. (artifact: 4890d72fac user: drh)
02:02 Reply: Incorrect query result (artifact: eecefe6fcc user: drh)
2023-03-14
20:18 Reply: Incorrect query result (artifact: 781ac7720f user: drh)
20:17 Reply: ANALYZE causes incorrect query results. (artifact: f77001b105 user: drh)
2023-03-12
10:42 Reply: Inconsistent results caused by UNION ALL in IN clause (artifact: 02c9d3df9f user: drh)
2023-03-11
23:30 Reply: LEFT JOIN performance regression in 3.41.1 (artifact: 47e9a43fba user: drh)
22:54 Reply: LEFT JOIN performance regression in 3.41.1 (artifact: f1b3154820 user: drh)
21:20 Reply: LEFT JOIN performance regression in 3.41.1 (artifact: f0f46d2eb1 user: drh)
2023-03-10
12:38 Reply: Help with query plan (artifact: e84cbeec20 user: drh)
2023-03-09
19:19 Reply: Does VACUUM deterministicallychange rowids? (artifact: 607aa624d2 user: drh)
2023-03-07
23:54 Reply: Assertion Failure when using RAISE(IGNORE) (artifact: 82dd6b2d69 user: drh)
2023-03-04
15:48 Reply: Incorrect result might caused by INDEX (artifact: 5ed971f266 user: drh)
2023-03-03
21:01 Reply: Incorrect result for COUNT on view with window function (artifact: d0aada7d10 user: drh)
20:53 Reply: Checkin cc4bb05b: Comment / Code is defective (artifact: 79b62f83ec user: drh)
20:21 Reply: Checkin cc4bb05b: Comment / Code is defective (artifact: ab6b2f76b3 user: drh)
17:10 Reply: Query for interrupt testing (artifact: da379e4bb2 user: drh)
2023-03-02
14:08 Reply: Incorrect results caused by join (artifact: 19a5829211 user: drh)
2023-03-01
20:28 Reply: Incorrect results caused by view and join (artifact: e9025b5ed8 user: drh)
15:25 Reply: Incorrect result that might be caused by json function (artifact: 54a12811fd user: drh)
Previous month ↓