diff options
| author | gshchepa/uchum@host.loc <> | 2008-02-07 02:33:21 +0400 |
|---|---|---|
| committer | gshchepa/uchum@host.loc <> | 2008-02-07 02:33:21 +0400 |
| commit | 8715855aa056013f418fd9c055e6f0d8badf58a3 (patch) | |
| tree | ff291bc2f29088223b8c4d9ca51b5f4dc2d2ec2e /mysql-test/r/heap.result | |
| parent | e80794b3ee3f402def4b957364104e31b53e7c01 (diff) | |
| download | mariadb-git-8715855aa056013f418fd9c055e6f0d8badf58a3.tar.gz | |
Fixed bug#30059.
Server handles truncation for assignment of too-long values
into CHAR/VARCHAR/TEXT columns in a different ways when the
truncated characters are spaces:
1. CHAR(N) columns silently ignore end-space truncation;
2. TEXT columns post a truncation warning/error in the
non-strict/strict mode.
3. VARCHAR columns always post a truncation note in
any mode.
Space truncation processing has been synchronised over
CHAR/VARCHAR/TEXT columns: current behavior of VARCHAR
columns has been propagated as standard.
Binary-encoded string/BLOB columns are not affected.
Diffstat (limited to 'mysql-test/r/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index 906c431b834..adfcc00174f 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -256,6 +256,7 @@ set @a=repeat(' ',20); insert into t1 values (concat('+',@a),concat('+',@a),concat('+',@a)); Warnings: Note 1265 Data truncated for column 'v' at row 1 +Note 1265 Data truncated for column 'c' at row 1 select concat('*',v,'*',c,'*',t,'*') from t1; concat('*',v,'*',c,'*',t,'*') *+ *+*+ * |