SQLite User Forum

Today In History
Login

This Day In History For 2024-05-12

1 Year Ago (more context)

2023-05-12
19:16 Reply: malformed database error when creating a view with an explicit database name and reattaching under a different name artifact: f043d07b57 user: larrybr
18:54 Reply: malformed database error when creating a view with an explicit database name and reattaching under a different name artifact: 930c456138 user: RichardDamon
18:51 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy artifact: b019474f25 user: anonymous
18:01 Reply: SELECT query with Float equality artifact: 86ed6b0a6b user: anonymous
17:37 Reply: Return of sqlite3_interrupt call artifact: db2e1f83db user: stephan
17:34 Post: Return of sqlite3_interrupt call artifact: 20fe63f69b user: nackerma
17:20 Reply: Heap buffer overflow in re_subcompile_string function artifact: 7d2f8fa5f5 user: songliu
16:58 Reply: SELECT query with Float equality artifact: a6a05099ec user: spindrift
16:36 Reply: Heap buffer overflow in re_subcompile_string function artifact: 23effa417d user: larrybr
16:22 Reply: Binary column: multiple data types and converting integer to blob artifact: 9cb7e91b5b user: kmedcalf
16:20 Reply: malformed database error when creating a view with an explicit database name and reattaching under a different name artifact: cf6df71da5 user: larrybr
16:01 Reply: malformed database error when creating a view with an explicit database name and reattaching under a different name artifact: 47a37c04dd user: drh
15:56 Reply: SELECT query with Float equality artifact: a99fb41818 user: kmedcalf
15:18 Edit reply: Binary column: multiple data types and converting integer to blob artifact: d8d36d50c2 user: kmedcalf
15:10 Reply: Assertion failure in sqlite3VdbeExec function (pKeyInfo) artifact: 92ccbfd4ab user: songliu
15:06 Post: Heap buffer overflow in re_subcompile_string function artifact: f50aecd5e8 user: songliu
15:06 Edit reply: Binary column: multiple data types and converting integer to blob artifact: 66c7b41050 user: spindrift
15:05 Reply: Binary column: multiple data types and converting integer to blob artifact: 0245bddbe6 user: larrybr
15:03 Post: malformed database error when creating a view with an explicit database name and reattaching under a different name artifact: f1cc2493cc user: Mytherin
15:00 Reply: Binary column: multiple data types and converting integer to blob artifact: fd2852ee6a user: spindrift
14:58 Post: SELECT query with Float equality artifact: fa286c4e26 user: anonymous
14:47 Edit reply: Binary column: multiple data types and converting integer to blob artifact: b51f19baba user: kmedcalf
14:44 Reply: Binary column: multiple data types and converting integer to blob artifact: c64a69c97c user: kmedcalf
14:43 Reply: Binary column: multiple data types and converting integer to blob artifact: fa8711abb1 user: spindrift
14:38 Reply: Binary column: multiple data types and converting integer to blob artifact: 9a49fc46c5 user: kmedcalf
14:30 Edit reply: Binary column: multiple data types and converting integer to blob artifact: bb157eb1da user: spindrift
14:26 Reply: Binary column: multiple data types and converting integer to blob artifact: bb07427a96 user: spindrift
14:13 Edit reply: Binary column: multiple data types and converting integer to blob artifact: f0fef4fc4d user: spindrift
14:10 Reply: Binary column: multiple data types and converting integer to blob artifact: 074fe72fac user: spindrift
14:08 Edit reply: Binary column: multiple data types and converting integer to blob artifact: ca4ad66da4 user: spindrift
14:05 Reply: Binary column: multiple data types and converting integer to blob artifact: 82f9229697 user: dvdraymond
14:02 Edit reply: Binary column: multiple data types and converting integer to blob artifact: 19aaed3b42 user: spindrift
14:00 Reply: Binary column: multiple data types and converting integer to blob artifact: dfeed51cf1 user: spindrift
13:44 Edit reply: Recovery data base artifact: 4265b14b18 user: spindrift
13:42 Reply: Recovery data base artifact: 49460bc2fa user: spindrift
13:26 Edit reply: Bilingual SQLite search tricks artifact: 485a892fb6 user: jicman
13:24 Reply: Bilingual SQLite search tricks artifact: 9695a0c32d user: jicman
13:12 Reply: Bilingual SQLite search tricks artifact: 41bec04bc7 user: kmedcalf
13:07 Edit reply: DBHASH.EXE artifact: 24adcdbe3a user: larrybr
13:02 Reply: DBHASH.EXE artifact: 9d7a8df89c user: larrybr
12:55 Reply: unable to open database file artifact: 75275aac9a user: jicman
12:50 Reply: Typos in `doc/lemon.html` and `src/btreeInt.h` artifact: f383bac50a user: drh
12:47 Reply: Recovery data base artifact: 42ba379079 user: anonymous
12:37 Reply: Binary column: multiple data types and converting integer to blob artifact: 5780cbb573 user: eisenach
12:36 Reply: Binary column: multiple data types and converting integer to blob artifact: 82ea13a3dc user: dvdraymond
12:35 Post: Typos in `doc/lemon.html` and `src/btreeInt.h` artifact: 3470da6168 user: Benjamin_Loison
11:54 Reply: Bilingual SQLite search tricks artifact: 88827b00e8 user: jchd18
11:51 Edit reply: Binary column: multiple data types and converting integer to blob artifact: 89a89b6b31 user: spindrift
11:51 Reply: Binary column: multiple data types and converting integer to blob artifact: cef346d785 user: spindrift
11:43 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy artifact: d83fd0b15b user: anonymous
11:11 Reply: Binary column: multiple data types and converting integer to blob artifact: 31b2005297 user: gunter_hick
10:52 Reply: Assertion failure in sqlite3VdbeExec function (pKeyInfo) artifact: d4b18c8077 user: drh
10:24 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy artifact: 78f1d813d3 user: anonymous
10:17 Reply: Bilingual SQLite search tricks artifact: a70cb290b3 user: dkfellows
10:17 Reply: Recovery data base artifact: 843f89291f user: spindrift
09:59 Reply: Silent data loss when inserting records using RETURNING clause in C# multithreaded scenario artifact: f4e718891d user: dkfellows
09:51 Reply: Bilingual SQLite search tricks artifact: 8a57b50293 user: jchd18
09:41 Post: DBHASH.EXE artifact: bd976560e0 user: AAsk1902
09:29 Reply: Bilingual SQLite search tricks artifact: 39ee911f71 user: sqweek
09:15 Reply: Bilingual SQLite search tricks artifact: 7699a36080 user: phil_g
09:08 Reply: Silent data loss when inserting records using RETURNING clause in C# multithreaded scenario artifact: 8695c67f01 user: enickson
09:03 Reply: Free use of first DB Page artifact: 6ef1c4b199 user: sqweek
08:58 Post: Binary column: multiple data types and converting integer to blob artifact: 5b411f93a5 user: eisenach
08:42 Reply: Recovery data base artifact: 4750fabc64 user: dkfellows
08:38 Reply: code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked artifact: 892d49c9cb user: dkfellows
08:32 Reply: Silent data loss when inserting records using RETURNING clause in C# multithreaded scenario artifact: c7a94d44f0 user: dkfellows
08:28 Edit: Silent data loss when inserting records using RETURNING clause in C# multithreaded scenario artifact: 36f7a2e749 user: enickson
07:08 Post: Silent data loss when inserting records using RETURNING clause in C# multithreaded scenario artifact: 44aaf065a3 user: enickson
07:02 Reply: Bilingual SQLite search tricks artifact: 70b8336dd3 user: punkish
06:38 Reply: Incorrect results caused by subqueries in ON clause artifact: fcf7499c2f user: zuming_jiang
06:13 Reply: Bilingual SQLite search tricks artifact: 810d025964 user: anonymous
05:35 Reply: Bilingual SQLite search tricks artifact: af4c88ced2 user: gunter_hick
05:08 Reply: unable to open database file artifact: fb6eb1688c user: anonymous
03:33 Reply: Recovery data base artifact: cbbfb75420 user: anonymous
01:12 Post: Assertion failure in sqlite3VdbeExec function (pKeyInfo) artifact: 43cbfc4d23 user: songliu

