Debian Codegraph @

mysql-test/suite/storage_engine/delete_with_keys.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, <CUSTOM_INDEX> (b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'x'),(7,'y'),(8,'z');
4 DELETE FROM t1 WHERE b > 'y';
5 DELETE FROM t1 WHERE a=2;
6 SELECT a,b FROM t1;
7 a b
8 1 a
9 3 c
10 4 d
11 5 e
12 6 x
13 7 y
14 DELETE FROM t1;
15 DROP TABLE t1;
16 CREATE TABLE t1 (a <INT_COLUMN> PRIMARY KEY, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
17 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'x'),(7,'y'),(8,'z');
18 DELETE FROM t1 WHERE b > 'y';
19 DELETE FROM t1 WHERE a=2;
20 SELECT a,b FROM t1;
21 a b
22 1 a
23 3 c
24 4 d
25 5 e
26 6 x
27 7 y
28 DELETE FROM t1;
29 DROP TABLE t1;
30 CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN>, c <INT_COLUMN>, <CUSTOM_INDEX>(a), <CUSTOM_INDEX>(b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
31 INSERT INTO t1 (a,b,c) VALUES (1,2,3),(4,5,6),(7,8,9);
32 DELETE FROM t1 WHERE a = 10 OR b = 20 ORDER BY c LIMIT 1;
33 SELECT a,b,c FROM t1;
34 a b c
35 1 2 3
36 4 5 6
37 7 8 9
38 DROP TABLE t1;