From a5bd5e9af2c3e16f560a37280b9a3cc3a4fe2f74 Mon Sep 17 00:00:00 2001
From: "gluh@eagle.intranet.mysql.r18.ru" <>
Date: Tue, 6 Sep 2005 16:19:59 +0500
Subject: Bug #6172 RAND(a) should only accept constant values as arguments(2nd
 version)   Argument of RAND function can be constant value only

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

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

diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test
index ebbc594952c..c75454a96d4 100644
--- a/mysql-test/t/func_math.test
+++ b/mysql-test/t/func_math.test
@@ -77,4 +77,13 @@ drop table t1;
 #
 select abs(-2) * -2;
 
+#
+# Bug #6172 RAND(a) should only accept constant values as arguments
+#
+create table t1 (i int);
+insert into t1 values (1);
+--error 1210
+select rand(i) from t1;
+drop table t1;
+
 # End of 4.1 tests
-- 
cgit v1.2.1