summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps_10nestset.test
diff options
context:
space:
mode:
authorunknown <joerg@mysql.com>2004-11-02 15:09:57 +0100
committerunknown <joerg@mysql.com>2004-11-02 15:09:57 +0100
commit6b53505f60b17edfc50b7cd34981fed6a647e462 (patch)
tree530efb5fcc4b6c0c5d4c5f2bc09dbf65d0115f86 /mysql-test/t/ps_10nestset.test
parent6a0ce3adbc776d5a62ffab636cc2a32c93c33e7e (diff)
downloadmariadb-git-6b53505f60b17edfc50b7cd34981fed6a647e462.tar.gz
Test expansion: "MOD" on non-integral first operand.
mysql-test/r/ps_10nestset.result: Result of expanded test: "MOD" on non-integral first operand. mysql-test/t/ps_10nestset.test: Use the newly expanded "MOD" operator (non-integral first operand, bug#6138).
Diffstat (limited to 'mysql-test/t/ps_10nestset.test')
-rw-r--r--mysql-test/t/ps_10nestset.test13
1 files changed, 6 insertions, 7 deletions
diff --git a/mysql-test/t/ps_10nestset.test b/mysql-test/t/ps_10nestset.test
index d2adaca689e..53e84f7a47d 100644
--- a/mysql-test/t/ps_10nestset.test
+++ b/mysql-test/t/ps_10nestset.test
@@ -61,12 +61,11 @@ while ($1)
select * from t1;
-# Waiting for the resolution of bug#6138
-# # Now, increase salary to a multiple of 50
-# prepare st_round from 'update t1 set salary = salary + ? - ( salary MOD ? )';
-# set @arg_round= 50;
-# execute st_round using @arg_round, @arg_round;
-#
-# select * from t1;
+# Now, increase salary to a multiple of 50 (checks for bug#6138)
+prepare st_round from 'update t1 set salary = salary + ? - ( salary MOD ? )';
+set @arg_round= 50;
+execute st_round using @arg_round, @arg_round;
+
+select * from t1;
drop table t1;