This is an automated cherry-pick of #9615

What problem does this PR solve?

Issue Number: close #9522

Problem Summary:

What is changed and how it works?

1. remove some useless arguments(pos, occ, match_type)
2. support first argument as ColumnConst

Check List

Tests

• Unit test
• Integration test
• Manual test (add detailed scripts or steps below)
• No code

Side effects

• Performance regression: Consumes more CPU
• Performance regression: Consumes more Memory
• Breaking backward compatibility

Documentation

• Affects user behaviors
• Contains syntax changes
• Contains variable changes
• Contains experimental features
• Changes MySQL compatibility

Release note

fix error when first argument of replace function is const