1--source include/have_rocksdb.inc 2 3# 4# Check whether CONNECTION option is supported 5# is supported in CREATE and ALTER TABLE 6# 7# Note: the test does not check whether the option 8# has any real effect on the table, only 9# that it's accepted 10# 11 12--disable_warnings 13DROP TABLE IF EXISTS t1; 14--enable_warnings 15 16CREATE DATABASE test_remote; 17CREATE SERVER test_connection FOREIGN DATA WRAPPER mysql 18OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test_remote'); 19CREATE SERVER test_connection2 FOREIGN DATA WRAPPER mysql 20OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test_remote'); 21 22CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=rocksdb CONNECTION='test_connection'; 23SHOW CREATE TABLE t1; 24ALTER TABLE t1 CONNECTION='test_connection2'; 25SHOW CREATE TABLE t1; 26 27DROP TABLE t1; 28 29DROP SERVER test_connection; 30DROP SERVER test_connection2; 31DROP DATABASE test_remote; 32 33