[td-10564] 1. Enable  and then refactor the parse the nested function in select clause. 2. Add some scalar string function in function module. 3. Add more test cases.

[TD-6264]<hotfix>:backport _block_dist() from 2.1 to 2.0 to fix core dump due to tbuf length limitation