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 ↓