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-24 14:56:26.

2021-08-24
14:56 Reply: Assertion Failure in constructAutomaticIndex() (artifact: 310fecd471 user: drh)
2021-08-23
14:27 Reply: When is "IS" used in SQLite? (artifact: bb5880682e user: drh)
2021-08-22
22:50 Reply: about "strict" mode (artifact: b10b89bf79 user: drh)
2021-08-21
19:25 Reply: about "strict" mode (artifact: 0248dcf7f0 user: drh)
16:51 Reply: Assertion failure "pExpr->pAggInfo==pAggInfo" (artifact: 89440d40ba user: drh)
16:40 Reply: lemon.out is great (artifact: 21ee8c117b user: drh)
2021-08-20
19:51 Reply: lemon cannot shift-reduce errors (artifact: 4d0b83d86b user: drh)
07:22 Reply: How to append one table of one database to another table of another database ? (artifact: ae460401d9 user: drh)
07:19 Reply: "database or disk is full" with in-memory database. Suggested next steps? (artifact: b1ba232667 user: drh)
2021-08-19
14:21 Reply: Is it safe to use unix-none VFS in concurrent reading to one database ? (artifact: 81cffecd58 user: drh)
2021-08-18
19:28 Reply: why do I get a row when querying a table with no rows? (artifact: 69f9b7e706 user: drh)
19:19 Edit: why do I get a row when querying a table with no rows? (artifact: be3dd8cfde user: drh)
2021-08-17
20:00 Edit reply: lemon cannot shift-reduce errors (artifact: 9e531e04c0 user: drh)
19:11 Reply: lemon cannot shift-reduce errors (artifact: cff80737bf user: drh)
11:54 Reply: DB creates file despite URI param "mode=memory" (artifact: be6851b169 user: drh)
2021-08-13
19:57 Reply: Converting from sqlite to sqlite3 (artifact: 8114d141cf user: drh)
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)