【 TiDB 使用环境】生产环境
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】
MySQL执行如下操作:
MariaDB [xx]> INSERT INTO `testform` (`id`) VALUES ('b284d7f8-5f28-4e0a-97bd-9d28a8eda7a1');
Query OK, 1 row affected (0.01 sec)
MariaDB [xx]> select * from testform;
+--------------------------------------+---------------+
| id | pushingstatus |
+--------------------------------------+---------------+
| b284d7f8-5f28-4e0a-97bd-9d28a8eda7a1 | 0 |
+--------------------------------------+---------------+
1 row in set (0.00 sec)
MariaDB [xx]> UPDATE `testform` SET pushingstatus='1' WHERE id='b284d7f8-5f28-4e0a-97bd-9d28a8eda7a1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [xx]> select * from testform;
+--------------------------------------+---------------+
| id | pushingstatus |
+--------------------------------------+---------------+
| b284d7f8-5f28-4e0a-97bd-9d28a8eda7a1 | 1 |
+--------------------------------------+---------------+
1 row in set (0.00 sec)
tidb 查询:
mysql> select * from testform;
+--------------------------------------+---------------+
| id | pushingstatus |
+--------------------------------------+---------------+
| b284d7f8-5f28-4e0a-97bd-9d28a8eda7a1 | 2 |
+--------------------------------------+---------------+
1 row in set (0.01 sec)
tidb sql_mode 如下:
mysql> show global variables like 'sql_mode';
+---------------+--------------------------------------------+
| Variable_name | Value |
+---------------+--------------------------------------------+
| sql_mode | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.00 sec)
为什么MySQL中update后的值,到了tidb中就变了呢?