Debian Codegraph @

mysql-test/suite/galera/t/galera_enum.test

raw
1 #
2 # Test the ENUM column type, as it is frequently an unwanted child
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 #
9 # ENUM as key
10 #
11
12 --connection node_1
13 CREATE TABLE t1 (f1 ENUM('', 'one', 'two'), KEY (f1)) ENGINE=InnoDB;
14
15 INSERT INTO t1 VALUES ('');
16 INSERT INTO t1 VALUES ('one'), ('two');
17 INSERT IGNORE INTO t1 VALUES (0), (1), (2);
18
19 --connection node_2
20 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
21 --source include/wait_condition.inc
22
23 SELECT COUNT(*) FROM t1;
24 SELECT COUNT(*) FROM t1 where f1 = '';
25 SELECT COUNT(*) FROM t1 where f1 = 'one';
26
27 DROP TABLE t1;
28
29 #
30 # ENUM as PK
31 #
32
33 --connection node_1
34 CREATE TABLE t1 (f1 ENUM('', 'one', 'two', 'three', 'four') PRIMARY KEY) ENGINE=InnoDB;
35
36 INSERT INTO t1 VALUES (''), ('one'), ('two');
37
38 --connection node_2
39 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
40 --source include/wait_condition.inc
41 SELECT COUNT(*) FROM t1;
42 SELECT COUNT(*) FROM t1 WHERE f1 = '';
43
44 # Conflict
45
46 --connection node_1
47 SET AUTOCOMMIT=OFF;
48 START TRANSACTION;
49 UPDATE t1 SET f1 = 'three' where f1 = '';
50
51 --connection node_2
52 SET AUTOCOMMIt=OFF;
53 START TRANSACTION;
54 UPDATE t1 SET f1 = 'four' where f1 = '';
55
56 --connection node_1
57 COMMIT;
58
59 --connection node_2
60 --error ER_LOCK_DEADLOCK
61 COMMIT;
62
63 --connection node_1
64
65 SELECT COUNT(*) FROM t1 WHERE f1 = 'three';
66 SELECT * FROM t1;
67
68 DROP TABLE t1;