JSON functions stopped working with blobs in 3.45
(1.1)
By nalgeon on 2024-01-21 04:47:01 edited from 1.0
[source]
Given this file data.json:
[1, 2, 3]
This query in SQLite shell 3.44 works fine:
select readfile('data.json') -> 1;
-- 2
The same query in SQLite shell 3.45 returns an error:
select readfile('data.json') -> 1;
-- Runtime error near line 1: malformed JSON
(2)
By Larry Brasfield (larrybr) on 2024-01-20 22:18:13
in reply to 1.0
[link]
[source]
This should work:
select CAST(readfile('data.json') AS TEXT) -> 1;
What you are seeing is a ...
Read more at sqlite.org
© News Score score the news, sort the news, rewrite the headlines