diff options
| author | Alexander Barkov <bar@mariadb.org> | 2018-01-30 11:35:27 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2018-01-30 11:35:27 +0400 |
| commit | c4a908cb56d3ed81879573631d1f180d4962ed4e (patch) | |
| tree | 852dacc9067df0323d0cbab752d268579506d339 /mysql-test/t/func_concat.test | |
| parent | dae4fb0acb373e653f826f0ec7bdaf2485ef0b93 (diff) | |
| download | mariadb-git-c4a908cb56d3ed81879573631d1f180d4962ed4e.tar.gz | |
MDEV-13790 UNHEX() of a somewhat complicated CONCAT() returns NULL
Diffstat (limited to 'mysql-test/t/func_concat.test')
| -rw-r--r-- | mysql-test/t/func_concat.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/func_concat.test b/mysql-test/t/func_concat.test index be573f494a2..69dd2c4063e 100644 --- a/mysql-test/t/func_concat.test +++ b/mysql-test/t/func_concat.test @@ -236,3 +236,9 @@ SELECT CONCAT(t2,'-',t2) c2 FROM (SELECT TRIM(t) t2 FROM t1) sub; DROP TABLE t1; SET optimizer_switch=@save_optimizer_switch; + +--echo # +--echo # MDEV-13790 UNHEX() of a somewhat complicated CONCAT() returns NULL +--echo # + +SELECT UNHEX(CONCAT('414C2', HEX(8 + ROUND(RAND()*7)), SUBSTR(SHA(UUID()),6,33),HEX(2+ROUND(RAND()*8)))) IS NULL AS c1; |