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 | 76aef47e6db3efd1a3115916a617b211b322524f (patch) | |
| tree | 8ef0c5224c2298c3260a5f59bcc83154a6f45f91 /mysql-test/r/func_crypt.result | |
| parent | 77f45ffe7799848d27a10887ccdfcb2ba509bb59 (diff) | |
| download | mariadb-git-76aef47e6db3efd1a3115916a617b211b322524f.tar.gz | |
Fix for bug #1271: Undefined variable in PASSWORD() function is not
handled correctly
Diffstat (limited to 'mysql-test/r/func_crypt.result')
| -rw-r--r-- | mysql-test/r/func_crypt.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/func_crypt.result b/mysql-test/r/func_crypt.result index 742de833bf7..96bbaa6cae7 100644 --- a/mysql-test/r/func_crypt.result +++ b/mysql-test/r/func_crypt.result @@ -7,3 +7,13 @@ old_password('test') password('test') select length(encrypt('test')), encrypt('test','aa'); length(encrypt('test')) encrypt('test','aa') 13 aaqPiZY5xR5l. +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); +name +tom +select name from t1 where name='tom' and pw=password(@undefined); +name +drop table t1; |