因为 MySQL 跳过了行记录的更新，则行记录的 DB_TRX_ID 不会更新为当前事务 A 的事务ID。 Update 更新后，通过Select 读取更新记录，根据快照读流程，这条记录的最新版本的数据对当前事务A 是不可见的，那只能通过记录的历史版本链，读取出创建ReadView开始前的数据返回。

Step 2: Update your MySQL username & password in the Java code Step 3: After that run "createTable" Java file. Step 4: Add the MySQL JDBC driver (mysql-connector-j.jar) to your project classpath.

edited More related issues and PR's: Unnecessary re-creating column index (H5, MySQL) #162 Indexes are recreated using H2 database #173 unnecessery recreation of unique constraints #191 Diff on ...