Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.14
-
None
-
spider
Description
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) |