Bug #104974 can not set group_replication_consistency=BEFORE without quotes
Submitted: 17 Sep 2021 14:13 Modified: 17 Sep 2021 14:32
Reporter: Ye Jinrong Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S3 (Non-critical)
Version:8.0.26 OS:Any
Assigned to: CPU Architecture:Any

[17 Sep 2021 14:13] Ye Jinrong 
Description:
We can not set group_replication_consistency=BEFORE without quotes, it will rise syntax error message.

How to repeat:
mysql>set global group_replication_consistency=EVENTUAL;
Query OK, 0 rows affected (0.00 sec)

mysql>set global group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER;
Query OK, 0 rows affected (0.00 sec)

mysql>set global group_replication_consistency=BEFORE;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEFORE' at line 1

mysql>set global group_replication_consistency='BEFORE';
Query OK, 0 rows affected (0.00 sec)

mysql>set global group_replication_consistency=AFTER;
Query OK, 0 rows affected (0.00 sec)

mysql>set global group_replication_consistency= BEFORE_AND_AFTER;
Query OK, 0 rows affected (0.00 sec)
[17 Sep 2021 14:16] Ye Jinrong 
Add the following option and value(with out quotes) in my.cnf to work correctly

group_replication_consistency=BEFORE
[17 Sep 2021 14:32] MySQL Verification Team 
Hello Ye Jinrong,

Thank you for the report.

regards,
Umesh