diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-02-17 11:09:33 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-02-17 11:09:33 +0100 |
| commit | 84c96a263efc2eacfe3003ed6c997056682adf8a (patch) | |
| tree | af0801c8bb8de8d279cf495385459db511081dcc /mysql-test/suite | |
| parent | 4881c650070f960173f8fa2e5f905600e291bb44 (diff) | |
| download | mariadb-git-84c96a263efc2eacfe3003ed6c997056682adf8a.tar.gz | |
different fix for internal Oracle MySQL bug#16324629 that doesn't crash
(simply, copied from FederatedX)
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/federated/federated_maybe_16324629.result | 16 | ||||
| -rw-r--r-- | mysql-test/suite/federated/federated_maybe_16324629.test | 23 |
2 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated_maybe_16324629.result b/mysql-test/suite/federated/federated_maybe_16324629.result new file mode 100644 index 00000000000..b1dd8097cac --- /dev/null +++ b/mysql-test/suite/federated/federated_maybe_16324629.result @@ -0,0 +1,16 @@ +CREATE DATABASE federated; +CREATE DATABASE federated; +create table federated.t1 (a int, b int, unique key (a), key (b)); +create table t1 (a int, b int, unique key (a), key (b)) +engine=federated CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; +insert into t1 values (3, 3), (7, 7); +delete t1 from t1 where a = 3; +select * from t1; +a b +3 3 +7 7 +drop table t1; +DROP TABLE IF EXISTS federated.t1; +DROP DATABASE IF EXISTS federated; +DROP TABLE IF EXISTS federated.t1; +DROP DATABASE IF EXISTS federated; diff --git a/mysql-test/suite/federated/federated_maybe_16324629.test b/mysql-test/suite/federated/federated_maybe_16324629.test new file mode 100644 index 00000000000..53d79e70c80 --- /dev/null +++ b/mysql-test/suite/federated/federated_maybe_16324629.test @@ -0,0 +1,23 @@ +# +# Inspired by a bug fix for internal Oracle MySQL bug#16324629 +# +source include/federated.inc; + +connection slave; +create table federated.t1 (a int, b int, unique key (a), key (b)); + +connection master; + +--replace_result $SLAVE_MYPORT SLAVE_PORT +eval create table t1 (a int, b int, unique key (a), key (b)) + engine=federated CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1'; + +insert into t1 values (3, 3), (7, 7); +delete t1 from t1 where a = 3; +select * from t1; +drop table t1; + +connection slave; +connection default; +source include/federated_cleanup.inc; + |