chore(query): make string to int respect behavior like PG

[sundy-li]

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/

Summary

1. reorder optimize rules
2. make string to int respect behavior like PG
3. refactor dummy column index

Tests

• [ ] Unit Test
• [x] Logic Test
• [ ] Benchmark Test
• [ ] No Test - Explain why

Type of change

• [ ] Bug Fix (non-breaking change which fixes an issue)
• [ ] New Feature (non-breaking change which adds functionality)
• [ ] Breaking Change (fix or feature that could cause existing functionality not to work as expected)
• [ ] Documentation Update
• [x] Refactoring
• [ ] Performance Improvement
• [ ] Other (please describe):

---

This change is 

[sundy-li]

Revert reorders, cause something wrong makes cluster ci hang

[github-actions[bot]]

Docker Image for PR

• tag: pr-16428-34b10a9-1726107562

note: this image tag is only available for internal use, please check the internal doc for more details.

[github-actions[bot]]

ClickBench Report

• hits: https://benchmark.databend.com/clickbench/pr/16428/10822683534/hits.html
• internal: https://benchmark.databend.com/clickbench/pr/16428/10822683534/internal.html
• load: https://benchmark.databend.com/clickbench/pr/16428/10822683534/load.html
• tpch: https://benchmark.databend.com/clickbench/pr/16428/10822683534/tpch.html