Debian Codegraph @

mysql-test/suite/engines/funcs/t/up_ignore.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NOT NULL);
5 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
7 SELECT * FROM t1 ORDER BY c1;
8 UPDATE t1 SET c1 = -10;
9 SELECT * FROM t1 ORDER BY c1;
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 SMALLINT NOT NULL);
12 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
13 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
14 SELECT * FROM t1 ORDER BY c1;
15 UPDATE t1 SET c1 = -10;
16 SELECT * FROM t1 ORDER BY c1;
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
19 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
20 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
21 SELECT * FROM t1 ORDER BY c1;
22 UPDATE t1 SET c1 = -10;
23 SELECT * FROM t1 ORDER BY c1;
24 DROP TABLE t1;
25 CREATE TABLE t1(c1 INT NOT NULL);
26 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
27 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
28 SELECT * FROM t1 ORDER BY c1;
29 UPDATE t1 SET c1 = -10;
30 SELECT * FROM t1 ORDER BY c1;
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 INTEGER NOT NULL);
33 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
34 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
35 SELECT * FROM t1 ORDER BY c1;
36 UPDATE t1 SET c1 = -10;
37 SELECT * FROM t1 ORDER BY c1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 BIGINT NOT NULL);
40 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
41 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
42 SELECT * FROM t1 ORDER BY c1;
43 UPDATE t1 SET c1 = -10;
44 SELECT * FROM t1 ORDER BY c1;
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 TINYINT NOT NULL);
47 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
48 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
49 SELECT * FROM t1 ORDER BY c1;
50 UPDATE IGNORE t1 SET c1 = -10;
51 SELECT * FROM t1 ORDER BY c1;
52 DROP TABLE t1;
53 CREATE TABLE t1(c1 SMALLINT NOT NULL);
54 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
55 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
56 SELECT * FROM t1 ORDER BY c1;
57 UPDATE IGNORE t1 SET c1 = -10;
58 SELECT * FROM t1 ORDER BY c1;
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 IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
63 SELECT * FROM t1 ORDER BY c1;
64 UPDATE IGNORE t1 SET c1 = -10;
65 SELECT * FROM t1 ORDER BY c1;
66 DROP TABLE t1;
67 CREATE TABLE t1(c1 INT NOT NULL);
68 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
69 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
70 SELECT * FROM t1 ORDER BY c1;
71 UPDATE IGNORE t1 SET c1 = -10;
72 SELECT * FROM t1 ORDER BY c1;
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 INTEGER NOT NULL);
75 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
76 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
77 SELECT * FROM t1 ORDER BY c1;
78 UPDATE IGNORE t1 SET c1 = -10;
79 SELECT * FROM t1 ORDER BY c1;
80 DROP TABLE t1;
81 CREATE TABLE t1(c1 BIGINT NOT NULL);
82 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
83 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
84 SELECT * FROM t1 ORDER BY c1;
85 UPDATE IGNORE t1 SET c1 = -10;
86 SELECT * FROM t1 ORDER BY c1;
87 DROP TABLE t1;
88