v.22.1Improvement

Fix SQL Function to Support Symlinks

Fix surprisingly bad code in SQL ordinary function file. Now it supports symlinks. #32640 (alexey-milovidov).
Improved the file SQL ordinary function to correctly support symbolic links (symlinks).

Why it matters

The existing implementation of the file function had inefficient and incorrect handling, especially for symbolic links. This fix resolves those issues, allowing users to interact with symlinks appropriately, improving reliability and correctness when accessing files via the file function.

How to use it

Simply use the file function as before in SQL queries; the function now transparently supports symlinks without requiring any additional user action or configuration.