SQLite User Forum

Today In History
Login

This Day In History For 2025-06-11

1 Year Ago (more context)

2024-06-11
21:28 Edit reply: Howto force sequential reading of DB file into RAM artifact: 6ef25cc276 user: ncruces
21:23 Edit reply: Howto force sequential reading of DB file into RAM artifact: 22253d2849 user: ncruces
21:23 Reply: Howto force sequential reading of DB file into RAM artifact: c801f13b1e user: ncruces
21:01 Post: Did the Variable opcode change recently? artifact: 0adbc56447 user: simonw
20:42 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 8030718b08 user: anonymous
18:26 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: bd80c9ff99 user: anonymous
17:18 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 251a4b2e6b user: drh
16:23 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 94a7575650 user: _blgl_
14:32 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: c722857e4a user: dmausner
14:27 Reply: Compilation error on MSVC with strict floating-point in version 3.46.0 artifact: e3bea0e7b2 user: cjihrig
13:30 Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 0ad96e2553 user: rhashimoto
13:23 Reply: Compilation error on MSVC with strict floating-point in version 3.46.0 artifact: 7f96cf74f9 user: drh
13:13 Post: Compilation error on MSVC with strict floating-point in version 3.46.0 artifact: 4feb1685cc user: cjihrig
12:15 Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: ce7f734186 user: stephan
11:27 Reply: Unable to restore database when using -interactive artifact: b90bb2f905 user: stephan
11:20 Reply: Unable to restore database when using -interactive artifact: d26b0809fc user: User123
11:06 Reply: Unable to restore database when using -interactive artifact: 50db55b660 user: stephan
10:55 Post: Unable to restore database when using -interactive artifact: 47eb2552a5 user: User123
10:03 Reply: Aborted(CompileError: WebAssembly.instantiate(): expected magic word artifact: bf38bcc5ef user: stephan
09:46 Reply: Aborted(CompileError: WebAssembly.instantiate(): expected magic word artifact: 29a36d789c user: anonymous
07:24 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 2e0ab77f97 user: _blgl_
06:34 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: f21c9f1f78 user: hanche
06:24 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 279127bea3 user: hanche
04:21 Edit reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: fb0b68466b user: stephancb
04:15 Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 9e29333922 user: stephancb

2 Years Ago (more context)

2023-06-11
23:43 Post: System.Data.SQLite version 1.0.118.0 released artifact: 6d00e5d25e user: mistachkin
23:33 Reply: sqlite3_backup_step() return value artifact: 3f9610b357 user: sqweek
21:34 Post: Full bloom filter blob capacity is never used? artifact: 06c3f01da6 user: jschaefer
19:15 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 8db70f2884 user: spindrift
19:03 Edit reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 6f9f4330d6 user: kmedcalf
19:01 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: e4ec2eba36 user: kmedcalf
18:44 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 35313b4827 user: anonymous
18:00 Reply: Default first record artifact: a6101efc5a user: kmedcalf
17:48 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: edfdc5d58a user: kmedcalf
17:39 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: fd53a1c8d3 user: kmedcalf
17:20 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 25b260ea34 user: kmedcalf
17:11 Edit reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 3f44097326 user: kmedcalf
17:09 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 7a718626d1 user: kmedcalf
17:07 Reply: Default first record artifact: 474548ce25 user: sqlitening
16:56 Edit reply: Default first record artifact: 5db9540ffe user: kmedcalf
16:55 Reply: Default first record artifact: ebede7283b user: kmedcalf
16:41 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 3699695e38 user: anonymous
16:40 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: 40ce927ba9 user: anonymous
16:36 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: d8e1d3b455 user: spindrift
16:34 Post: Default first record artifact: 17556b9c6c user: sqlitening
16:23 Reply: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: a62e1504bc user: kmedcalf
16:11 Post: 3.42 and `ON CONFLICT` behavior with `unixepoch('subsec')` artifact: d8655750e7 user: anonymous
15:11 Post: Unwanted page reloading sqlite3 nodejs artifact: 37b43750e7 user: anonymous
13:55 Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: eebbf5954f user: anonymous
13:44 Reply: Query Assistance please artifact: 454aa1001a user: spindrift
11:39 Reply: Query Assistance please artifact: 1ffd061247 user: 75568618
10:58 Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 7c11be5b22 user: spindrift
10:54 Edit reply: Query Assistance please artifact: 0c4b891578 user: spindrift
10:53 Reply: Query Assistance please artifact: ceb5b67b14 user: spindrift
10:46 Edit: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 78e67f4a07 user: sqbright777
10:34 Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 68eea1c4ed user: sqbright777
07:47 Post: Query Assistance please artifact: ad9bf3eca4 user: 75568618
07:09 Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 9df9cc1265 user: spindrift
01:14 Edit reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 2b4c4faf16 user: kmedcalf
01:11 Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 1cc7e6ef57 user: kmedcalf
00:49 Post: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: dc71a759c4 user: sqbright777

3 Years Ago (more context)

2022-06-11
23:54 Reply: view can't find temp table artifact: 753696a126 user: kmedcalf
23:48 Reply: The changes() SQL function cannot be used as value for Returning? artifact: bb9b2e6bf4 user: kmedcalf
22:53 Post: view can't find temp table artifact: 0b57425871 user: anonymous
22:07 Reply: The changes() SQL function cannot be used as value for Returning? artifact: 4e621013b5 user: anonymous
17:47 Reply: The changes() SQL function cannot be used as value for Returning? artifact: 5b36798be1 user: kmedcalf
17:39 Edit reply: The changes() SQL function cannot be used as value for Returning? artifact: 505988856b user: kmedcalf
17:17 Edit reply: The changes() SQL function cannot be used as value for Returning? artifact: b153dace95 user: kmedcalf
17:16 Reply: The changes() SQL function cannot be used as value for Returning? artifact: c3e247dc1f user: kmedcalf
10:03 Reply: Update query writes value of primary key to the value field instead of updated value artifact: 2165380f8c user: anonymous
09:23 Post: The changes() SQL function cannot be used as value for Returning? artifact: da84e23a40 user: anonymous
08:11 Reply: Update query writes value of primary key to the value field instead of updated value artifact: e69c199f8a user: pizza_dox_9999
03:02 Edit reply: Update query writes value of primary key to the value field instead of updated value artifact: ca43089c5a user: kmedcalf
01:27 Reply: Update query writes value of primary key to the value field instead of updated value artifact: 25a8882ff2 user: kmedcalf
01:06 Reply: Assertion `pCur->eCurType==CURTYPE_VTAB' failed artifact: b9800546f9 user: bajinsheng

4 Years Ago (more context)

2021-06-11
19:34 Reply: Bug: ALTER TABLE RENAME TO vs CTE VIEWs / multiple references artifact: 04f72b274e user: bjoern
17:19 Reply: Using an alias in queries artifact: f963011a06 user: cuz
16:52 Reply: Using an alias in queries artifact: b0c9444644 user: Trudge
16:13 Reply: SQLite.Interop.dll: Exception 0xc00000fd artifact: 149dde15d0 user: mistachkin
15:41 Reply: bug A stack buffer overflow vulnerability was discovered in SQLite 3.36.0 artifact: 2a909afa35 user: anonymous
14:38 Reply: Using an alias in queries artifact: 14540d4bf6 user: Trudge
14:27 Reply: Inconsistent memory stats of sqlite3 with different compilers artifact: d7a50522ed user: slavin
13:27 Reply: Bug: ALTER TABLE RENAME TO vs CTE VIEWs / multiple references artifact: 5a2528deaa user: drh
13:12 Reply: Returning expr not working with sqlite3_exec() in C code artifact: 7efa3e6c18 user: loki1993
12:49 Reply: bug A stack buffer overflow vulnerability was discovered in SQLite 3.36.0 artifact: 41702338dd user: drh
11:55 Reply: Returning expr not working with sqlite3_exec() in C code artifact: d83d4d8b6f user: kmedcalf
11:39 Reply: Vritual Tables Performing SQL Queries artifact: 12f01b3fbf user: dan
11:16 Edit reply: Returning expr not working with sqlite3_exec() in C code artifact: 805a25a56e user: loki1993
11:14 Delete reply: Returning expr not working with sqlite3_exec() in C code artifact: bc2842cea7 user: loki1993
10:43 Reply: Returning expr not working with sqlite3_exec() in C code artifact: a1bda8a27e user: loki1993
10:37 Reply: Returning expr not working with sqlite3_exec() in C code artifact: 18081d9486 user: loki1993
10:32 Reply: Returning expr not working with sqlite3_exec() in C code artifact: b32fdc0409 user: kmedcalf
09:48 Post: Returning expr not working with sqlite3_exec() in C code artifact: 5bd5dc109a user: loki1993
08:49 Post: SQLite.Interop.dll: Exception 0xc00000fd artifact: 4b86de6e77 user: Flohack
08:44 Edit reply: Vritual Tables Performing SQL Queries artifact: 0bd6ca49c1 user: ddevienne
08:41 Reply: Vritual Tables Performing SQL Queries artifact: d0a80b3d68 user: ddevienne
08:23 Post: Is it possible to switch off: ability to find a full-index-scan query plan for queries using INDEXED BY ? artifact: 9bc035e1a8 user: anonymous
07:54 Post: Vritual Tables Performing SQL Queries artifact: 76d4fa272a user: brianchrz
03:37 Post: bug A stack buffer overflow vulnerability was discovered in SQLite 3.36.0 artifact: 08a0d6d9bf user: salmonx
02:27 Reply: json_contains Function Idea artifact: e83566d92a user: SeverKetor
01:46 Reply: SQLite SEE compatibility with existing CryptoAPI databases artifact: c669910628 user: anonymous

5 Years Ago (more context)

2020-06-11
23:58 Reply: DROP VIEW IF EXISTS failure artifact: d829560381 user: kmedcalf
22:45 Reply: Unexepected commit result with two threads application artifact: 0c5764aa29 user: brodybits
22:32 Reply: DROP VIEW IF EXISTS failure artifact: 8fa4c468a7 user: kyle
22:30 Edit reply: DROP VIEW IF EXISTS failure artifact: 3c07434c03 user: kmedcalf
22:26 Reply: DROP VIEW IF EXISTS failure artifact: 0c23f063e6 user: kmedcalf
22:23 Reply: Unexepected commit result with two threads application artifact: cf6696cc8c user: brodybits
21:54 Reply: DROP VIEW IF EXISTS failure artifact: f4242d51a3 user: kyle
21:27 Reply: DROP VIEW IF EXISTS failure artifact: 67b6070e33 user: stephan
21:24 Reply: DROP VIEW IF EXISTS failure artifact: d1fcf3295e user: kyle
21:13 Reply: DROP VIEW IF EXISTS failure artifact: 2b717ba1e9 user: younique
21:03 Edit reply: DROP VIEW IF EXISTS failure artifact: f7b3ac9fe1 user: andreas-kupries
21:03 Reply: DROP VIEW IF EXISTS failure artifact: b33eceef2d user: andreas-kupries
20:56 Reply: DROP VIEW IF EXISTS failure artifact: 1c50c4f701 user: younique
20:53 Reply: DROP VIEW IF EXISTS failure artifact: 8e7d38857e user: younique
20:44 Reply: DROP VIEW IF EXISTS failure artifact: 9a6a0507cc user: LarryBrasfield
20:23 Edit reply: DROP VIEW IF EXISTS failure artifact: 05c80dfae0 user: LarryBrasfield
20:18 Reply: DROP VIEW IF EXISTS failure artifact: 601ac7a13c user: LarryBrasfield
20:01 Post: DROP VIEW IF EXISTS failure artifact: daec33be27 user: younique
19:03 Reply: .mode html fails on html content artifact: 3392f0a349 user: dfgriggs
18:57 Reply: .mode html fails on html content artifact: 731032502e user: LarryBrasfield
18:44 Post: .mode html fails on html content artifact: ceba329da6 user: tonyp
17:43 Edit reply: Limiting the "precision" of floating-point to text conversions in the printf() leads to testsuite failure in version 3.26.0 artifact: edebacf2c9 user: LarryBrasfield
17:42 Reply: Limiting the "precision" of floating-point to text conversions in the printf() leads to testsuite failure in version 3.26.0 artifact: 80a3308b3a user: drh
17:36 Reply: Limiting the "precision" of floating-point to text conversions in the printf() leads to testsuite failure in version 3.26.0 artifact: b1ec8da265 user: LarryBrasfield
14:35 Edit reply: Request: stored functions/procedures artifact: 375f58f1a2 user: jicman
14:32 Reply: Request: stored functions/procedures artifact: 1fab151e71 user: jicman
13:53 Reply: Request: stored functions/procedures artifact: 538fbde154 user: lcarlp
10:59 Post: Limiting the "precision" of floating-point to text conversions in the printf() leads to testsuite failure in version 3.26.0 artifact: f2d5ba3a1b user: odubaj
09:45 Reply: Request: stored functions/procedures artifact: 091b028453 user: anonymous
09:31 Reply: python sqlite3 not support numpy type? artifact: 081884f5a0 user: wyoung
09:21 Reply: sqlite user authentication in c++ project artifact: 0c78f9bf42 user: wyoung
09:00 Reply: Odd buffer overflow artifact: dc3b11b6d9 user: markstz
08:36 Post: python sqlite3 not support numpy type? artifact: aa1a2abf3f user: anonymous
05:36 Reply: sqlite user authentication in c++ project artifact: bd53c3de92 user: zzsedward
03:03 Reply: sqlite user authentication in c++ project artifact: b0ec327d34 user: stephan
02:50 Reply: sqlite user authentication in c++ project artifact: 4ce5ef5712 user: stephan
02:22 Edit reply: Odd buffer overflow artifact: 5a67f08eb1 user: LarryBrasfield
02:21 Reply: Odd buffer overflow artifact: 2e6ac491bd user: LarryBrasfield
00:54 Reply: sqlite user authentication in c++ project artifact: 3ea916a80a user: zzsedward
00:33 Reply: Odd buffer overflow artifact: 7dd292c557 user: RichardDamon