I have more than 100k records in my directory, but I am able to fetch only 100k records, not able to fetch after 100k records by using limit and offset.
I am attaching files also.
if i use 1.17 or 1.14 able to fetch all records.
SELECT * FROM dfs. `C:\Users\ravik\Downloads\test_folder` LIMIT 10000 OFFSET 90000