home / fixtures

fixtures

Query actions Query actions
  • Explain this query

    Runs a SQLite explain

Test tables description

Custom SQL query returning 125 rows (hide)

This data as json, testall, testnone, testresponse, CSV

namebuiltintypeencnargflags
group_concat 1 w utf8 1 2097152
group_concat 1 w utf8 2 2097152
julianday 1 s utf8 -1 2099200
ntile 1 w utf8 1 2097152
nullif 1 s utf8 2 2099200
sqlite_compileoption_get 1 s utf8 1 2097152
current_timestamp 1 s utf8 0 2097152
sqlite_compileoption_used 1 s utf8 1 2097152
sum 1 w utf8 1 2097152
quote 1 s utf8 1 2099200
printf 1 s utf8 -1 2099200
likelihood 1 s utf8 2 2099200
last_value 1 w utf8 1 2097152
rank 1 w utf8 0 2097152
round 1 s utf8 1 2099200
round 1 s utf8 2 2099200
rtrim 1 s utf8 1 2099200
rtrim 1 s utf8 2 2099200
nth_value 1 w utf8 2 2097152
random 1 s utf8 0 2097152
trim 1 s utf8 1 2099200
trim 1 s utf8 2 2099200
time 1 s utf8 -1 2099200
total 1 w utf8 1 2097152
substr 1 s utf8 2 2099200
substr 1 s utf8 3 2099200
replace 1 s utf8 3 2099200
upper 1 s utf8 1 2099200
typeof 1 s utf8 1 2099200
load_extension 1 s utf8 1 524288
load_extension 1 s utf8 2 524288
soundex 1 s utf8 1 2099200
avg 1 w utf8 1 2097152
abs 1 s utf8 1 2099200
strftime 1 s utf8 -1 2099200
substring 1 s utf8 2 2099200
substring 1 s utf8 3 2099200
randomblob 1 s utf8 1 2097152
unicode 1 s utf8 1 2099200
percent_rank 1 w utf8 0 2097152
row_number 1 w utf8 0 2097152
last_insert_rowid 1 s utf8 0 2097152
sqlite_log 1 s utf8 2 2099200
unlikely 1 s utf8 1 2099200
char 1 s utf8 -1 2099200
count 1 w utf8 0 2097152
count 1 w utf8 1 2097152
date 1 s utf8 -1 2099200
total_changes 1 s utf8 0 2097152
changes 1 s utf8 0 2097152
sqlite_version 1 s utf8 0 2097152
coalesce 1 s utf8 -1 2099200
glob 1 s utf8 2 2099200
zeroblob 1 s utf8 1 2099200
hex 1 s utf8 1 2099200
iif 1 s utf8 3 2099200
sqlite_source_id 1 s utf8 0 2097152
datetime 1 s utf8 -1 2099200
cume_dist 1 w utf8 0 2097152
instr 1 s utf8 2 2099200
dense_rank 1 w utf8 0 2097152
ifnull 1 s utf8 2 2099200
current_date 1 s utf8 0 2097152
current_time 1 s utf8 0 2097152
lag 1 w utf8 1 2097152
lag 1 w utf8 3 2097152
lag 1 w utf8 2 2097152
like 1 s utf8 2 2099200
like 1 s utf8 3 2099200
max 1 s utf8 -1 2099200
max 1 w utf8 1 2097152
min 1 s utf8 -1 2099200
min 1 w utf8 1 2097152
lead 1 w utf8 1 2097152
lead 1 w utf8 3 2097152
lead 1 w utf8 2 2097152
lower 1 s utf8 1 2099200
ltrim 1 s utf8 1 2099200
ltrim 1 s utf8 2 2099200
first_value 1 w utf8 1 2097152
length 1 s utf8 1 2099200
likely 1 s utf8 1 2099200
sleep 0 s utf8 1 0
escape_fts 0 s utf8 1 0
json_replace 0 s utf8 -1 2099200
json_type 0 s utf8 2 2099200
json_type 0 s utf8 1 2099200
json_remove 0 s utf8 -1 2099200
convert_units 0 s utf8 3 0
json_quote 0 s utf8 1 2099200
json_group_object 0 w utf8 2 3147776
json_extract 0 s utf8 -1 2099200
rtreedepth 0 s utf8 1 0
bm25 0 s utf8 -1 0
prepare_connection_args 0 s utf8 0 0
json 0 s utf8 1 2099200
fts5_isalnum 0 s utf8 -1 0
json_group_array 0 w utf8 1 3147776
json_array 0 s utf8 -1 2099200
fts5_expr 0 s utf8 -1 0
json_set 0 s utf8 -1 2099200
json_patch 0 s utf8 2 2099200
match 0 s utf8 2 0
json_insert 0 s utf8 -1 2099200
fts5 0 s utf8 1 0
fts5_fold 0 s utf8 -1 0
fts5_expr_tcl 0 s utf8 -1 0
fts3_tokenizer 0 s utf8 2 524288
fts3_tokenizer 0 s utf8 1 524288
snippet 0 s utf8 -1 0
json_array_length 0 s utf8 2 2099200
json_array_length 0 s utf8 1 2099200
optimize 0 s utf8 1 0
json_valid 0 s utf8 1 2099200
matchinfo 0 s utf8 2 0
matchinfo 0 s utf8 1 0
fts5_decode 0 s utf8 2 0
json_object 0 s utf8 -1 2099200
rtreecheck 0 s utf8 -1 0
rtreenode 0 s utf8 2 0
highlight 0 s utf8 -1 0
fts5_decode_none 0 s utf8 2 0
fts5_source_id 0 s utf8 0 0
offsets 0 s utf8 1 0
fts5_rowid 0 s utf8 -1 0
Powered by Datasette