SQLite Forum

Timeline
Login

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

169 events for the month beginning 2022-11-01 by user anonymous

Following month ↑
2022-11-30
14:13 Reply: sqlite3_step() always returning TDS_MORE artifact: 5dd0c12507 user: anonymous
13:24 Post: sqlite3_step() always returning TDS_MORE artifact: 51042bf757 user: anonymous
07:24 Reply: Static incorporation of extensions artifact: 5a435721dd user: anonymous
01:39 Reply: Keeping the index and delete the table artifact: f95f6f1b2c user: anonymous
2022-11-29
21:44 Reply: Static incorporation of extensions artifact: 9d5ce0b2ee user: anonymous
2022-11-28
23:01 Reply: TEMP TABLE + UPSERT + RETURNING → no row artifact: a5ed862153 user: anonymous
12:52 Post: BigDecimal/Double precision artifact: 317d2b7a2e user: anonymous
06:27 Post: TEMP TABLE + UPSERT + RETURNING → no row artifact: 800f12cf73 user: anonymous
2022-11-26
08:52 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 9c57704acc user: anonymous
07:25 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: f22536934e user: anonymous
04:56 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 6b02e9c914 user: anonymous
03:45 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: d80b47317e user: anonymous
03:23 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 3f201be563 user: anonymous
2022-11-25
22:13 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 3615934519 user: anonymous
10:04 Reply: change column check constraint artifact: 94b0305d7e user: anonymous
06:56 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: ed6e93cd80 user: anonymous
06:17 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: deaf726b23 user: anonymous
00:10 Post: Missing documentation hyphen? artifact: 87dd66375a user: anonymous
2022-11-24
23:53 Reply: Is fts5 fit for ebook search ? artifact: 919e8e8e1d user: anonymous
09:53 Reply: change column check constraint artifact: 47db8031ce user: anonymous
07:45 Post: change column check constraint artifact: a919015be1 user: anonymous
06:39 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 372383faff user: anonymous
05:52 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: d27ac9ee26 user: anonymous
04:24 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: ae518422ee user: anonymous
00:40 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: b01fa15652 user: anonymous
2022-11-23
18:16 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 00f099cbfe user: anonymous
17:51 Reply: SQLite3 wasm does not persist in OPFS storage artifact: 67a87c0377 user: anonymous
13:44 Reply: SQLite3 wasm does not persist in OPFS storage artifact: 193a63c0db user: anonymous
10:14 Post: SQLite3 wasm does not persist in OPFS storage artifact: fdb69a08da user: anonymous
05:03 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 425031bb05 user: anonymous
04:44 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: c7d442b4d4 user: anonymous
03:54 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: a6928c9a0d user: anonymous
03:40 Reply: Datatype for timespec? artifact: e0c1961c4b user: anonymous
2022-11-22
23:47 Reply: Datatype for timespec? artifact: 2b1345ebbd user: anonymous
22:30 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 0c1f90b0ec user: anonymous
22:09 Reply: Datatype for timespec? artifact: 8458de1e43 user: anonymous
20:10 Reply: Keeping the index and delete the table artifact: 8dacb3504e user: anonymous
19:15 Reply: cid stability in pragma results artifact: 060fec6beb user: anonymous
18:54 Reply: Keeping the index and delete the table artifact: 1430df01b0 user: anonymous
18:37 Reply: Keeping the index and delete the table artifact: ad541a463d user: anonymous
18:15 Post: Bug report: Unknown VFS error message artifact: 1217fdd6b3 user: anonymous
09:58 Reply: Built in operators artifact: 75f0d4b2dd user: anonymous
06:34 Reply: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 2fd7c904b1 user: anonymous
03:17 Reply: ALTER TABLE RENAME strange behavior artifact: 37ab03c451 user: anonymous
2022-11-21
21:44 Reply: ALTER TABLE RENAME strange behavior artifact: 1d18f2f23c user: anonymous
21:31 Reply: ALTER TABLE RENAME strange behavior artifact: e9c0a4765c user: anonymous
19:18 Reply: ALTER TABLE RENAME strange behavior artifact: 0c6d78bf3f user: anonymous
19:11 Reply: ALTER TABLE RENAME strange behavior artifact: 0c54fc2d6d user: anonymous
19:05 Reply: ALTER TABLE RENAME strange behavior artifact: e454bce4ed user: anonymous
17:46 Reply: ALTER TABLE RENAME strange behavior artifact: afec400575 user: anonymous
17:33 Post: ALTER TABLE RENAME strange behavior artifact: ce0d670b43 user: anonymous
17:02 Reply: Pragma query with mutiple DBs artifact: 3c72bf511f user: anonymous
15:59 Reply: Pragma query with mutiple DBs artifact: 4e99275cd7 user: anonymous
13:52 Post: Do VACUUM INTO interrupts and restarts on db updates? artifact: b75ec8c285 user: anonymous
11:54 Reply: Parse tree artifact: 57d4c235cd user: anonymous
06:38 Reply: sqlite3_open crashing artifact: 54abb68dbc user: anonymous
02:34 Reply: Can I rename the field that is PK? artifact: 036aa67b7c user: anonymous
00:34 Reply: Can I rename the field that is PK? artifact: 647896df47 user: anonymous
2022-11-20
21:28 Reply: cid stability in pragma results artifact: 292fbcba40 user: anonymous
20:29 Reply: cid stability in pragma results artifact: d101821a1f user: anonymous
20:17 Reply: cid stability in pragma results artifact: 779d051222 user: anonymous
19:56 Post: Is fts5 fit for ebook search ? artifact: fe3ae85d79 user: anonymous
18:20 Post: cid stability in pragma results artifact: 6e1ae33006 user: anonymous
09:42 Reply: Base85, Yet another text/blob conversion artifact: 3d1f092136 user: anonymous
02:47 Reply: sqlite3_open crashing artifact: e8cfa5abd0 user: anonymous
2022-11-19
23:00 Reply: deactivating triggers temporarily artifact: 0aee6e6b74 user: anonymous
10:56 Reply: sqlite3_open crashing artifact: 59a9a0d5d2 user: anonymous
07:18 Reply: System.Data.Sqlite.Core for Macos M1 available for download / nuget artifact: e4d00a78fd user: anonymous
01:33 Reply: deactivating triggers temporarily artifact: 2a8f40cfe9 user: anonymous
2022-11-18
23:10 Reply: sqlite mutex sqlite3_mutex_enter with multiple database files artifact: 8e1561b881 user: anonymous
19:11 Reply: deactivating triggers temporarily artifact: d24e62aded user: anonymous
17:36 Reply: WASM opfs & multiple tabs artifact: 88f6d83cf4 user: anonymous
16:03 Reply: WASM opfs & multiple tabs artifact: 2fcb79e851 user: anonymous
10:11 Reply: sqlite3_open crashing artifact: eb84e60302 user: anonymous
09:23 Reply: sqlite3_open crashing artifact: 2025ef7eb9 user: anonymous
00:30 Post: sqlite mutex sqlite3_mutex_enter with multiple database files artifact: 56bc7f4999 user: anonymous
2022-11-17
20:35 Reply: sqlite3_value_encoding usage artifact: 1e2695f6db user: anonymous
16:24 Reply: WASM opfs & multiple tabs artifact: 2d127a9975 user: anonymous
14:20 Reply: sqlite3_value_encoding usage artifact: 0373fb774c user: anonymous
13:34 Post: sqlite3_value_encoding usage artifact: c9f445453d user: anonymous
12:05 Reply: Base85, Yet another text/blob conversion artifact: 203bcc15eb user: anonymous
11:05 Reply: Documentation corrections artifact: 9a7e0ff408 user: anonymous
03:35 Reply: SQLite3 Keywords artifact: f05413d9d7 user: anonymous
01:54 Post: Fatal error: Uncaught Error: Object of class SQLite3Result could not be converted to string in C:\Users artifact: d48f00d60f user: anonymous
2022-11-16
22:28 Reply: Is rootpage a stable identifier for a table? artifact: c88b053090 user: anonymous
17:36 Reply: Need help in scaling SQLite when using SQLite as cache artifact: aceb2f7f19 user: anonymous
13:39 Reply: SQLite3 Keywords artifact: f2fffb126a user: anonymous
08:29 Reply: Possible bug: Unable to find an entry point artifact: 4affcccfa6 user: anonymous
05:59 Post: Segmentation Fault in sqlite3.c (allocateCursor) in SQLite 3.36.0 artifact: c05c857f36 user: anonymous
2022-11-15
20:52 Reply: advice on SQLite DB structure artifact: 903fd1f716 user: anonymous
18:23 Reply: SQLITE_BUSY on closing db but with no stmt busy artifact: bfca24b10f user: anonymous
11:05 Reply: sqlite3_open crashing artifact: 796f50956e user: anonymous
03:59 Post: sqlite3_open crashing artifact: 609346a6a8 user: anonymous
2022-11-14
18:48 Reply: SQLITE_BUSY on closing db but with no stmt busy artifact: 47bf292320 user: anonymous
16:14 Reply: ESM Compatible WASM package artifact: 315c87575e user: anonymous
15:21 Post: .NET NuGet Package artifact: dfb5989cd8 user: anonymous
15:08 Post: Efficiency of data repeated across rows in a result set artifact: 8aac19ad85 user: anonymous
14:53 Reply: VS2022 installer with Sqlite db artifact: b61f9ac4f0 user: anonymous
01:35 Reply: Double rather than Int artifact: a3ed0267c7 user: anonymous
00:59 Reply: VS2022 installer with Sqlite db artifact: f9cc2d714f user: anonymous
00:22 Reply: Why allowed to create tables with nonsense data types / names? artifact: 9f36edc9bb user: anonymous
00:09 Reply: Enhancement request - add description of the autoindexes artifact: 913e7f27ec user: anonymous
2022-11-13
22:11 Reply: Enhancement request - add description of the autoindexes artifact: 18d67b6768 user: anonymous
21:35 Reply: VS2022 installer with Sqlite db artifact: d0752ffbfa user: anonymous
20:30 Post: Enhancement request - add description of the autoindexes artifact: 164e2cafc9 user: anonymous
18:44 Post: Why allowed to create tables with nonsense data types / names? artifact: ff3255121f user: anonymous
17:30 Post: VS2022 installer with Sqlite db artifact: f049769841 user: anonymous
16:25 Post: SQLITE_BUSY on closing db but with no stmt busy artifact: c8b364331a user: anonymous
15:41 Post: Sqldiff no such collation sequence artifact: 831a664676 user: anonymous
04:04 Reply: EXPLAIN QUERY PLAN doesn't show the table names that the query pulls data from artifact: a7fc5285fa user: anonymous
03:17 Reply: MacOS download is still 3.28.0, not 3.39 artifact: 74dcb1fc34 user: anonymous
2022-11-12
23:38 Post: EXPLAIN QUERY PLAN doesn't show the table names that the query pulls data from artifact: 16140bf655 user: anonymous
23:35 Post: MacOS download is still 3.28.0, not 3.39 artifact: 32cd84446d user: anonymous
22:43 Post: Linking with shared library - undefined references artifact: 46f91b408a user: anonymous
22:09 Reply: Is there a function to quote identifiers? artifact: 48ee475013 user: anonymous
17:55 Reply: Can just reading pragma schema_version corrupt the database file? artifact: 612fe96e56 user: anonymous
17:53 Reply: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: c198dddbaa user: anonymous
14:06 Reply: Can just reading pragma schema_version corrupt the database file? artifact: 0bc8e957ef user: anonymous
13:45 Reply: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: a61226ba2a user: anonymous
13:32 Post: Just a note of thanks for the great SQLite dbms artifact: b4da31835b user: anonymous
13:28 Post: Can just reading pragma schema_version corrupt the database file? artifact: 2b9cc3dae1 user: anonymous
13:07 Post: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: 919c34e727 user: anonymous
2022-11-10
22:39 Post: tab characters in 4 lines of code - apologies artifact: 0cdce5db8c user: anonymous
22:08 Reply: CVE-2019-8602, CVE-2019-8600 and CVE-2019-8598 artifact: e1d6fd74cb user: anonymous
18:59 Reply: System.Data.Sqlite.Core for Macos M1 available for download / nuget artifact: 6a6042dc4f user: anonymous
16:33 Reply: ENOTABUG Bug report: default journal_mode seems to delete journal without checking status artifact: 4b77f12aa4 user: anonymous
14:56 Reply: ENOTABUG Bug report: default journal_mode seems to delete journal without checking status artifact: 2a291fb19d user: anonymous
02:30 Reply: "database disk image is malformed" with an in-memory database? artifact: 9e45dcdc7d user: anonymous
2022-11-09
21:56 Reply: SQLite3 Seg Fault when executing query artifact: e7087afe6b user: anonymous
21:16 Post: CVE-2019-8602, CVE-2019-8600 and CVE-2019-8598 artifact: 74f3dd062c user: anonymous
20:23 Reply: sqlite3_exec artifact: ab460e4c41 user: anonymous
20:04 Reply: clone table: INTEGER columns become INT artifact: 30815fb796 user: anonymous
18:19 Post: Invalid SQL for using column inside a subquery in projection artifact: 9940a82447 user: anonymous
10:36 Reply: group_concat - ORDER BY parameter please. artifact: 71fa8862f9 user: anonymous
2022-11-08
19:06 Reply: How to obtain check constraints? artifact: 68cfe85bf7 user: anonymous
18:39 Reply: How to obtain check constraints? artifact: 25a479dc92 user: anonymous
11:58 Reply: How to use zipfile with archive in memory? artifact: 0799bd76dd user: anonymous
10:02 Post: How to obtain check constraints? artifact: 6c4301a107 user: anonymous
03:05 Reply: base64 amalgamation source artifact: 478b277665 user: anonymous
2022-11-07
16:04 Post: base64 amalgamation source artifact: 039e131a4b user: anonymous
14:25 Reply: Automated vulnerability detection artifact: 3adcbfe4a9 user: anonymous
12:30 Post: Automated vulnerability detection artifact: ff3f64672e user: anonymous
2022-11-06
00:20 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 7e1669422a user: anonymous
2022-11-05
21:43 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 5bd24406f2 user: anonymous
18:06 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: e373f2a1bd user: anonymous
14:57 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 40f566cbde user: anonymous
00:13 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: ef0a8c127b user: anonymous
2022-11-04
20:29 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 16b257ea26 user: anonymous
20:09 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 42c0ae11be user: anonymous
19:54 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: dbcdbda3f8 user: anonymous
18:30 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 802141a302 user: anonymous
18:29 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 6411b0500d user: anonymous
17:39 Reply: Problem with sqlite3 (CLI): Error: too many options artifact: 00c726682d user: anonymous
17:25 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: e8d25e8c3e user: anonymous
16:59 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 3ea14b49c9 user: anonymous
16:30 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: f90cebfc13 user: anonymous
16:17 Post: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 53b73c853a user: anonymous
01:01 Post: Problem with sqlite3 (CLI): Error: too many options artifact: ef17b8e345 user: anonymous
2022-11-03
14:09 Post: Legacy/No Legacy mode artifact: 4556e6d659 user: anonymous
10:53 Reply: why are json function arguments variadic? artifact: f420c6564b user: anonymous
10:32 Reply: why are json function arguments variadic? artifact: bd21a0e883 user: anonymous
10:24 Reply: why are json function arguments variadic? artifact: 98c1b46f6a user: anonymous
07:45 Post: why are json function arguments variadic? artifact: 34bf6c7a3a user: anonymous
06:04 Reply: "database disk image is malformed" with an in-memory database? artifact: ad5e50ce6d user: anonymous
06:02 Reply: "database disk image is malformed" with an in-memory database? artifact: 1d3ba4ead7 user: anonymous
2022-11-02
22:36 Post: documentation of temporary files... artifact: 5c77a8cf04 user: anonymous
15:26 Reply: Abuse of nullvalue in shell output artifact: 5fb0b6294d user: anonymous
2022-11-01
19:55 Post: 1.0.117.0 Status artifact: 783fbac6b0 user: anonymous
03:48 Reply: Another CLI crashing problem artifact: a4a765b922 user: anonymous
Previous month ↓