bloomberg / bloomberg/comdb2

SQL documentation doesn't list json functions

Open
#1,542 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.5k
Forks
243
Avg merge
2d 2h
Merged PRs (30d)
37

Description

It seems comdb2 now supports sqlite's json functions (comdb2 version from internal unstable dpkg distribution):
```
cdb2sql> SELECT json_extract('{"a":2,"c":[4,5,{"f":7}]}', '$.c[2].f')
(json_extract('{"a":2,"c":[4,5,{"f":7}]}', '$.c[2].f')=7)
```

But these are not documented on:
https://bloomberg.github.io/comdb2/sql.html

Contributor guide

Open the contributing guide

Research direction

Start with the SQL documentation at https://bloomberg.github.io/comdb2/sql.html and compare its documented functions with the SQLite JSON functions shown in the issue's cdb2sql example. Confirm the supported JSON functions in comdb2, then update the SQL documentation so those functions are listed.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, sqlite
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.