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))))



