Skip to content

Uncaught Error: no such function: json_extract #237

@kimown

Description

@kimown

I want use json1 in sql.js, I test some sql snippet in online demo

create table user (name text,phone JSON );
insert into user (name, phone) values("oz",'{"cell":"+491765", "home":"+498973"}');
select user.phone from user where user.name=='oz';
select json_extract(user.phone, '$.cell') from user;

reference

image

but throw error : Uncaught Error: no such function: json_extract, how can I enable JSON1 extension, should I change Makefile like FTS5 extension.
https://github.com/kripken/sql.js/pull/199

https://github.com/kripken/sql.js/issues/68

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions