summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Bertrand <bertrandop@gmail.com>2018-12-05 19:01:37 +0100
committerOlivier Bertrand <bertrandop@gmail.com>2018-12-05 19:01:37 +0100
commitc2482c76dc4b164839d540818db1a61b9a0ce5f0 (patch)
tree4a954fcdbbc67f47ac734c3452e3ff2196f2f51d
parent60525ad348f92b85c788ca514cab60ac74a36652 (diff)
downloadmariadb-git-c2482c76dc4b164839d540818db1a61b9a0ce5f0.tar.gz
Modified because different result on Windows and Linux
-rw-r--r--storage/connect/mysql-test/connect/r/part_table.result5
-rw-r--r--storage/connect/mysql-test/connect/t/part_table.test2
2 files changed, 3 insertions, 4 deletions
diff --git a/storage/connect/mysql-test/connect/r/part_table.result b/storage/connect/mysql-test/connect/r/part_table.result
index 4c74f1a6f49..80127fac70c 100644
--- a/storage/connect/mysql-test/connect/r/part_table.result
+++ b/storage/connect/mysql-test/connect/r/part_table.result
@@ -89,10 +89,9 @@ id msg
60 sixty
81 eighty one
72 seventy two
-EXPLAIN PARTITIONS
SELECT * FROM t1 WHERE id = 81;
-id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 3 ALL NULL NULL NULL NULL 6 Using where
+id msg
+81 eighty one
DELETE FROM t1;
Warnings:
Note 1105 xt1: 4 affected rows
diff --git a/storage/connect/mysql-test/connect/t/part_table.test b/storage/connect/mysql-test/connect/t/part_table.test
index 8c0eb4cac70..37133b96ca5 100644
--- a/storage/connect/mysql-test/connect/t/part_table.test
+++ b/storage/connect/mysql-test/connect/t/part_table.test
@@ -47,7 +47,7 @@ INSERT INTO t1 VALUES(7,'seven'),(10,'ten'),(40,'forty'),(60,'sixty'),(81,'eight
INSERT INTO t1 VALUES(72,'seventy two'),(11,'eleven'),(1,'one'),(35,'thirty five'),(8,'eight');
SELECT partition_name, table_rows FROM information_schema.partitions WHERE table_name = 't1';
SELECT * FROM t1;
-EXPLAIN PARTITIONS
+#EXPLAIN PARTITIONS deleted because it returns differeent key on Windows and Linux
SELECT * FROM t1 WHERE id = 81;
DELETE FROM t1;
DROP TABLE t1;