Tools

AI-generated text

LLM 0.37.3 fixes logging compatibility with newer SQLite

LLM 0.37.3 is a bug-fix release addressing a logging problem involving the latest Homebrew package.

LLM 0.37.3 fixes logging compatibility with newer SQLite

LLM 0.37.3 has been released as a bug-fix update, primarily addressing a problem with the software’s latest Homebrew package. Homebrew now ships SQLite 3.54.1, whose correction of an earlier bug changed the result of a query and disrupted LLM’s logging code.

The difference appears in a nested JSON query:

select json_object('a', (select json_array(1)))

SQLite 3.54.0 returns {"a":[1]}, while version 3.54.1 returns {"a":"[1]"} for the same query: in the latter result, the array appears as text.

According to D. Richard Hipp, the behavior in 3.54.1 matches the documentation. The inner SELECT returns SQL text rather than a JSON value, so the result produced by 3.54.0 was the bug.

The problem can be worked around by explicitly converting the result of the inner query to JSON:

select json_object('a', json((select json_array(1))))