From 45c8b748a28ff7ec85c5ad4afe5970bb470e66e3 Mon Sep 17 00:00:00 2001 From: Joas Schilling Date: Mon, 21 Mar 2022 11:19:36 +0100 Subject: Set MySQL ONLY_FULL_GROUP_BY config Signed-off-by: Joas Schilling --- .drone.yml | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to '.drone.yml') diff --git a/.drone.yml b/.drone.yml index e7e0fb8f5..47fad6ef9 100644 --- a/.drone.yml +++ b/.drone.yml @@ -271,6 +271,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -314,6 +315,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -357,6 +359,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -400,6 +403,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -444,6 +448,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -488,6 +493,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -531,6 +537,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -574,6 +581,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud @@ -617,6 +625,7 @@ services: - --innodb_large_prefix=true - --innodb_file_format=barracuda - --innodb_file_per_table=true + - --sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION environment: MYSQL_DATABASE: oc_autotest MYSQL_PASSWORD: owncloud -- cgit v1.2.3