This Day In History For 2024-03-20
1 Year Ago (more context)
2023-03-20
| ||
23:45 | • Reply: Incorrect results caused by IN clause for different COLLATION artifact: 65c76fe270 user: drh | |
23:33 | • Reply: Incorrect result might be caused by ANALYZE artifact: 756dd36c85 user: ChiZhang | |
23:06 | • Edit reply: sqlite ln vs log artifact: aa184b5c0c user: thipages | |
23:05 | • Reply: sqlite ln vs log artifact: d76274d772 user: thipages | |
22:46 | • Edit: Incorrect results caused by IN clause for different COLLATION artifact: f3e82e2af5 user: zuming_jiang | |
22:45 | • Post: Incorrect results caused by IN clause for different COLLATION artifact: 9a28d04b41 user: zuming_jiang | |
22:41 | • Reply: sqlite ln vs log artifact: 6e6c7dac3a user: kmedcalf | |
22:32 | • Reply: sqlite ln vs log artifact: 22c4996eb7 user: thipages | |
22:10 | • Reply: sqlite ln vs log artifact: 918e389298 user: thipages | |
21:53 | • Reply: unexpected result artifact: 06dfee8d59 user: larrybr | |
21:38 | • Reply: unexpected result artifact: bc91869337 user: anonymous | |
21:30 | • Reply: unexpected result artifact: fdfe42fc68 user: anonymous | |
21:29 | • Reply: unexpected result artifact: e3727471f8 user: anonymous | |
21:27 | • Reply: unexpected result artifact: 7ca90ee309 user: kmedcalf | |
21:05 | • Edit: Research questions about how sqlite works artifact: 050b29539f user: sgarcia | |
21:03 | • Reply: unexpected result artifact: eb0f4636a2 user: anonymous | |
20:46 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: b49034dbec user: jkreibich | |
20:39 | • Reply: unexpected result artifact: 239157f96a user: anonymous | |
20:19 | • Post: Research questions about how sqlite works artifact: 38c9a445aa user: sgarcia | |
19:43 | • Reply: Feature request: Stored Procedures artifact: 579cbcabc0 user: anonymous | |
19:26 | • Reply: SQLite Wasm for Safari And Firefox progress artifact: e5aa4a4a21 user: anonymous | |
19:00 | • Reply: Hctree is an experimental high-concurrency database backend for SQLite. artifact: 93ceb7d300 user: tlaverdure | |
18:36 | • Reply: unexpected result artifact: 77215b85a2 user: larrybr | |
18:27 | • Reply: unexpected result artifact: 765b686f68 user: jicman | |
17:00 | • Edit reply: DLL load failed %1 is not a valid Win32 application artifact: f89f8372df user: kmedcalf | |
16:59 | • Edit reply: DLL load failed %1 is not a valid Win32 application artifact: ad814c9aa5 user: kmedcalf | |
16:55 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: a20fc3087a user: kmedcalf | |
16:27 | • Reply: "database disk image is malformed" caused by UNION subqueries artifact: f081dd0354 user: zuming_jiang | |
16:26 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: d4cd752557 user: kmedcalf | |
16:22 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 8b58d6a1a7 user: kmedcalf | |
16:12 | • Reply: "database disk image is malformed" caused by UNION subqueries artifact: 635480dd3d user: dan | |
16:05 | • Reply: Incorrect result might be caused by ANALYZE artifact: b2f1d10313 user: dan | |
15:47 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: a1f76fb087 user: anonymous | |
15:39 | • Post: unexpected result artifact: cb668840ac user: anonymous | |
15:32 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: 8fce2b17c4 user: drh | |
15:31 | • Reply: Incorrect result might be caused by ANALYZE artifact: b2dcfd3a4b user: ChiZhang | |
15:22 | • Edit reply: DLL load failed %1 is not a valid Win32 application artifact: ad2063a18f user: kmedcalf | |
15:21 | • Edit reply: DLL load failed %1 is not a valid Win32 application artifact: 5c09e216f4 user: kmedcalf | |
15:19 | • Edit reply: PRAGMA reverse_unordered_selects cause different results artifact: 375c1b4f46 user: kmedcalf | |
15:12 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: 83a680e861 user: kmedcalf | |
14:56 | • Edit reply: DLL load failed %1 is not a valid Win32 application artifact: fa6c8878de user: kmedcalf | |
14:54 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 87fec43dbf user: wkwkwk | |
14:53 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 7e0bccb109 user: kmedcalf | |
14:45 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: a00e228d9b user: spindrift | |
14:10 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 185ca64b0c user: anonymous | |
12:45 | • Edit reply: sqlite ln vs log artifact: da0c69818b user: Clothears | |
12:42 | • Reply: sqlite ln vs log artifact: cd288a4615 user: Clothears | |
12:39 | • Reply: Some additions to the Next.js demos artifact: 70c4f31a08 user: stephan | |
12:21 | • Reply: Some additions to the Next.js demos artifact: b581bd1d7c user: mandolyte | |
12:12 | • Post: sqlite ln vs log artifact: ead5eaddbc user: thipages | |
12:12 | • Delete reply: PRAGMA reverse_unordered_selects cause different results artifact: 6c65c5c663 user: slavin | |
08:59 | • Reply: FILTER clause with window functions artifact: 2414dce254 user: anonymous | |
08:48 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: ef6f593b8b user: jkreibich | |
08:04 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: 83acfbb457 user: John-Jove | |
08:03 | • Post: Minor misprint in the docs artifact: 52f446c028 user: hanche | |
06:25 | • Reply: "database disk image is malformed" caused by UNION subqueries artifact: 1501b80112 user: slavin | |
06:21 | • Reply: PRAGMA reverse_unordered_selects cause different results artifact: 9e6c0bc9df user: slavin | |
06:20 | • Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: cb55b60837 user: maikbe | |
05:35 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 795fef6017 user: kmedcalf | |
05:32 | • Post: PRAGMA reverse_unordered_selects cause different results artifact: 61fb10f865 user: John-Jove | |
05:03 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 6ece69495c user: kmedcalf | |
04:54 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 7d4cf3fc53 user: RandomCoder | |
03:06 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: b3b7d5530c user: wkwkwk | |
02:00 | • Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: de5bffaa2f user: drh | |
2 Years Ago (more context)
2022-03-20
| ||
23:41 | • Reply: Unable to update table data using ODBC artifact: ae5fe7ad70 user: lvth01 | |
23:14 | • Reply: Unable to update table data using ODBC artifact: 3ccd79a67a user: lvth01 | |
19:45 | • Edit reply: Possible to see how many opcodes were executed for a query? artifact: 2ae9ed146a user: kmedcalf | |
19:33 | • Edit reply: Possible to see how many opcodes were executed for a query? artifact: b1d03cdaa6 user: kmedcalf | |
19:29 | • Reply: How to unpivot a cross-table with “changing“ numbers of columns and column names? artifact: 6d661afd6e user: anonymous | |
18:43 | • Edit reply: Possible to see how many opcodes were executed for a query? artifact: 8e80d75b20 user: kmedcalf | |
18:32 | • Reply: Possible to see how many opcodes were executed for a query? artifact: 033cc6f3b7 user: kmedcalf | |
18:21 | • Reply: Possible to see how many opcodes were executed for a query? artifact: 931cdddcf7 user: simonw | |
17:54 | • Reply: Possible to see how many opcodes were executed for a query? artifact: dfb178d58c user: kmedcalf | |
17:54 | • Reply: How to unpivot a cross-table with “changing“ numbers of columns and column names? artifact: a301780291 user: anonymous | |
17:47 | • Reply: Possible to see how many opcodes were executed for a query? artifact: 0163f1fd38 user: kmedcalf | |
16:42 | • Post: Possible to see how many opcodes were executed for a query? artifact: 4ab713ad16 user: simonw | |
08:12 | • Reply: Unable to update table data using ODBC artifact: 4f16fe90de user: TripeHound | |
07:03 | • Reply: How to unpivot a cross-table with “changing“ numbers of columns and column names? artifact: 51603d29db user: anonymous | |
01:02 | • Reply: Possible tiny bug in sqlite3 .help - ".help .width" outputs more information than requested artifact: 18e7046a3c user: simonw | |
00:27 | • Reply: Unable to update table data using ODBC artifact: 2446734956 user: larrybr | |
00:17 | • Reply: Possible tiny bug in sqlite3 .help - ".help .width" outputs more information than requested artifact: 2022b289d3 user: larrybr | |
00:00 | • Post: Possible tiny bug in sqlite3 .help - ".help .width" outputs more information than requested artifact: e5750049dd user: simonw | |
3 Years Ago (more context)
2021-03-20
| ||
23:38 | • Reply: bug pragma incremental_vacuum OOMs in .mode box artifact: 54f80107ca user: larrybr | |
21:10 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: eec2bbd78d user: stephan | |
20:28 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: 0f01b1f686 user: kmedcalf | |
20:08 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: 42a9be955f user: stephan | |
19:57 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: 35a1523e9c user: kmedcalf | |
19:52 | • Reply: Opening Huaiwei android notes artifact: b24949da46 user: anonymous | |
19:33 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: 7d6c811181 user: kmedcalf | |
19:30 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: 7c78cbc7ff user: kmedcalf | |
19:18 | • Edit reply: "Scope" of SQLITE_DETERMINISTIC? artifact: a0b4fa92a0 user: kmedcalf | |
19:16 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: 8c3d318ce9 user: kmedcalf | |
18:52 | • Edit reply: 'ON DELETE CASCADE' seems to not be working artifact: 42f3915b82 user: kmedcalf | |
18:50 | • Reply: 'ON DELETE CASCADE' seems to not be working artifact: a567b7f3ae user: kmedcalf | |
18:43 | • Post: "Scope" of SQLITE_DETERMINISTIC? artifact: d4e848e31a user: stephan | |
18:27 | • Reply: bug pragma incremental_vacuum OOMs in .mode box artifact: 60112141ef user: larrybr | |
18:15 | • Reply: 'ON DELETE CASCADE' seems to not be working artifact: 82283fe1c1 user: anonymous | |
17:18 | • Edit: Proposal: Implement the MOD(x, y) function artifact: f7ec45597c user: tarest | |
17:17 | • Edit: Proposal: Implementing TRIM, SUBSTRING and POSITION standard SQL string functions artifact: de86d9d988 user: tarest | |
17:16 | • Edit reply: Proposal: Add the SUBSTRING alias to the SUBSTR function artifact: 93bce78862 user: tarest | |
17:16 | • Edit: Proposal: Add the SUBSTRING alias to the SUBSTR function artifact: 3f1e5e3330 user: tarest | |
14:37 | • Reply: Constexpr parsing of sql statement artifact: bbdc93c3d3 user: marcob | |
13:10 | • Edit reply: Week numbers in queries artifact: 73d99e4497 user: hanche | |
13:00 | • Reply: Week numbers in queries artifact: 981761eb8b user: hanche | |
09:54 | • Edit: (Deleted) artifact: 3604da9716 user: derhexer | |
09:23 | • Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 97ccb5b69b user: anonymous | |
08:20 | • Post: (Deleted) artifact: 95376d9674 user: derhexer | |
04:21 | • Reply: How do I use sqlite3_malloc in Sqlite artifact: 9413fefa7c user: anonymous | |
04:03 | • Reply: Proper set up for working with SQLite, C, Tcl/Tk? artifact: 3a4e1f9d0e user: 1codedebugger | |
02:54 | • Post: FTS build docs inconsistency artifact: 3b423b4adc user: lexfiend | |
00:58 | • Reply: Help getting excel/csv file into SQLite? please help artifact: 761be89ccf user: larrybr | |
00:13 | • Post: Help getting excel/csv file into SQLite? please help artifact: 7a1ad190e4 user: jaygray | |
00:11 | • Reply: Proper set up for working with SQLite, C, Tcl/Tk? artifact: b56fa23aac user: GSnyder | |
4 Years Ago (more context)
2020-03-20
| ||
21:38 | • Reply: lemon stack limit artifact: a2572b6050 user: anonymous | |
21:33 | • Post: Reading/writing record format artifact: 4b50e98999 user: anonymous | |
16:31 | • Reply: database is locked artifact: c1fbe2411e user: anonymous | |
14:14 | • Reply: Search does not search the message title artifact: cd9f25b893 user: gonzus | |
13:49 | • Post: lempar.c fix artifact: 5ad42d7a77 user: gonzus | |
13:31 | • Reply: Request for comment: New ANALYZE syntax artifact: d4e3f50140 user: anonymous | |
11:30 | • Reply: database is locked artifact: 5c66fa498e user: TripeHound | |
11:22 | • Reply: database is locked artifact: 305f3b3d29 user: gunter_hick | |
10:40 | • Post: database is locked artifact: 0cf75fdb16 user: takeshi | |
09:50 | • Reply: SQLite TCL test suite on linux subsystem for windows, floating point rounding differences artifact: bb2b7e998e user: havwila | |
05:27 | • Reply: ESCAPE '%' artifact: 527fb867e7 user: doug9forester | |
04:20 | • Reply: When will/were recent "sqlite3 new security issues CVEs" be addressed? artifact: 5516c9d3a0 user: anonymous | |
03:17 | • Reply: ESCAPE '%' artifact: 846632411f user: kmedcalf | |
02:23 | • Reply: When will/were recent "sqlite3 new security issues CVEs" be addressed? artifact: 62ce0159e7 user: anonymous | |
02:03 | • Reply: ESCAPE '%' artifact: 7723bbd5d1 user: doug9forester | |
01:38 | • Reply: ESCAPE '%' artifact: a437ff35f6 user: TripeHound | |