Error in error log; (21) API called with NULL prepared statement

[chrisjlocke]

Discussed in #3598

^{Originally posted by Moaneschien March 28, 2024}
Before report it as a bug, after running the query below, the error pane says:

(21) API called with NULL prepared statement
(21) misuse at line 90775 of [d8cd6d49b4]

the result of the query is fine. I've seen it a few times before but didn't pay much attention as the results are ok. This one I caught. Checked it against SQLite 3.45.1 from the command line and it works fine, as expected. Is it a bug?

DB Browser for SQLite Version 3.13.99 (Mar 26 2024)
Last commit hash when built: 3e7dd41

Win 11

CREATE TABLE observationPT10M (
  ds  TEXT NOT NULL,  --'%F'
  pt10m INTEGER NOT NULL, --10 min index, 1 - 144
  energy_consumed Real,
  energy_returned Real,
  UNIQUE(ds,pt10m)
) STRICT;

CREATE UNIQUE INDEX idx_dspt10m 
    ON observationPT10M (ds, pt10m);

SELECT ds,
       max(energy_consumed), 
       max(energy_returned)
  FROM observationPT10M
 GROUP BY strftime('%Y', ds)
;

---

At the least, running this statement generates the error.

CREATE UNIQUE INDEX idx_dspt10m 
    ON observationPT10M (ds, pt10m);

[chrisjlocke]

Confirmed in both the nightly and rc1 of 3.13. In both versions, the line number and GUID is different (which sort of makes sense).

[justinclift]

Sounds like something we'd better investigate and fix before the 3.13 release too.