summaryrefslogtreecommitdiff
path: root/mysql-test/r/strict.result
diff options
context:
space:
mode:
authorunknown <ram@gw.mysql.r18.ru>2005-01-19 12:04:35 +0400
committerunknown <ram@gw.mysql.r18.ru>2005-01-19 12:04:35 +0400
commitaf5778538db5694f3bec965e1bc95e4d883dceee (patch)
tree738f7cc58c4e81b16b532888abd1f92ea470a8c8 /mysql-test/r/strict.result
parent7eb38d6c0af693f768d8622dce42ed11566f1c62 (diff)
downloadmariadb-git-af5778538db5694f3bec965e1bc95e4d883dceee.tar.gz
A fix (bug #6999: Traditional: Wrong SQLSTATE returned for string truncation).
sql/share/errmsg.txt: A fix (bug #6999: Traditional: Wrong SQLSTATE returned for string truncation). ER_DATA_TOO_LONG (22001) has been added.
Diffstat (limited to 'mysql-test/r/strict.result')
-rw-r--r--mysql-test/r/strict.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result
index fb228d37da3..c8f8006b992 100644
--- a/mysql-test/r/strict.result
+++ b/mysql-test/r/strict.result
@@ -814,14 +814,14 @@ DROP TABLE t1;
CREATE TABLE t1 (col1 CHAR(5), col2 VARCHAR(6));
INSERT INTO t1 VALUES ('hello', 'hello'),('he', 'he'),('hello ', 'hello ');
INSERT INTO t1 (col1) VALUES ('hellobob');
-ERROR 01000: Data truncated for column 'col1' at row 1
+ERROR 22001: Data too long for column 'col1' at row 1
INSERT INTO t1 (col2) VALUES ('hellobob');
ERROR 01000: Data truncated for column 'col2' at row 1
INSERT INTO t1 (col2) VALUES ('hello ');
Warnings:
Note 1265 Data truncated for column 'col2' at row 1
UPDATE t1 SET col1 ='hellobob' WHERE col1 ='he';
-ERROR 01000: Data truncated for column 'col1' at row 2
+ERROR 22001: Data too long for column 'col1' at row 2
UPDATE t1 SET col2 ='hellobob' WHERE col2 ='he';
ERROR 01000: Data truncated for column 'col2' at row 2
INSERT IGNORE INTO t1 VALUES ('hellobob', 'hellobob');