Closed rfhb closed 2 years ago
SQLite's function json_tree() returned, for example, in the field fullkey a value as
SQLite
json_tree()
fullkey
$.primary_outcome[0].time_frame
$."primary_outcome"[0]."time_frame"
See https://sqlite.org/src/info/4a1553b55f085163.
SQL code in docdb_query.src_sqlite() of package nodbi is being adapted to account for this change.
docdb_query.src_sqlite()
nodbi
SQLite's functionjson_tree()returned, for example, in the fieldfullkeya value as$.primary_outcome[0].time_frameup to and including version 3.38.2, but returns$."primary_outcome"[0]."time_frame"(note the double quotes added) from version 3.38.3 onward.See https://sqlite.org/src/info/4a1553b55f085163.
SQL code in
docdb_query.src_sqlite()of packagenodbiis being adapted to account for this change.