fix substring function in pure compiled mode for different signatures

[PrateekGarg-gs]

• add test for substring native function

[github-actions[bot]]

Test Results

   522 files     522 suites   35m 51s :stopwatch: 3 826 tests 3 794 :heavy_check_mark: 32 :zzz: 0 :x: 5 129 runs  5 097 :heavy_check_mark: 32 :zzz: 0 :x:

Results for commit 76766859.

:recycle: This comment has been updated with latest results.