2 Years Ago (more context)

2022-05-12
18:38 Reply: Must the callback provided to preupdate_hook be thread-safe? artifact: bf25a60770 user: larrybr
18:21 Reply: Must the callback provided to preupdate_hook be thread-safe? artifact: a07d3efdc2 user: Thomasdezeeuw
16:42 Reply: Must the callback provided to preupdate_hook be thread-safe? artifact: 059ceb2ecd user: larrybr
16:40 Reply: Must the callback provided to preupdate_hook be thread-safe? artifact: 15c15fafa1 user: dan
16:19 Post: Must the callback provided to preupdate_hook be thread-safe? artifact: ecd6acdd3c user: Thomasdezeeuw
14:29 Reply: An Inconsistent Result Depending on Parenthesization artifact: af3d07f908 user: bajinsheng
12:54 Edit: Possible endless loop in a non-CTE query in 3.39 artifact: fe6a6af269 user: stephan
12:54 Reply: Possible endless loop in a non-CTE query in 3.39 artifact: d869843aa6 user: stephan
12:50 Reply: Possible endless loop in a non-CTE query in 3.39 artifact: aa3f14797f user: drh
12:12 Reply: An Inconsistent Result Depending on Parenthesization artifact: ecb84f8873 user: drh
09:27 Reply: Clarification on lemon state report artifact: afa8ff7757 user: mingodad
08:11 Post: Possible endless loop in a non-CTE query in 3.39 artifact: 46659c762e user: stephan
03:08 Reply: An Inconsistent Result Depending on Parenthesization artifact: be088c9e4a user: bajinsheng

