diff options
author | Joas Schilling <coding@schilljs.com> | 2022-03-21 11:19:36 +0100 |
---|---|---|
committer | Joas Schilling <coding@schilljs.com> | 2022-03-22 11:55:36 +0100 |
commit | 45c8b748a28ff7ec85c5ad4afe5970bb470e66e3 (patch) | |
tree | 27698f99bfe47fdc10c23cbf7b8dfeeaa269d3b5 | |
parent | 8b9fbbdeb1c5998433dca590675ac36076fe028d (diff) |
Set MySQL ONLY_FULL_GROUP_BY config
Signed-off-by: Joas Schilling <coding@schilljs.com>
-rw-r--r-- | .drone.jsonnet | 3 | ||||
-rw-r--r-- | .drone.yml | 9 |
2 files changed, 11 insertions, 1 deletions
diff --git a/.drone.jsonnet b/.drone.jsonnet index ad6f39b32..4033c02ae 100644 --- a/.drone.jsonnet +++ b/.drone.jsonnet @@ -77,7 +77,8 @@ local PipelineMySQL(test_set) = Pipeline( command: [ "--innodb_large_prefix=true", "--innodb_file_format=barracuda", - "--innodb_file_per_table=true" + "--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" ], tmpfs: [ "/var/lib/mysql" 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 |