diff options
| author | jimw@rama.(none) <> | 2006-07-12 13:22:38 -0700 |
|---|---|---|
| committer | jimw@rama.(none) <> | 2006-07-12 13:22:38 -0700 |
| commit | 30d7290c2127e709bd9d8753eebbb67114a0b94d (patch) | |
| tree | a62c206cafe37632e7eae07821fbe93990d86fb9 /mysql-test/r/cast.result | |
| parent | bd183d42dcf66432d2e8051e030919a4669eaf8c (diff) | |
| download | mariadb-git-30d7290c2127e709bd9d8753eebbb67114a0b94d.tar.gz | |
Bug #17903: cast to char results in binary
The character set was not being properly initialized in CAST() with
a type like "CHAR(2) BINARY", which resulted in incorrect results or
even a crash.
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index d60efa083e0..a07ca21652b 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -381,3 +381,14 @@ DROP TABLE t1; select cast(NULL as decimal(6)) as t1; t1 NULL +set names latin1; +select hex(cast('a' as char(2) binary)); +hex(cast('a' as char(2) binary)) +61 +select hex(cast('a' as binary(2))); +hex(cast('a' as binary(2))) +6100 +select hex(cast('a' as char(2) binary)); +hex(cast('a' as char(2) binary)) +61 +End of 5.0 tests |