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 ↓