Debian Codegraph @

mysql-test/suite/maria/alter.result

raw
1 drop table if exists t1;
2 Warnings:
3 Note 1051 Unknown table 'test.t1'
4 CREATE TABLE t1 (pk INT, d DATETIME, PRIMARY KEY(pk), KEY(d)) ENGINE=Aria;
5 ALTER TABLE t1 DISABLE KEYS;
6 INSERT INTO t1 VALUES (1,'2000-01-01 22:22:22'),(2,'2012-12-21 12:12:12');
7 INSERT INTO t1 VALUES (3, '2008-07-24');
8 ALTER TABLE t1 ENABLE KEYS;
9 SELECT t1a.pk FROM t1 AS t1a LEFT JOIN t1 AS t1b ON t1a.pk = t1b.pk;
10 pk
11 1
12 2
13 3
14 SELECT * FROM t1 AS t1a LEFT JOIN t1 AS t1b ON t1a.pk = t1b.pk;
15 pk d pk d
16 1 2000-01-01 22:22:22 1 2000-01-01 22:22:22
17 2 2012-12-21 12:12:12 2 2012-12-21 12:12:12
18 3 2008-07-24 00:00:00 3 2008-07-24 00:00:00
19 DROP TABLE t1;
20 CREATE TABLE t1 (pk INT PRIMARY KEY, i INT, KEY(i)) ENGINE=Aria;
21 ALTER TABLE t1 DISABLE KEYS;
22 INSERT INTO t1 VALUES (1,11);
23 INSERT INTO t1 VALUES (2,0),(3,33),(4,0),(5,55),(6,66),(7,0),(8,88),(9,99);
24 ALTER TABLE t1 ENABLE KEYS;
25 SELECT * FROM t1 WHERE i = 0 OR pk BETWEEN 6 AND 10;
26 pk i
27 2 0
28 4 0
29 6 66
30 7 0
31 8 88
32 9 99
33 DROP TABLE t1;
34 CREATE TABLE t1 (f INT) ENGINE=Aria transactional=1;
35 SHOW CREATE TABLE t1;
36 Table Create Table
37 t1 CREATE TABLE `t1` (
38 `f` int(11) DEFAULT NULL
39 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
40 INSERT INTO t1 VALUES (1),(2);
41 ALTER TABLE t1 ORDER BY unknown_column;
42 ERROR 42S22: Unknown column 'unknown_column' in 'ORDER BY'
43 SHOW CREATE TABLE t1;
44 Table Create Table
45 t1 CREATE TABLE `t1` (
46 `f` int(11) DEFAULT NULL
47 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
48 CREATE TABLE t2 SELECT * FROM t1;
49 DROP TABLE t1, t2;
50 #
51 # MDEV-19055 Assertion `(_my_thread_var())->thr_errno != 0' failed in pagecache_read
52 #
53 CREATE OR REPLACE TABLE t1 (x INT) ENGINE=Aria;
54 CREATE TEMPORARY TABLE t2 (a TIME) ENGINE=Aria;
55 ALTER TABLE t2 ADD b DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
56 ALTER TABLE t2 ADD CHECK (b = 4);
57 INSERT IGNORE INTO t2 () VALUES (),(),(),();
58 ALTER IGNORE TABLE t2 ADD c INT;
59 SELECT count(a),sum(a) FROM t2;
60 count(a) sum(a)
61 0 NULL
62 DELETE FROM t2 ORDER BY c LIMIT 1;
63 INSERT IGNORE INTO t2 SELECT * FROM t2;
64 OPTIMIZE TABLE t2;
65 Table Op Msg_type Msg_text
66 test.t2 optimize status OK
67 SELECT count(a),sum(a) FROM t2;
68 count(a) sum(a)
69 0 NULL
70 INSERT IGNORE INTO t2 SELECT * FROM t2;
71 SET SQL_MODE= 'STRICT_ALL_TABLES';
72 SELECT count(a),sum(a) FROM t2;
73 count(a) sum(a)
74 0 NULL
75 ALTER TABLE t2 CHANGE IF EXISTS d c INT;
76 ERROR 22007: Truncated incorrect datetime value: '4'
77 SELECT count(a),sum(a) FROM t2;
78 count(a) sum(a)
79 0 NULL
80 ALTER IGNORE TABLE t2 ADD IF NOT EXISTS e BIT;
81 ALTER TABLE t1 MODIFY IF EXISTS xx INT;
82 INSERT IGNORE INTO t2 () VALUES (),(),(),();
83 SELECT count(a),sum(a) FROM t2;
84 count(a) sum(a)
85 0 NULL
86 check table t1;
87 Table Op Msg_type Msg_text
88 test.t1 check status OK
89 check table t2;
90 Table Op Msg_type Msg_text
91 test.t2 check status OK
92 DROP TABLE t1,t2;
93 #
94 # MDEV-17576
95 # Assertion `share->reopen == 1' failed in maria_extra upon ALTER on
96 # Aria table with triggers and locks
97 #
98 CREATE TABLE t1 (a INT) ENGINE=Aria;
99 CREATE TRIGGER tr BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t1 SELECT * FROM t1;
100 LOCK TABLE t1 WRITE;
101 ALTER TABLE t1 FORCE, LOCK=EXCLUSIVE;
102 DROP TRIGGER tr;
103 DROP TABLE t1;
104 #
105 # End of 10.2 test
106 #
107 #
108 # MDEV-17665 Assertion `!share || share->page_type == PAGECACHE_LSN_PAGE',
109 # `type != PAGECACHE_READ_UNKNOWN_PAGE' and similar ones upon concurrent
110 # Aria operations
111 #
112 CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, KEY(a)) ENGINE=Aria;
113 ALTER TABLE t1 DISABLE KEYS;
114 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_100;
115 connect con1,localhost,root,,test;
116 connect con2,localhost,root,,test;
117 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_100;
118 connection con1;
119 FLUSH TABLES;
120 connection default;
121 INSERT INTO t1 SELECT 1;
122 ERROR 21S01: Column count doesn't match value count at row 1
123 connection con2;
124 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
125 disconnect con2;
126 connection con1;
127 disconnect con1;
128 connection default;
129 DROP TABLE t1;
130 #
131 # MDEV-22674 Server crash in compare_bin, ASAN heap-buffer-overflow in
132 # _ma_dpointer, Assertion `!info->s->have_versioning ||
133 # info->s->lock_key_trees' failed in restore_table_state_after_repair
134 #
135 CREATE TABLE t1 (id INT, d DATETIME, PRIMARY KEY(d,id),INDEX(d)) ENGINE=Aria;
136 INSERT INTO t1 SELECT seq, NOW() FROM seq_1_to_500;
137 CREATE TABLE t2 (a INT) ENGINE=InnoDB;
138 INSERT INTO t2 VALUES (1);
139 connect con1,localhost,root,,test;
140 ALTER TABLE t1 DISABLE KEYS;
141 INSERT INTO t1 (id) SELECT b FROM t2;
142 connection default;
143 INSERT INTO t1 SELECT a FROM t2;
144 ERROR 21S01: Column count doesn't match value count at row 1
145 connection con1;
146 ERROR 42S22: Unknown column 'b' in 'SELECT'
147 disconnect con1;
148 connection default;
149 drop table t1, t2;
150 # This is also in MDEV-22674
151 CREATE TABLE t1 (id INT, d DATETIME, PRIMARY KEY(d,id),INDEX(d)) ENGINE=Aria;
152 INSERT INTO t1 SELECT seq, NOW() FROM seq_1_to_500;
153 CREATE TABLE t2 (a INT) ENGINE=InnoDB;
154 INSERT INTO t2 VALUES (1);
155 ALTER TABLE t1 DISABLE KEYS;
156 INSERT INTO t1 (id) SELECT b FROM t2;
157 ERROR 42S22: Unknown column 'b' in 'SELECT'
158 INSERT INTO t1 SELECT a FROM t2;
159 ERROR 21S01: Column count doesn't match value count at row 1
160 SELECT COUNT(*) FROM t1;
161 COUNT(*)
162 500
163 DROP TABLE t1,t2;
164 #
165 # MDEV-23296 Assertion `block->type == PAGECACHE_EMPTY_PAGE ||
166 # block->type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == type ||
167 # (block->type == PAGECACHE_PLAIN_PAGE && type == PAGECACHE_LSN_PAGE)'
168 # with aria_max_sort_file_size
169 #
170 SET @max_size.save= @@aria_max_sort_file_size;
171 SET GLOBAL aria_max_sort_file_size= 0;
172 CREATE TABLE t1 (pk INT PRIMARY KEY, a CHAR(255), KEY(a)) ENGINE=Aria;
173 ALTER TABLE t1 DISABLE KEYS;
174 INSERT INTO t1 VALUES (1,'foo'),(2,'bar');
175 ALTER TABLE t1 ENABLE KEYS;
176 INSERT INTO t1 VALUES (3,'nice try');
177 SELECT * FROM t1;
178 pk a
179 1 foo
180 2 bar
181 3 nice try
182 DROP TABLE t1;
183 SET GLOBAL aria_max_sort_file_size= @max_size.save;
184 #
185 # End of 10.4 test
186 #
187 #
188 # MDEV-25505 Assertion `old_flags == ((my_flags & 0x10000U) ? 1 : 0)'
189 # failed in my_realloc
190 #
191 CREATE TABLE t1 (pk int, c text, primary key (pk), key(c(32))) ENGINE=Aria ROW_FORMAT=DYNAMIC;
192 ALTER TABLE t1 DISABLE KEYS;
193 INSERT INTO t1 VALUES (1, 'Nine chars or more');
194 ALTER TABLE t1 ENABLE KEYS;
195 DROP TABLE t1;
196 #
197 # MDEV-25923 Memory not freed or Assertion `old_flags == ((my_flags &
198 # 0x10000U) ? 1 : 0)' failed in my_realloc upon ALTER on Aria table
199 # with GIS column
200 #
201 CREATE TABLE t1 (pk INT PRIMARY KEY, a POINT DEFAULT ST_GEOMFROMTEXT('Point(1 1)')) ENGINE=Aria;
202 INSERT INTO t1 (pk) SELECT seq FROM seq_1_to_100;
203 SET @old_threads= @@SESSION.aria_repair_threads;
204 SET SESSION aria_repair_threads= 2;
205 ALTER TABLE t1 ROW_FORMAT=DYNAMIC;
206 DROP TABLE t1;
207 #
208 # MDEV-33562: Assertion `(old_flags & 1) == ((my_flags & 0x10000U) ?
209 # 1 : 0)' failed in my_realloc from sort_get_next_record on INSERT
210 #
211 SET @old_mode= @@SESSION.sql_mode;
212 SET sql_mode='';
213 CREATE TEMPORARY TABLE t (b TEXT, INDEX s(b(300))) ROW_FORMAT=DYNAMIC ENGINE=Aria;
214 INSERT INTO t VALUES (REPEAT ('a',10000000));
215 Warnings:
216 Warning 1265 Data truncated for column 'b' at row 1
217 CREATE TABLE ti LIKE t;
218 INSERT INTO ti SELECT * FROM t;
219 DROP TABLE t, ti;
220 SET SESSION aria_repair_threads= @old_threads;
221 SET SESSION sql_mode= @old_mode;