diff options
| author | unknown <igor@rurik.mysql.com> | 2005-03-09 16:53:20 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-03-09 16:53:20 -0800 |
| commit | 83fa3560bc13734b2d92c84064d836fd2e05bc8d (patch) | |
| tree | 323b4ef95a894e973d0d6fe11eba38be1a6e725e /mysql-test/t/func_str.test | |
| parent | ab32d7b000d08f50dc482a0b40eba48dd45f46e9 (diff) | |
| parent | e1d3524d814022c3df689917ead8d8eda17db834 (diff) | |
| download | mariadb-git-83fa3560bc13734b2d92c84064d836fd2e05bc8d.tar.gz | |
Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0
into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
mysql-test/r/func_str.result:
Auto merged
mysql-test/t/func_str.test:
Auto merged
netware/BUILD/mwenv:
Auto merged
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 a69febef340..2fa6b603155 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -485,3 +485,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; + |