SQLite Forum

Timeline
Login

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

50 events by user drh occurring around 2021-04-28 17:59:38.

2021-05-15
11:41 Reply: Using json_extract in create table for generated fields artifact: 884b20ce2f user: drh
2021-05-14
15:42 Reply: Discovered bug in xBestIndex of virtual tables artifact: 1bec475be0 user: drh
11:29 Edit: Special characters * and ? are not supported in Database Names on Windows? artifact: b905b705ef user: drh
11:26 Reply: Minor Warning compiling SQlite 3.35.5 warning with GCC 11 artifact: 24a4535f6a user: drh
2021-05-13
20:00 Reply: Nothing for several days from the forum artifact: 5c35c64a08 user: drh
18:27 Reply: sqlite3_stmt_readonly is dependent on the current database artifact: 57fbd21a46 user: drh
17:15 Reply: sqlite3_stmt_readonly is dependent on the current database artifact: 4698f7dd26 user: drh
15:46 Reply: Nothing for several days from the forum artifact: a20af00349 user: drh
13:56 Reply: Unexpected output from the SELECT statement artifact: cb52b92c31 user: drh
11:59 Reply: What is the recommended way to update multiple columns from a single select? artifact: 34ba8e1ed2 user: drh
2021-05-12
22:04 Reply: Inconsistent results in the WHERE clause artifact: 696eed8057 user: drh
14:45 Reply: Index Btree artifact: 54256d55d6 user: drh
2021-05-11
10:24 Reply: Fast way to insert rows in SQLite artifact: 6409f3be36 user: drh
2021-05-07
22:43 Reply: Inconsistent behavior when using nth_value and COUNT artifact: 10dcf43a6c user: drh
14:48 Edit: Inconsistent behavior when using nth_value and COUNT artifact: 5aad5527cb user: drh
2021-05-06
10:55 Reply: Is dbsqlfuzz open source? artifact: 73e1d482e2 user: drh
2021-05-04
23:22 Reply: Bug report: equivalence transfer results in incorrect output artifact: 54acbdc6ac user: drh
18:31 Reply: Bug report: equivalence transfer results in incorrect output artifact: 000320915c user: drh
12:12 Reply: Possible inconsistent result when use EXISTS ( SELECT...) expression in a WHERE clause artifact: 4d00cccc65 user: drh
2021-05-03
18:14 Reply: License of SQLite pikchr RR diagrams artifact: cb6fb48be1 user: drh
2021-04-29
15:51 Reply: Confusion of some subquery results artifact: 25720db54e user: drh
11:56 Reply: Confusion of some subquery results artifact: f004a24c57 user: drh
10:42 Reply: Version 3.35.6 ?? artifact: ab8fde48c0 user: drh
2021-04-28
18:59 Reply: Version 3.35.6 ?? artifact: 58cf889e5f user: drh
17:59 Reply: Version 3.35.6 ?? artifact: 28bd44184b user: drh
2021-04-26
14:34 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 44a9c99a2c user: drh
14:05 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 5b83b5c921 user: drh
14:00 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 123490e95b user: drh
12:38 Reply: bug report : adding constant to GROUP BY leads to different output artifact: 25bd73d320 user: drh
2021-04-24
13:48 Reply: Getting error when pipe sql into sqlite3 utility artifact: b5a93aeb49 user: drh
10:58 Reply: Different results in SELECT DISTINCT artifact: 5ca5ad9aa9 user: drh
2021-04-23
13:11 Reply: sqlite.org/draft shows the same data as sqlite.org artifact: f3dd6edad1 user: drh
13:08 Reply: unqualified rowid as a SELECT column artifact: c12053d13c user: drh
2021-04-21
17:38 Reply: query plan for "is null" on column defined as "not null" artifact: fd9662783e user: drh
2021-04-20
12:00 Reply: Why no release announcement in this Forum anymore? artifact: 5fff4d8f52 user: drh
10:48 Edit reply: Why no release announcement in this Forum anymore? artifact: 9a0442c5b0 user: drh
10:47 Reply: V 3.35.5 artifact: 192864ae2e user: drh
10:46 Reply: Why no release announcement in this Forum anymore? artifact: 0d0ac5e99c user: drh
2021-04-19
13:20 Reply: SQLite doesn't use indexes for bitwise clauses? artifact: b4d48a923f user: drh
11:51 Reply: SQLite doesn't use indexes for bitwise clauses? artifact: e27ae565f5 user: drh
2021-04-15
21:19 Reply: Question About Command Line Backup of Locked DB artifact: a252371d80 user: drh
12:09 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: f8941a24a8 user: drh
12:07 Reply: programming sqlite bytecode directly ? artifact: 7313ba5cb6 user: drh
2021-04-14
14:03 Reply: usage of SHA-1 artifact: d225ef5b13 user: drh
2021-04-13
23:44 Edit reply: Regression: Mixing AND with OR results in no rows returned artifact: 9cb906da7f user: drh
18:43 Reply: Regression: Mixing AND with OR results in no rows returned artifact: d36426225c user: drh
18:25 Edit reply: Regression: Mixing AND with OR results in no rows returned artifact: d23189d7c0 user: drh
2021-04-12
11:34 Reply: How to get the last row_id in a table without inserting anything artifact: a1cfd66c76 user: drh
11:31 Reply: find in b+-tree node artifact: b303800549 user: drh
11:26 Reply: UNION Sorts on First Field artifact: 3b5f4b47a7 user: drh