Server version: 10.0.15-MariaDB-log mariadb.org binary distribution

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost-master [(none)]> create database proxy_test;
Query OK, 1 row affected (0.01 sec)

root@localhost-master [(none)]> use proxy_test;
Database changed
root@localhost-master [proxy_test]> create table foo(col1 int);
Query OK, 0 rows affected (0.04 sec)

root@localhost-master [proxy_test]> create table bar
    -> engine=connect table_type=proxy tabname=foo dbname=proxy_test;
Query OK, 0 rows affected (0.01 sec)

root@localhost-master [proxy_test]> show table status from proxy_test\G
*************************** 1. row ***************************
           Name: bar
         Engine: CONNECT
        Version: 10
     Row_format: Fixed
           Rows: 10
 Avg_row_length: 0
    Data_length: 0
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: NULL
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: `TABLE_TYPE`='proxy' `TABNAME`='foo' `DBNAME`='proxy_test'
        Comment:
*************************** 2. row ***************************
           Name: foo
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2015-02-25 15:34:39
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:
2 rows in set (0.00 sec)

root@localhost-master [proxy_test]> drop table foo;
Query OK, 0 rows affected (0.04 sec)

root@localhost-master [proxy_test]> show table status from proxy_test\G
ERROR 1146 (42S02): Table 'proxy_test.foo' doesn't exist
root@localhost-master [proxy_test]> create table spam(meat_type char(20));
Query OK, 0 rows affected (0.03 sec)

root@localhost-master [proxy_test]> create table eggs(egg_type varchar(100));
Query OK, 0 rows affected (0.03 sec)

root@localhost-master [proxy_test]> show table status from proxy_test\G
ERROR 1146 (42S02): Table 'proxy_test.foo' doesn't exist
root@localhost-master [proxy_test]> drop table bar;
Query OK, 0 rows affected (0.01 sec)

root@localhost-master [proxy_test]> show table status from proxy_test\G
*************************** 1. row ***************************
           Name: eggs
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2015-02-25 15:44:36
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:
*************************** 2. row ***************************
           Name: spam
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2015-02-25 15:44:17
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:
2 rows in set (0.00 sec)

root@localhost-master [proxy_test]>