summaryrefslogtreecommitdiff
path: root/mysql-test/r/myisam-blob.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2015-12-29 14:17:31 +0400
committerAlexander Barkov <bar@mariadb.org>2015-12-29 14:17:31 +0400
commite1b9be5417668b184893148adea5f1f0e3a8d00f (patch)
tree73a4b1035a07612863b227721e659038c3410744 /mysql-test/r/myisam-blob.result
parente126baafbc78f15c794082f0a93740d81041d038 (diff)
downloadmariadb-git-e1b9be5417668b184893148adea5f1f0e3a8d00f.tar.gz
MDEV-9319 ALTER from a bigger to a smaller blob type truncates too much data
Diffstat (limited to 'mysql-test/r/myisam-blob.result')
-rw-r--r--mysql-test/r/myisam-blob.result4
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/myisam-blob.result b/mysql-test/r/myisam-blob.result
index 43db7c8badd..6b41a244621 100644
--- a/mysql-test/r/myisam-blob.result
+++ b/mysql-test/r/myisam-blob.result
@@ -29,9 +29,11 @@ select length(data) from t1;
length(data)
18874368
alter table t1 modify data blob;
+Warnings:
+Warning 1265 Data truncated for column 'data' at row 1
select length(data) from t1;
length(data)
-0
+65535
drop table t1;
CREATE TABLE t1 (data BLOB) ENGINE=myisam;
INSERT INTO t1 (data) VALUES (NULL);