3 Years Ago (more context)

2021-05-12
23:06 Post: Unexpected output from the SELECT statement artifact: 6c8960f545 user: LY1598773890
22:55 Reply: Inconsistent results in the WHERE clause artifact: 2aa3f5495c user: LY1598773890
22:04 Reply: Inconsistent results in the WHERE clause artifact: 696eed8057 user: drh
18:40 Post: Inconsistent results in the WHERE clause artifact: 8988341615 user: LY1598773890
15:14 Reply: SQLite 3.7.5 and above versions available in Redhat 6 artifact: 56ed992ef9 user: wyoung
15:06 Reply: Index Btree artifact: 2cc73c01d3 user: knu
14:45 Reply: Index Btree artifact: 54256d55d6 user: drh
14:40 Reply: SQLite 3.7.5 and above versions available in Redhat 6 artifact: 3cbbbd6fb5 user: anonymous
13:56 Reply: SQLite 3.7.5 and above versions available in Redhat 6 artifact: cf9184eb51 user: wyoung
13:06 Reply: Fast way to insert rows in SQLite artifact: dbd6cb2db7 user: cuz
12:55 Reply: Fast way to insert rows in SQLite artifact: 3694675536 user: skywalk
12:49 Reply: SQLite 3.7.5 and above versions available in Redhat 6 artifact: 4241d5e14c user: cuz
12:37 Reply: SQLite 3.7.5 and above versions available in Redhat 6 artifact: 8566f03e79 user: stephan
12:35 Reply: Index Btree artifact: e1880098e4 user: anonymous
12:35 Reply: Any examples of writing a loadable extension in Python? artifact: af9856aa51 user: cuz
12:31 Post: SQLite 3.7.5 and above versions available in Redhat 6 artifact: 4bb4b89227 user: anonymous
12:28 Reply: Any examples of writing a loadable extension in Python? artifact: 398956b244 user: anonymous
12:20 Reply: How to convert am/pm time to 24hrs time format artifact: d23be1d9f3 user: hanche
12:14 Post: Some questions on SQLite internals artifact: 70694d0e0d user: anonymous
11:54 Post: Any examples of writing a loadable extension in Python? artifact: 4845b22d77 user: anonymous
11:15 Reply: Index Btree artifact: d4199709aa user: curmudgeon
08:16 Reply: Entity Framework Core created a query that does not return artifact: 5025892b7c user: colonel_giuseppe
08:05 Post: Not receiving emails artifact: 50c4ec6b98 user: curmudgeon
07:25 Post: Index Btree artifact: 90b632d52a user: anonymous
03:05 Reply: How to convert am/pm time to 24hrs time format artifact: 42c5819ce8 user: anonymous
02:29 Post: Feedback on writing a SQLite VFS for a distributed object store artifact: c25091294d user: pdonnell
01:28 Reply: Cleaning up after SQLite artifact: 97ebb857c5 user: anonymous
00:52 Reply: Entity Framework Core created a query that does not return artifact: 0ccd60dcd5 user: larrybr
00:29 Reply: Cleaning up after SQLite artifact: 78d03db70e user: kmedcalf
00:13 Post: Cleaning up after SQLite artifact: 4512bdbaf4 user: anonymous

