SQLite Forum

Timeline
Login

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

50 most recent forum posts by user dan

2022-09-28
14:23 Reply: fts-related questions (tokenizer access, range search) (artifact: 78068a3866 user: dan)
2022-09-01
17:42 Reply: Concurrent `PRAGMA {data,temp}_store_directory = ...` is very dangerous when docs say even malicious SQL should be safe (artifact: 855b4a503f user: dan)
2022-08-19
16:36 Edit: Unhandled NRE in SQLite (artifact: c0171d98f7 user: dan)
2022-08-18
15:50 Reply: Why walRestartLog need to reset readlock? (artifact: 6f9d2f1e4b user: dan)
2022-08-17
11:33 Reply: Why walRestartLog need to reset readlock? (artifact: 3c26098e25 user: dan)
2022-08-15
10:44 Reply: Why walRestartLog need to reset readlock? (artifact: e742d259b1 user: dan)
2022-08-12
13:55 Reply: wal-index may be inconsistent with wal log (artifact: 9536f83330 user: dan)
2022-08-10
15:36 Reply: "Error: not an error" when using the .expert CLI tool with a query containing a quoted keyword (artifact: 429da50cd8 user: dan)
2022-08-08
05:50 Edit reply: GROUP BY failing to GROUP (artifact: d6204c4718 user: dan)
05:50 Reply: GROUP BY failing to GROUP (artifact: ce74cd1a2c user: dan)
2022-07-29
13:35 Reply: Potential typo in equation in window function documentation (artifact: 75ecaf9379 user: dan)
2022-07-12
10:47 Reply: Sqlite VFS Fatfs create table error 26 (artifact: 5a03246db5 user: dan)
2022-07-08
15:46 Reply: Update TEA build (artifact: f68e88da97 user: dan)
2022-07-05
18:10 Reply: CSV virtual table bug (artifact: c47a940294 user: dan)
18:04 Reply: Possible regression with JSON handling (artifact: b812a84493 user: dan)
10:49 Reply: BUG: DELETE / DROP TABLE fails with self referencing FK data (artifact: 66094d1013 user: dan)
2022-06-30
16:06 Reply: sqlite3_prepare_v2() fails on string literal with a semicolon on Android (artifact: d95bd3dff7 user: dan)
2022-06-28
11:11 Reply: Status of wal2 branch (artifact: 60adeea487 user: dan)
2022-06-27
21:47 Reply: Status of wal2 branch (artifact: 2c30cddf94 user: dan)
15:11 Reply: WHERE NOT IN query plan optimization (artifact: 27c605852c user: dan)
13:56 Reply: Status of wal2 branch (artifact: 49cef62bba user: dan)
2022-06-24
14:56 Reply: question about WAL mode (artifact: 9f5d5cb2a4 user: dan)
2022-06-16
14:15 Reply: BUG: DELETE / DROP TABLE fails with self referencing FK data (artifact: 7e66ca8025 user: dan)
2022-06-07
13:36 Reply: How to handle IN operator in virtual table? (artifact: a805baa418 user: dan)
2022-06-03
21:14 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection (artifact: fe8ae5eccf user: dan)
20:54 Reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' (artifact: cb2ba2e61c user: dan)
2022-05-12
16:40 Reply: Must the callback provided to preupdate_hook be thread-safe? (artifact: 15c15fafa1 user: dan)
2022-05-03
10:51 Reply: (SOLVED) any idea what went wrong on this 4TB db to cause "database or disk is full" ? (artifact: 5c2bae99a7 user: dan)
2022-04-28
18:28 Reply: Why SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTERTABLE (artifact: f85f84cbc1 user: dan)
2022-04-25
11:02 Reply: Two crashes found through fuzzing (artifact: 0f0091d6b2 user: dan)
10:44 Reply: Possible bug with INNER JOIN in 3.38.2 (artifact: a27911b63f user: dan)
2022-04-20
16:44 Reply: Surprising behavior of aggregate JSON functions? (artifact: f630ffc4db user: dan)
2022-04-16
15:22 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: bf55b5a789 user: dan)
2022-04-14
18:34 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: 880f31fa3c user: dan)
17:33 Edit reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: 542982906b user: dan)
17:33 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: 5cde70092c user: dan)
2022-04-07
13:47 Reply: sqlite3 fts5 contentless or content=external table, how store and read a non-FTS column value (artifact: 804cc92a00 user: dan)
2022-03-23
11:35 Reply: Corrupt FTS5 table after declaring triggers a certain way (artifact: 93be31a44a user: dan)
2022-03-19
14:15 Reply: Unexpected result from query with window function (artifact: c1226f163d user: dan)
2022-03-18
06:51 Reply: Performance Analysis (artifact: 4b6ee2a416 user: dan)
2022-02-25
20:15 Reply: Addressing multiple WITH definitions (artifact: 464835f569 user: dan)
2022-02-23
11:16 Reply: Conditional Trigger using WHEN clause NOT Working. (artifact: 2a2e3020ac user: dan)
11:04 Edit: The SQLite SET-AND Gotcha (artifact: 731f159fc9 user: dan)
11:03 Reply: Set F_FULLSYNC on macOS? (artifact: 14469d5fc3 user: dan)
2022-02-20
08:22 Edit reply: Slow aggregate query (artifact: 6f141af7b9 user: dan)
08:17 Reply: Slow aggregate query (artifact: d2e506b20b user: dan)
2022-02-14
14:28 Reply: increasing page_size not working for >10GB DB? (artifact: 3862820843 user: dan)
2022-02-04
21:29 Reply: FTS5 error: database disk image is malformed (artifact: 5acb884b07 user: dan)
2022-01-10
11:42 Reply: pragma table_info Bug (artifact: 452941eaa1 user: dan)
2022-01-03
11:21 Reply: Reading SQLite database by using C Language (artifact: 051f0e1b6e user: dan)