rm -rf 87847
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/87847 -v
bin/mysqld --basedir=$PWD --datadir=$PWD/87847 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/87847/log.err 2>&1 &

-- 5.7.19 - affected (didn't check earlier versions - JSON type =>MySQL 5.7.8)
-- Restarted or even reconnected - checksum varies

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> create database test; use test;
Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test]> create table t_json (a json);
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> insert t_json values('{"key1": "value1", "key2": "value2"}');
Query OK, 1 row affected (0.00 sec)

root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 2787775366 |
+-------------+------------+
1 row in set (0.00 sec)

root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 2787775366 |
+-------------+------------+
1 row in set (0.00 sec)

root@localhost [test]> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 2809538996 |
+-------------+------------+
1 row in set (0.00 sec)
root@localhost [test]> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 1722814384 |
+-------------+------------+
1 row in set (0.00 sec)


## 8.0.3 - not affected, most likely fixed after internal BUG#23535703
## May be backport fix into 5.7?

[umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.3-rc-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> create database test;
Query OK, 1 row affected (0.01 sec)

root@localhost [(none)]> use test
Database changed
root@localhost [test]> create table t_json (a json);
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> insert t_json values('{"key1": "value1", "key2": "value2"}');
Query OK, 1 row affected (0.01 sec)

root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 1649790511 |
+-------------+------------+
1 row in set (0.00 sec)

root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 1649790511 |
+-------------+------------+
1 row in set (0.00 sec)

root@localhost [test]> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.3-rc-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 1649790511 |
+-------------+------------+
1 row in set (0.00 sec)

root@localhost [test]>
root@localhost [test]> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.3-rc-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 1649790511 |
+-------------+------------+
1 row in set (0.00 sec)

root@localhost [test]>

== Restarted instance, confirmed that it didn't change even then

[umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                         Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.3-rc-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> checksum table t_json;
+-------------+------------+
| Table       | Checksum   |
+-------------+------------+
| test.t_json | 1649790511 |
+-------------+------------+
1 row in set (0.01 sec)

root@localhost [test]>