0.10.42026-10-23
Added
- IS NULL and IS NOT NULL operators.
- depth field.
- CONTAINS_CYRILLIC function; better Japanese text detection.
- STRPOS function, split from LOCATE.
- rlike as a regex operator alias.
- Encrypted entries in zip archives; more fields available for archived files, with archive paths included in their values.
- include: directives in .hgignore and .dockerignore.
- Function argument counts and literals compared with typed expressions are checked when the query is parsed.
- Integration test suite covering traversal, ignore files, formats, grouping, dates, archives and CLI flags.
Changed
- Expressions carry static types; caches, sorting, grouping and aggregates work on typed values instead of rendered text.
- fsize is numeric: it compares, groups, sorts and aggregates by byte count while printing the formatted size.
- CURRENTDATE, NOW, DATEADD, DATESUB, FROMUNIXTIME, LASTDAY and DATETRUNC return datetimes.
- LEAST and GREATEST operate on strings as well as numbers.
- xattr() returns values that are not UTF-8 as 0x.. hex instead of an empty string (#187).
- Unknown columns in GROUP BY and ORDER BY, ungrouped columns in grouped queries, an empty IN () and an incomplete WHERE clause are rejected.
- A literal that can never match a typed expression (length(name) > 'abc') is rejected before the search starts.
- LIKE '' matches the empty string.
- Bare words are treated as function calls only for functions that take no arguments.
- Root aliases are case-insensitive; JSON column names are lowercase.
- Search roots defined by subqueries inherit the root options of the parent query; a grouped subquery in FROM yields one entry per group.
- Faster sorting, aggregates, subquery caching, BFS traversal with LIMIT, deferred evaluation of heavy columns.
Fixed
- GROUP BY merged distinct values that render alike, such as sizes of 10,241 and 10,242 bytes both shown as 10.00KiB.
- Missing boolean values sorted as false instead of last.
- HAVING, aggregate aliases and MIN/MAX/COALESCE corner cases.
- Correlated subqueries: caching, nested contexts and the group values they see.
- Symlink handling and ignore rules applied across symlinks.
- SVG dimension detection, MP4 duration and exif_alt for negative altitudes.
- Errors no longer break JSON and HTML output or the row count.
- --help and --version after other arguments; paths containing whitespace; floating point literals and unary minus.
- Windows: datetime formatting, Unix permission fields, extended attributes on musl builds.
- Subquery OFFSET applied twice; depth calculation; path under symlinks.
0.10.32026-09-05
Added
* HAVING support
Changed
queries with conflicting AND branches are now considered invalid (only isfile, isdir, ispipe, etc. are supported by now)
Fixed
* fixed unary minus handling
* non-tty output now doesn't use ANSI colors #186
* other bugs fixed
0.10.22026-06-28
* support plocate and Everything #98
added wordcount, charcount, encoding, hasbom, line_ending fields
* added git-related fields
added blksize, atimensec, mtimensec, ctimensec fields
added symlinktarget and isbrokensymlink fields
* support extattrs and acl fields on Windows
* support metadata extraction for FLAC, Ogg Vorbis, Opus, and several other formats
added mp3comment, mp3track, and mp3disc fields
* added .qml to the known source file extensions
* optimized number of syscalls #175
* fixed bugs related to grouping and subqueries
Thanks to @akneni and @dsully for raising the issues that inspired these new feature ideas!
0.10.12026-05-30
* support subqueries in the FROM clause
* support positional GROUP BY
support EXTRACT and DATETRUNC functions
* parse "t" and "f" as truthy values
* fixed panic when parsing invalid datetimes #184
* optimized release build by reducing codegen-units to 1 #183
Thanks to @dvs-111 and @zamazan4ik for reporting bugs and bringing in the ideas how to improve the project!
0.10.02026-04-10
added issticky, atime, mtime, ctime, xattr_count and rdev fields
added support for POSIX and Windows ACLs (fields acl, defaultacl, hasacl and hasdefaultacl, functions HASACLENTRY, ACLENTRY, HASDEFAULTACLENTRY and DEFAULTACL_ENTRY)
added support for extended file attributes (fields extattrs and hasextattrs, function HAS_EXTATTR)
* support Linux capabilities v2 and v3
* support xattrs on Windows
* added many EXIF fields
added datetime functions DAYNAME, DAYOFYEAR, DATEADD, DATESUB, DATEDIFF, FROMUNIXTIME, LASTDAY
* added a parameter to ROUND function
NOCOLOR env var handling is fixed to match the original intent
* allow calling zero-arg functions (not only boolean) without parenthesis
* a lot of bugs fixed, and stability greatly improved
0.9.32026-03-03
* improved interactive mode: persistent history, cd and pwd commands
* LIMIT now supports offsets with OFFSET keyword or with LIMIT M,N notation
CONTAINSGREEK function
* configurable support for US dates format
0.9.22025-12-09
* support subqueries as columns
* add PI, FLOOR, CEIL and ROUND functions
* improved HTML output formatting
* fixed bugs
Thanks to @mathrick for another reported issues!
0.9.12025-11-14
* complex subqueries which can refer their parent tables #124
* EXISTS / NOT EXISTS operator
CURRENTTIMESTAMP, CURRENT_TIME functions
* filename column (just the name of a file without extension)
* improved error reporting #182
Thanks to @mathrick and @shah for creating the issues which helped to make this release!
0.9.02025-07-16
* subqueries support
* bash completion #174
* make checking for hardlinks an optional setting for every search root
new fields exifexposuretime (or exifexptime), exifaperture, exifshutterspeed, exiffnumber (or exiffnum), exifisospeed (or exifiso), exiffocallength (or exiffocallen), exiflensmake, exiflensmake #177
* path returns a relative path #178
Thanks to @Xanadul, @gwiener, @volodyalipkin and @mathrick for their suggestions and bug-reports that helped to form this release!
0.8.122025-05-15
* search logic optimized to check files against more lightweight conditions first
* supported IN (...list of values...) expression
* LEAST and GREATEST functions
* LOCATE function
* added .awk as a known source code file extension
Thanks to @ototo for testing and reporting failed builds #173 (due to a broken semver in one of the dependencies)!