From f602be8d3f860d2c59399a5fd7e601871859ad7e Mon Sep 17 00:00:00 2001
From: "gluh@gluh.mysql.r18.ru" <>
Date: Tue, 21 Oct 2003 15:14:06 +0500
Subject: Fix for bug #1271: Undefined variable in PASSWORD() function is not
 handled correctly

---
 mysql-test/t/func_crypt.test | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'mysql-test/t/func_crypt.test')

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;
+
-- 
cgit v1.2.1