diff options
| author | unknown <igor@rurik.mysql.com> | 2005-03-09 10:58:52 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-03-09 10:58:52 -0800 |
| commit | 85be2e57ab807e98c8620b0204d864602920bc89 (patch) | |
| tree | 9003f0838a291edb951f927a9de4ed0c93e8a96b /mysql-test/t/func_str.test | |
| parent | 914afabd39ebc9884ce0e6f65c36253067b3fe15 (diff) | |
| parent | 44d66d26dc6dbf1e7c90dc3c4cffe7b5d4baba41 (diff) | |
| download | mariadb-git-85be2e57ab807e98c8620b0204d864602920bc89.tar.gz | |
Manual merge
sql/item_strfunc.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index b1f144cbca2..4e504797a48 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -482,3 +482,19 @@ DROP TABLE t1; # SELECT CHAR(NULL,121,83,81,'76') as my_column; SELECT CHAR_LENGTH(CHAR(NULL,121,83,81,'76')) as my_column; +# +# Test case for bug #8669: null aes_decrypt result in order by query +# + +CREATE TABLE t1 (id int PRIMARY KEY, str char(255) NOT NULL); +CREATE TABLE t2 (id int NOT NULL UNIQUE); +INSERT INTO t2 VALUES (1),(2); +INSERT INTO t1 VALUES (1, aes_encrypt('foo', 'bar')); +INSERT INTO t1 VALUES (2, 'not valid'); + +SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id; +SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id + ORDER BY t1.id; + +DROP TABLE t1, t2; + |