From d2a07f9e3a97adc6efc54c07746947ea0a782fdf Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 21 Nov 2005 19:59:58 +0400 Subject: 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 --- mysql-test/t/cast.test | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/cast.test') 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; -- cgit v1.2.1