SQLite 3.40 又把 right join 搞坏了,调试了老半天才发现是sqlite的问题(mac自带的sqlite是3.39.5,没有bug)
select a.key, b.value from json_each('{"a": 1, "b": 2}') a right join json_each('["a", "c"]') b on a.key = b.value
select a.key, b.value from json_each('{"a": 1, "b": 2}') a right join json_each('["a", "c"]') b on a.key = b.value