SQLite Forum

Timeline
Login

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

50 forum posts by user drh occurring on or before 2021-08-13 12:24:34.

2021-08-13
12:24 Reply: Test ACID properties SQLITE (artifact: 6354094425 user: drh)
11:37 Reply: Sqlite connections isolated even after COMMIT (artifact: 8b24a48d44 user: drh)
2021-08-12
13:54 Edit: SQL lite irrespective query (artifact: 2acbfdfadb user: drh)
2021-08-11
13:09 Reply: inner join bug with compound queries (artifact: 2417eac1f3 user: drh)
2021-08-10
13:34 Edit: Handling of json keys containing double quotes (artifact: 96abde02a0 user: drh)
2021-08-07
20:56 Reply: Old Nabble SQLite mailing list site down? (artifact: 04c0216524 user: drh)
2021-08-06
22:29 Reply: Bug: unexpected result from an empty table (artifact: e4def599a5 user: drh)
15:27 Reply: The amalgamation has repeated files? (artifact: 0e2e2a8264 user: drh)
14:31 Reply: Bug: inconsistent result when an optimization is on and off (artifact: 01d879f18b user: drh)
12:05 Reply: SQLITE_NOTICE(283): recovered 2 frames from WAL file /home/hwaci/fossil/sqlite.fossil-wal (artifact: 3e8f912d7c user: drh)
2021-07-30
20:11 Reply: Bug: `GENERATED ALWAYS` constraint ends up in column type (artifact: 82e5f7eb2e user: drh)
2021-07-29
13:44 Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? (artifact: f2096cd579 user: drh)
2021-07-27
12:53 Reply: Bug in sqlite3PagerSharedLock? (artifact: 03faa0b7de user: drh)
2021-07-26
02:21 Reply: sqlite3_carray_bind and constness (artifact: 5b9d77a2cd user: drh)
2021-07-23
23:54 Reply: ALTER TABLE DROP COLUMN corrupts data (artifact: ec86256907 user: drh)
23:17 Reply: ALTER TABLE DROP COLUMN corrupts data (artifact: ac6086ecde user: drh)
2021-07-22
23:10 Edit reply: problem report: incorrect join behavior (artifact: f8786ea8e1 user: drh)
22:27 Edit reply: How can I calculate trip duration? (artifact: 572f99b3e9 user: drh)
22:22 Reply: How can I calculate trip duration? (artifact: 7656460e6b user: drh)
16:23 Reply: problem report: incorrect join behavior (artifact: 74fe3e169e user: drh)
14:55 Reply: problem report: incorrect join behavior (artifact: 2078b7edd2 user: drh)
14:14 Reply: problem report: incorrect join behavior (artifact: 33c9cd5abf user: drh)
13:41 Reply: problem report: incorrect join behavior (artifact: 9c3268b134 user: drh)
2021-07-20
18:36 Edit reply: SDS.SEE.xml (artifact: 34916a6ab2 user: drh)
18:35 Reply: SDS.SEE.xml (artifact: debaaed29c user: drh)
16:18 Reply: Unexpected return from the NULL column (artifact: f42238afcd user: drh)
14:39 Reply: ROWID in compound SELECT (artifact: 250fe78dbc user: drh)
01:12 Reply: SDS.SEE.xml (artifact: ae08174c6b user: drh)
01:07 Reply: sqlite3_deserialize double memory freeing (artifact: 3dbd10abf7 user: drh)
2021-07-19
20:54 Reply: Different comparison results in WHERE and SELECT clauses (artifact: 6075b3f357 user: drh)
17:39 Reply: Is pragma integrity_check safe during app working? (artifact: 50372c92a7 user: drh)
17:05 Reply: Programmatically getting information about the 'where' clause (artifact: d4b73f1cbf user: drh)
16:10 Reply: Is pragma integrity_check safe during app working? (artifact: 7cda26315a user: drh)
2021-07-17
14:47 Reply: SQLITE_WITHIN macro with one compare operator (artifact: 00f7d00418 user: drh)
2021-07-16
22:51 Reply: Should SQLite be able to optimize this query? (artifact: 878ca7a9be user: drh)
19:46 Edit reply: Should SQLite be able to optimize this query? (artifact: f6901a235d user: drh)
19:40 Edit reply: Should SQLite be able to optimize this query? (artifact: f9df43adb5 user: drh)
19:38 Reply: Should SQLite be able to optimize this query? (artifact: 4a76777e6d user: drh)
19:05 Reply: Should SQLite be able to optimize this query? (artifact: 6be1468b85 user: drh)
17:27 Reply: Custom error messages for required table-valued function parameter (artifact: c83977a7e6 user: drh)
15:05 Reply: Should SQLite be able to optimize this query? (artifact: 442c21d1d2 user: drh)
01:22 Reply: Should SQLite be able to optimize this query? (artifact: e071e0991f user: drh)
2021-07-15
23:29 Edit reply: Should SQLite be able to optimize this query? (artifact: 062d576715 user: drh)
23:27 Reply: Should SQLite be able to optimize this query? (artifact: f7f6637918 user: drh)
19:34 Reply: Should SQLite be able to optimize this query? (artifact: 8c0a5f40fb user: drh)
18:06 Reply: Should SQLite be able to optimize this query? (artifact: 5f119f0dff user: drh)
17:18 Reply: Should SQLite be able to optimize this query? (artifact: fffb9616bd user: drh)
16:25 Reply: Should SQLite be able to optimize this query? (artifact: 0fc6dcfcf7 user: drh)
11:03 Reply: Custom error messages for required table-valued function parameter (artifact: bce87eaf56 user: drh)
2021-07-14
00:51 Reply: fortify source (artifact: b6c72bddd4 user: drh)