mysql> select @@global.pxc_strict_mode;
+--------------------------+
| @@global.pxc_strict_mode |
+--------------------------+
| ENFORCING |
+--------------------------+
1 row in set (0.00 sec)
mysql> create temporary table t2 as select * from t1;
ERROR 1105 (HY000): Percona-XtraDB-Cluster prohibits use of CREATE TABLE AS SELECT with pxc_strict_mode = ENFORCING or MASTER
Error log:
2017-03-02T23:53:12.270010Z 14 [ERROR] WSREP: Percona-XtraDB-Cluster prohibits use of CREATE TABLE AS SELECT with pxc_strict_mode = ENFORCING or MASTER
mysql> select @@global. pxc_strict_ mode; ------- ------- ------+ pxc_strict_ mode | ------- ------- ------+ ------- ------- ------+
+------
| @@global.
+------
| ENFORCING |
+------
1 row in set (0.00 sec)
mysql> create temporary table t2 as select * from t1; XtraDB- Cluster prohibits use of CREATE TABLE AS SELECT with pxc_strict_mode = ENFORCING or MASTER
ERROR 1105 (HY000): Percona-
Error log: 02T23:53: 12.270010Z 14 [ERROR] WSREP: Percona- XtraDB- Cluster prohibits use of CREATE TABLE AS SELECT with pxc_strict_mode = ENFORCING or MASTER
2017-03-