[Bug]: having vector score reported unsupported expression executor now is not yet implemented

[heni02]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

v3.0.4-hotfix

Commit ID

6b326bf

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

sql:

SELECT content_type,
                    COUNT(*) as count,
                    AVG(cosine_similarity(question_vector,
                        (SELECT question_vector FROM ca_comprehensive_dataset WHERE md5_id = (SELECT md5_id FROM ca_comprehensive_dataset WHERE question_vector IS NOT NULL LIMIT 1))
                    )) as avg_similarity
             FROM ca_comprehensive_dataset
             WHERE question_vector IS NOT NULL
               AND content_type IS NOT NULL
               AND content_type != ''
             GROUP BY content_type
             HAVING avg_similarity > 0.6
             ORDER BY avg_similarity DESC
             LIMIT 10

报错：

unsupported expression executor for typ:<id:225 width:1024 > sub:<node_id:8 row_size:1 >  now is not yet implemented

Expected Behavior

No response

Steps to Reproduce

ddl:
SET foreign_key_checks = 0;set experimental_fulltext_index=1;set experimental_ivf_index=1;drop database if exists anli_test;create database anli_test;use anli_test;CREATE TABLE ca_comprehensive_dataset (md5_id varchar(255) NOT NULL,question text DEFAULT NULL,answer json DEFAULT NULL,source_type varchar(255) DEFAULT NULL,content_type varchar(255) DEFAULT NULL,keyword varchar(255) DEFAULT NULL,question_vector vecf64(1024) DEFAULT NULL COMMENT '摘要的向量集',allow_access varchar(511) DEFAULT NULL,allow_identities varchar(512) DEFAULT NULL,delete_flag int DEFAULT NULL,created_at timestamp DEFAULT CURRENT_TIMESTAMP(),updated_at timestamp DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP(),PRIMARY KEY (md5_id),KEY idx_comprehensive_allow_access (allow_access),KEY idx_comprehensive_allow_identities (allow_identities),KEY idx_comprehensive_content_type (content_type));

load data url s3option {'endpoint'='http://cos.ap-guangzhou.myqcloud.com','access_key_id'='xx','secret_access_key'='xx','bucket'='mo-load-guangzhou-1308875761', 'filepath'='mo-big-data/ca_ai_ca_comprehensive_dataset.csv'} into table ca_comprehensive_dataset FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' PARALLEL 'TRUE';

Additional information

No response