Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23688

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

    XMLWordPrintable

Details

    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)
      

      Attachments

        Activity

          People

            ycp Yuchen Pei
            hiller1 hiller1
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.