diff options
author | unknown <joerg@mysql.com> | 2004-11-02 15:09:57 +0100 |
---|---|---|
committer | unknown <joerg@mysql.com> | 2004-11-02 15:09:57 +0100 |
commit | 6b53505f60b17edfc50b7cd34981fed6a647e462 (patch) | |
tree | 530efb5fcc4b6c0c5d4c5f2bc09dbf65d0115f86 /mysql-test/t/ps_10nestset.test | |
parent | 6a0ce3adbc776d5a62ffab636cc2a32c93c33e7e (diff) | |
download | mariadb-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.test | 13 |
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; |