| 1 |
# |
| 2 |
# LP#959512 IO cache not reset at trx cleanup if write set was empty Edit |
| 3 |
# |
| 4 |
|
| 5 |
--source include/galera_cluster.inc |
| 6 |
--source include/have_innodb.inc |
| 7 |
|
| 8 |
DROP TABLE IF EXISTS variable; |
| 9 |
DROP TABLE IF EXISTS foo; |
| 10 |
CREATE TABLE variable ( |
| 11 |
name varchar(128) NOT NULL DEFAULT '' COMMENT 'The name of the variable.', |
| 12 |
value longblob NOT NULL COMMENT 'The value of the variable.', |
| 13 |
PRIMARY KEY (name) |
| 14 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Named variable/value pairs created by Drupal core or any...'; |
| 15 |
CREATE TABLE foo (a int); |
| 16 |
INSERT INTO variable (name, value) VALUES ('menu_expanded', 'a:0:{}'); |
| 17 |
START TRANSACTION; |
| 18 |
SELECT 1 AS expression FROM variable variable |
| 19 |
WHERE ( (name = 'menu_expanded') ) FOR UPDATE; |
| 20 |
UPDATE variable SET value='a:0:{}' WHERE ( (name = 'menu_expanded') ); |
| 21 |
COMMIT; |
| 22 |
INSERT INTO foo VALUES (1); |
| 23 |
UPDATE foo SET a = 2 WHERE a = 1; |
| 24 |
|
| 25 |
DROP TABLE foo; |
| 26 |
DROP TABLE variable; |