1 files changed, 43 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/change_column_varbin_multiple.test b/storage/tokudb/mysql-test/tokudb/t/change_column_varbin_multiple.test
new file mode 100644
index 00000000000..34f5fc78c90
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb/t/change_column_varbin_multiple.test
@@ -0,0 +1,43 @@
+# test that varbinary expansion changes the length sum works
+
+--disable_warnings
+DROP TABLE IF EXISTS t;
+--enable_warnings
+
+SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON;
+
+# multiple fields all < 256
+CREATE TABLE t (a VARBINARY(100), b VARBINARY(100)) ENGINE=Tokudb;
+INSERT INTO t VALUES ('hi','there'),('you','people');
+SELECT * FROM t;
+
+# schema only
+ALTER TABLE t CHANGE COLUMN a a VARBINARY(101);
+SHOW CREATE TABLE t;
+
+# update offsets
+ALTER TABLE t CHANGE COLUMN a a VARBINARY(200);
+SHOW CREATE TABLE t;
+SELECT * FROM t;
+
+DROP TABLE t;
+
+CREATE TABLE t (i INT, a VARBINARY(100), b VARBINARY(100)) ENGINE=Tokudb;
+INSERT INTO t VALUES (1, 'hi','there'),(2, 'you','people');
+SELECT * FROM t;
+
+# schema only
+ALTER TABLE t CHANGE COLUMN a a VARBINARY(101);
+SHOW CREATE TABLE t;
+
+# update offsets
+ALTER TABLE t CHANGE COLUMN a a VARBINARY(200);
+SHOW CREATE TABLE t;
+SELECT * FROM t;
+
+DROP TABLE t;
+
+
+
+
+