SQLite Forum

Timeline
Login

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

50 most recent forum posts by user drh

2024-03-29
00:26 Reply: Variant values (artifact: 14a6577671 user: drh)
2024-03-28
15:37 Reply: ROW_NUMBER() and ORDER BY (artifact: eac641c1b8 user: drh)
12:39 Reply: Lock-Byte Page Size (artifact: c84f915f79 user: drh)
2024-03-27
16:30 Reply: Incorrect query result caused by large number comparison (artifact: a577499529 user: drh)
2024-03-25
19:06 Reply: VACUUM after ALTER TABLE (artifact: 2a8121c756 user: drh)
11:37 Reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 20883b9597 user: drh)
11:10 Reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 84634ed443 user: drh)
2024-03-24
22:13 Edit reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 2ffa2c528d user: drh)
22:12 Reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 5923058bd9 user: drh)
19:14 Reply: Coverity issue (artifact: cb728b71a8 user: drh)
2024-03-23
12:16 Reply: sqlite3_analyzer.exe as a standalone executable? (artifact: 6d7fd48e53 user: drh)
12:02 Delete reply: CLI - JSON odd? (artifact: 8940e5c711 user: drh)
12:02 Reply: CLI - JSON odd? (artifact: 9a0997c3e4 user: drh)
12:01 Reply: CLI - JSON odd? (artifact: 2a24b3a9fa user: drh)
2024-03-22
16:27 Reply: In-place VACUUM 20x slower than VACUUM INTO (artifact: d9f82b4dff user: drh)
14:00 Reply: Any documentation about .stats on ? (artifact: 9f183f7305 user: drh)
2024-03-21
00:54 Reply: UDF running own SQL (artifact: 0f8ad18165 user: drh)
00:44 Reply: Does SQLite have HOT updates, and optimized non-blob field updates? (artifact: e139405b1f user: drh)
2024-03-19
16:24 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: 4421827feb user: drh)
16:05 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: 9aee75cc7a user: drh)
15:55 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: 173e2de357 user: drh)
10:59 Reply: Incorrect result caused by SUM function (artifact: 9dcb5f4c4a user: drh)
2024-03-17
22:10 Edit reply: No error on upsert violating unique constraint (artifact: 1609073990 user: drh)
22:09 Reply: No error on upsert violating unique constraint (artifact: 59cf409a5c user: drh)
22:07 Reply: No error on upsert violating unique constraint (artifact: 9bcbe0c1b9 user: drh)
2024-03-15
13:20 Reply: func4 test failures on Linux i586 in 3.45.2 (artifact: 74ad63442b user: drh)
2024-03-14
19:26 Reply: func4 test failures on Linux i586 in 3.45.2 (artifact: e0b7606cf9 user: drh)
2024-03-12
20:44 Reply: How sqlite updates row? (artifact: 163b72c949 user: drh)
2024-03-11
20:00 Reply: Error while building sqlite3.dll on windows 10 (artifact: 7975999363 user: drh)
17:11 Edit: Error while building sqlite3.dll on windows 10 (artifact: 5b6f1fef2d user: drh)
14:47 Reply: About UTF-16 and UTF-8 (artifact: 663d45952f user: drh)
13:14 Reply: About UTF-16 and UTF-8 (artifact: 70ea2d652c user: drh)
11:53 Reply: UTF16 string binding issue (artifact: 708f5fcfd3 user: drh)
2024-03-09
18:05 Reply: Incorrect query result caused by large number comparison (artifact: 93c073ed4d user: drh)
15:40 Reply: Incorrect query result caused by large number comparison (artifact: bd131cc7ec user: drh)
15:15 Reply: should strftime('%V','now') work? (artifact: fc25831602 user: drh)
11:39 Reply: should strftime('%V','now') work? (artifact: baa40978db user: drh)
00:43 Reply: Incorrect result may caused by window function (artifact: 8a6e383777 user: drh)
2024-03-08
14:36 Reply: Incorrect query result may caused by Conflict key word (artifact: e28e4a3b1a user: drh)
2024-03-07
12:43 Reply: Incorrect result may caused by Distinct (artifact: 40da29c1f6 user: drh)
2024-03-06
21:11 Reply: Tests fail on Windows 10 build from source with no changes (artifact: f737a931fa user: drh)
21:08 Reply: pretty print JSON (artifact: 651202f7da user: drh)
17:48 Reply: SQLite Encryption Extension in Xcode for iOS/iPadOS/MacOS (artifact: 34d07e8ec8 user: drh)
11:40 Reply: Incorrect query result caused by type conversion (artifact: a175deea25 user: drh)
10:58 Reply: Inconsistent query result caused by optimization (artifact: 2435699e53 user: drh)
2024-03-05
12:13 Reply: @drh: forum mentioning deficiency (lead e.g. to JSON BLOB bug) (artifact: c40c32c15c user: drh)
2024-03-04
18:30 Reply: Dates in the past (artifact: ad1769ebb5 user: drh)
16:05 Edit reply: Report bugs against SQLite (artifact: f7eacab33c user: drh)
11:36 Reply: Report bugs against SQLite (artifact: 410c5984ac user: drh)
2024-03-03
20:40 Reply: Dates in the past (artifact: b88696a8b6 user: drh)