SQLite User Forum

Today In History
Login

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