_memory
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
This data as json, testall, testnone, testresponse, CSV
name | narg | flags | type | deterministic | directonly | subtype | innocuous |
---|---|---|---|---|---|---|---|
group_concat | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
group_concat | 2 | 2097152 | w | 0 | 0 | 0 | 1 |
julianday | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
ntile | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
nullif | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
sqlite_compileoption_get | 1 | 2097152 | s | 0 | 0 | 0 | 1 |
current_timestamp | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
sqlite_compileoption_used | 1 | 2097152 | s | 0 | 0 | 0 | 1 |
sum | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
quote | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
printf | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
likelihood | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
last_value | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
rank | 0 | 2097152 | w | 0 | 0 | 0 | 1 |
round | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
round | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
rtrim | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
rtrim | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
nth_value | 2 | 2097152 | w | 0 | 0 | 0 | 1 |
random | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
trim | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
trim | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
time | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
total | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
substr | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
substr | 3 | 2099200 | s | 1 | 0 | 0 | 1 |
replace | 3 | 2099200 | s | 1 | 0 | 0 | 1 |
upper | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
typeof | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
load_extension | 1 | 524288 | s | 0 | 1 | 0 | 0 |
load_extension | 2 | 524288 | s | 0 | 1 | 0 | 0 |
soundex | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
avg | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
abs | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
strftime | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
substring | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
substring | 3 | 2099200 | s | 1 | 0 | 0 | 1 |
randomblob | 1 | 2097152 | s | 0 | 0 | 0 | 1 |
unicode | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
percent_rank | 0 | 2097152 | w | 0 | 0 | 0 | 1 |
row_number | 0 | 2097152 | w | 0 | 0 | 0 | 1 |
last_insert_rowid | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
sqlite_log | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
unlikely | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
char | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
count | 0 | 2097152 | w | 0 | 0 | 0 | 1 |
count | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
date | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
total_changes | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
changes | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
sqlite_version | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
coalesce | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
glob | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
zeroblob | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
hex | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
iif | 3 | 2099200 | s | 1 | 0 | 0 | 1 |
sqlite_source_id | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
datetime | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
cume_dist | 0 | 2097152 | w | 0 | 0 | 0 | 1 |
instr | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
dense_rank | 0 | 2097152 | w | 0 | 0 | 0 | 1 |
ifnull | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
current_date | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
current_time | 0 | 2097152 | s | 0 | 0 | 0 | 1 |
lag | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
lag | 3 | 2097152 | w | 0 | 0 | 0 | 1 |
lag | 2 | 2097152 | w | 0 | 0 | 0 | 1 |
like | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
like | 3 | 2099200 | s | 1 | 0 | 0 | 1 |
max | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
max | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
min | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
min | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
lead | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
lead | 3 | 2097152 | w | 0 | 0 | 0 | 1 |
lead | 2 | 2097152 | w | 0 | 0 | 0 | 1 |
lower | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
ltrim | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
ltrim | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
first_value | 1 | 2097152 | w | 0 | 0 | 0 | 1 |
length | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
likely | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
sleep | 1 | 0 | s | 0 | 0 | 0 | 0 |
escape_fts | 1 | 0 | s | 0 | 0 | 0 | 0 |
json_replace | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
json_type | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
json_type | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
json_remove | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
convert_units | 3 | 0 | s | 0 | 0 | 0 | 0 |
json_quote | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
json_group_object | 2 | 3147776 | w | 1 | 0 | 1 | 1 |
json_extract | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
rtreedepth | 1 | 0 | s | 0 | 0 | 0 | 0 |
bm25 | -1 | 0 | s | 0 | 0 | 0 | 0 |
prepare_connection_args | 0 | 0 | s | 0 | 0 | 0 | 0 |
json | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
fts5_isalnum | -1 | 0 | s | 0 | 0 | 0 | 0 |
json_group_array | 1 | 3147776 | w | 1 | 0 | 1 | 1 |
json_array | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
fts5_expr | -1 | 0 | s | 0 | 0 | 0 | 0 |
json_set | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
json_patch | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
match | 2 | 0 | s | 0 | 0 | 0 | 0 |
json_insert | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
fts5 | 1 | 0 | s | 0 | 0 | 0 | 0 |
fts5_fold | -1 | 0 | s | 0 | 0 | 0 | 0 |
fts5_expr_tcl | -1 | 0 | s | 0 | 0 | 0 | 0 |
fts3_tokenizer | 2 | 524288 | s | 0 | 1 | 0 | 0 |
fts3_tokenizer | 1 | 524288 | s | 0 | 1 | 0 | 0 |
snippet | -1 | 0 | s | 0 | 0 | 0 | 0 |
json_array_length | 2 | 2099200 | s | 1 | 0 | 0 | 1 |
json_array_length | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
optimize | 1 | 0 | s | 0 | 0 | 0 | 0 |
json_valid | 1 | 2099200 | s | 1 | 0 | 0 | 1 |
matchinfo | 2 | 0 | s | 0 | 0 | 0 | 0 |
matchinfo | 1 | 0 | s | 0 | 0 | 0 | 0 |
fts5_decode | 2 | 0 | s | 0 | 0 | 0 | 0 |
json_object | -1 | 2099200 | s | 1 | 0 | 0 | 1 |
rtreecheck | -1 | 0 | s | 0 | 0 | 0 | 0 |
rtreenode | 2 | 0 | s | 0 | 0 | 0 | 0 |
highlight | -1 | 0 | s | 0 | 0 | 0 | 0 |
fts5_decode_none | 2 | 0 | s | 0 | 0 | 0 | 0 |
fts5_source_id | 0 | 0 | s | 0 | 0 | 0 | 0 |
offsets | 1 | 0 | s | 0 | 0 | 0 | 0 |
fts5_rowid | -1 | 0 | s | 0 | 0 | 0 | 0 |