SQLite Forum

Timeline
Login

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

83 events for the month beginning 2022-05-01 by user kmedcalf

Following month ↑
2022-05-31
05:03 Reply: View with CTE no longer works artifact: 6cd1bf165b user: kmedcalf
2022-05-30
21:19 Reply: View with CTE no longer works artifact: 25c1c367fa user: kmedcalf
18:19 Reply: Usage: .read FILE - Read file doseont work artifact: 7a66214c8f user: kmedcalf
16:59 Reply: Why is the query planner avoiding my index? artifact: 9e86358da5 user: kmedcalf
16:36 Edit reply: Why is the query planner avoiding my index? artifact: cd16dfef39 user: kmedcalf
16:33 Reply: Why is the query planner avoiding my index? artifact: 469d88517a user: kmedcalf
2022-05-29
19:56 Reply: Create Index allows non-existent column artifact: 82b4984bc7 user: kmedcalf
17:25 Reply: Create Index allows non-existent column artifact: b90f6082ba user: kmedcalf
2022-05-28
03:34 Reply: Pre-determine multiple ids in multiple tables to facilitate foreign key linking for new data? artifact: 6731c72f6c user: kmedcalf
02:22 Reply: Pre-determine multiple ids in multiple tables to facilitate foreign key linking for new data? artifact: b31e161ff7 user: kmedcalf
00:36 Reply: Documentation ieee754 extension in CLI documentation artifact: 48ca47d0f4 user: kmedcalf
2022-05-27
23:49 Edit reply: Documentation ieee754 extension in CLI documentation artifact: c1509728a5 user: kmedcalf
23:31 Edit reply: Documentation ieee754 extension in CLI documentation artifact: 089c54b250 user: kmedcalf
21:41 Reply: Documentation ieee754 extension in CLI documentation artifact: 03a42dff8d user: kmedcalf
05:09 Reply: Log10(100) = 1.9999999999999998 ?!? artifact: 2bb96bd74a user: kmedcalf
05:05 Edit reply: Log10(100) = 1.9999999999999998 ?!? artifact: cb9ae8a0c1 user: kmedcalf
2022-05-26
20:21 Edit reply: Log10(100) = 1.9999999999999998 ?!? artifact: 45e66e7357 user: kmedcalf
20:15 Edit reply: Log10(100) = 1.9999999999999998 ?!? artifact: 70f3f150b7 user: kmedcalf
20:08 Edit reply: Log10(100) = 1.9999999999999998 ?!? artifact: f1a40b9eea user: kmedcalf
20:05 Edit reply: Log10(100) = 1.9999999999999998 ?!? artifact: e83acbfa15 user: kmedcalf
19:24 Reply: Log10(100) = 1.9999999999999998 ?!? artifact: 0d6f362bb8 user: kmedcalf
2022-05-25
19:11 Edit reply: Log10(100) = 1.9999999999999998 ?!? artifact: 00cc402188 user: kmedcalf
19:03 Reply: Log10(100) = 1.9999999999999998 ?!? artifact: 04ad7e86e5 user: kmedcalf
2022-05-24
05:28 Reply: Using TEXT vs REAL reduces insert performance artifact: 343b5095fe user: kmedcalf
2022-05-23
19:24 Reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 5165df43db user: kmedcalf
19:01 Reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: bf56a8114a user: kmedcalf
18:39 Reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 28b9668c9b user: kmedcalf
17:04 Reply: Memory leaking while using routine sqlite3_step function artifact: 829cc71027 user: kmedcalf
2022-05-22
21:08 Reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 4887dba1bd user: kmedcalf
20:51 Edit reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: db8bb3cd7c user: kmedcalf
20:49 Edit reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: aeac4a5764 user: kmedcalf
20:37 Edit reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 16d64d4138 user: kmedcalf
20:32 Edit reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 42ab22ff4b user: kmedcalf
20:29 Edit reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 4b0cc65fd6 user: kmedcalf
20:27 Reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 7257f78c53 user: kmedcalf
20:16 Edit reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 76fbdce76a user: kmedcalf
19:56 Reply: under what conditions will `sqlite3_value_bytes()` invalidate a blob pointer? artifact: 34045711aa user: kmedcalf
19:28 Edit reply: Upgrading from 3.31.1 to 3.38.5 - suddenly embedded 0-bytes in TEXT column? artifact: 9256641bbb user: kmedcalf
19:08 Reply: Upgrading from 3.31.1 to 3.38.5 - suddenly embedded 0-bytes in TEXT column? artifact: c5601972e1 user: kmedcalf
2022-05-20
21:49 Reply: Add split function artifact: fbaacf401b user: kmedcalf
20:28 Reply: Add split function artifact: 5b8c83df98 user: kmedcalf
17:59 Reply: Add split function artifact: 81d91803c8 user: kmedcalf
16:39 Reply: Add split function artifact: 26fd834025 user: kmedcalf
16:28 Reply: Add split function artifact: 269026e994 user: kmedcalf
2022-05-19
18:41 Reply: Can this postgres query with CTE get transformed into sqlite? artifact: 47a361ffa6 user: kmedcalf
2022-05-18
22:35 Edit reply: Multiple connections from the same process? artifact: f1506df513 user: kmedcalf
18:11 Reply: Multiple connections from the same process? artifact: 81885691ef user: kmedcalf
2022-05-15
03:42 Reply: Identifying table field is from when selecting data from multiple tables artifact: 149f4aa7c1 user: kmedcalf
2022-05-14
17:39 Reply: null inserted between the character values artifact: 1d82448d35 user: kmedcalf
17:30 Reply: Inserting into two tables in one statement, one of which requires a foreign key reference to the other? artifact: a00ae34f2d user: kmedcalf
04:45 Edit reply: select with linked tables returns incorrect column count artifact: 2d8d0dd8a4 user: kmedcalf
04:37 Reply: select with linked tables returns incorrect column count artifact: c658f5d63e user: kmedcalf
04:17 Reply: select with linked tables returns incorrect column count artifact: f8566d922b user: kmedcalf
2022-05-13
17:04 Reply: An Unexpected NULL Column Caused by Where Clause in RIGHT JOIN artifact: 85d9f2026e user: kmedcalf
2022-05-10
23:48 Reply: display rows as columns artifact: 9e5be41333 user: kmedcalf
2022-05-09
23:34 Reply: Best way to retrieve enumerated "vectors" artifact: 99f081a36a user: kmedcalf
21:52 Reply: Best way to retrieve enumerated "vectors" artifact: 12e0980f10 user: kmedcalf
19:58 Reply: Best way to retrieve enumerated "vectors" artifact: 0506a27ab8 user: kmedcalf
19:33 Edit reply: Best way to retrieve enumerated "vectors" artifact: fd4e88cdd3 user: kmedcalf
19:30 Reply: Best way to retrieve enumerated "vectors" artifact: 75c89d3f6a user: kmedcalf
2022-05-08
21:23 Reply: Possible Wrong Results of the Group By Clause artifact: 2365503b30 user: kmedcalf
2022-05-07
23:34 Edit reply: doc: date/time functions are technically non-compliant with ISO 8601 artifact: 878668c8bd user: kmedcalf
23:20 Reply: doc: date/time functions are technically non-compliant with ISO 8601 artifact: 9e47a59f53 user: kmedcalf
18:42 Reply: UPSERT and last_insert_rowid() artifact: 1ead75e2c4 user: kmedcalf
2022-05-04
08:59 Reply: 4/17/2022, 5:03:31 PM convert into YYYY-MM-DD HH:MM:SS artifact: a3bb9fb306 user: kmedcalf
2022-05-03
22:29 Edit reply: Two queries work separately, but fail when combined artifact: 98152185a5 user: kmedcalf
22:27 Reply: Two queries work separately, but fail when combined artifact: b022dc0d0f user: kmedcalf
21:58 Edit reply: Two queries work separately, but fail when combined artifact: 4aef7e4b03 user: kmedcalf
21:53 Reply: Two queries work separately, but fail when combined artifact: d9f54b6a9b user: kmedcalf
19:34 Edit reply: Two queries work separately, but fail when combined artifact: d5a7be993c user: kmedcalf
19:29 Reply: Two queries work separately, but fail when combined artifact: bfd27a42f3 user: kmedcalf
19:26 Reply: Two queries work separately, but fail when combined artifact: 01489112b9 user: kmedcalf
00:06 Reply: Possible Wrong Results of the Group By Clause artifact: f838421571 user: kmedcalf
2022-05-02
21:31 Reply: Path of running CLI (Windows)? artifact: ca08683323 user: kmedcalf
21:21 Edit reply: Path of running CLI (Windows)? artifact: 548056efb7 user: kmedcalf
21:16 Reply: Path of running CLI (Windows)? artifact: d02be707c8 user: kmedcalf
21:05 Reply: Possible Wrong Results of the Group By Clause artifact: f492707544 user: kmedcalf
21:02 Reply: Possible Wrong Results of the Group By Clause artifact: 3e3bdf6d94 user: kmedcalf
20:56 Reply: Possible Wrong Results of the Group By Clause artifact: 372a64adc9 user: kmedcalf
20:52 Reply: Possible Wrong Results of the Group By Clause artifact: e493c2efd9 user: kmedcalf
20:10 Reply: Possible Wrong Results of the Group By Clause artifact: 92f8495d83 user: kmedcalf
18:21 Reply: Possible Wrong Results of the Group By Clause artifact: d123434a30 user: kmedcalf
04:51 Reply: Possible Wrong Results of the Group By Clause artifact: 39865b1cb2 user: kmedcalf
Previous month ↓