Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_limit.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4 DELETE FROM t1 ORDER BY c1 LIMIT 2;
5 SELECT * FROM t1 ORDER BY c1;
6 c1
7 2
8 3
9 4
10 5
11 6
12 7
13 8
14 9
15 DELETE FROM t1 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
16 SELECT * FROM t1 ORDER BY c1;
17 c1
18 2
19 3
20 4
21 6
22 7
23 8
24 9
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 SMALLINT NOT NULL);
27 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
28 DELETE FROM t1 ORDER BY c1 LIMIT 2;
29 SELECT * FROM t1 ORDER BY c1;
30 c1
31 2
32 3
33 4
34 5
35 6
36 7
37 8
38 9
39 DELETE FROM t1 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
40 SELECT * FROM t1 ORDER BY c1;
41 c1
42 2
43 3
44 4
45 6
46 7
47 8
48 9
49 DROP TABLE t1;
50 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
51 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
52 DELETE FROM t1 ORDER BY c1 LIMIT 2;
53 SELECT * FROM t1 ORDER BY c1;
54 c1
55 2
56 3
57 4
58 5
59 6
60 7
61 8
62 9
63 DELETE FROM t1 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
64 SELECT * FROM t1 ORDER BY c1;
65 c1
66 2
67 3
68 4
69 6
70 7
71 8
72 9
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 INT NOT NULL);
75 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
76 DELETE FROM t1 ORDER BY c1 LIMIT 2;
77 SELECT * FROM t1 ORDER BY c1;
78 c1
79 2
80 3
81 4
82 5
83 6
84 7
85 8
86 9
87 DELETE FROM t1 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
88 SELECT * FROM t1 ORDER BY c1;
89 c1
90 2
91 3
92 4
93 6
94 7
95 8
96 9
97 DROP TABLE t1;
98 CREATE TABLE t1(c1 INTEGER NOT NULL);
99 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
100 DELETE FROM t1 ORDER BY c1 LIMIT 2;
101 SELECT * FROM t1 ORDER BY c1;
102 c1
103 2
104 3
105 4
106 5
107 6
108 7
109 8
110 9
111 DELETE FROM t1 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
112 SELECT * FROM t1 ORDER BY c1;
113 c1
114 2
115 3
116 4
117 6
118 7
119 8
120 9
121 DROP TABLE t1;
122 CREATE TABLE t1(c1 BIGINT NOT NULL);
123 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
124 DELETE FROM t1 ORDER BY c1 LIMIT 2;
125 SELECT * FROM t1 ORDER BY c1;
126 c1
127 2
128 3
129 4
130 5
131 6
132 7
133 8
134 9
135 DELETE FROM t1 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
136 SELECT * FROM t1 ORDER BY c1;
137 c1
138 2
139 3
140 4
141 6
142 7
143 8
144 9
145 DROP TABLE t1;