SQLite Forum

Timeline
Login

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

171 events for the month beginning 2022-11-01 by user kmedcalf

Following month ↑
2022-11-30
16:57 Reply: U+C2B7 is not recognized by sqlite3 on PowerShell artifact: f63112ae9b user: kmedcalf
01:48 Edit reply: Keeping the index and delete the table artifact: 9fe8a1ef0a user: kmedcalf
01:47 Reply: Keeping the index and delete the table artifact: 7c376a7961 user: kmedcalf
2022-11-29
18:02 Reply: Disabling Quoting in sqlite3 CLI's .import artifact: 6d5442b058 user: kmedcalf
15:05 Edit reply: Disabling Quoting in sqlite3 CLI's .import artifact: 80601fe2df user: kmedcalf
15:02 Edit reply: Disabling Quoting in sqlite3 CLI's .import artifact: 14adfc50c8 user: kmedcalf
15:00 Reply: Disabling Quoting in sqlite3 CLI's .import artifact: 6ab5b0e39b user: kmedcalf
14:55 Reply: Static incorporation of extensions artifact: c64ddf3a03 user: kmedcalf
14:32 Reply: Disabling Quoting in sqlite3 CLI's .import artifact: 383aaacdcd user: kmedcalf
14:01 Edit reply: Disabling Quoting in sqlite3 CLI's .import artifact: 59b5e08659 user: kmedcalf
13:59 Reply: Disabling Quoting in sqlite3 CLI's .import artifact: e16d650951 user: kmedcalf
12:11 Edit reply: Disabling Quoting in sqlite3 CLI's .import artifact: 4e23346c18 user: kmedcalf
12:10 Reply: Disabling Quoting in sqlite3 CLI's .import artifact: b503c07f18 user: kmedcalf
12:07 Edit reply: Disabling Quoting in sqlite3 CLI's .import artifact: 635023b9b8 user: kmedcalf
12:06 Reply: Disabling Quoting in sqlite3 CLI's .import artifact: f21eab8cf5 user: kmedcalf
2022-11-28
19:03 Reply: Prepare fail artifact: 199bb11cc7 user: kmedcalf
18:57 Reply: PIVOT / UNPIVOT / TRANSPOSE / CROSSTAB artifact: c4cc400db8 user: kmedcalf
16:31 Reply: Prepare fail artifact: b4dd396079 user: kmedcalf
16:19 Reply: Prepare fail artifact: cdf44ef3c2 user: kmedcalf
15:10 Reply: Base85, Yet another text/blob conversion artifact: fe9eac788f user: kmedcalf
14:31 Reply: BigDecimal/Double precision artifact: 3359cfdc60 user: kmedcalf
14:23 Edit reply: BigDecimal/Double precision artifact: d379ab326a user: kmedcalf
14:21 Reply: BigDecimal/Double precision artifact: 6862e3ef76 user: kmedcalf
2022-11-27
19:15 Reply: speeding up a JOIN + GROUP BY query artifact: cd544aa28f user: kmedcalf
15:58 Edit reply: speeding up a JOIN + GROUP BY query artifact: c0001f9f93 user: kmedcalf
15:52 Reply: speeding up a JOIN + GROUP BY query artifact: c5c805fca3 user: kmedcalf
12:49 Reply: speeding up a JOIN + GROUP BY query artifact: fb7b294ee1 user: kmedcalf
11:13 Reply: speeding up a JOIN + GROUP BY query artifact: 8b9a5b3df8 user: kmedcalf
10:56 Reply: speeding up a JOIN + GROUP BY query artifact: 43a82ec551 user: kmedcalf
10:14 Reply: speeding up a JOIN + GROUP BY query artifact: 91c53cf630 user: kmedcalf
09:47 Reply: speeding up a JOIN + GROUP BY query artifact: 97a19e2df7 user: kmedcalf
09:17 Edit reply: speeding up a JOIN + GROUP BY query artifact: 7eaaf89e06 user: kmedcalf
09:16 Reply: speeding up a JOIN + GROUP BY query artifact: fdf430a9fa user: kmedcalf
00:26 Reply: speeding up a JOIN + GROUP BY query artifact: 8c1a04c322 user: kmedcalf
2022-11-26
06:14 Edit reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 1aa262188a user: kmedcalf
06:10 Edit reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 6b95f11cfd user: kmedcalf
06:09 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 8871f1b056 user: kmedcalf
2022-11-25
18:25 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 3584f44684 user: kmedcalf
17:54 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 334a299467 user: kmedcalf
07:27 Reply: missing error message for subquery returning more than one row artifact: 64c6383935 user: kmedcalf
2022-11-24
18:06 Edit reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 15e25f3311 user: kmedcalf
18:05 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 105a0ab358 user: kmedcalf
16:14 Edit reply: v3.40.0 very slow with UNIONs (or so I think) artifact: c3e8be7298 user: kmedcalf
16:08 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: b02585bb4b user: kmedcalf
01:20 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 539e746712 user: kmedcalf
2022-11-23
18:15 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 18f08abfaa user: kmedcalf
18:10 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: d91de0aaeb user: kmedcalf
07:50 Edit reply: v3.40.0 very slow with UNIONs (or so I think) artifact: df9f18d22b user: kmedcalf
07:47 Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 0713cad155 user: kmedcalf
00:41 Reply: Datatype for timespec? artifact: 4cd34b18de user: kmedcalf
2022-11-22
23:02 Reply: Datatype for timespec? artifact: 76189dbce4 user: kmedcalf
21:00 Reply: Datatype for timespec? artifact: 0afaeafb41 user: kmedcalf
20:58 Edit reply: Datatype for timespec? artifact: 6cbcafd741 user: kmedcalf
20:57 Reply: Datatype for timespec? artifact: 80c001e380 user: kmedcalf
20:52 Edit reply: Clarification on VACUUMing artifact: f04cf68070 user: kmedcalf
20:51 Reply: Clarification on VACUUMing artifact: 17feffb783 user: kmedcalf
20:45 Reply: Parse tree artifact: d8b5549dea user: kmedcalf
16:23 Reply: Clarification on VACUUMing artifact: 67bfa5fe92 user: kmedcalf
16:19 Edit reply: Datatype for timespec? artifact: d80574d4e2 user: kmedcalf
16:16 Reply: Datatype for timespec? artifact: 5e6c0612e7 user: kmedcalf
16:10 Reply: cid stability in pragma results artifact: 8f9720c512 user: kmedcalf
15:42 Reply: Datatype for timespec? artifact: 2666e9b818 user: kmedcalf
02:41 Reply: Datatype for timespec? artifact: 5508b5d1ac user: kmedcalf
02:35 Reply: Datatype for timespec? artifact: 5b753f6a77 user: kmedcalf
02:29 Reply: Datatype for timespec? artifact: 3686904724 user: kmedcalf
2022-11-21
19:31 Edit reply: ALTER TABLE RENAME strange behavior artifact: c39294438d user: kmedcalf
19:28 Reply: ALTER TABLE RENAME strange behavior artifact: e845d236dd user: kmedcalf
18:49 Reply: ALTER TABLE RENAME strange behavior artifact: 4ed8df57f9 user: kmedcalf
18:10 Edit reply: Do VACUUM INTO interrupts and restarts on db updates? artifact: 2f955d3a55 user: kmedcalf
17:43 Reply: ALTER TABLE RENAME strange behavior artifact: 9085454b59 user: kmedcalf
17:32 Reply: Pragma query with mutiple DBs artifact: 80d55a5799 user: kmedcalf
16:42 Reply: Pragma query with mutiple DBs artifact: a406aca527 user: kmedcalf
15:07 Edit reply: Do VACUUM INTO interrupts and restarts on db updates? artifact: aa3c0a184a user: kmedcalf
14:55 Edit reply: Do VACUUM INTO interrupts and restarts on db updates? artifact: d36a50787a user: kmedcalf
14:52 Reply: Do VACUUM INTO interrupts and restarts on db updates? artifact: fc580e3166 user: kmedcalf
14:42 Edit reply: Pragma query with mutiple DBs artifact: adfc94b267 user: kmedcalf
14:40 Reply: Pragma query with mutiple DBs artifact: 85e459aeec user: kmedcalf
14:34 Reply: Pragma query with mutiple DBs artifact: 11bd0cd477 user: kmedcalf
2022-11-20
21:23 Edit reply: Sharing in-memory DB between connecitons artifact: ad934b2ec8 user: kmedcalf
21:22 Reply: Sharing in-memory DB between connecitons artifact: a1bb137b94 user: kmedcalf
20:37 Reply: cid stability in pragma results artifact: 7f6b08e18e user: kmedcalf
19:53 Edit reply: cid stability in pragma results artifact: 701995aaa1 user: kmedcalf
19:48 Reply: cid stability in pragma results artifact: 2f8868012b user: kmedcalf
19:41 Edit reply: it would be helpful if a wrong path in ATTACH croaked with an error artifact: 10f27753ad user: kmedcalf
19:40 Reply: it would be helpful if a wrong path in ATTACH croaked with an error artifact: 812fac7412 user: kmedcalf
18:10 Reply: it would be helpful if a wrong path in ATTACH croaked with an error artifact: 5813ad6481 user: kmedcalf
18:00 Reply: it would be helpful if a wrong path in ATTACH croaked with an error artifact: ff7eb2627a user: kmedcalf
17:16 Reply: Sharing in-memory DB between connecitons artifact: 0d027f9240 user: kmedcalf
16:52 Edit reply: Error occurred when CAST and COLLATE BINARY are used together artifact: 4987753012 user: kmedcalf
16:37 Reply: Error occurred when CAST and COLLATE BINARY are used together artifact: f5e9359a3c user: kmedcalf
16:23 Reply: An error occurred when the CAST function converted the numerical value in the form of Scientific notation artifact: 3f085531bf user: kmedcalf
2022-11-19
19:43 Reply: deactivating triggers temporarily artifact: 11e299011b user: kmedcalf
2022-11-18
14:34 Reply: sqlite3_open crashing artifact: f4fc780f44 user: kmedcalf
14:32 Reply: sqlite3_open crashing artifact: a7a5168fab user: kmedcalf
2022-11-16
22:33 Reply: Is rootpage a stable identifier for a table? artifact: 7e06c8f207 user: kmedcalf
18:05 Reply: SQLite3 Keywords artifact: 634f5fb5b9 user: kmedcalf
2022-11-15
22:18 Edit reply: SQLite3 Keywords artifact: d38f9f377a user: kmedcalf
22:07 Reply: SQLite3 Keywords artifact: 9d57a38041 user: kmedcalf
20:04 Edit reply: SQLite3 Keywords artifact: af9e80198d user: kmedcalf
20:03 Edit reply: SQLite3 Keywords artifact: 7c472208ab user: kmedcalf
19:58 Reply: SQLite3 Keywords artifact: e887ffa7f2 user: kmedcalf
15:54 Reply: sqlite3_open crashing artifact: 6a0abaaadd user: kmedcalf
14:53 Reply: spatialite on Linux: .schema returns Error: no such column: rowid
artifact: c876a18487 user: kmedcalf
2022-11-14
23:15 Reply: sqlite does not work (allegedly) artifact: 382e646c71 user: kmedcalf
23:06 Reply: SQLITE_BUSY on closing db but with no stmt busy artifact: 4a08ee6e94 user: kmedcalf
21:41 Reply: SQLITE_BUSY on closing db but with no stmt busy artifact: 41d097ea2f user: kmedcalf
15:51 Edit reply: Double rather than Int artifact: 57dd5d7c04 user: kmedcalf
15:49 Edit reply: Double rather than Int artifact: ba74578c7b user: kmedcalf
15:10 Edit reply: Double rather than Int artifact: eb5c839fd0 user: kmedcalf
15:05 Reply: Double rather than Int artifact: 3f1021e381 user: kmedcalf
00:40 Edit reply: Enhancement request - add description of the autoindexes artifact: b9145be82e user: kmedcalf
00:38 Reply: Enhancement request - add description of the autoindexes artifact: f302518a69 user: kmedcalf
00:05 Reply: Enhancement request - add description of the autoindexes artifact: 18006e8bb1 user: kmedcalf
2022-11-13
23:48 Reply: Enhancement request - add description of the autoindexes artifact: 4bfe8a5977 user: kmedcalf
22:56 Reply: Enhancement request - add description of the autoindexes artifact: 41db6f3f78 user: kmedcalf
22:42 Edit reply: Enhancement request - add description of the autoindexes artifact: f202a2e04f user: kmedcalf
22:40 Edit reply: Enhancement request - add description of the autoindexes artifact: c8300dd661 user: kmedcalf
22:31 Edit reply: Enhancement request - add description of the autoindexes artifact: f6c7b2e947 user: kmedcalf
22:06 Edit reply: Enhancement request - add description of the autoindexes artifact: 3def0beebb user: kmedcalf
22:05 Reply: Enhancement request - add description of the autoindexes artifact: 843187a75b user: kmedcalf
21:37 Reply: Enhancement request - add description of the autoindexes artifact: f80a4f37ce user: kmedcalf
21:21 Reply: Enhancement request - add description of the autoindexes artifact: 0ab2df9b05 user: kmedcalf
21:09 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 8f2a0be2ce user: kmedcalf
20:57 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 59b35d40c5 user: kmedcalf
20:52 Edit reply: Follow-up: ATTACH successful, but next qery is not artifact: c5c69c40aa user: kmedcalf
20:45 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 5ddb03b841 user: kmedcalf
20:18 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 57e5c94145 user: kmedcalf
20:03 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 78c0fd7ff2 user: kmedcalf
19:59 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 3b17c42952 user: kmedcalf
19:58 Reply: Follow-up: ATTACH successful, but next qery is not artifact: a495874833 user: kmedcalf
19:19 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 03e43453dd user: kmedcalf
17:19 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 46049bf5b6 user: kmedcalf
17:16 Reply: SQLITE_BUSY on closing db but with no stmt busy artifact: c2b98cafab user: kmedcalf
15:56 Reply: Follow-up: ATTACH successful, but next qery is not artifact: 57778eb643 user: kmedcalf
2022-11-12
18:32 Reply: Double rather than Int artifact: 0559fc3a10 user: kmedcalf
18:24 Reply: Extra linefeed with "order by" artifact: 4666ff1b23 user: kmedcalf
18:20 Reply: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: 91fa546f42 user: kmedcalf
17:05 Reply: Table-valued PRAGMA statements vs functions within transactions artifact: f77e090338 user: kmedcalf
16:58 Reply: Extra linefeed with "order by" artifact: ed291e7819 user: kmedcalf
15:38 Edit reply: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: a4632b5f6d user: kmedcalf
15:36 Edit reply: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: 7d4ebbc1f8 user: kmedcalf
15:34 Reply: UNIQUE column constraint - where's the UNIQUE INDEX? artifact: e78c1c9b70 user: kmedcalf
15:26 Reply: sqlite3_exec: followup artifact: bd5c2f7113 user: kmedcalf
15:24 Reply: Detecting Changes to Database tables? (for paged queries etc) artifact: 211199a5ed user: kmedcalf
2022-11-11
02:51 Reply: Finding More than one value for another value artifact: 5a0533ef47 user: kmedcalf
2022-11-10
16:05 Reply: Table-valued PRAGMA statements vs functions within transactions artifact: a5b240b5ac user: kmedcalf
2022-11-09
20:23 Reply: sqlite3_exec artifact: 3943dd5784 user: kmedcalf
19:42 Reply: ENOTABUG Bug report: default journal_mode seems to delete journal without checking status artifact: 6efb6a3e3c user: kmedcalf
19:36 Reply: sqlite3_exec artifact: 132a91ca40 user: kmedcalf
14:05 Reply: How to use zipfile with archive in memory? artifact: c625d6b587 user: kmedcalf
2022-11-08
19:06 Reply: SQLite3 Seg Fault when executing query artifact: 10bb8b03e2 user: kmedcalf
04:55 Reply: How to use zipfile with archive in memory? artifact: 7bf6bc0ab5 user: kmedcalf
04:31 Reply: How to use zipfile with archive in memory? artifact: e26eaa2d27 user: kmedcalf
2022-11-07
18:25 Reply: base64 amalgamation source artifact: bde6874eda user: kmedcalf
2022-11-06
16:07 Reply: Pending release of SQLite version 3.40.0 artifact: 705531834a user: kmedcalf
2022-11-05
17:32 Reply: Natural sort order artifact: dfe10bf8d5 user: kmedcalf
17:17 Reply: Natural sort order artifact: 74a2357d06 user: kmedcalf
17:10 Reply: Natural sort order artifact: 3d6644547d user: kmedcalf
00:16 Reply: Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths artifact: 776c02d0cf user: kmedcalf
2022-11-04
20:51 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: c7c6555f19 user: kmedcalf
20:41 Edit reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: 02fcfee9f8 user: kmedcalf
20:41 Reply: Unexpected results from query - Order of operations LIMIT within subquery and ORDER BY in outer query artifact: cdcd3bddfa user: kmedcalf
13:09 Reply: Legacy/No Legacy mode artifact: 07fa7913a6 user: kmedcalf
2022-11-03
15:25 Reply: Enumerate list of SQLie APIs artifact: fed3c0c465 user: kmedcalf
14:54 Reply: Enumerate list of SQLie APIs artifact: 15ad1911a6 user: kmedcalf
12:16 Reply: Enumerate list of SQLie APIs artifact: 3711654214 user: kmedcalf
2022-11-02
14:14 Edit reply: Extensions Destructor? artifact: a38be46f01 user: kmedcalf
14:10 Edit reply: Extensions Destructor? artifact: 478aae9d3c user: kmedcalf
14:07 Reply: Extensions Destructor? artifact: c02415d3e1 user: kmedcalf
13:51 Reply: Abuse of nullvalue in shell output artifact: 48ba845fd6 user: kmedcalf
2022-11-01
20:26 Reply: Extensions Destructor? artifact: 1a78998dc2 user: kmedcalf
Previous month ↓