tidb fails to pushdown `json_extract` resulting in querry oom or server crash

### 1. Minimal reproduce step (Required)

```py
import pymysql
import json
import os
import random

# Database connection parameters
db_params = {
'host': 'localhost',
'user': 'your_username',
'password': 'your_password',
'db': 'your_database',
'charset': 'utf8mb4',
'cursorclass': pymysql.cursors.DictCursor
}

# Initialize connection
connection = pymysql.connect(**db_params)

# Function to create database and table
def create_database_and_table():
with connection.cursor() as cursor:
cursor.execute("CREATE DATABASE IF NOT EXISTS your_database;")
cursor.execute("USE your_database;")
cursor.execute("""
CREATE TABLE IF NOT EXISTS blocks (
workchain TINYINT NOT NULL,
shard BIGINT UNSIGNED NOT NULL,
seqno INT UNSIGNED NOT NULL,
root_hash VARBINARY(32) NOT NULL,
shards_info JSON NULL,
PRIMARY KEY (workchain, shard, seqno),
CONSTRAINT blocks_root_hash UNIQUE (root_hash)
);
""")
connection.commit()

# Function to generate a random hex string
def generate_hex_string(length=64):
return ''.join(random.choice('0123456789abcdef') for _ in range(length))

# Function to generate fake shards_info JSON
def generate_shards_info(fake=True):
if fake:
# Generate random shards_info that does not match the query condition
shards_info = [{"info": {"rootHash": [generate_hex_string(2)]}} for _ in range(random.randint(1, 5))]
else:
# Generate shards_info that matches the query condition
shards_info = [{"info": {"rootHash": ["01"]}}] # This will match the UNHEX condition in the SQL query
return json.dumps(shards_info)

# Function to generate and insert fake data
def generate_fake_data(num_records, insert_matching_row=True):
with connection.cursor() as cursor:
if insert_matching_row:
# Insert one matching row
matching_workchain = -1
matching_shard = 0x8000000000000000
matching_seqno = random.randint(0, 4294967295)
matching_root_hash = os.urandom(32)
matching_shards_info = generate_shards_info(fake=False)

sql = """
INSERT INTO blocks (workchain, shard, seqno, root_hash, shards_info)
VALUES (%s, %s, %s, %s, %s)
"""
cursor.execute(sql, (matching_workchain, matching_shard, matching_seqno, matching_root_hash, matching_shards_info))

# Insert fake rows
for _ in range(num_records - 1):
fake_workchain = random.randint(-128, 127)
fake_seqno = random.randint(0, 4294967295)
fake_root_hash = os.urandom(32)
fake_shards_info = generate_shards_info()

cursor.execute(sql, (fake_workchain, matching_shard, fake_seqno, fake_root_hash, fake_shards_info))

connection.commit()

# Create database and table
create_database_and_table()

# Generate 10_000_000 fake records, with 1 matching row
generate_fake_data(10**6)

# Close the connection
connection.close()
```

```sql
SELECT root_hash
FROM blocks
WHERE workchain = -1
AND shard = 0x8000000000000000
AND UNHEX(JSON_UNQUOTE(JSON_EXTRACT(shards_info,
'$[0].info.rootHash[0]'))) =
0x1
LIMIT 1;
```
[ddebbdd3fb95f2b16335f77890ad99b1ddec5992a4670105079a6a768c36bd5c.txt](https://github.com/pingcap/tidb/files/13488294/ddebbdd3fb95f2b16335f77890ad99b1ddec5992a4670105079a6a768c36bd5c.txt)

using
```
/*+ READ_FROM_STORAGE(TIFLASH[blocks]) */
```
reduces memory usage from 8gb to 980kb
[be3ba3f6fe2722f7b62db5fc771750f47e5484ba9426644ca165b25fe8113c9e.txt](https://github.com/pingcap/tidb/files/13488363/be3ba3f6fe2722f7b62db5fc771750f47e5484ba9426644ca165b25fe8113c9e.txt)

### 2. What did you expect to see? (Required)
I expected a simple streaming search with `JSON_UNQUOTE` filter pushed down to tikv, which successfully was done with tiflash.

### 3. What did you see instead (Required)
```
HY000][1105] Your query has been cancelled due to exceeding the allowed memory limit for the tidb-server instance and this query is currently using the most memory. Please try narrowing your query scope or increase the tidb_server_memory_limit and try again.[conn=2819858710]
```

Server with version
```
Release Version: v6.5.2
Edition: Community
Git Commit Hash: 29116c0256c52b224da2b34d712c1063d171c0ad
Git Branch: heads/refs/tags/v6.5.2
UTC Build Time: 2023-04-19 10:52:06
GoVersion: go1.19.8
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv
```
crashes with oom.

I have no info about memory usage because of the crash, but it has same execution plan.

### 4. What is your TiDB version? (Required)
```
Release Version: v7.4.0
Edition: Community
Git Commit Hash: 38cb4f3312be9199a983c0ef282d2ea2e28a7824
Git Branch: heads/refs/tags/v7.4.0
UTC Build Time: 2023-10-10 14:18:50
GoVersion: go1.21.1
Race Enabled: false
Check Table Before Drop: false
Store: tikv
```