LGHome opened a new issue, #18090: URL: https://github.com/apache/shardingsphere/issues/18090
VERSION：shardingsphere-jdbc-core-spring-boot-starter 5.0.0 Question: 1. i want to excute a cross schema query sql, but it went wrong, so i set the 'sql-federation-enabled' to 'true' ,the sql can normal excute. 2.but when i want to excute the across schema query sql with 'order by' ,It will cause errors. if remove the 'order by' it will normal excute. How do I solve this problem? My configuration is as follows:  sql： `SELECT hf.file_id, iu.b, iu.c FROM hfle_file hf LEFT JOIN hpfm_tenant_tl ht ON hf.tenant_id = ht.tenant_id AND ht.lang = ? LEFT JOIN iam_user iu ON hf.created_by = iu.id WHERE 1 = 1 AND hf.tenant_id = ? ORDER BY hf.file_id DESC LIMIT 10` Remarks：table 'hfle_file' in 'filedb' schema，table 'iam_user ','hpfm_tenant_tl ' in another schema。 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
