diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2003-10-21 15:14:06 +0500 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2003-10-21 15:14:06 +0500 |
| commit | 42de9a3ed95af04abfb0a77b79bddd6f2327d6b9 (patch) | |
| tree | 8ef0c5224c2298c3260a5f59bcc83154a6f45f91 /mysql-test/t/func_crypt.test | |
| parent | 14affe7e2fa5287aa205353e80615d089861a104 (diff) | |
| download | mariadb-git-42de9a3ed95af04abfb0a77b79bddd6f2327d6b9.tar.gz | |
Fix for bug #1271: Undefined variable in PASSWORD() function is not
handled correctly
Diffstat (limited to 'mysql-test/t/func_crypt.test')
| -rw-r--r-- | mysql-test/t/func_crypt.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_crypt.test b/mysql-test/t/func_crypt.test index f403d96e885..e612405c5e9 100644 --- a/mysql-test/t/func_crypt.test +++ b/mysql-test/t/func_crypt.test @@ -4,3 +4,12 @@ select length(encrypt('foo', 'ff')) <> 0; --replace_result $1$aa$4OSUA5cjdx0RUQ08opV27/ aaqPiZY5xR5l. select old_password('test'), password('test'); select length(encrypt('test')), encrypt('test','aa'); + +drop table if exists t1; +create table t1 (name varchar(50), pw varchar(16)); +insert into t1 values ('tom', password('my_pass')); +set @pass='my_pass'; +select name from t1 where name='tom' and pw=password(@pass); +select name from t1 where name='tom' and pw=password(@undefined); +drop table t1; + |