1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/suite/xpand/update.result b/mysql-test/suite/xpand/update.result
new file mode 100644
index 00000000000..9b39f318ca1
--- /dev/null
+++ b/mysql-test/suite/xpand/update.result
@@ -0,0 +1,26 @@
+CREATE DATABASE IF NOT EXISTS `db1`;
+USE `db1`;
+DROP TABLE IF EXISTS `t1`;
+Warnings:
+Note	1051	Unknown table 'db1.t1'
+CREATE TABLE `t1`(i BIGINT, t TEXT)ENGINE=xpand;
+INSERT INTO `t1` (i, t) VALUES (42, 'один');
+INSERT INTO `t1` (i, t) VALUES (42, 'ноль');
+SELECT * FROM `t1` ORDER BY `i` DESC, `t` DESC;
+i	t
+42	один
+42	ноль
+UPDATE `t1` SET i=i+1,t='два' WHERE t='один';
+SELECT * FROM `t1` ORDER BY `i` DESC, `t` DESC;
+i	t
+42	один
+42	ноль
+USE test;
+UPDATE `db1`.`t1` SET i=i+1,t='три' WHERE t='два';
+SELECT * FROM `db1`.`t1` ORDER BY `i` DESC, `t` DESC;
+i	t
+42	один
+42	ноль
+DROP TABLE `db1`.`t1`;
+USE test;
+DROP DATABASE `db1`;