Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL, PRIMARY KEY(c1));
3 INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10);
4 SELECT _rowid FROM t1;
5 _rowid
6 -1
7 -10
8 1
9 10
10 2
11 3
12 4
13 5
14 7
15 8
16 9
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 SMALLINT NOT NULL, PRIMARY KEY(c1));
19 INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10);
20 SELECT _rowid FROM t1;
21 _rowid
22 -1
23 -10
24 1
25 10
26 2
27 3
28 4
29 5
30 7
31 8
32 9
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, PRIMARY KEY(c1));
35 INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10);
36 SELECT _rowid FROM t1;
37 _rowid
38 -1
39 -10
40 1
41 10
42 2
43 3
44 4
45 5
46 7
47 8
48 9
49 DROP TABLE t1;
50 CREATE TABLE t1(c1 INT NOT NULL, PRIMARY KEY(c1));
51 INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10);
52 SELECT _rowid FROM t1;
53 _rowid
54 -1
55 -10
56 1
57 10
58 2
59 3
60 4
61 5
62 7
63 8
64 9
65 DROP TABLE t1;
66 CREATE TABLE t1(c1 INTEGER NOT NULL, PRIMARY KEY(c1));
67 INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10);
68 SELECT _rowid FROM t1;
69 _rowid
70 -1
71 -10
72 1
73 10
74 2
75 3
76 4
77 5
78 7
79 8
80 9
81 DROP TABLE t1;
82 CREATE TABLE t1(c1 BIGINT NOT NULL, PRIMARY KEY(c1));
83 INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10);
84 SELECT _rowid FROM t1;
85 _rowid
86 -1
87 -10
88 1
89 10
90 2
91 3
92 4
93 5
94 7
95 8
96 9
97 DROP TABLE t1;