SQLite Forum

Timeline
Login

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

53 events for the month beginning 2023-01-01 by user drh

Following month ↑
2023-01-31
13:02 Reply: Poor optimization for query after 3.38.5 artifact: a09011861f user: drh
12:51 Reply: Poor optimization for query after 3.38.5 artifact: 87bc6d203c user: drh
2023-01-30
20:47 Reply: Poor optimization for query after 3.38.5 artifact: 5cd0030cc4 user: drh
15:58 Reply: Poor optimization for query after 3.38.5 artifact: 761adbe367 user: drh
2023-01-26
14:12 Edit reply: sqlite3_vtab_in_first artifact: 19cfd2f1bf user: drh
11:32 Edit: SQLite WASM in node.js artifact: c8dcf058b3 user: drh
02:24 Edit reply: sqlite3_vtab_in_first artifact: 3461cff0ce user: drh
01:10 Reply: sqlite3_vtab_in_first artifact: eb5206c51f user: drh
2023-01-25
19:07 Reply: create_module_v2 destructor called too early? artifact: ed813060a8 user: drh
17:02 Reply: sqlite3_vtab_in_first artifact: abc040d03a user: drh
2023-01-24
15:58 Reply: Using SQLite on z/OS (readlink) artifact: a7f94d0123 user: drh
2023-01-23
21:42 Reply: i've got that terrible warning at the end of building my c++ project artifact: e731078311 user: drh
20:47 Reply: Suspicious 'address of array 'pParse->writeMask' will always evaluate to true' warning artifact: 910f947b8d user: drh
13:33 Reply: Virtual Table _ CSV artifact: fe30cb5c34 user: drh
2023-01-21
12:24 Reply: HEX - What is the reverse function? artifact: 1b58838319 user: drh
2023-01-20
11:27 Reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 9dd717e9da user: drh
2023-01-19
14:10 Reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 6c7852cc28 user: drh
2023-01-18
20:14 Edit: SQLLite Querying Question artifact: abce426e85 user: drh
2023-01-17
21:46 Reply: bug? running error with SQLITE_OMIT_WAL FOR RBU artifact: 2e5e53761b user: drh
11:53 Reply: In the sqlite shell, show the number of rows in the result set artifact: 302655c8fb user: drh
2023-01-16
19:29 Reply: bug? running error with SQLITE_OMIT_WAL FOR RBU artifact: 7d4580a7f3 user: drh
2023-01-14
13:59 Reply: Completion of error handling artifact: 5f34734750 user: drh
2023-01-13
19:36 Reply: IS NULL in UPDATE RETURNING clause yields an incorrect result artifact: ebf1d1e138 user: drh
19:18 Edit reply: IS NULL in UPDATE RETURNING clause yields an incorrect result artifact: 99415b5c56 user: drh
18:38 Reply: IS NULL in UPDATE RETURNING clause yields an incorrect result artifact: 74d46c0a27 user: drh
18:30 Reply: IS NULL in UPDATE RETURNING clause yields an incorrect result artifact: 96ab4dae8e user: drh
18:13 Reply: Completion of error handling artifact: 28083af7bc user: drh
18:01 Reply: Loading extensions in a trigger, unsafe use of load_extension() artifact: 636c3764b1 user: drh
17:13 Reply: Completion of error handling artifact: 0dc98c3929 user: drh
12:57 Reply: Completion of error handling artifact: 20681e90e2 user: drh
2023-01-11
21:41 Reply: sqlite3_context_db_handle question artifact: e54e5177be user: drh
20:50 Reply: Why in tables WITHOUT ROWID is the amount of payload that spills onto overflow pages from leaf page like for an index page? artifact: 89d24ed2c7 user: drh
10:48 Reply: Cancellation in custom SQLiteFunction artifact: 900352c19d user: drh
2023-01-10
19:59 Reply: Issue with pragma table_info / data-type on views in 3.41 artifact: 2f46954039 user: drh
15:37 Reply: about the result 1='1' that sqlite behave different with mysql or oracle artifact: b76de293a0 user: drh
15:11 Reply: Find an issue sqlite cannot open on some release version of Linux artifact: 40fdd858d3 user: drh
14:01 Reply: SQLite won't .quit from Windows PowerShell artifact: 6067932e96 user: drh
13:58 Reply: Find an issue sqlite cannot open on some release version of Linux artifact: 90d7de53ff user: drh
13:56 Reply: sqlite3_reset not picking up error from window function final artifact: 886777fb49 user: drh
2023-01-09
16:08 Reply: Loop in SELECT? artifact: 0fab0269e3 user: drh
15:00 Reply: Why does --safe not prevent readfile()? artifact: a49be43272 user: drh
14:40 Reply: SQLite3 not compiling with non-GCC compilers artifact: f661cf5cbd user: drh
14:34 Reply: Why is json_extract() considered unsafe? artifact: b34cdd2be3 user: drh
13:37 Reply: Issue with pragma table_info / data-type on views in 3.41 artifact: f97e1f919a user: drh
11:35 Reply: Email notifications KO? artifact: 3e78b683f1 user: drh
2023-01-06
11:56 Reply: ORDER BY in VIEW definition or in SELECT from the view? artifact: 156df19bf5 user: drh
11:49 Reply: How to reset and account password artifact: aa3b75a741 user: drh
2023-01-05
23:35 Delete reply: Specify hash type on downloads page artifact: 9d2cc7bf21 user: drh
23:35 Reply: Specify hash type on downloads page artifact: a3a09e0282 user: drh
22:21 Reply: Which of these queries is faster? artifact: 93f105f576 user: drh
21:18 Reply: Release security fix for CVE-2022-46908 artifact: 82d4df9d60 user: drh
18:07 Reply: Release security fix for CVE-2022-46908 artifact: 1f2f94dfa3 user: drh
01:42 Reply: Crash in zipfile(NULL) in 3.40.0 artifact: 731e268cb7 user: drh
Previous month ↓