SQLite Forum

Timeline
Login

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

162 events for the month beginning 2021-03-01 by user kmedcalf

Following month ↑
2021-03-31
21:54 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: 34c81d83c9 user: kmedcalf)
08:17 Reply: Automatic change True value to 1 (artifact: a59cf634b1 user: kmedcalf)
2021-03-30
23:48 Reply: What is the point of a lone SELECT statement in an SQLite trigger? (artifact: 90773dd940 user: kmedcalf)
23:08 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: 968d5c12a8 user: kmedcalf)
22:59 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: be3b67da52 user: kmedcalf)
22:25 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: df0d14ed6a user: kmedcalf)
19:48 Reply: Automatic change True value to 1 (artifact: 70643d03d7 user: kmedcalf)
03:12 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: 08c0529cc6 user: kmedcalf)
00:12 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: 68c88ac201 user: kmedcalf)
2021-03-29
23:12 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM (artifact: 8b49459ada user: kmedcalf)
22:57 Reply: SQLite Heap overflow (artifact: 13b194bac6 user: kmedcalf)
22:05 Edit reply: SQLite Heap overflow (artifact: c9faf097fc user: kmedcalf)
22:02 Reply: SQLite Heap overflow (artifact: aec45a16c1 user: kmedcalf)
09:55 Reply: Query Contraint with an if clause? (artifact: ffe32a3922 user: kmedcalf)
2021-03-28
22:58 Edit reply: Query Contraint with an if clause? (artifact: 8d9efbec4b user: kmedcalf)
22:00 Reply: "ERROR ON LOAD EXTENSION" (artifact: 700586f957 user: kmedcalf)
21:14 Reply: Query Contraint with an if clause? (artifact: 6056ad879f user: kmedcalf)
19:31 Reply: "ERROR ON LOAD EXTENSION" (artifact: 21355ed4b1 user: kmedcalf)
19:22 Reply: "ERROR ON LOAD EXTENSION" (artifact: 2c92c0c10c user: kmedcalf)
19:08 Reply: Query Contraint with an if clause? (artifact: 1d60147f5f user: kmedcalf)
2021-03-27
20:34 Reply: Window function is not functioning as expected (artifact: d35402c815 user: kmedcalf)
04:22 Reply: Novice question about running UTF-8 on CLI from file. (artifact: 9b30198744 user: kmedcalf)
02:20 Reply: Window function is not functioning as expected (artifact: 04b2d31b62 user: kmedcalf)
01:56 Reply: Window function is not functioning as expected (artifact: 3820dff397 user: kmedcalf)
2021-03-26
02:44 Edit reply: possible to use output of a SELECT-query for ordering? (artifact: ae7c03afe5 user: kmedcalf)
02:41 Edit reply: possible to use output of a SELECT-query for ordering? (artifact: d0ad858c00 user: kmedcalf)
02:38 Edit reply: possible to use output of a SELECT-query for ordering? (artifact: 88172e7259 user: kmedcalf)
02:32 Reply: possible to use output of a SELECT-query for ordering? (artifact: 318ba84d8a user: kmedcalf)
2021-03-25
13:26 Reply: Views in LEFT JOIN queries not using index (artifact: d7d581270d user: kmedcalf)
13:18 Reply: R*Tree table constraints (artifact: 981ee72f6d user: kmedcalf)
13:05 Edit reply: Views in LEFT JOIN queries not using index (artifact: 444abe5a10 user: kmedcalf)
13:04 Reply: Views in LEFT JOIN queries not using index (artifact: ba13977b2b user: kmedcalf)
2021-03-24
21:06 Reply: Generating random test data using SQL (artifact: 7bc398e49a user: kmedcalf)
17:48 Reply: 3.25 math functions vs. extension-functions.c (artifact: ab0bfaeca4 user: kmedcalf)
17:37 Reply: Help rewriting a query to match the speed of a 2nd query (artifact: f5f61bf672 user: kmedcalf)
17:33 Reply: Help rewriting a query to match the speed of a 2nd query (artifact: b123b05f9a user: kmedcalf)
02:00 Reply: DROP TABLE failure - is it intentional or a bug? (artifact: 54d2c4d5b9 user: kmedcalf)
2021-03-23
23:46 Edit reply: Select distinct from most recent record (artifact: e5aeb398e4 user: kmedcalf)
23:45 Edit reply: Select distinct from most recent record (artifact: 4422f03ab9 user: kmedcalf)
23:42 Reply: Select distinct from most recent record (artifact: 7d7b5e84c1 user: kmedcalf)
22:50 Edit reply: DROP TABLE failure - is it intentional or a bug? (artifact: 537f0aea78 user: kmedcalf)
22:36 Edit reply: DROP TABLE failure - is it intentional or a bug? (artifact: 14ca232195 user: kmedcalf)
22:30 Reply: DROP TABLE failure - is it intentional or a bug? (artifact: 09dbb19de6 user: kmedcalf)
21:29 Reply: DROP TABLE failure - is it intentional or a bug? (artifact: 5fba669965 user: kmedcalf)
09:21 Reply: Strange CLI .exit issue (artifact: 689292a7db user: kmedcalf)
00:28 Edit reply: Strange CLI .exit issue (artifact: aa19ba40c5 user: kmedcalf)
2021-03-22
23:55 Edit reply: Strange CLI .exit issue (artifact: f0913e5e39 user: kmedcalf)
23:55 Reply: Strange CLI .exit issue (artifact: cfa5258799 user: kmedcalf)
23:43 Reply: Strange CLI .exit issue (artifact: 51dc89703e user: kmedcalf)
23:41 Reply: Strange CLI .exit issue (artifact: d1e963806d user: kmedcalf)
23:37 Reply: Strange CLI .exit issue (artifact: c053d0a861 user: kmedcalf)
23:32 Reply: Strange CLI .exit issue (artifact: 937b1c01bf user: kmedcalf)
21:43 Reply: DROP TABLE failure - is it intentional or a bug? (artifact: 1af825eb37 user: kmedcalf)
2021-03-21
18:58 Reply: Bug ? Same query that works in shell produces constraint violation when run by a C program with sqlite3_{prepare,bind,step} (artifact: ed73b997db user: kmedcalf)
17:48 Reply: Bug ? Same query that works in shell produces constraint violation when run by a C program with sqlite3_{prepare,bind,step} (artifact: 0f293dcd0e user: kmedcalf)
03:00 Reply: "Scope" of SQLITE_DETERMINISTIC? (artifact: 0901c9f815 user: kmedcalf)
2021-03-20
20:28 Reply: "Scope" of SQLITE_DETERMINISTIC? (artifact: 0f01b1f686 user: kmedcalf)
19:57 Reply: "Scope" of SQLITE_DETERMINISTIC? (artifact: 35a1523e9c user: kmedcalf)
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)
2021-03-19
23:09 Reply: Error compiling Tcl binding with ICU (artifact: e1a2e6b859 user: kmedcalf)
23:01 Reply: Error compiling Tcl binding with ICU (artifact: 7bae8256b9 user: kmedcalf)
22:56 Reply: How do I use sqlite3_malloc in Sqlite (artifact: 7f8cff9bd2 user: kmedcalf)
01:24 Reply: Cancelling the query (artifact: 811c6730d2 user: kmedcalf)
00:33 Edit reply: Cancelling the query (artifact: c844b9ff59 user: kmedcalf)
00:31 Reply: Cancelling the query (artifact: f8e779e0ce user: kmedcalf)
2021-03-18
21:13 Reply: Updating a value with one from another table? (artifact: 8862b4dc9c user: kmedcalf)
21:09 Reply: Updating a value with one from another table? (artifact: fbad1e84e1 user: kmedcalf)
09:27 Reply: SQL to return list of PRAGMAs (artifact: c4626dd38a user: kmedcalf)
01:18 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard (artifact: c0f2fc8a6f user: kmedcalf)
01:13 Reply: SQL to return list of PRAGMAs (artifact: 44c912d109 user: kmedcalf)
01:04 Reply: SQL to return list of PRAGMAs (artifact: ff76d026c7 user: kmedcalf)
00:46 Reply: Serious problems with STORED columns (artifact: 6a881ec9c1 user: kmedcalf)
2021-03-17
20:22 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard (artifact: 02ee2dc2dd user: kmedcalf)
20:18 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard (artifact: 6077aefb38 user: kmedcalf)
20:15 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard (artifact: c0c79cb0d7 user: kmedcalf)
2021-03-16
20:02 Reply: Missing records from the IN list (artifact: 34d1a7e19a user: kmedcalf)
19:12 Reply: Missing records from the IN list (artifact: 6de95f44e9 user: kmedcalf)
16:36 Reply: Serious problems with STORED columns (artifact: 3965a966ce user: kmedcalf)
15:17 Reply: Bug(?) in columns available in 'offset' clause of sub-select (artifact: 0e9e3888b6 user: kmedcalf)
14:40 Reply: Serious problems with STORED columns (artifact: f5c09d33c0 user: kmedcalf)
02:47 Reply: Serious problems with STORED columns (artifact: d9d81d1a8d user: kmedcalf)
2021-03-15
22:59 Reply: Serious problems with STORED columns (artifact: c6040bf211 user: kmedcalf)
22:56 Edit reply: Serious problems with STORED columns (artifact: 02313c094f user: kmedcalf)
22:50 Reply: Serious problems with STORED columns (artifact: cf7d0d3566 user: kmedcalf)
22:35 Reply: Serious problems with STORED columns (artifact: d0c3b6bfe3 user: kmedcalf)
15:12 Reply: Can you see what I do wrong? (artifact: 05c04c3891 user: kmedcalf)
13:58 Reply: TEXT values can contain arbitrary binary data (artifact: b737c3f38d user: kmedcalf)
01:09 Edit reply: Can you see what I do wrong? (artifact: e209c65189 user: kmedcalf)
01:07 Reply: Can you see what I do wrong? (artifact: 5629f5813c user: kmedcalf)
2021-03-14
20:49 Reply: Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS (artifact: 25bdf4636a user: kmedcalf)
16:17 Reply: How to insert control characters? (artifact: 756fb1a496 user: kmedcalf)
2021-03-13
08:31 Edit reply: integer primary key and index table (artifact: 9c45682c78 user: kmedcalf)
08:30 Reply: integer primary key and index table (artifact: 9a311edb5b user: kmedcalf)
08:24 Edit reply: integer primary key and index table (artifact: d5a2f69e0f user: kmedcalf)
08:23 Edit reply: integer primary key and index table (artifact: 795fe4a536 user: kmedcalf)
08:22 Reply: integer primary key and index table (artifact: 98e2ce0123 user: kmedcalf)
00:01 Reply: Inserting the image as BLOB (artifact: 5f901b57ba user: kmedcalf)
2021-03-11
20:35 Reply: How to READ and WRITE an image to an SQLITE BLOB FIELD (artifact: 62a11196b7 user: kmedcalf)
17:47 Delete reply: Operation speed (artifact: 7ac06a6956 user: kmedcalf)
17:47 Reply: Operation speed (artifact: 20e0f4e485 user: kmedcalf)
17:46 Delete reply: Operation speed (artifact: 5f2dd06615 user: kmedcalf)
17:43 Reply: Operation speed (artifact: 45c5582297 user: kmedcalf)
17:18 Reply: Operation speed (artifact: 09d24ddc91 user: kmedcalf)
17:12 Edit reply: Operation speed (artifact: 3d65405819 user: kmedcalf)
17:09 Reply: Operation speed (artifact: 3abca07223 user: kmedcalf)
04:37 Reply: Operation speed (artifact: 069b348f70 user: kmedcalf)
04:29 Reply: Operation speed (artifact: db938d57f1 user: kmedcalf)
04:12 Reply: Operation speed (artifact: e2c555f30c user: kmedcalf)
01:31 Reply: import mishandles table name (artifact: dde5a2bfaa user: kmedcalf)
2021-03-10
17:10 Reply: How to corrupt - windows (artifact: 6bf3105fe1 user: kmedcalf)
2021-03-09
21:23 Reply: Get other vlues from a row in Python (artifact: a30c3072fb user: kmedcalf)
21:10 Reply: How to corrupt - windows (artifact: 204dd55df9 user: kmedcalf)
21:06 Edit reply: How to corrupt - windows (artifact: ddc8a94e1e user: kmedcalf)
21:03 Edit reply: How to corrupt - windows (artifact: 171b5e7948 user: kmedcalf)
20:54 Reply: How to corrupt - windows (artifact: 540c8222f6 user: kmedcalf)
19:04 Reply: Verifying schema for application file format (artifact: a2e6dbed3e user: kmedcalf)
18:53 Reply: Type of the column (artifact: 585f90ce90 user: kmedcalf)
18:13 Edit reply: How to corrupt - windows (artifact: 9c71fd7968 user: kmedcalf)
18:11 Reply: How to corrupt - windows (artifact: 115c17e478 user: kmedcalf)
17:57 Reply: Type of the column (artifact: dd552dbf82 user: kmedcalf)
17:49 Edit reply: How to corrupt - windows (artifact: 8584f00cd0 user: kmedcalf)
17:35 Reply: How to corrupt - windows (artifact: 51ff31a128 user: kmedcalf)
2021-03-07
23:58 Reply: IN parameters within a query (artifact: 32731aada3 user: kmedcalf)
23:27 Reply: IN parameters within a query (artifact: 988f8b9ebc user: kmedcalf)
23:26 Reply: IN parameters within a query (artifact: e9b2d9653f user: kmedcalf)
22:51 Reply: IN parameters within a query (artifact: 8d8908f06a user: kmedcalf)
21:56 Edit reply: IN parameters within a query (artifact: 0f1f23930c user: kmedcalf)
21:54 Reply: IN parameters within a query (artifact: 9b5317a72e user: kmedcalf)
21:49 Reply: IN parameters within a query (artifact: 0a9545ef17 user: kmedcalf)
21:44 Reply: IN parameters within a query (artifact: 459974a0b4 user: kmedcalf)
20:27 Reply: IN parameters within a query (artifact: c463ef8552 user: kmedcalf)
18:39 Edit reply: Integer becomes blob (artifact: 11cd947379 user: kmedcalf)
18:27 Reply: Integer becomes blob (artifact: 916b7736a3 user: kmedcalf)
17:51 Edit reply: Integer becomes blob (artifact: fc008fb3c5 user: kmedcalf)
17:35 Reply: Integer becomes blob (artifact: 04e24ede9d user: kmedcalf)
2021-03-06
16:17 Edit reply: BEGIN CONCURRENT SQLITE BUSY (artifact: 78a476d17e user: kmedcalf)
16:16 Edit reply: BEGIN CONCURRENT SQLITE BUSY (artifact: 57c21f880e user: kmedcalf)
13:10 Reply: BEGIN CONCURRENT SQLITE BUSY (artifact: bc05cf9e41 user: kmedcalf)
08:06 Delete reply: Different behavior for shared cache on OSX/Linux vs Windows (artifact: d7ec4d629e user: kmedcalf)
07:55 Reply: Different behavior for shared cache on OSX/Linux vs Windows (artifact: f3f528df3a user: kmedcalf)
2021-03-04
23:01 Edit reply: How to handle double backslashes when binding parameters in C API? (artifact: cc1f329e92 user: kmedcalf)
23:01 Reply: How to handle double backslashes when binding parameters in C API? (artifact: 32f96217a5 user: kmedcalf)
09:49 Reply: encoding on new DB-File (artifact: 1d71462cce user: kmedcalf)
00:16 Edit reply: encoding on new DB-File (artifact: d1c75b4df5 user: kmedcalf)
00:15 Edit reply: encoding on new DB-File (artifact: 587423ac21 user: kmedcalf)
00:12 Edit reply: encoding on new DB-File (artifact: ddf51a5dca user: kmedcalf)
00:12 Reply: encoding on new DB-File (artifact: ac7d0ae407 user: kmedcalf)
2021-03-03
16:03 Edit reply: encoding on new DB-File (artifact: e3df844802 user: kmedcalf)
16:02 Reply: encoding on new DB-File (artifact: 505a2ff973 user: kmedcalf)
15:52 Reply: encoding on new DB-File (artifact: 41c209a363 user: kmedcalf)
15:48 Edit reply: encoding on new DB-File (artifact: 19a55c4b13 user: kmedcalf)
15:38 Edit reply: encoding on new DB-File (artifact: ff654e34cd user: kmedcalf)
15:34 Edit reply: encoding on new DB-File (artifact: 0185da73f2 user: kmedcalf)
15:33 Reply: encoding on new DB-File (artifact: 5dc4b6e95d user: kmedcalf)
2021-03-02
19:38 Reply: Deferred index update? (artifact: c0db2a2677 user: kmedcalf)
2021-03-01
13:34 Reply: Database UTF-16 support (artifact: 817cda25ee user: kmedcalf)
13:29 Reply: Database UTF-16 support (artifact: 5b4de9df31 user: kmedcalf)
Previous month ↓