histdb:211: bad math expression: operator expected at `in select ...

[xkortex]

Just started getting this error on fresh install of Ubuntu 18.04.

Linux 4.18.0-15-generic #16~18.04.1-Ubuntu SMP Thu Feb 7 14:06:04 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
zsh 5.4.2 (x86_64-ubuntu-linux-gnu)
sqlite3 3.22.0 2018-01-22 18:45:57 0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1

Currently at master 873610f. Typing histdb shows

Error: no such column: true
Error: no such column: true
error in -header -separator                          select strftime(case when datetime(max_start, 'unixepoch') > datetime('now', 'start of day') then '%H:%M' else '%d/%m' end, max_start, 'unixepoch', 'localtime') as time, session as ses, dir, argv as cmd from (select session, replace(places.dir, '/home/user', '~') as dir, replace(commands.argv, '
', '
') as argv, max(start_time) as max_start
from
  commands 
  join history on history.command_id = commands.id
  join places on history.place_id = places.id
where true and places.host='guibox'
group by history.command_id, history.place_id
order by max_start desc
limit 20) order by max_start asc
histdb:211: bad math expression: operator expected at `in select ...'

If I checkout 9598f2f and restart zsh, the error goes away.

[larkery]

That's very odd, especially the syntax error; select true should generally work. I'll see whether I can reproduce this somehow.

873610f does change the default where clause to 'true', but this should be legal. What's your sqlite version (although a long shot, maybe this is different?)