Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
188 events by user kmedcalf occurring around 2021-05-17 18:01:48.
2021-06-25
| ||
01:36 | • Reply: How to insert certain table_1 column value in table_2 along with new user input values artifact: 20b72cca2c user: kmedcalf | |
00:50 | • Reply: How to insert certain table_1 column value in table_2 along with new user input values artifact: adba6bc133 user: kmedcalf | |
2021-06-24
| ||
13:58 | • Reply: sqlite header and source version mismatch artifact: a79dc5af70 user: kmedcalf | |
2021-06-23
| ||
11:27 | • Reply: CROSS JOIN sometimes re-orders tables when lhs is a CTE artifact: a3b73bcaa6 user: kmedcalf | |
11:27 | • Delete reply: CROSS JOIN sometimes re-orders tables when lhs is a CTE artifact: 538b04fa0a user: kmedcalf | |
11:22 | • Reply: CROSS JOIN sometimes re-orders tables when lhs is a CTE artifact: 64075c1ffd user: kmedcalf | |
11:09 | • Reply: CROSS JOIN sometimes re-orders tables when lhs is a CTE artifact: 2211d27236 user: kmedcalf | |
2021-06-22
| ||
01:38 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: 83c021ce24 user: kmedcalf | |
2021-06-21
| ||
23:53 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: efe44bfd1f user: kmedcalf | |
23:48 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: f5ddde7a75 user: kmedcalf | |
04:33 | • Edit: CLI Documentation Error artifact: 86da48bff8 user: kmedcalf | |
04:33 | • Post: CLI Documentation Error artifact: 869c380198 user: kmedcalf | |
01:52 | • Reply: Bug Use «RETURNING» in transaction cause error 5 on commit. artifact: 52f001ddd5 user: kmedcalf | |
01:43 | • Reply: Bug Use «RETURNING» in transaction cause error 5 on commit. artifact: a9318e2f70 user: kmedcalf | |
2021-06-20
| ||
21:14 | • Reply: Feature request, PRAGMA for setting default transaction mode artifact: 06aded1153 user: kmedcalf | |
2021-06-18
| ||
08:41 | • Reply: Unhandled exception on server application artifact: a5c9e94bb9 user: kmedcalf | |
08:35 | • Reply: Unhandled exception on server application artifact: 52a0154d68 user: kmedcalf | |
06:40 | • Reply: Unhandled exception on server application artifact: cf3a41fba5 user: kmedcalf | |
05:53 | • Reply: can we use a for/while loop inside sqlite triggers ? artifact: fb04c3b2fd user: kmedcalf | |
03:26 | • Reply: Unhandled exception on server application artifact: 00d78885f9 user: kmedcalf | |
02:58 | • Reply: can we use a for/while loop inside sqlite triggers ? artifact: 92767311f0 user: kmedcalf | |
02:28 | • Edit reply: can we use a for/while loop inside sqlite triggers ? artifact: 77bf509367 user: kmedcalf | |
02:22 | • Reply: can we use a for/while loop inside sqlite triggers ? artifact: 98bdfc922b user: kmedcalf | |
2021-06-17
| ||
03:25 | • Reply: Extract files from sqlar with a directory prepended artifact: 89243a7fc2 user: kmedcalf | |
2021-06-16
| ||
20:14 | • Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: 0968209207 user: kmedcalf | |
2021-06-15
| ||
16:58 | • Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: fd7f4730be user: kmedcalf | |
13:45 | • Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: f628d35f22 user: kmedcalf | |
09:22 | • Reply: A stack overflow vulnerability in SQLite nmakehelp.c allows arbitrary code execution via a crated file artifact: dca2fcf098 user: kmedcalf | |
2021-06-14
| ||
04:30 | • Reply: Novice question concerning adding conditional incremental integer counter artifact: c43c59f6cc user: kmedcalf | |
04:23 | • Edit reply: Novice question concerning adding conditional incremental integer counter artifact: 2baded7f45 user: kmedcalf | |
04:13 | • Reply: Novice question concerning adding conditional incremental integer counter artifact: 42727de115 user: kmedcalf | |
03:42 | • Reply: Novice question concerning adding conditional incremental integer counter artifact: f463012fda user: kmedcalf | |
03:35 | • Reply: Novice question concerning adding conditional incremental integer counter artifact: 3e603318ac user: kmedcalf | |
03:30 | • Reply: Novice question concerning adding conditional incremental integer counter artifact: a7fddeecb9 user: kmedcalf | |
2021-06-12
| ||
04:15 | • Edit reply: documention: is DISTINCT optinoal in funtion? artifact: 3ac28f03b5 user: kmedcalf | |
04:14 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: 5b48a06152 user: kmedcalf | |
04:10 | • Edit reply: documention: is DISTINCT optinoal in funtion? artifact: 6aec83b1e1 user: kmedcalf | |
04:04 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: bf544da703 user: kmedcalf | |
04:03 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: 70e1d64580 user: kmedcalf | |
2021-06-11
| ||
11:55 | • Reply: Returning expr not working with sqlite3_exec() in C code artifact: d83d4d8b6f user: kmedcalf | |
10:32 | • Reply: Returning expr not working with sqlite3_exec() in C code artifact: b32fdc0409 user: kmedcalf | |
2021-06-10
| ||
00:24 | • Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: c3f5e83af4 user: kmedcalf | |
2021-06-08
| ||
20:44 | • Reply: Requesting optimization for index expression case artifact: 8fc7c5d0b7 user: kmedcalf | |
2021-06-07
| ||
19:38 | • Edit reply: unable to get latest updates to database (WAL mode) from one open handler when updated from other open handler artifact: 40c89a1fda user: kmedcalf | |
19:35 | • Reply: unable to get latest updates to database (WAL mode) from one open handler when updated from other open handler artifact: 8bbc946bd9 user: kmedcalf | |
05:04 | • Reply: WAL files deleted artifact: 93545e50e0 user: kmedcalf | |
2021-06-06
| ||
15:15 | • Reply: How to create a table as the union of two tables? artifact: 573d7154a6 user: kmedcalf | |
2021-06-02
| ||
10:29 | • Reply: How to convert the data type of the new column in the view? artifact: a437bbbf0e user: kmedcalf | |
00:49 | • Reply: Query performance regression after v3.33.0 (OP_SeekScan?) artifact: 2ad5681eb0 user: kmedcalf | |
2021-06-01
| ||
22:34 | • Reply: Query performance regression after v3.33.0 (OP_SeekScan?) artifact: b058b09208 user: kmedcalf | |
20:20 | • Reply: How to avoid 'row X missing from index' when using a custom collation? artifact: 67b6a4dc94 user: kmedcalf | |
19:56 | • Reply: How to avoid 'row X missing from index' when using a custom collation? artifact: e215d0a1ed user: kmedcalf | |
19:47 | • Reply: How to avoid 'row X missing from index' when using a custom collation? artifact: d1db925a1b user: kmedcalf | |
19:18 | • Reply: What am I doing wrong to get errors when trying to compile amalgamation file in Linux artifact: f7f02db70f user: kmedcalf | |
2021-05-31
| ||
14:59 | • Reply: Nothing for several days from the forum artifact: b742bf9891 user: kmedcalf | |
2021-05-29
| ||
02:18 | • Reply: foreign key issue on deleate artifact: 9b2de402ff user: kmedcalf | |
2021-05-28
| ||
23:42 | • Edit reply: Bug of json_each if object has value field. artifact: 902b7b09df user: kmedcalf | |
23:41 | • Reply: Bug of json_each if object has value field. artifact: c88dadca20 user: kmedcalf | |
05:09 | • Reply: foreign key issue on deleate artifact: 3591a0cac2 user: kmedcalf | |
03:25 | • Reply: nested case statement not working artifact: 5560dd3768 user: kmedcalf | |
2021-05-27
| ||
23:36 | • Reply: nested case statement not working artifact: 7a49b2631e user: kmedcalf | |
17:55 | • Reply: Is there a way to optimize this UPDATE command to run faster? artifact: 72a1d04ea7 user: kmedcalf | |
10:28 | • Reply: Inconsistent output possibly due to affinity issue artifact: 8ae88cd0bc user: kmedcalf | |
01:33 | • Reply: index to help with selection and ordering artifact: 2981ef024d user: kmedcalf | |
2021-05-25
| ||
23:17 | • Edit reply: Inconsistent output possibly due to affinity issue artifact: 882a631175 user: kmedcalf | |
23:15 | • Reply: Inconsistent output possibly due to affinity issue artifact: 6d4606c7e4 user: kmedcalf | |
20:46 | • Reply: Inconsistent output possibly due to affinity issue artifact: ffa015ac07 user: kmedcalf | |
2021-05-24
| ||
05:30 | • Reply: short circuiting subqueries with `IN`? artifact: b606b3736a user: kmedcalf | |
00:30 | • Reply: Independent in-memory database per thread? artifact: 6aa65fb4c2 user: kmedcalf | |
2021-05-23
| ||
20:33 | • Edit reply: nested case statement not working artifact: 58d4ae77d2 user: kmedcalf | |
20:33 | • Reply: nested case statement not working artifact: b94071851a user: kmedcalf | |
20:23 | • Reply: short circuiting subqueries with `IN`? artifact: ba228d0af2 user: kmedcalf | |
20:13 | • Reply: short circuiting subqueries with `IN`? artifact: ed2d66f197 user: kmedcalf | |
20:00 | • Edit reply: short circuiting subqueries with `IN`? artifact: 8b093b0dcd user: kmedcalf | |
19:59 | • Edit reply: short circuiting subqueries with `IN`? artifact: 3f2f3c4298 user: kmedcalf | |
19:51 | • Edit reply: short circuiting subqueries with `IN`? artifact: 7e47eb65f9 user: kmedcalf | |
19:43 | • Reply: short circuiting subqueries with `IN`? artifact: a2fbda8fd2 user: kmedcalf | |
19:29 | • Reply: short circuiting subqueries with `IN`? artifact: 9581ff7a5a user: kmedcalf | |
17:16 | • Reply: sql parser error artifact: 006a53dbf1 user: kmedcalf | |
2021-05-22
| ||
17:01 | • Reply: Can I read(select) parallelly on the same connection in multi-threads? artifact: d6e6fac7a1 user: kmedcalf | |
16:28 | • Reply: How often sqlite flush to disk under NORMAL mode? artifact: 3c185ba715 user: kmedcalf | |
2021-05-21
| ||
08:22 | • Reply: How often sqlite flush to disk under NORMAL mode? artifact: 8445738c33 user: kmedcalf | |
2021-05-20
| ||
05:20 | • Reply: How to check if HAVE_USLEEP is activated? artifact: 6fcbc1c18d user: kmedcalf | |
2021-05-19
| ||
15:49 | • Edit reply: Feature request: expose additional state to identify left-open statements artifact: 3a2637cccc user: kmedcalf | |
15:47 | • Reply: Feature request: expose additional state to identify left-open statements artifact: 8f10be4b47 user: kmedcalf | |
2021-05-17
| ||
22:55 | • Reply: Window RAM Disk no better than local SSD? artifact: 25b09883f0 user: kmedcalf | |
19:57 | • Reply: Nearest-match join artifact: e90722f177 user: kmedcalf | |
19:13 | • Edit reply: Nearest-match join artifact: b6ed194641 user: kmedcalf | |
19:08 | • Edit reply: Nearest-match join artifact: c1255b2c54 user: kmedcalf | |
19:04 | • Edit reply: Nearest-match join artifact: 80f40393fa user: kmedcalf | |
18:51 | • Edit reply: Nearest-match join artifact: 7a40a1d69e user: kmedcalf | |
18:39 | • Edit reply: Nearest-match join artifact: d3e0628ac3 user: kmedcalf | |
18:34 | • Reply: Nearest-match join artifact: 53c0b254f1 user: kmedcalf | |
18:01 | • Edit reply: Nearest-match join artifact: 61008f60b6 user: kmedcalf | |
06:43 | • Reply: memory vs mmap artifact: e296da94ba user: kmedcalf | |
02:53 | • Reply: memory vs mmap artifact: 9eb30885eb user: kmedcalf | |
01:12 | • Reply: memory vs mmap artifact: 7eee1ce2e4 user: kmedcalf | |
2021-05-16
| ||
21:34 | • Reply: How to reset auto increment on DB browser artifact: b024cf15db user: kmedcalf | |
18:52 | • Reply: Feedback on writing a SQLite VFS for a distributed object store artifact: fe688bde49 user: kmedcalf | |
18:16 | • Edit reply: Nearest-match join artifact: a56291ed45 user: kmedcalf | |
18:05 | • Reply: Global PRAGMA data_version artifact: 51912e77b7 user: kmedcalf | |
17:52 | • Reply: Nearest-match join artifact: 7f37b22b52 user: kmedcalf | |
17:26 | • Reply: Nearest-match join artifact: 65a778b940 user: kmedcalf | |
03:20 | • Reply: Global PRAGMA data_version artifact: 8e90cb3c80 user: kmedcalf | |
01:43 | • Edit reply: Global PRAGMA data_version artifact: 76f1eb7475 user: kmedcalf | |
01:41 | • Edit reply: Global PRAGMA data_version artifact: f81cda753c user: kmedcalf | |
01:40 | • Reply: Global PRAGMA data_version artifact: ff1ea94534 user: kmedcalf | |
2021-05-13
| ||
19:42 | • Reply: Nothing for several days from the forum artifact: efc5830784 user: kmedcalf | |
13:35 | • Reply: Fast way to insert rows in SQLite artifact: d32ab102c4 user: kmedcalf | |
13:17 | • Reply: What is the recommended way to update multiple columns from a single select? artifact: 7533a14610 user: kmedcalf | |
2021-05-12
| ||
00:29 | • Reply: Cleaning up after SQLite artifact: 78d03db70e user: kmedcalf | |
2021-05-11
| ||
06:41 | • Edit reply: Add into date in sqlite artifact: 8be44e9bce user: kmedcalf | |
06:40 | • Reply: Add into date in sqlite artifact: 1c90efc2c4 user: kmedcalf | |
2021-05-09
| ||
19:15 | • Reply: Statement that fires trigger is not executed when the trigger causes an error artifact: a5cfd84dd7 user: kmedcalf | |
2021-05-07
| ||
04:56 | • Reply: Recursive query to find the shortest path artifact: 50dfc41ac8 user: kmedcalf | |
2021-05-06
| ||
23:45 | • Reply: Foreign key that is never enforced? artifact: a4909c0b63 user: kmedcalf | |
23:21 | • Reply: Foreign key that is never enforced? artifact: 1b5b112f13 user: kmedcalf | |
07:19 | • Edit reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 5e8ba03d0e user: kmedcalf | |
06:56 | • Reply: Including decimal.c in compiled binary and enabling by default artifact: 4738436891 user: kmedcalf | |
06:34 | • Reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 6c704bdb4d user: kmedcalf | |
2021-05-05
| ||
05:50 | • Reply: Columns metadata is invalit for RETURNING clause artifact: 47b5abadc1 user: kmedcalf | |
03:31 | • Edit reply: Including decimal.c in compiled binary and enabling by default artifact: 1e87626b93 user: kmedcalf | |
03:29 | • Reply: Including decimal.c in compiled binary and enabling by default artifact: 80156d1e04 user: kmedcalf | |
03:26 | • Reply: User Defined Functions artifact: 400562ef40 user: kmedcalf | |
03:24 | • Reply: User Defined Functions artifact: 28c335ff41 user: kmedcalf | |
2021-05-04
| ||
17:47 | • Reply: User Defined Functions artifact: a50b7c8474 user: kmedcalf | |
17:39 | • Reply: User Defined Functions artifact: 7fd14b907d user: kmedcalf | |
06:47 | • Reply: cli: .mode insert - use current table name artifact: 680dae1d1a user: kmedcalf | |
05:24 | • Reply: Including decimal.c in compiled binary and enabling by default artifact: 49333ac211 user: kmedcalf | |
2021-05-03
| ||
19:39 | • Reply: cli: .mode insert - use current table name artifact: 66231ac0e2 user: kmedcalf | |
19:23 | • Reply: New type of transaction (or a new behavior for DEFERRED transactions) artifact: d16bff50ff user: kmedcalf | |
19:13 | • Reply: New type of transaction (or a new behavior for DEFERRED transactions) artifact: 434435c1cc user: kmedcalf | |
17:44 | • Reply: Setting temp_store_directory on Windows in future proof way artifact: cd6b69fd36 user: kmedcalf | |
17:17 | • Edit reply: Database is locked when "upgrading" from read to write artifact: ceb2ebdd13 user: kmedcalf | |
17:17 | • Reply: Database is locked when "upgrading" from read to write artifact: 1db18a0bed user: kmedcalf | |
17:03 | • Reply: Database is locked when "upgrading" from read to write artifact: 02440085bd user: kmedcalf | |
02:30 | • Reply: Recursive query to find the shortest path artifact: 845ed93705 user: kmedcalf | |
02:15 | • Reply: Database is locked when "upgrading" from read to write artifact: 4253fbbecd user: kmedcalf | |
02:10 | • Reply: Database is locked when "upgrading" from read to write artifact: 082ef04876 user: kmedcalf | |
2021-05-02
| ||
19:36 | • Reply: Setting temp_store_directory on Windows in future proof way artifact: f96ab2dab2 user: kmedcalf | |
07:54 | • Reply: Setting temp_store_directory on Windows in future proof way artifact: 2cdd0c12bb user: kmedcalf | |
04:37 | • Reply: "Office Space"... I'm losing all those pennies artifact: d8c5916ad5 user: kmedcalf | |
02:27 | • Reply: "Office Space"... I'm losing all those pennies artifact: 0e203a8c04 user: kmedcalf | |
02:19 | • Reply: "Office Space"... I'm losing all those pennies artifact: a1a054be3a user: kmedcalf | |
2021-05-01
| ||
23:34 | • Reply: Recursive query to find the shortest path artifact: 2e18f2b1cc user: kmedcalf | |
23:17 | • Reply: how to collate in a union and noaccent artifact: 214e1a95c1 user: kmedcalf | |
01:25 | • Reply: SQLite database in space? artifact: 7728edc880 user: kmedcalf | |
2021-04-30
| ||
05:27 | • Reply: Where is the temporary database file stored? artifact: 61124efd0c user: kmedcalf | |
05:15 | • Edit reply: Where is the temporary database file stored? artifact: 2e93357a27 user: kmedcalf | |
05:09 | • Reply: Where is the temporary database file stored? artifact: 15cf96fdec user: kmedcalf | |
2021-04-29
| ||
17:44 | • Reply: WAL files deleted artifact: acb9609c43 user: kmedcalf | |
04:12 | • Reply: Help, reading sqlite3_blob_open() artifact: 19653eea3e user: kmedcalf | |
2021-04-28
| ||
12:40 | • Edit reply: Database is locked when "upgrading" from read to write artifact: dca7f2f1fc user: kmedcalf | |
12:32 | • Reply: Database is locked when "upgrading" from read to write artifact: 6e85b59f15 user: kmedcalf | |
12:30 | • Edit reply: Database is locked when "upgrading" from read to write artifact: b9ff09b2d4 user: kmedcalf | |
12:25 | • Reply: Database is locked when "upgrading" from read to write artifact: c3cb9524be user: kmedcalf | |
12:15 | • Reply: Database is locked when "upgrading" from read to write artifact: e51c0e031c user: kmedcalf | |
2021-04-27
| ||
22:40 | • Reply: Database is locked when "upgrading" from read to write artifact: bde839c27d user: kmedcalf | |
2021-04-25
| ||
20:22 | • Reply: How to convert to CTE artifact: be4e00339e user: kmedcalf | |
19:35 | • Reply: How to convert to CTE artifact: 8a3238875e user: kmedcalf | |
17:45 | • Reply: bug report : adding constant to GROUP BY leads to different output artifact: 9fd8fe958d user: kmedcalf | |
17:37 | • Reply: Backup via file system backup software artifact: 65c94f0cec user: kmedcalf | |
17:22 | • Reply: How to convert to CTE artifact: 5f2210c2d8 user: kmedcalf | |
07:15 | • Edit reply: How to convert to CTE artifact: 5bc8ed823f user: kmedcalf | |
07:10 | • Edit reply: How to convert to CTE artifact: 6d727c5e38 user: kmedcalf | |
07:09 | • Edit reply: How to convert to CTE artifact: eac7dae83f user: kmedcalf | |
04:46 | • Edit reply: How to convert to CTE artifact: 6147f5adc8 user: kmedcalf | |
04:39 | • Edit reply: How to convert to CTE artifact: 427b179b5d user: kmedcalf | |
04:28 | • Reply: How to convert to CTE artifact: 11d6641deb user: kmedcalf | |
01:42 | • Reply: Backup via file system backup software artifact: 35eefef49b user: kmedcalf | |
01:36 | • Reply: Backup via file system backup software artifact: 72e792cdac user: kmedcalf | |
2021-04-24
| ||
22:09 | • Reply: Sending output to a pipe artifact: 801ee0be99 user: kmedcalf | |
21:59 | • Reply: PROBLEM WITH TRANSACTION artifact: 87e58b3e1f user: kmedcalf | |
21:55 | • Reply: Different results in SELECT DISTINCT artifact: 6d8903632c user: kmedcalf | |
06:41 | • Reply: How to convert to CTE artifact: 5dc12daa39 user: kmedcalf | |
2021-04-23
| ||
23:52 | • Edit reply: How to convert to CTE artifact: c35ccbe517 user: kmedcalf | |
23:49 | • Reply: How to convert to CTE artifact: 9024d83761 user: kmedcalf | |
05:11 | • Reply: How to convert to CTE artifact: c8f9a59f56 user: kmedcalf | |
2021-04-22
| ||
23:13 | • Edit reply: How to convert to CTE artifact: ac7b767772 user: kmedcalf | |
22:54 | • Edit reply: How to convert to CTE artifact: 8f9aa20c01 user: kmedcalf | |
22:49 | • Reply: How to convert to CTE artifact: 8316acd06d user: kmedcalf | |
21:50 | • Reply: How to convert to CTE artifact: 18dcf85aed user: kmedcalf | |
21:34 | • Reply: How to convert to CTE artifact: a4510ab6e2 user: kmedcalf | |
21:10 | • Reply: How to convert to CTE artifact: 6794586fbd user: kmedcalf | |
20:30 | • Reply: How to convert to CTE artifact: a085d59c5b user: kmedcalf | |
18:32 | • Reply: Execute changes in Photoshop Elements artifact: 3983e96915 user: kmedcalf | |
2021-04-21
| ||
02:37 | • Edit reply: The NUMERIC data type? artifact: 6c939f8f70 user: kmedcalf | |
02:29 | • Edit reply: The NUMERIC data type? artifact: 44aca9a5a8 user: kmedcalf | |