summaryrefslogtreecommitdiff
path: root/tests-8.3/update.sql
blob: 470cf98345e6fd9094821efa1738e5f27a3d8943 (plain)
1
2
3
4
5
6
7
8
\set nbranches :scale
\set ntellers 10 * :scale
\set naccounts 100000 * :scale
\setrandom aid 1 :naccounts
\setrandom bid 1 :nbranches
\setrandom tid 1 :ntellers
\setrandom delta -5000 5000
UPDATE accounts SET abalance = abalance + :delta WHERE aid = :aid;