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/r/ps_10nestset.result | |
| 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/r/ps_10nestset.result')
| -rw-r--r-- | mysql-test/r/ps_10nestset.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/ps_10nestset.result b/mysql-test/r/ps_10nestset.result index 68f58a03674..ff63485a5f9 100644 --- a/mysql-test/r/ps_10nestset.result +++ b/mysql-test/r/ps_10nestset.result @@ -62,4 +62,15 @@ id emp salary l r 4 Donna 1064.80 5 6 5 Eddie 931.70 7 8 6 Fred 798.60 9 10 +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; +id emp salary l r +1 Jerry 1350.00 1 12 +2 Bert 1200.00 2 3 +3 Chuck 1250.00 4 11 +4 Donna 1100.00 5 6 +5 Eddie 950.00 7 8 +6 Fred 800.00 9 10 drop table t1; |