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

Stale FRM in federated client

    XMLWordPrintable

    Details

      Description

      Reproduce

      install soname 'ha_federatedx';
       
      create or replace table t1 (x int);
      --replace_result $MASTER_MYPORT MASTER_MYPORT
      eval create or replace table tf engine=FEDERATED connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1';
      create or replace table t1 (x varchar(255));
      insert into tf values ("hello");
       
      drop database test;
      create database test;
      uninstall soname 'ha_federatedx';
      

      Result

      mysqltest: At line 7: query 'insert into tf values ("hello")' failed: 1366: Incorrect integer value: 'hello' for column 'x' at row 1
      

      Expected

      No error.

      Reproduce 2

      then

      insert into t1 values ("hello");
      select * from tf;
      

      Result 2

      +------+
      | x    |
      +------+
      |    0 |
      +------+
      

      Expected 2.

      "hello" returned.

      Notes

      FRM discrepancy is allowed between server and client.

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            midenok Aleksey Midenkov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration