diff options
| author | bar@mysql.com <> | 2005-11-21 19:59:58 +0400 |
|---|---|---|
| committer | bar@mysql.com <> | 2005-11-21 19:59:58 +0400 |
| commit | 435c2ba671baa3251befb6f70099313e29fbd65a (patch) | |
| tree | da56b5a9608dfa26e9dabf1777a3e56c422603b2 /mysql-test/r/cast.result | |
| parent | 174d28e4cc1e1def318bb25fe7100fcd641a787c (diff) | |
| download | mariadb-git-435c2ba671baa3251befb6f70099313e29fbd65a.tar.gz | |
Additional fix for Bug#14255 CAST(x AS BINARY(N)) does not pad
cast.result:
cast.test:
Avoid 0x00 byte in test results, use HEX instead.
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 817be3a2e7c..98beedc5b1c 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -165,9 +165,9 @@ cast(_latin1'ab' AS char) as c1, cast(_latin1'a ' AS char) as c2, cast(_latin1'abc' AS char(2)) as c3, cast(_latin1'a ' AS char(2)) as c4, -cast(_latin1'a' AS char(2)) as c5; +hex(cast(_latin1'a' AS char(2))) as c5; c1 c2 c3 c4 c5 -ab a ab a a +ab a ab a 6100 Warnings: Warning 1292 Truncated incorrect CHAR(2) value: 'abc' Warning 1292 Truncated incorrect CHAR(2) value: 'a ' @@ -185,9 +185,9 @@ cast(_latin1'a' AS char(2)) as c5; Warnings: Warning 1292 Truncated incorrect CHAR(2) value: 'abc' Warning 1292 Truncated incorrect CHAR(2) value: 'a ' -select * from t1; -c1 c2 c3 c4 c5 -ab a ab a a +select c1,c2,c3,c4,hex(c5) from t1; +c1 c2 c3 c4 hex(c5) +ab a ab a 6100 show create table t1; Table Create Table t1 CREATE TABLE `t1` ( |