summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorramil@mysql.com <>2006-06-27 13:02:02 +0500
committerramil@mysql.com <>2006-06-27 13:02:02 +0500
commit283d51b6bac2f17cbd2c410ecba1753409644dc5 (patch)
tree5d0a7146a2c619f6b290abc558d7483a01663612 /mysql-test/t
parent0ce586f81646daf6f1ddc78f9b266291b4483a5a (diff)
downloadmariadb-git-283d51b6bac2f17cbd2c410ecba1753409644dc5.tar.gz
Fix for bug #18014: data loss caused by altering decimal fields.
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/type_newdecimal.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/type_newdecimal.test b/mysql-test/t/type_newdecimal.test
index 74782a5bddb..22f746d0220 100644
--- a/mysql-test/t/type_newdecimal.test
+++ b/mysql-test/t/type_newdecimal.test
@@ -1095,3 +1095,14 @@ insert into t1 values(
insert into t1 values(1e100);
select * from t1;
drop table t1;
+
+#
+# Bug #18014: problem with 'alter table'
+#
+
+create table t1(a decimal(7,2));
+insert into t1 values(123.12);
+select * from t1;
+alter table t1 modify a decimal(10,2);
+select * from t1;
+drop table t1;