summaryrefslogtreecommitdiff
path: root/mysql-test/t/cast.test
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2005-11-21 19:59:58 +0400
committerunknown <bar@mysql.com>2005-11-21 19:59:58 +0400
commitd2a07f9e3a97adc6efc54c07746947ea0a782fdf (patch)
treeda56b5a9608dfa26e9dabf1777a3e56c422603b2 /mysql-test/t/cast.test
parentb50d01f4f5f6b19aa9a87cfbbb84bdddee62fa90 (diff)
downloadmariadb-git-d2a07f9e3a97adc6efc54c07746947ea0a782fdf.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. mysql-test/t/cast.test: Additional fix for Bug#14255 CAST(x AS BINARY(N)) does not pad Avoid 0x00 byte in test results, use HEX instead. mysql-test/r/cast.result: Additional fix for Bug#14255 CAST(x AS BINARY(N)) does not pad
Diffstat (limited to 'mysql-test/t/cast.test')
-rw-r--r--mysql-test/t/cast.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/cast.test b/mysql-test/t/cast.test
index 70eb87131df..dc7f695e38e 100644
--- a/mysql-test/t/cast.test
+++ b/mysql-test/t/cast.test
@@ -64,7 +64,7 @@ select
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;
select cast(1000 as CHAR(3));
create table t1 select
@@ -73,7 +73,7 @@ create table t1 select
cast(_latin1'abc' AS char(2)) as c3,
cast(_latin1'a ' AS char(2)) as c4,
cast(_latin1'a' AS char(2)) as c5;
-select * from t1;
+select c1,c2,c3,c4,hex(c5) from t1;
show create table t1;
drop table t1;