且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

插入,更新和删除后的版本查询输出

更新时间:2023-12-04 16:17:31

这是一个棘手的问题,但是答案的确是C,因为从未提交过"ONE"的原始值,所以两个记录都被添加到了相同的事务,结果只有一个版本"包含两行,两行都带有"TWO"的描述.

This is a bit of a trick question, but the answer is indeed C, because the original value of "ONE" was never committed, both records were added in the same transaction and as a result there is only one "version" containing two rows, both with a description of "TWO".