ROLLBACK example with mistake
Hi,
I believe you have a mistake in ROLLBACK example. If you changed name to 'Johnson" and made COMMIT then you are not able to get back to 'Winnfield' anymore, right?
Hi Małgorzata!
Thanks for reaching out.
In Minute 1:50 we display Winnfield as a reference to what ROLLBACK; would have displayed otherwise; i.e. if COMMIT; had not been executed. You are right when you say "the last name should not change to 'Winnfield' since the change from 'Winnfield' to 'Johnson' occurred BEFORE the last commit". You could also think of it as: "if there was no commit executed, ROLLBACK; would have led to "Winnfield" - the last non-committed state.
Hope this helps.
Best,
Tsvetelin
In the slide, the first line is written Transaction Control Language but in parentheses is written DCL , it should be written TCL.