Comment 3 for bug 1281124

Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

Don't this see anymore with latest PXC-5.6

mysql>
mysql> create table a (a int) engine=innodb;
Query OK, 0 rows affected (0.05 sec)

mysql> set wsrep_on=0;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values (2);
Query OK, 1 row affected (0.00 sec)

mysql> set wsrep_on=1;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from a;
+------+
| a |
+------+
| 2 |
+------+
1 row in set (0.00 sec)

mysql> delete from a;
Query OK, 1 row affected (0.01 sec)

mysql> select * from a;
Empty set (0.00 sec)

mysql> set wsrep_on=0;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values (2);
Query OK, 1 row affected (0.01 sec)

mysql> set wsrep_on=1;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from a;
+------+
| a |
+------+
| 2 |
+------+
1 row in set (0.00 sec)

mysql> delete from a where a = 2;
Query OK, 1 row affected (0.02 sec)

mysql>