4 Years Ago (more context)

2020-05-12
22:31 Edit: Can this simple query be optimized? artifact: 13cc4dead3 user: andyMcoy
22:19 Reply: Can this simple query be optimized? artifact: 5879df2de9 user: kmedcalf
21:51 Reply: 'LEFT OUTER JOIN' has been broken with 3.31 artifact: c56f716b9f user: hsakamt
21:05 Reply: Forum suggestion artifact: d26949f590 user: wyoung
20:57 Reply: Forum suggestion artifact: f89455a8d9 user: wyoung
20:20 Post: Can this simple query be optimized? artifact: 237c5eb04f user: andyMcoy
19:45 Reply: Forum suggestion artifact: 16d39f39a5 user: RichardDamon
19:20 Reply: Forum suggestion artifact: cefc9828aa user: jicman
19:10 Post: Forum suggestion artifact: ec2484a83b user: younique
18:50 Reply: Thoughts on why this is not working? artifact: b0a331ad9c user: jicman
18:35 Reply: Thoughts on why this is not working? artifact: 22f9fed604 user: kmedcalf
18:26 Reply: Thoughts on why this is not working? artifact: 40e55a4ab0 user: jicman
18:12 Reply: Using sqlite3_load_extension on windows artifact: fdc8f657b3 user: kmedcalf
18:01 Post: Thoughts on why this is not working? artifact: fa0bb7d523 user: jicman
17:41 Reply: Using sqlite3_load_extension on windows artifact: 4f9c6fd0ef user: curmudgeon
17:37 Edit reply: Using sqlite3_load_extension on windows artifact: cc9eba82f1 user: kmedcalf
17:35 Edit reply: Using sqlite3_load_extension on windows artifact: 81fb0fb951 user: kmedcalf
17:35 Reply: Using sqlite3_load_extension on windows artifact: 06cf40156b user: kmedcalf
16:43 Reply: When committed changes become visible to connections that ATTACH? artifact: 38bb2c03ab user: drh
16:18 Post: When committed changes become visible to connections that ATTACH? artifact: b4df11e77e user: vvoinov
14:09 Reply: Using sqlite3_load_extension on windows artifact: 75837d21b5 user: curmudgeon
12:55 Reply: Bug?: CREATE TABLE with unsatisfied FK and DROP TABLE results in Error artifact: e284f56b21 user: gunter_hick
12:40 Reply: sqlite3_backup_init() function call crashing in Solaris artifact: 9570aa3860 user: stephan
12:29 Post: sqlite3_backup_init() function call crashing in Solaris artifact: 9ca89c3dfe user: anonymous
12:07 Edit reply: Can't get series.c extension to compile artifact: d245091f9d user: drh
12:05 Reply: 'LEFT OUTER JOIN' has been broken with 3.31 artifact: 976380bc6b user: drh
11:22 Reply: Bug?: CREATE TABLE with unsatisfied FK and DROP TABLE results in Error artifact: 8cb5f92610 user: martinrode
10:58 Post: matrix subpath at sqlite.org artifact: 1139196f52 user: Maxulite
10:39 Reply: Can't get series.c extension to compile artifact: a51f93c10e user: curmudgeon
10:25 Reply: When will/were recent "sqlite3 new security issues CVEs" be addressed? artifact: 4f27aaf7b8 user: drh
10:20 Reply: Can't get series.c extension to compile artifact: 7dc4621807 user: drh
10:19 Reply: 'LEFT OUTER JOIN' has been broken with 3.31 artifact: d8d8f7f326 user: drh
09:57 Post: Can't get series.c extension to compile artifact: 988758c65f user: curmudgeon
04:45 Post: 'LEFT OUTER JOIN' has been broken with 3.31 artifact: d522ac388a user: hsakamt
00:24 Reply: When will/were recent "sqlite3 new security issues CVEs" be addressed? artifact: 300bfeccc2 user: rrware