Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 97 insertions, 0 deletions

diff --git a/mysql-test/suite/engines/funcs/r/se_rowid.result b/mysql-test/suite/engines/funcs/r/se_rowid.result
new file mode 100644
index 00000000..5ea7cb6c
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/r/se_rowid.result
@@ -0,0 +1,97 @@
+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;