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;
17 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
18 SELECT * FROM t1 ORDER BY c1;
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;
46 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
47 SELECT * FROM t1 ORDER BY c1;
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;
75 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
76 SELECT * FROM t1 ORDER BY c1;
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;
104 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
105 SELECT * FROM t1 ORDER BY c1;
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;
133 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
134 SELECT * FROM t1 ORDER BY c1;
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;
162 UPDATE t1 SET c1 = -10 WHERE c1 >= 5 ORDER BY c1 LIMIT 1;
163 SELECT * FROM t1 ORDER BY c1;