Debian Codegraph @

mysql-test/suite/maria/lock.result

raw
1 drop table if exists t1,t2;
2 Warnings:
3 Note 1051 Unknown table 'test.t1,test.t2'
4 CREATE TABLE t1 (i INT) ENGINE=Aria;
5 CREATE TABLE t2 (i INT) ENGINE=Aria;
6 LOCK TABLE t1 WRITE, t2 WRITE;
7 DROP TABLE t1;
8 UNLOCK TABLES;
9 DROP TABLE t2;
10 CREATE TABLE t1 (i INT) ENGINE=Aria;
11 CREATE TABLE t2 (i INT) ENGINE=Aria;
12 LOCK TABLE t1 WRITE, t2 WRITE;
13 FLUSH TABLE t1;
14 select * from t1;
15 i
16 unlock tables;
17 drop table t1,t2;
18 CREATE TABLE t1 (i INT) ENGINE=Aria;
19 CREATE TABLE t2 (i INT) ENGINE=Aria;
20 LOCK TABLE t1 WRITE, t2 WRITE;
21 repair table t1 use_frm;
22 Table Op Msg_type Msg_text
23 test.t1 repair status OK
24 select * from t1;
25 i
26 drop table t2;
27 unlock tables;
28 drop table t1;
29 CREATE TABLE t1 (i INT) ENGINE=Aria;
30 LOCK TABLES t1 WRITE, t1 AS t1a WRITE;
31 DROP TABLE t1;
32 #
33 # MDEV-8200 aria bug with insert select when select is a aria table
34 # (wrong result or assertion failure:
35 # `table->file->stats.records > 0 || error')
36 #
37 CREATE TABLE t1 (f1 INT) ENGINE=Aria;
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `f1` int(11) DEFAULT NULL
42 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
43 INSERT INTO t1 VALUES (1);
44 CREATE TABLE t2 (f2 INT) ENGINE=MyISAM;
45 CREATE TABLE tmp (f3 INT) engine=Aria;
46 LOCK TABLE t2 WRITE, tmp WRITE, tmp AS tmp_alias WRITE, t1 WRITE;
47 INSERT INTO tmp SELECT f1 FROM t1;
48 INSERT INTO t2 SELECT f3 FROM tmp AS tmp_alias;
49 select * from t2;
50 f2
51 1
52 unlock tables;
53 DROP TABLE t1,t2,tmp;
54 #
55 # Same without transactional
56 #
57 CREATE TABLE t1 (f1 INT) transactional=0 ENGINE=Aria;
58 SHOW CREATE TABLE t1;
59 Table Create Table
60 t1 CREATE TABLE `t1` (
61 `f1` int(11) DEFAULT NULL
62 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
63 INSERT INTO t1 VALUES (2);
64 CREATE TABLE t2 (f2 INT) ENGINE=MyISAM;
65 CREATE TABLE tmp (f3 INT) transactional=0 engine=Aria;
66 LOCK TABLE t2 WRITE, tmp WRITE, tmp AS tmp_alias WRITE, t1 WRITE;
67 INSERT INTO tmp SELECT f1 FROM t1;
68 INSERT INTO t2 SELECT f3 FROM tmp AS tmp_alias;
69 select * from t2;
70 f2
71 2
72 unlock tables;
73 DROP TABLE t1,t2,tmp;
74 #
75 # Using spatical keys (disables versioning)
76 #
77 CREATE TABLE t1 (f1 INT, c1 geometry NOT NULL, SPATIAL KEY i1 (c1)) transactional=1 ENGINE=Aria;
78 SHOW CREATE TABLE t1;
79 Table Create Table
80 t1 CREATE TABLE `t1` (
81 `f1` int(11) DEFAULT NULL,
82 `c1` geometry NOT NULL,
83 SPATIAL KEY `i1` (`c1`)
84 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
85 INSERT INTO t1 VALUES (3,
86 PolygonFromText('POLYGON((-18.6086111000 -66.9327777000,
87 -18.6055555000 -66.8158332999,
88 -18.7186111000 -66.8102777000,
89 -18.7211111000 -66.9269443999,
90 -18.6086111000 -66.9327777000))'));
91 CREATE TABLE t2 (f2 INT) ENGINE=MyISAM;
92 CREATE TABLE tmp (f3 INT, c1 geometry NOT NULL, SPATIAL KEY i1 (c1)) transactional=1 ENGINE=Aria;
93 LOCK TABLE t2 WRITE, tmp WRITE, tmp AS tmp_alias WRITE, t1 WRITE;
94 INSERT INTO tmp SELECT f1,c1 FROM t1;
95 INSERT INTO t2 (f2) SELECT f3 FROM tmp AS tmp_alias;
96 select * from t2;
97 f2
98 3
99 unlock tables;
100 DROP TABLE t1,t2,tmp;
101 #
102 # MDEV-10378 Assertion `trn' failed in virtual int ha_maria::start_stmt
103 #
104 CREATE TABLE t1 (f1 VARCHAR(3), f2 INT, pk INT, PRIMARY KEY (pk)) ENGINE=Aria;
105 INSERT INTO t1 VALUES ('foo',10,1), ('foo',1,2);
106 LOCK TABLE t1 WRITE;
107 ALTER TABLE t1 ADD UNIQUE KEY (f1);
108 ERROR 23000: Duplicate entry 'foo' for key 'f1'
109 ALTER TABLE t1 ADD KEY (f2);
110 DROP TABLE t1;
111 #
112 # MDEV-10748 Server crashes in ha_maria::implicit_commit upon ALTER TABLE
113 #
114 CREATE TABLE t1 (a INT, b INT) ENGINE=Aria;
115 SELECT * FROM t1;
116 a b
117 CREATE TABLE t2 (c INT) ENGINE=Aria;
118 LOCK TABLE t2 READ, t1 WRITE;
119 ALTER TABLE t1 CHANGE b a INT;
120 ERROR 42S21: Duplicate column name 'a'
121 UNLOCK TABLES;
122 DROP TABLE t1, t2;
123 #
124 # MDEV-10748 Server crashes in ha_maria::implicit_commit upon ALTER TABLE
125 #
126 CREATE TABLE t1 (a INT) ENGINE=Aria;
127 CREATE TABLE t2 (b INT) ENGINE=Aria;
128 LOCK TABLES t1 WRITE, t2 AS t2a WRITE, t2 WRITE;
129 ALTER TABLE t2 CHANGE b c VARBINARY(30000), ALGORITHM=COPY;
130 UNLOCK TABLES;
131 DROP TABLE t1, t2;
132 # More complex test, from RQG
133 CREATE TABLE t1 (a INT) ENGINE=Aria;
134 CREATE TABLE t2 (b INT) ENGINE=Aria;
135 CREATE OR REPLACE VIEW v2 AS SELECT * FROM t2 ;
136 LOCK TABLES t1 WRITE, t2 AS t2a WRITE, v2 WRITE CONCURRENT, t2 WRITE;
137 ALTER TABLE t1 FORCE;
138 ALTER TABLE t2 CHANGE b c VARBINARY(30000), ALGORITHM=INPLACE;
139 ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
140 ALTER TABLE t2 CHANGE b c VARBINARY(30000), ALGORITHM=COPY;
141 UNLOCK TABLES;
142 DROP VIEW v2;
143 DROP TABLE t1, t2;
144 # End of 10.2 tests
145 #
146 # MDEV-14669 Assertion `file->trn == trn' failed in ha_maria::start_stmt
147 #
148 CREATE TABLE t1 (i INT) ENGINE=Aria;
149 INSERT INTO t1 VALUES (1),(2);
150 CREATE TABLE t2 (c CHAR(1)) ENGINE=Aria;
151 INSERT INTO t2 VALUES ('a'),('b');
152 connect con1,localhost,root,,test;
153 LOCK TABLE t1 WRITE;
154 OPTIMIZE TABLE t1;
155 Table Op Msg_type Msg_text
156 test.t1 optimize status OK
157 connection default;
158 DELETE FROM t2 WHERE c < 1;
159 Warnings:
160 Warning 1292 Truncated incorrect DECIMAL value: 'a'
161 Warning 1292 Truncated incorrect DECIMAL value: 'b'
162 connection con1;
163 OPTIMIZE TABLE t1;
164 Table Op Msg_type Msg_text
165 test.t1 optimize status Table is already up to date
166 disconnect con1;
167 connection default;
168 DROP TABLE t1, t2;
169 #
170 # MDEV-22829 SIGSEGV in _ma_reset_history on LOCK
171 #
172 CREATE TABLE t1 (f1 INT) ENGINE=Aria;
173 CREATE TABLE t2 (f2 INT) ENGINE=Aria;
174 LOCK TABLES t2 WRITE, t1 WRITE;
175 INSERT INTO t1 VALUES (1);
176 CREATE TRIGGER ai AFTER INSERT ON t1 FOR EACH ROW UPDATE t1 SET v=1 WHERE b=new.a;
177 ERROR 42S22: Unknown column 'a' in 'NEW'
178 UNLOCK TABLES;
179 DROP TABLE t1, t2;