lnav icon indicating copy to clipboard operation
lnav copied to clipboard

Escape fields with dots in rewriter

Open ppcharli opened this issue 6 years ago • 1 comments

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

ppcharli avatar Apr 03 '19 15:04 ppcharli

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.

tstack avatar Apr 11 '19 18:04 tstack