When using Spider storage engine on MariaDB 10.5 to connect to a MariaDB 10.6 remote server, if the spider table in your query has an index and is used as part of the query you will get

ERROR 12710 (HY000): Invalid information from remote table 'employees.dept_emp'

If you run the following command you get the same error

show index from emp_spider.dept_emp;

ERROR 12710 (HY000): Invalid information from remote table 'employees.dept_emp'

This issue easily reproducible.

1. Create a 10.6 server and load the following schema onto it https://github.com/datacharmer/test_db
2. Create a user to use for spider access
3. Then build a 10.5 server
4. Load the emp_spider_repro.sql schema onto the 10.5 server
   1. Be sure use the correct details for creating the server for Spider engine to use
5. Run the following commands on the 10.5 server

show index from emp_spider.dept_emp;

select count(*) from emp_spider.employees;

select count(*) from emp_spider.employees where emp_no between 1 and 40000;

The first and last command will return with an error but the second command will succeed