mysql> show create table sbtest1\G

       Table: sbtest1

Create Table: CREATE TABLE `sbtest1` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `k` int(10) unsigned NOT NULL DEFAULT 0,

  `c` char(120) NOT NULL DEFAULT '',

  `pad` char(60) NOT NULL DEFAULT '',

  PRIMARY KEY (`id`),

  KEY `k_1` (`k`)

) ENGINE=SPIDER AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8 COMMENT='wrapper "mysql", table "sbtest1",srv "backend1"'

1 row in set (0.00 sec)

mysql>  SELECT id FROM sbtest1 WHERE id BETWEEN 1 AND 10;

ERROR 12710 (HY000): Invalid information from remote table 'test.sbtest1'

mysql> 

mysql>  SELECT id FROM sbtest1 order by id asc limit 10;;

+----+

| id |

+----+

|  1 |

|  2 |

|  3 |

|  4 |

|  5 |

|  6 |

|  7 |

|  8 |

|  9 |

| 10 |

+----+

10 rows in set (0.01 sec)

ERROR: 

No query specified

mysql> select version();

+---------------------+

| version()           |

+---------------------+

| 10.4.14-MariaDB-log |

+---------------------+

1 row in set (0.00 sec)