diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-04-27 15:02:35 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-27 15:02:35 +0400 |
| commit | cfb4d9f9dcc6e6bac92785fb32779e157d52daee (patch) | |
| tree | 6a6d6e611e62b25542f3f5a9b8c2985f3db32397 /mysql-test/t/func_str.test | |
| parent | 441349aa0659f07828af7c09164e142b8d565b3a (diff) | |
| download | mariadb-git-cfb4d9f9dcc6e6bac92785fb32779e157d52daee.tar.gz | |
MDEV-12592 Illegal mix of collations with the HEX function
Fixing repertoire for HEX() from MY_REPERTOIRE_EXTENDED to MY_REPERTOIRE_ASCII.
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index bc5b112e949..b3f6b4faf49 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -1806,3 +1806,23 @@ DROP TABLE t1; --echo # --echo # End of 10.1 tests --echo # + + +--echo # +--echo # Start of 10.3 tests +--echo # + +--echo # +--echo # MDEV-12592 Illegal mix of collations with the HEX function +--echo # + +SET NAMES utf8; +CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1); +INSERT INTO t1 VALUES (0x09),('a'); +SELECT IF(a<' ',HEX(a),a) FROM t1 ORDER BY a; +DROP TABLE t1; + + +--echo # +--echo # End of 10.3 tests +--echo # |