summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_partition_range.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/ndb_partition_range.test')
-rw-r--r--mysql-test/t/ndb_partition_range.test6
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/t/ndb_partition_range.test b/mysql-test/t/ndb_partition_range.test
index 66235b0e9eb..5b70b26c97b 100644
--- a/mysql-test/t/ndb_partition_range.test
+++ b/mysql-test/t/ndb_partition_range.test
@@ -140,7 +140,7 @@ CREATE TABLE test.t1 (
a3 BIT NOT NULL,
a4 DECIMAL(8,3),
a5 INT NOT NULL,
- a6 VARCHAR(255),
+ a6 INT,
PRIMARY KEY(a1))
TABLESPACE ts1 STORAGE DISK ENGINE=NDB
PARTITION BY LIST (a1)
@@ -148,6 +148,10 @@ CREATE TABLE test.t1 (
PARTITION p1 VALUES IN (6,7,8,9, 10),
PARTITION p2 VALUES IN (11, 12, 13, 14, 15));
+# Alter table directly without any statements inbetween
+ALTER TABLE test.t1 DROP COLUMN a6;
+ALTER TABLE test.t1 ADD COLUMN a6 VARCHAR(255);
+
let $j= 15;
--disable_query_log
while ($j)