Edit File: se_rowid.result
DROP TABLE IF EXISTS t1; CREATE TABLE t1(c1 TINYINT NOT NULL, PRIMARY KEY(c1)); INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10); SELECT _rowid FROM t1; _rowid -1 -10 1 10 2 3 4 5 7 8 9 DROP TABLE t1; CREATE TABLE t1(c1 SMALLINT NOT NULL, PRIMARY KEY(c1)); INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10); SELECT _rowid FROM t1; _rowid -1 -10 1 10 2 3 4 5 7 8 9 DROP TABLE t1; CREATE TABLE t1(c1 MEDIUMINT NOT NULL, PRIMARY KEY(c1)); INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10); SELECT _rowid FROM t1; _rowid -1 -10 1 10 2 3 4 5 7 8 9 DROP TABLE t1; CREATE TABLE t1(c1 INT NOT NULL, PRIMARY KEY(c1)); INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10); SELECT _rowid FROM t1; _rowid -1 -10 1 10 2 3 4 5 7 8 9 DROP TABLE t1; CREATE TABLE t1(c1 INTEGER NOT NULL, PRIMARY KEY(c1)); INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10); SELECT _rowid FROM t1; _rowid -1 -10 1 10 2 3 4 5 7 8 9 DROP TABLE t1; CREATE TABLE t1(c1 BIGINT NOT NULL, PRIMARY KEY(c1)); INSERT INTO t1 VALUES(1),(2),(3),(5),(10),(9),(8),(7),(4),(-1),(-10); SELECT _rowid FROM t1; _rowid -1 -10 1 10 2 3 4 5 7 8 9 DROP TABLE t1;
Back to File Manager