diff options
| author | gshchepa/uchum@host.loc <> | 2008-05-06 21:43:46 +0500 |
|---|---|---|
| committer | gshchepa/uchum@host.loc <> | 2008-05-06 21:43:46 +0500 |
| commit | 1c45081b5285a9ae2c5401cffd1fcfe0a312f4e7 (patch) | |
| tree | 274f7ab47cd2d388e2f9a34437a09d2eaba46f74 /mysql-test/r/strict.result | |
| parent | 5eaa779436743ce156d91cdb4ff8b41b6bcc5cda (diff) | |
| download | mariadb-git-1c45081b5285a9ae2c5401cffd1fcfe0a312f4e7.tar.gz | |
Partial rollback of fix for bug #30059: End-space truncation is inconsistent
or incorrect.
For better conformance with standard, truncation procedure of CHAR columns
has been changed to ignore truncation of trailing whitespace characters
(note has been removed).
Finally, for columns with non-binary charsets:
1. CHAR(N) columns silently ignore trailing whitespace truncation;
2. VARCHAR and TEXT columns issue Note about truncation.
BLOBs and other columns with BINARY charset are unaffected.
Diffstat (limited to 'mysql-test/r/strict.result')
| -rw-r--r-- | mysql-test/r/strict.result | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result index 0a714635f70..34869862a63 100644 --- a/mysql-test/r/strict.result +++ b/mysql-test/r/strict.result @@ -934,8 +934,6 @@ NULL NULL DROP TABLE t1; CREATE TABLE t1 (col1 CHAR(5), col2 VARCHAR(6)); INSERT INTO t1 VALUES ('hello', 'hello'),('he', 'he'),('hello ', 'hello '); -Warnings: -Note 1265 Data truncated for column 'col1' at row 3 INSERT INTO t1 (col1) VALUES ('hellobob'); ERROR 22001: Data too long for column 'col1' at row 1 INSERT INTO t1 (col2) VALUES ('hellobob'); |