diff options
| author | Alexander Barkov <bar@mysql.com> | 2010-07-07 10:38:11 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mysql.com> | 2010-07-07 10:38:11 +0400 |
| commit | 00e86d01a72c539b915e07f4b7b8fe218433fd60 (patch) | |
| tree | e872e3c1b1d8935b62347e5c4fd395d237b68567 /mysql-test/t/func_digest.test | |
| parent | 72bb9b7acbacc20172512184dc2724fccbc7a741 (diff) | |
| download | mariadb-git-00e86d01a72c539b915e07f4b7b8fe218433fd60.tar.gz | |
Bug#54661 sha2() returns BINARY result
Problem: sha2() reported its result as BINARY
Fix:
- Inheriting Item_func_sha2 from Item_str_ascii_func
- Setting max_length via fix_length_and_charset()
instead of direct assignment.
- Adding tests
Diffstat (limited to 'mysql-test/t/func_digest.test')
| -rw-r--r-- | mysql-test/t/func_digest.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/func_digest.test b/mysql-test/t/func_digest.test index 4020ef0f4fc..81f19c7e091 100644 --- a/mysql-test/t/func_digest.test +++ b/mysql-test/t/func_digest.test @@ -481,3 +481,16 @@ SELECT LENGTH(SHA2( '', 224 )) / 2 * 8 = 224; SELECT LENGTH(SHA2( 'any', 256 )) / 2 * 8 = 256; SELECT LENGTH(SHA2( 'size', 384 )) / 2 * 8 = 384; SELECT LENGTH(SHA2( 'computed', 512 )) / 2 * 8 = 512; + +--echo # +--echo # Bug#54661 sha2() returns BINARY result +--echo # +--enable_metadata +SET NAMES binary; +SELECT sha2('1',224); +SET NAMES utf8; +SELECT sha2('1',224); +SET NAMES latin1; +SELECT sha2('1',224); +--disable_metadata + |