fselect کے پرانے ورژن – تمام ورژنز

### 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.
• `CURRENT_DATE`, `NOW`, `DATE_ADD`, `DATE_SUB`, `FROM_UNIXTIME`, `LAST_DAY` and `DATE_TRUNC` 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](https://github.com/jhspetersson/fselect/issues/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.

### Added

• `HAVING` support

### Changed

• queries with conflicting `AND` branches are now considered invalid (only `is_file`, `is_dir`, `is_pipe`, etc. are supported by now)

### Fixed

• fixed unary minus handling
• non-tty output now doesn't use ANSI colors #186
• other bugs fixed

- support plocate and Everything #98
- added word_count, char_count, encoding, has_bom, line_ending fields
- added git-related fields
- added blksize, atime_nsec, mtime_nsec, ctime_nsec fields
- added symlink_target and is_broken_symlink fields
- support extattrs and acl fields on Windows
- support metadata extraction for FLAC, Ogg Vorbis, Opus, and several other formats
- added mp3_comment, mp3_track, and mp3_disc 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!

- support subqueries in the FROM clause
- support positional GROUP BY
- support EXTRACT and DATE_TRUNC 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!

- added is_sticky, atime, mtime, ctime, xattr_count and rdev fields
- added support for POSIX and Windows ACLs (fields acl, default_acl, has_acl and has_default_acl, functions HAS_ACL_ENTRY, ACL_ENTRY, HAS_DEFAULT_ACL_ENTRY and DEFAULT_ACL_ENTRY)
- added support for extended file attributes (fields extattrs and has_extattrs, function HAS_EXTATTR)
- support Linux capabilities v2 and v3
- support xattrs on Windows
- added many EXIF fields
- added datetime functions DAYNAME, DAYOFYEAR, DATE_ADD, DATE_SUB, DATE_DIFF, FROM_UNIXTIME, LAST_DAY
- added a parameter to ROUND function
- NO_COLOR 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

- improved interactive mode: persistent history, cd and pwd commands
- LIMIT now supports offsets with OFFSET keyword or with LIMIT M,N notation
- CONTAINS_GREEK function
- configurable support for US dates format

- support subqueries as columns
- add PI, FLOOR, CEIL and ROUND functions
- improved HTML output formatting
- fixed bugs
Thanks to @mathrick for another reported issues!

- complex subqueries which can refer their parent tables #124
- EXISTS / NOT EXISTS operator
- CURRENT_TIMESTAMP, 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!

- subqueries support
- bash completion #174
- make checking for hardlinks an optional setting for every search root
- new fields exif_exposure_time (or exif_exptime), exif_aperture, exif_shutter_speed, exif_f_number (or exif_f_num), exif_iso_speed (or exif_iso), exif_focal_length (or exif_focal_len), exif_lens_make, exif_lens_make #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!

- 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 (due to a broken semver in one of the dependencies)!

- bugfixes, including #171 and #172
- added running time measurements for debug mode
Thanks again @volodyalipkin for reporting the issues!

- added ABS, EXP, LN and LOG functions
- better support search roots with spaces
- fixed various bugs including #150 and #167
Thanks to all contributors and bug reporters! @4censord @paolobarbolini @rickhg12hs 🌃

- support duration extraction from WAV files
- add IS_FONT field for ad hoc font file extensions detection
- support .gradle as known source code file extension
- add .DJV as another ad hoc known file type

- added BETWEEN operator #139
- added FORMAT_TIME function #143
- check for updates (optional feature disabled by default) #138
- added mkv duration extractor #140
- added quit and exit commands for interactive mode
- added .tsx as a known source file extension
Many thanks go to @4censord, @Dialga and @Luxzi who contributed to this release!