sap data services连接 starrocks报错

尝试使用 sap data services 4.2/ 4.3 连接 starrocks , 创建datastores时会报错,选择mysql的数据库,8.x版本, 会提示如下报错信息:
Cannot establish database connection.SQL submitted to database <information_schema> resulted in error<[MySQL][ODBC 8.0(w) Driver][mysqld-8.0.33]Getting analyzing error.Detail message: Set statement only support constant expr…>. The SQLsubmitted is <SET SESSION sql_mode=(SELECTCONCAT(@@sql_mode,’,ANSI_QUOTES’))>.’ (BODI-1111341)
关键是starrocks 不支持子查询赋值,有大佬遇到类似情况吗?