Debian Codegraph @

mysql-test/suite/galera/r/lp959512.result

raw
1 connection node_2;
2 connection node_1;
3 DROP TABLE IF EXISTS variable;
4 Warnings:
5 Note 1051 Unknown table 'test.variable'
6 DROP TABLE IF EXISTS foo;
7 Warnings:
8 Note 1051 Unknown table 'test.foo'
9 CREATE TABLE variable (
10 name varchar(128) NOT NULL DEFAULT '' COMMENT 'The name of the variable.',
11 value longblob NOT NULL COMMENT 'The value of the variable.',
12 PRIMARY KEY (name)
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Named variable/value pairs created by Drupal core or any...';
14 CREATE TABLE foo (a int);
15 INSERT INTO variable (name, value) VALUES ('menu_expanded', 'a:0:{}');
16 START TRANSACTION;
17 SELECT 1 AS expression FROM variable variable
18 WHERE ( (name = 'menu_expanded') ) FOR UPDATE;
19 expression
20 1
21 UPDATE variable SET value='a:0:{}' WHERE ( (name = 'menu_expanded') );
22 COMMIT;
23 INSERT INTO foo VALUES (1);
24 UPDATE foo SET a = 2 WHERE a = 1;
25 DROP TABLE foo;
26 DROP TABLE variable;