summaryrefslogtreecommitdiff
path: root/mysql-test/suite/binlog/r
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-03-29 10:58:20 +0100
committerSergei Golubchik <serg@mariadb.org>2019-03-29 10:58:20 +0100
commitf2a0c758da3d9f0fa42c96114b453cf4835bcbab (patch)
treed51cdc29774cfc04f522e2253542d73c94a9728b /mysql-test/suite/binlog/r
parentfc168c3a5e58d8b364a2e87e0d876a261ec7fced (diff)
parentd0116e10a5da52503a89a413e481996ce3f65e63 (diff)
downloadmariadb-git-f2a0c758da3d9f0fa42c96114b453cf4835bcbab.tar.gz
Merge branch '10.1' into 10.2
Diffstat (limited to 'mysql-test/suite/binlog/r')
-rw-r--r--mysql-test/suite/binlog/r/binlog_innodb_stm.result17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_innodb_stm.result b/mysql-test/suite/binlog/r/binlog_innodb_stm.result
new file mode 100644
index 00000000000..829ed7d3c61
--- /dev/null
+++ b/mysql-test/suite/binlog/r/binlog_innodb_stm.result
@@ -0,0 +1,17 @@
+create table categories(
+cat_id int not null primary key,
+cat_name varchar(255) not null,
+cat_description text
+) engine=innodb;
+create table products(
+prd_id int not null auto_increment primary key,
+prd_name varchar(355) not null,
+prd_price decimal,
+cat_id int not null,
+foreign key fk_cat(cat_id)
+references categories(cat_id)
+on update cascade
+) engine=innodb;
+insert into categories values (1, 'drinks', 'drinks');
+update categories set cat_description=2 where cat_id=1;
+drop table products, categories;