Debian Codegraph @

mysql-test/suite/storage_engine/delete.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (10000,'foobar'),(1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
4 INSERT INTO t1 (a,b) SELECT a, b FROM t1;
5 DELETE FROM t1 WHERE b IN ('c');
6 SELECT a,b FROM t1;
7 a b
8 1 a
9 1 a
10 10000 foobar
11 10000 foobar
12 2 b
13 2 b
14 4 d
15 4 d
16 5 e
17 5 e
18 DELETE FROM t1 WHERE a < 0 OR b = 'a';
19 SELECT a,b FROM t1;
20 a b
21 10000 foobar
22 10000 foobar
23 2 b
24 2 b
25 4 d
26 4 d
27 5 e
28 5 e
29 DELETE FROM t1 WHERE a <= 4 ORDER BY b DESC LIMIT 1;
30 SELECT a,b FROM t1;
31 a b
32 10000 foobar
33 10000 foobar
34 2 b
35 2 b
36 4 d
37 5 e
38 5 e
39 CREATE TABLE t2 (c <CHAR_COLUMN>, d <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
40 INSERT INTO t2 (c,d) SELECT b, a FROM t1;
41 SELECT c,d FROM t2;
42 c d
43 b 2
44 b 2
45 d 4
46 e 5
47 e 5
48 foobar 10000
49 foobar 10000
50 DELETE t2.* FROM t1, t2 WHERE c < b AND a + d != 1;
51 SELECT a,b FROM t1;
52 a b
53 10000 foobar
54 10000 foobar
55 2 b
56 2 b
57 4 d
58 5 e
59 5 e
60 SELECT c,d FROM t2;
61 c d
62 foobar 10000
63 foobar 10000
64 DELETE FROM t2, t1.* USING t2, t1 WHERE c = 'foobar' and b = c;
65 SELECT a,b FROM t1;
66 a b
67 2 b
68 2 b
69 4 d
70 5 e
71 5 e
72 SELECT c,d FROM t2;
73 c d
74 DELETE FROM t1;
75 SELECT a,b FROM t1;
76 a b
77 DROP TABLE t1, t2;