---- TESTING WITH DIFFERENT VERSIONS -----

[ To get the difference clearly, check the Image attached to the related Items ]

##### Concentrating on Second session here as we are interested in that. So, pasting outputs of second session only #####

5.5:
===

mysql> select @@log_bin,@@version,@@binlog_format,@@tx_isolation;
+-----------+------------+-----------------+-----------------+
| @@log_bin | @@version  | @@binlog_format | @@tx_isolation  |
+-----------+------------+-----------------+-----------------+
|         1 | 5.5.56-log | ROW             | REPEATABLE-READ |
+-----------+------------+-----------------+-----------------+
1 row in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 31E
                 trx_state: RUNNING
               trx_started: 2020-07-27 02:39:31
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 3
       trx_mysql_thread_id: 8
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 0
          trx_lock_structs: 2
     trx_lock_memory_bytes: 376
           trx_rows_locked: 2
         trx_rows_modified: 1          ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 10000
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | xyz  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

----------------------------------------------------------------

mysql> select @@log_bin,@@version,@@binlog_format,@@tx_isolation;
+-----------+------------+-----------------+-----------------+
| @@log_bin | @@version  | @@binlog_format | @@tx_isolation  |
+-----------+------------+-----------------+-----------------+
|         1 | 5.5.56-log | STATEMENT       | REPEATABLE-READ |
+-----------+------------+-----------------+-----------------+
1 row in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql>  select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 324
                 trx_state: RUNNING
               trx_started: 2020-07-27 02:42:18
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 3
       trx_mysql_thread_id: 8
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 0
          trx_lock_structs: 2
     trx_lock_memory_bytes: 376
           trx_rows_locked: 2
         trx_rows_modified: 1              ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 10000
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | xyz  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)



5.6:
===

mysql> select @@log_bin,@@version,@@binlog_format,@@tx_isolation;
+-----------+------------+-----------------+-----------------+
| @@log_bin | @@version  | @@binlog_format | @@tx_isolation  |
+-----------+------------+-----------------+-----------------+
|         1 | 5.6.47-log | ROW             | REPEATABLE-READ |
+-----------+------------+-----------------+-----------------+
1 row in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1; 
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 7074337
                 trx_state: RUNNING
               trx_started: 2020-07-27 02:31:45
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 2
       trx_mysql_thread_id: 11
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 0
          trx_lock_structs: 2
     trx_lock_memory_bytes: 360
           trx_rows_locked: 2
         trx_rows_modified: 0           ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 10000
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

--------------------------------------------------------------

mysql> select @@log_bin,@@version,@@binlog_format,@@tx_isolation;
+-----------+------------+-----------------+-----------------+
| @@log_bin | @@version  | @@binlog_format | @@tx_isolation  |
+-----------+------------+-----------------+-----------------+
|         1 | 5.6.47-log | STATEMENT       | REPEATABLE-READ |
+-----------+------------+-----------------+-----------------+
1 row in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1; 
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 7074342
                 trx_state: RUNNING
               trx_started: 2020-07-27 02:36:04
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 3
       trx_mysql_thread_id: 11
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 0
          trx_lock_structs: 2
     trx_lock_memory_bytes: 360
           trx_rows_locked: 2
         trx_rows_modified: 1              ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 10000
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | xyz  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.01 sec)



5.7:
===

mysql> select @@log_bin,@@version,@@binlog_format,@@tx_isolation;
+-----------+------------+-----------------+-----------------+
| @@log_bin | @@version  | @@binlog_format | @@tx_isolation  |
+-----------+------------+-----------------+-----------------+
|         1 | 5.7.23-log | ROW             | REPEATABLE-READ |
+-----------+------------+-----------------+-----------------+
1 row in set, 1 warning (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1; 
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 26648
                 trx_state: RUNNING
               trx_started: 2020-07-27 02:53:11
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 2
       trx_mysql_thread_id: 9
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 1
          trx_lock_structs: 2
     trx_lock_memory_bytes: 1136
           trx_rows_locked: 2
         trx_rows_modified: 0                 ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 0
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.01 sec)

----------------------------------------------------------------------

mysql> select @@log_bin,@@version,@@binlog_format,@@tx_isolation;
+-----------+------------+-----------------+-----------------+
| @@log_bin | @@version  | @@binlog_format | @@tx_isolation  |
+-----------+------------+-----------------+-----------------+
|         1 | 5.7.23-log | STATEMENT       | REPEATABLE-READ |
+-----------+------------+-----------------+-----------------+
1 row in set, 1 warning (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 26653
                 trx_state: RUNNING
               trx_started: 2020-07-27 02:58:06
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 3
       trx_mysql_thread_id: 9
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 1
          trx_lock_structs: 2
     trx_lock_memory_bytes: 1136
           trx_rows_locked: 2
         trx_rows_modified: 1              ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 0
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | xyz  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.01 sec)


8.0:
===

mysql> select @@log_bin,@@version,@@binlog_format,@@transaction_isolation;
+-----------+-----------+-----------------+-------------------------+
| @@log_bin | @@version | @@binlog_format | @@transaction_isolation |
+-----------+-----------+-----------------+-------------------------+
|         1 | 8.0.21    | ROW             | REPEATABLE-READ         |
+-----------+-----------+-----------------+-------------------------+
1 row in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql>  select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 1559
                 trx_state: RUNNING
               trx_started: 2020-07-27 03:08:13
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 2
       trx_mysql_thread_id: 9
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 1
          trx_lock_structs: 2
     trx_lock_memory_bytes: 1136
           trx_rows_locked: 2
         trx_rows_modified: 0              ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 0
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
       trx_schedule_weight: NULL
1 row in set (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

------------------------------------------------------------------

mysql> select @@log_bin,@@version,@@binlog_format,@@transaction_isolation;
+-----------+-----------+-----------------+-------------------------+
| @@log_bin | @@version | @@binlog_format | @@transaction_isolation |
+-----------+-----------+-----------------+-------------------------+
|         1 | 8.0.21    | STATEMENT       | REPEATABLE-READ         |
+-----------+-----------+-----------------+-------------------------+
1 row in set (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | abc  |
+------+------+
1 row in set (0.00 sec)

mysql> UPDATE t1 SET name='xyz' WHERE id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()\G
*************************** 1. row ***************************
                    trx_id: 1564
                 trx_state: RUNNING
               trx_started: 2020-07-27 03:11:00
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 3
       trx_mysql_thread_id: 9
                 trx_query: select * from information_schema.innodb_trx where trx_mysql_thread_id=connection_id()
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 1
          trx_lock_structs: 2
     trx_lock_memory_bytes: 1136
           trx_rows_locked: 2
         trx_rows_modified: 1              ********************************
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 0
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
       trx_schedule_weight: NULL
1 row in set (0.00 sec)

mysql>  select * from t1;
+------+------+
| id   | name |
+------+------+
|    1 | xyz  |
+------+------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)