Changes between Version 3 and Version 4 of Transakcii
- Timestamp:
- 02/12/26 00:40:45 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Transakcii
v3 v4 32 32 SELECT highest_market_value_in_eur 33 33 FROM players 34 WHERE player_id = 26;34 WHERE player_id = 65; 35 35 UPDATE players 36 36 SET highest_market_value_in_eur = 7000000 37 WHERE player_id = 26;37 WHERE player_id = 65; 38 38 39 39 COMMIT; … … 42 42 SELECT highest_market_value_in_eur 43 43 FROM players 44 WHERE player_id = 26;44 WHERE player_id = 65; 45 45 46 46 COMMIT; … … 54 54 SELECT highest_market_value_in_eur 55 55 FROM players 56 WHERE player_id = 26;56 WHERE player_id = 65; 57 57 58 58 UPDATE players 59 SET highest_market_value_in_eur = 900000060 WHERE player_id = 26;59 SET highest_market_value_in_eur = 70000000 60 WHERE player_id = 65; 61 61 62 62 COMMIT; … … 64 64 SELECT highest_market_value_in_eur 65 65 FROM players 66 WHERE player_id = 26;66 WHERE player_id = 65; 67 67 68 68 COMMIT; … … 77 77 {{{ 78 78 BEGIN; 79 SELECT * FROM players WHERE player_id = 10FOR UPDATE;80 SELECT * FROM players WHERE player_id = 20 FOR UPDATE;79 SELECT * FROM players WHERE player_id = 65 FOR UPDATE; 80 SELECT * FROM players WHERE player_id = 80 FOR UPDATE; 81 81 COMMIT; 82 82 83 83 BEGIN; 84 SELECT * FROM players WHERE player_id = 20 FOR UPDATE;85 SELECT * FROM players WHERE player_id = 10FOR UPDATE;84 SELECT * FROM players WHERE player_id = 80 FOR UPDATE; 85 SELECT * FROM players WHERE player_id = 65 FOR UPDATE; 86 86 COMMIT; 87 87 }}} … … 94 94 SELECT * FROM players 95 95 96 WHERE player_id IN ( 10, 20)96 WHERE player_id IN (65, 80) 97 97 98 98 ORDER BY player_id … … 133 133 BEGIN; 134 134 135 SELECT * FROM players WHERE player_id = 1FOR UPDATE;135 SELECT * FROM players WHERE player_id = 65 FOR UPDATE; 136 136 137 137 -- само редот со id=1 е заклучен 138 138 139 SELECT * FROM players WHERE player_id = 2;139 SELECT * FROM players WHERE player_id = 80; 140 140 141 141 -- работи нормално 142 142 143 UPDATE players SET highest_market_value_in_eur = highest_market_value_in_eur - 100 WHERE player_id = 1;143 UPDATE players SET highest_market_value_in_eur = highest_market_value_in_eur - 100 WHERE player_id = 65; 144 144 145 145 -- чека, редот е заклучен … … 156 156 UPDATE players 157 157 SET market_value_in_eur = market_value_in_eur - 5000000 158 WHERE player_id = 19054;158 WHERE player_id = 65; 159 159 160 160 -- трансакцијата е започната, но не е направен COMMIT … … 165 165 SELECT market_value_in_eur 166 166 FROM players 167 WHERE player_id = 19054;167 WHERE player_id = 65; 168 168 -- Session 2 ја гледа старата вредност 169 169 }}} … … 178 178 SELECT market_value_in_eur 179 179 FROM players 180 WHERE player_id = 19054;180 WHERE player_id = 65; 181 181 -- сега Session 2 ја гледа новата вредност 182 182 }}}
