lnav
lnav copied to clipboard
Escape fields with dots in rewriter
If fields have dots rewriter with SQL fail i.e: "value" : { "ip.protocol": { "kind" : "string", "identifier" : true, "rewriter": ";SELECT :ip.protocol || ' (' || (SELECT message FROM http_status_codes WHERE status = :ip.protocol ) || ') '" } Failed with error:text_log:ip.protocol:1:near ".": syntax error
Yeah, it looks like the bind variable names in SQLite only work with alpha-numeric chars and quoting doesn't seem to work. Will need to figure out something here.