summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_math.test
diff options
context:
space:
mode:
authorunknown <gluh@eagle.intranet.mysql.r18.ru>2005-09-06 16:19:59 +0500
committerunknown <gluh@eagle.intranet.mysql.r18.ru>2005-09-06 16:19:59 +0500
commit61a5fac1cc0e2cddcc98db8396f06b719cfcad1a (patch)
tree53b496b95a7630be277e1e5bc00721b8d922f773 /mysql-test/t/func_math.test
parentf53de1f247373f56f30238c18893d6e01bad4d95 (diff)
downloadmariadb-git-61a5fac1cc0e2cddcc98db8396f06b719cfcad1a.tar.gz
Bug #6172 RAND(a) should only accept constant values as arguments(2nd version)
Argument of RAND function can be constant value only
Diffstat (limited to 'mysql-test/t/func_math.test')
-rw-r--r--mysql-test/t/func_math.test9
1 files changed, 9 insertions, 0 deletions
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