Debian Codegraph @

mysql-test/suite/engines/funcs/r/up_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 UPDATE t1 SET c1 = -1 ORDER BY c1 LIMIT 2;
5 SELECT * FROM t1 ORDER BY c1;
6 c1
7 -1
8 -1
9 2
10 3
11 4
12 5
13 6
14 7
15 8
16 9
17 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
18 SELECT * FROM t1 ORDER BY c1;
19 c1
20 -10
21 -1
22 -1
23 2
24 3
25 4
26 6
27 7
28 8
29 9
30 DROP TABLE t1;
31 CREATE TABLE t1(c1 SMALLINT NOT NULL);
32 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
33 UPDATE t1 SET c1 = -1 ORDER BY c1 LIMIT 2;
34 SELECT * FROM t1 ORDER BY c1;
35 c1
36 -1
37 -1
38 2
39 3
40 4
41 5
42 6
43 7
44 8
45 9
46 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
47 SELECT * FROM t1 ORDER BY c1;
48 c1
49 -10
50 -1
51 -1
52 2
53 3
54 4
55 6
56 7
57 8
58 9
59 DROP TABLE t1;
60 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
61 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
62 UPDATE t1 SET c1 = -1 ORDER BY c1 LIMIT 2;
63 SELECT * FROM t1 ORDER BY c1;
64 c1
65 -1
66 -1
67 2
68 3
69 4
70 5
71 6
72 7
73 8
74 9
75 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
76 SELECT * FROM t1 ORDER BY c1;
77 c1
78 -10
79 -1
80 -1
81 2
82 3
83 4
84 6
85 7
86 8
87 9
88 DROP TABLE t1;
89 CREATE TABLE t1(c1 INT NOT NULL);
90 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
91 UPDATE t1 SET c1 = -1 ORDER BY c1 LIMIT 2;
92 SELECT * FROM t1 ORDER BY c1;
93 c1
94 -1
95 -1
96 2
97 3
98 4
99 5
100 6
101 7
102 8
103 9
104 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
105 SELECT * FROM t1 ORDER BY c1;
106 c1
107 -10
108 -1
109 -1
110 2
111 3
112 4
113 6
114 7
115 8
116 9
117 DROP TABLE t1;
118 CREATE TABLE t1(c1 INTEGER NOT NULL);
119 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
120 UPDATE t1 SET c1 = -1 ORDER BY c1 LIMIT 2;
121 SELECT * FROM t1 ORDER BY c1;
122 c1
123 -1
124 -1
125 2
126 3
127 4
128 5
129 6
130 7
131 8
132 9
133 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
134 SELECT * FROM t1 ORDER BY c1;
135 c1
136 -10
137 -1
138 -1
139 2
140 3
141 4
142 6
143 7
144 8
145 9
146 DROP TABLE t1;
147 CREATE TABLE t1(c1 BIGINT NOT NULL);
148 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
149 UPDATE t1 SET c1 = -1 ORDER BY c1 LIMIT 2;
150 SELECT * FROM t1 ORDER BY c1;
151 c1
152 -1
153 -1
154 2
155 3
156 4
157 5
158 6
159 7
160 8
161 9
162 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
163 SELECT * FROM t1 ORDER BY c1;
164 c1
165 -10
166 -1
167 -1
168 2
169 3
170 4
171 6
172 7
173 8
174 9
175 DROP TABLE t1;