SQLite Forum

Timeline
Login

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

50 most recent forum posts by user dvdraymond

2022-06-17
18:50 Reply: Conditionnal Update a field from another field (artifact: ad029cf0ab user: dvdraymond)
2022-06-16
15:54 Reply: BUG: DELETE / DROP TABLE fails with self referencing FK data (artifact: ac3ed3f2af user: dvdraymond)
2022-06-10
16:48 Reply: Aggregate function by multiple columns (artifact: 3e5958039b user: dvdraymond)
16:37 Reply: Aggregate function by multiple columns (artifact: e73a4bf49d user: dvdraymond)
16:04 Reply: Match All IN (value1, value2, etc) (artifact: 55b030c686 user: dvdraymond)
2022-05-16
13:10 Reply: Inserting into two tables in one statement, one of which requires a foreign key reference to the other? (artifact: 024927d57a user: dvdraymond)
2022-05-03
18:53 Reply: Two queries work separately, but fail when combined (artifact: 0ca736812e user: dvdraymond)
2022-04-26
17:54 Reply: Max() over datetime field (artifact: aadaac5040 user: dvdraymond)
17:24 Reply: Max() over datetime field (artifact: 8665aba164 user: dvdraymond)
2022-04-21
13:35 Reply: Parser bug in INSERT .. SELECT .. ON CONFLICT clause (artifact: a116917be9 user: dvdraymond)
13:23 Reply: Parser bug in INSERT .. SELECT .. ON CONFLICT clause (artifact: 16fcd671e2 user: dvdraymond)
2022-04-06
20:09 Reply: DOT commands - Is there a way to concatenate multiple commands? (artifact: 13655a9fc3 user: dvdraymond)
2022-04-05
15:14 Reply: Many-To-Many problem (artifact: 5018ddab1a user: dvdraymond)
2022-03-31
18:59 Reply: Selected RowId Not Returned after .input (artifact: d2d8484ec7 user: dvdraymond)
2022-03-21
19:58 Reply: Possible to see how many opcodes were executed for a query? (artifact: 330c8532d8 user: dvdraymond)
15:59 Reply: Unexpected result from query with window function (artifact: eac169ea1d user: dvdraymond)
2022-03-07
20:06 Reply: Search for a range of characters (artifact: 6b4269ac87 user: dvdraymond)
19:32 Reply: Search for a range of characters (artifact: 4bc798757c user: dvdraymond)
2022-02-25
13:33 Reply: Enhancement Idea: Rollback And Release Savepoint (artifact: 4b489d87e4 user: dvdraymond)
2022-02-09
19:57 Reply: Journal recreating for every execution (artifact: a136e9b30e user: dvdraymond)
2022-01-31
17:09 Reply: Query against view of two joined tables not using index; bug or missed optimization? (artifact: 189c3e0790 user: dvdraymond)
17:04 Reply: Query against view of two joined tables not using index; bug or missed optimization? (artifact: f8024404ea user: dvdraymond)
2022-01-24
16:20 Reply: Case when (artifact: 2bfad8ddec user: dvdraymond)
13:56 Reply: INSERT INTO SELECT upgrade to IMMEDIATE/EXCLUSIVE (artifact: d8dabebf8d user: dvdraymond)
2022-01-21
15:46 Reply: Is it possible to fix a more than 1G corrupted SQLite file with only the first 16K content corrupted? (artifact: 7de4b52ee4 user: dvdraymond)
13:24 Reply: Case when (artifact: 081d83bc24 user: dvdraymond)
13:03 Reply: Case when (artifact: ae28e9b548 user: dvdraymond)
2022-01-20
19:00 Reply: Case when (artifact: e8046d3240 user: dvdraymond)
15:40 Reply: feature request: vacuum into without indexes (artifact: 3af80049ee user: dvdraymond)
2022-01-13
16:49 Reply: Unable to read while database is locked (artifact: 3fe1aa5b4d user: dvdraymond)
2022-01-12
18:38 Reply: SELECT with LIMIT OFFSET clause return unexpected result (with sample db and query) (artifact: 195588b84d user: dvdraymond)
2022-01-06
14:27 Reply: autovacuum in sqlite VS autovacuum in PG (artifact: f24c56d390 user: dvdraymond)
2021-12-13
16:33 Reply: How to merge two or more tables that have the same structure? (artifact: bb0ca9f424 user: dvdraymond)
2021-11-17
13:16 Reply: ROWID primary key works slower than index (artifact: 53a09f7a9f user: dvdraymond)
2021-10-20
18:39 Reply: I need a little help with UPDATE? (artifact: 1bb7b4bdd9 user: dvdraymond)
2021-10-13
14:59 Reply: binary .dump format (artifact: d287c1fe01 user: dvdraymond)
2021-09-28
13:36 Reply: Views, Casting vs and converters (artifact: 3a773c65a1 user: dvdraymond)
2021-09-01
13:19 Reply: STRICT tables and UNIQUE indices (artifact: 146daf1138 user: dvdraymond)
2021-08-31
14:54 Reply: Possible bug: Unexpected result using correlated aggregate subquery (artifact: 1d6f05c554 user: dvdraymond)
14:21 Reply: Possible bug: Unexpected result using correlated aggregate subquery (artifact: 85a3337362 user: dvdraymond)
2021-08-24
15:20 Reply: Most performant way to test for having 0, 1 or more rows in a table (artifact: 9d87c828fc user: dvdraymond)
2021-08-16
12:49 Reply: Avoiding recursive CTE materialisation (artifact: 6523441ecc user: dvdraymond)
2021-08-12
17:05 Reply: LEFT AND RIGHT OUTER JOINS problem (artifact: 9387707b37 user: dvdraymond)
13:40 Reply: SQLite irrespective query (artifact: 99678ffcb5 user: dvdraymond)
2021-07-22
13:20 Reply: problem report: incorrect join behavior (artifact: d730d754d7 user: dvdraymond)
13:01 Reply: How to submit changes (artifact: b7d7244259 user: dvdraymond)
12:44 Reply: operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors (artifact: a148f53ae6 user: dvdraymond)
2021-07-20
13:48 Reply: cycle detection in CHECK constraint with recursive CTE (artifact: a184978699 user: dvdraymond)
2021-07-19
19:43 Reply: Unexpected return from the NULL column (artifact: 3b70b2ac1d user: dvdraymond)
2021-07-15
18:23 Reply: Should SQLite be able to optimize this query? (artifact: 3344977a85 user: dvdraymond)