Support other integer types for SubstringUTF8 & RightUTF8 functions (#…

…9507) (#9512)

close #9473

Support other integer types for SubstringUTF8 & RightUTF8 functions

Signed-off-by: gengliqi <gengliqiii@gmail.com>

ddl: fix query partition table failed after rename column (#9789) | t…

…idb=release-7.5 tikv=release-7.5 pd=release-7.5 (#9790)

This is an automated cherry-pick of #9789

### What problem does this PR solve?

Issue Number: close #9787

Problem Summary:

### What is changed and how it works?

Also picked #8694

```commit-message
Sync schema for all partitions if the schema of one of physical tables is different from the logical table.
```

### Check List

Tests <!-- At least one of them must be included. -->

- [ ] 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

<!-- bugfix or new feature needs a release note -->

```release-note
fix query partition table failed after rename column
```

---------

Signed-off-by: Lloyd-Pottiger <yan1579196623@gmail.com>
Co-authored-by: Lloyd-Pottiger <yan1579196623@gmail.com>
Co-authored-by: jinhelin <linjinhe33@gmail.com>

Set proxy's memory limit by TiFlash (#9753) and update tiflash proxy (#…

…9776)

ref #4982, close #9745

Signed-off-by: CalvinNeo <calvinneo1995@gmail.com>
Signed-off-by: Calvin Neo <calvinneo1995@gmail.com>
Signed-off-by: JaySon-Huang <tshent@qq.com>

Co-authored-by: JaySon <tshent@qq.com>

Storages: load RSResult only once (#9738)

ref #6233

Before, TiFlash will load the `RSResult` three times for one query (MVCC/Build Bitmap/Query).

This PR introduces `DMFilePackFilterResult` which load `RSResult` only once, and only passes the `RSResult` to `DMFileReader`.

Signed-off-by: JaySon-Huang <tshent@qq.com>

Co-authored-by: JaySon <tshent@qq.com>
Co-authored-by: JaySon-Huang <tshent@qq.com>

Support other integer types for SubstringUTF8 & RightUTF8 functions (#…

…9507) (#9514)

close #9473

Support other integer types for SubstringUTF8 & RightUTF8 functions

Signed-off-by: JaySon-Huang <tshent@qq.com>

Co-authored-by: JaySon <tshent@qq.com>
Co-authored-by: JaySon-Huang <tshent@qq.com>

Storages: Shutdown the LocalIndexScheduler before shutting down PageS…

…torage/DeltaMergeStore (release-8.5) (#9713)

close #9714

Storages: Shutdown the LocalIndexScheduler before shutting down PageStorage/DeltaMergeStore
* Add a method `LocalIndexerScheduler::shutdown()` and ensure the running task are all finished before shutting down the GlobalPageStorage in `ContextShared::shutdown()`.

Signed-off-by: JaySon-Huang <tshent@qq.com>

PageCtl: Support getting blob data from PageStorage instance (release…

…-7.5) (#9717)

close #9716

PageCtl: Support getting blob data from PageStorage instance
And output the "PageEntryV3.offset" in decimal instead of hexadecimal

Signed-off-by: JaySon-Huang <tshent@qq.com>

Support other integer types for SubstringUTF8 & RightUTF8 functions (#…

…9507) (#9513)

close #9473

Support other integer types for SubstringUTF8 & RightUTF8 functions

Signed-off-by: gengliqi <gengliqiii@gmail.com>

Co-authored-by: Liqi Geng <gengliqiii@gmail.com>
Co-authored-by: gengliqi <gengliqiii@gmail.com>

Storages: refactor DMFile vector search (#9549)

ref #9032

Storages: refactor DMFile vector search

Signed-off-by: Lloyd-Pottiger <yan1579196623@gmail.com>

Co-authored-by: ti-chi-bot[bot] <108142056+ti-chi-bot[bot]@users.noreply.github.com>

Storage: Abort adding vector index if encryption enabled (#9504)

ref #9032, close #9505

Storage: Abort adding vector index if encryption enabled