search

WebReflection / dblite

sqlite for node.js without gyp problems
MIT License
209 stars 34 forks source link

sqlite json functions don't work #48

Closed agdolla closed 7 years ago

agdolla commented 7 years ago

from command line this works:

sqlite> select * from json_each(json_array(20170318,20170319,20170329));
0|20170318|integer|20170318|1||$[0]|$
1|20170319|integer|20170319|2||$[1]|$
2|20170329|integer|20170329|3||$[2]|$

from dblite it results:

[ {}, {}, {} ]
WebReflection commented 7 years ago

Quickly checked, I actually have a syntax error.

Which version of sqlite are you using and for which platform?

WebReflection commented 7 years ago

screenshot from 2017-03-27 18-57-11

it works like a charm where supported