This is an automated email from the ASF dual-hosted git repository.
rohit pushed a commit to branch 4.15
in repository https://gitbox.apache.org/repos/asf/cloudstack-documentation.git
The following commit(s) were added to refs/heads/4.15 by this push:
new ba570a1 MySQL sql_mode change (#239)
ba570a1 is described below
commit ba570a12cbfb9abea68d1b1ccc575ddc08346d72
Author: Harikrishna <[email protected]>
AuthorDate: Fri Sep 3 16:27:01 2021 +0530
MySQL sql_mode change (#239)
* MySQL sql_mode change
* Fixed formatting
---
source/upgrading/upgrade/upgrade_notes.rst | 20 ++++++++++++++++++++
1 file changed, 20 insertions(+)
diff --git a/source/upgrading/upgrade/upgrade_notes.rst
b/source/upgrading/upgrade/upgrade_notes.rst
index 55a6288..7b2b7d1 100644
--- a/source/upgrading/upgrade/upgrade_notes.rst
+++ b/source/upgrading/upgrade/upgrade_notes.rst
@@ -101,3 +101,23 @@ added in CloudStack's db.properties file:
db.cloud.driver=jdbc:mysql
db.usage.driver=jdbc:mysql
+
+
+MySQL 8.0 sql mode change
+-------------------------
+
+MySQL mode (sql_mode) has changed in CloudStack db.properties to
+"STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
+ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION".
+
+This gets automatically applies to the MySQL session used by CloudStack
management server.
+
+If the admin uses MySQL directly and wants to query tables it is advised to
change the sql_mode in the corresponding session or globally.
+
+Eg. mysql> set global
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
+ ">
ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION";
+ Query OK, 0 rows affected (0.00 sec)
+
+ mysql> set sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
+ "> ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION";
+ Query OK, 0 rows affected (0.00 sec)
\ No newline at end of file
