[Commits] bccd15ec735: Test result updates #3

revision-id: bccd15ec7354ea4db189633e6c74eb27dbd4d826 (mariadb-10.6.1-360-gbccd15ec735) parent(s): c49639020e93f8ee2eca0692342dc48eb08a6102 author: Sergei Petrunia committer: Sergei Petrunia timestamp: 2022-03-17 19:52:09 +0300 message: Test result updates #3 --- mysql-test/suite/innodb_zip/r/page_size.result | 4 +- .../mysql-test/type_inet/type_inet6.result | 28 +++---- .../mysql-test/type_inet/type_inet6_innodb.result | 36 ++++----- .../mysql-test/type_inet/type_inet6_memory.result | 36 ++++----- .../mysql-test/type_inet/type_inet6_myisam.result | 44 +++++------ .../mysql-test/type_test/type_test_double.result | 4 +- .../mysql-test/type_test/type_test_int8.result | 4 +- .../mysql-test/type_uuid/type_uuid.result | 28 +++---- .../mysql-test/type_uuid/type_uuid_innodb.result | 86 +++++++++++----------- .../mysql-test/type_uuid/type_uuid_memory.result | 80 ++++++++++---------- .../mysql-test/type_uuid/type_uuid_myisam.result | 80 ++++++++++---------- storage/connect/mysql-test/connect/r/alter.result | 4 +- storage/connect/mysql-test/connect/r/bson.result | 4 +- storage/connect/mysql-test/connect/r/json.result | 4 +- .../mysql-test/connect/r/mysql_index.result | 4 +- .../mroonga/storage/r/geometry_contains.result | 4 +- ...riable_max_n_records_for_estimate_global.result | 4 +- ..._records_for_estimate_not_found_in_limit.result | 4 +- ...iable_max_n_records_for_estimate_session.result | 4 +- .../mroonga/wrapper/r/count_star_with_index.result | 8 +- .../sequence/mysql-test/sequence/group_by.result | 54 +++++++------- storage/sequence/mysql-test/sequence/group_by.test | 2 +- storage/sequence/mysql-test/sequence/simple.result | 42 +++++------ 23 files changed, 284 insertions(+), 284 deletions(-) diff --git a/mysql-test/suite/innodb_zip/r/page_size.result b/mysql-test/suite/innodb_zip/r/page_size.result index 8925fe3a8ed..c99db2ba773 100644 --- a/mysql-test/suite/innodb_zip/r/page_size.result +++ b/mysql-test/suite/innodb_zip/r/page_size.result @@ -372,8 +372,8 @@ CHECK TABLE t1; Table Op Msg_type Msg_text test.t1 check status OK EXPLAIN SELECT * FROM t1 WHERE b LIKE 'adfd%'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 769 NULL # Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range b b 769 # 12 Using where DROP TABLE t1; # Test 8) Test creating a table that could lead to undo log overflow. CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob, diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6.result b/plugin/type_inet/mysql-test/type_inet/type_inet6.result index 6e05d589695..e55117e6608 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.result @@ -1280,8 +1280,8 @@ DROP TABLE t1; CREATE TABLE t1 (id INT, a INET6); INSERT INTO t1 VALUES (1,'::1'),(2,'::2'); EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=COALESCE(CAST('::1' AS INET6)) AND id>0; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = INET6'::1' and `test`.`t1`.`id` > 0 DROP TABLE t1; @@ -1293,15 +1293,15 @@ INSERT INTO t1 VALUES (1,'::1'),(2,'::2'); EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=COALESCE(CAST('::1' AS INET6)) AND LENGTH(CONCAT(a,RAND()))>1; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = INET6'::1' and octet_length(concat(INET6'::1',rand())) > 1 EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=COALESCE(CAST('::1' AS INET6)) AND LENGTH(a)>1; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = INET6'::1' DROP TABLE t1; @@ -1312,8 +1312,8 @@ CREATE TABLE t1 (id INT, a INET6); INSERT INTO t1 VALUES (1,'::1'),(2,'::2'); EXPLAIN EXTENDED SELECT * FROM t1 WHERE COALESCE(a)='::1' AND COALESCE(a)=CONCAT(a); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where coalesce(`test`.`t1`.`a`) = '::1' and concat(`test`.`t1`.`a`) = '::1' DROP TABLE t1; @@ -1324,13 +1324,13 @@ CREATE TABLE t1 (a INET6, b VARCHAR(32), KEY (a), KEY(b)) ; INSERT INTO t1 VALUES ('::a','::a'),('::a','::b'); SET @@optimizer_switch='semijoin=off,materialization=on,in_to_exists=off,subquery_cache=off'; EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT a AS a_inner FROM t1 GROUP BY a_inner); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where -2 MATERIALIZED t1 index NULL a 17 NULL 2 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY t1 NULL ALL NULL NULL NULL NULL 2 Using where +2 MATERIALIZED t1 NULL index NULL a 17 NULL 2 Using index EXPLAIN SELECT * FROM t1 WHERE b IN (SELECT a AS a_inner FROM t1 GROUP BY a_inner); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where -2 DEPENDENT SUBQUERY t1 index_subquery a a 17 func 2 Using index; Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY t1 NULL ALL NULL NULL NULL NULL 2 Using where +2 DEPENDENT SUBQUERY t1 NULL index_subquery a a 17 func 2 Using index; Using where SET @@optimizer_switch=DEFAULT; DROP TABLE t1; # diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.result b/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.result index a6911751747..ace9afd2266 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.result @@ -24,15 +24,15 @@ SELECT * FROM t1 WHERE a='::ff'; a ::ff EXPLAIN SELECT * FROM t1 WHERE a='::ff'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index SELECT * FROM t1 WHERE a='garbage'; a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect inet6 value: 'garbage' SELECT * FROM t1 WHERE a>='::fe'; @@ -40,21 +40,21 @@ a ::fe ::ff EXPLAIN SELECT * FROM t1 WHERE a>='::fe'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a>='garbage'; a EXPLAIN SELECT * FROM t1 WHERE a>='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a IN ('::80','::a0','::f0'); a ::80 ::a0 ::f0 EXPLAIN SELECT * FROM t1 WHERE a IN ('::80','::a0','::f0'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 3 Using where; Using index SELECT * FROM t1 WHERE a IN ('::80','::a0','garbage'); a ::80 @@ -62,8 +62,8 @@ a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a IN ('::80','::a0','garbage'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index Warnings: Warning 1292 Incorrect inet6 value: 'garbage' SELECT * FROM t1 WHERE a BETWEEN '::80' AND '::81'; @@ -71,19 +71,19 @@ a ::80 ::81 EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '::80' AND '::81'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a BETWEEN '::80' AND 'garbage'; a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '::80' AND 'garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a=CAST('::ff' AS INET6); a ::ff EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=CAST('::ff' AS INET6); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ref a a 17 const 1 100.00 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ref a a 17 const 1 100.00 Using where; Using index Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = INET6'::ff' DROP TABLE t1; diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6_memory.result b/plugin/type_inet/mysql-test/type_inet/type_inet6_memory.result index db4196366ca..899fdc9c8bd 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6_memory.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6_memory.result @@ -24,15 +24,15 @@ SELECT * FROM t1 WHERE a='::ff'; a ::ff EXPLAIN SELECT * FROM t1 WHERE a='::ff'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where SELECT * FROM t1 WHERE a='garbage'; a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect inet6 value: 'garbage' SELECT * FROM t1 WHERE a>='::fe'; @@ -40,23 +40,23 @@ a ::fe ::ff EXPLAIN SELECT * FROM t1 WHERE a>='::fe'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a>='garbage'; a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a>='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a IN ('::80','::a0','::f0'); a ::80 ::a0 ::f0 EXPLAIN SELECT * FROM t1 WHERE a IN ('::80','::a0','::f0'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 6 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 6 Using where SELECT * FROM t1 WHERE a IN ('::80','::a0','garbage'); a ::80 @@ -64,8 +64,8 @@ a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a IN ('::80','::a0','garbage'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 4 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 4 Using where Warnings: Warning 1292 Incorrect inet6 value: 'garbage' SELECT * FROM t1 WHERE a BETWEEN '::80' AND '::81'; @@ -73,8 +73,8 @@ a ::80 ::81 EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '::80' AND '::81'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a BETWEEN '::80' AND 'garbage'; a Warnings: @@ -143,14 +143,14 @@ Warning 1292 Incorrect inet6 value: 'garbage' Warning 1292 Incorrect inet6 value: 'garbage' Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '::80' AND 'garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a=CAST('::ff' AS INET6); a ::ff EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=CAST('::ff' AS INET6); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ref a a 17 const 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ref a a 17 const 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = INET6'::ff' DROP TABLE t1; diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6_myisam.result b/plugin/type_inet/mysql-test/type_inet/type_inet6_myisam.result index ba65d61cb08..37f0c913a2a 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6_myisam.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6_myisam.result @@ -24,15 +24,15 @@ SELECT * FROM t1 WHERE a='::ff'; a ::ff EXPLAIN SELECT * FROM t1 WHERE a='::ff'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index SELECT * FROM t1 WHERE a='garbage'; a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect inet6 value: 'garbage' SELECT * FROM t1 WHERE a>='::fe'; @@ -40,21 +40,21 @@ a ::fe ::ff EXPLAIN SELECT * FROM t1 WHERE a>='::fe'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a>='garbage'; a EXPLAIN SELECT * FROM t1 WHERE a>='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a IN ('::80','::a0','::f0'); a ::80 ::a0 ::f0 EXPLAIN SELECT * FROM t1 WHERE a IN ('::80','::a0','::f0'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 3 Using where; Using index SELECT * FROM t1 WHERE a IN ('::80','::a0','garbage'); a ::80 @@ -62,8 +62,8 @@ a Warnings: Warning 1292 Incorrect inet6 value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a IN ('::80','::a0','garbage'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index Warnings: Warning 1292 Incorrect inet6 value: 'garbage' SELECT * FROM t1 WHERE a BETWEEN '::80' AND '::81'; @@ -71,19 +71,19 @@ a ::80 ::81 EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '::80' AND '::81'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a BETWEEN '::80' AND 'garbage'; a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '::80' AND 'garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a=CAST('::ff' AS INET6); a ::ff EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=CAST('::ff' AS INET6); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ref a a 17 const 1 100.00 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ref a a 17 const 1 100.00 Using where; Using index Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = INET6'::ff' DROP TABLE t1; @@ -96,15 +96,15 @@ SELECT * FROM t1 WHERE c>CAST('::1' AS INET6); c ::2 EXPLAIN SELECT * FROM t1 WHERE c>CAST('::1' AS INET6); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index c c 67 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL index c c 67 NULL 3 Using where; Using index SELECT * FROM t1 WHERE c=CAST('::1' AS INET6); c 0::1 ::1 EXPLAIN SELECT * FROM t1 WHERE c=CAST('::1' AS INET6); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index c c 67 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL index c c 67 NULL 3 Using where; Using index DROP TABLE t1; # # End of 10.5 tests diff --git a/plugin/type_test/mysql-test/type_test/type_test_double.result b/plugin/type_test/mysql-test/type_test/type_test_double.result index 19ebb6cde64..a7bb0451fa8 100644 --- a/plugin/type_test/mysql-test/type_test/type_test_double.result +++ b/plugin/type_test/mysql-test/type_test/type_test_double.result @@ -304,8 +304,8 @@ DROP TABLE t1; CREATE TABLE t1 (a TEST_DOUBLE, KEY(a)); INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7); EXPLAIN SELECT * FROM t1 WHERE a=3; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 9 const 1 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 9 const 1 Using index DROP TABLE t1; # Testing aggregation for result CREATE TABLE t1 (a TEST_DOUBLE); diff --git a/plugin/type_test/mysql-test/type_test/type_test_int8.result b/plugin/type_test/mysql-test/type_test/type_test_int8.result index f18c990cf3b..9af7f7e6e22 100644 --- a/plugin/type_test/mysql-test/type_test/type_test_int8.result +++ b/plugin/type_test/mysql-test/type_test/type_test_int8.result @@ -283,8 +283,8 @@ DROP TABLE t1; CREATE TABLE t1 (a TEST_INT8, KEY(a)); INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7); EXPLAIN SELECT * FROM t1 WHERE a=3; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 9 const 1 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 9 const 1 Using index DROP TABLE t1; # Testing aggregation for result CREATE TABLE t1 (a TEST_INT8); diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result index 43ef4e911dc..bc7e3f6677e 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result @@ -2462,8 +2462,8 @@ INSERT INTO t1 VALUES (1,'00000000-0000-0000-0000-000000000001'), (2,'00000000-0000-0000-0000-000000000002'); EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=COALESCE(CAST('00000000-0000-0000-0000-000000000001' AS UUID)) AND id>0; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = UUID'00000000-0000-0000-0000-000000000001' and `test`.`t1`.`id` > 0 DROP TABLE t1; @@ -2477,15 +2477,15 @@ INSERT INTO t1 VALUES EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=COALESCE(CAST('00000000-0000-0000-0000-000000000001' AS UUID)) AND LENGTH(CONCAT(a,RAND()))>1; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = UUID'00000000-0000-0000-0000-000000000001' and octet_length(concat(UUID'00000000-0000-0000-0000-000000000001',rand())) > 1 EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=COALESCE(CAST('00000000-0000-0000-0000-000000000001' AS UUID)) AND LENGTH(a)>1; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = UUID'00000000-0000-0000-0000-000000000001' DROP TABLE t1; @@ -2498,8 +2498,8 @@ INSERT INTO t1 VALUES (2,'00000000-0000-0000-0000-000000000002'); EXPLAIN EXTENDED SELECT * FROM t1 WHERE COALESCE(a)='00000000-0000-0000-0000-000000000001' AND COALESCE(a)=CONCAT(a); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`a` AS `a` from `test`.`t1` where coalesce(`test`.`t1`.`a`) = '00000000-0000-0000-0000-000000000001' and concat(`test`.`t1`.`a`) = '00000000-0000-0000-0000-000000000001' DROP TABLE t1; @@ -2518,13 +2518,13 @@ INSERT INTO t1 VALUES ); SET @@optimizer_switch='semijoin=off,materialization=on,in_to_exists=off,subquery_cache=off'; EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT a AS a_inner FROM t1 GROUP BY a_inner); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where -2 MATERIALIZED t1 index NULL a 17 NULL 2 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY t1 NULL ALL NULL NULL NULL NULL 2 Using where +2 MATERIALIZED t1 NULL index NULL a 17 NULL 2 Using index EXPLAIN SELECT * FROM t1 WHERE b IN (SELECT a AS a_inner FROM t1 GROUP BY a_inner); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where -2 DEPENDENT SUBQUERY t1 index_subquery a a 17 func 2 Using index; Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY t1 NULL ALL NULL NULL NULL NULL 2 Using where +2 DEPENDENT SUBQUERY t1 NULL index_subquery a a 17 func 2 Using index; Using where SET @@optimizer_switch=DEFAULT; DROP TABLE t1; # diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result index f777723eefc..6d35f6bff84 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result @@ -24,15 +24,15 @@ SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-0000000000ff'; a 00000000-0000-0000-0000-0000000000ff EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-0000000000ff'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index SELECT * FROM t1 WHERE a='garbage'; a Warnings: Warning 1292 Incorrect uuid value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect uuid value: 'garbage' SELECT * FROM t1 WHERE a>='00000000-0000-0000-0000-0000000000fe'; @@ -40,13 +40,13 @@ a 00000000-0000-0000-0000-0000000000fe 00000000-0000-0000-0000-0000000000ff EXPLAIN SELECT * FROM t1 WHERE a>='00000000-0000-0000-0000-0000000000fe'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a>='garbage'; a EXPLAIN SELECT * FROM t1 WHERE a>='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a IN ( '00000000-0000-0000-0000-000000000080', @@ -63,8 +63,8 @@ EXPLAIN SELECT * FROM t1 WHERE a IN '00000000-0000-0000-0000-0000000000a0', '00000000-0000-0000-0000-0000000000f0' ); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 3 Using where; Using index SELECT * FROM t1 WHERE a IN ( '00000000-0000-0000-0000-000000000080', @@ -82,8 +82,8 @@ EXPLAIN SELECT * FROM t1 WHERE a IN '00000000-0000-0000-0000-0000000000a0', 'garbage' ); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index Warnings: Warning 1292 Incorrect uuid value: 'garbage' SELECT * FROM t1 WHERE a BETWEEN @@ -95,8 +95,8 @@ a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND '00000000-0000-0000-0000-000000000081'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND 'garbage'; @@ -104,14 +104,14 @@ a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND 'garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a=CAST('00000000-0000-0000-0000-0000000000ff' AS UUID); a 00000000-0000-0000-0000-0000000000ff EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=CAST('00000000-0000-0000-0000-0000000000ff' AS UUID); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ref a a 17 const 1 100.00 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ref a a 17 const 1 100.00 Using where; Using index Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = UUID'00000000-0000-0000-0000-0000000000ff' DROP TABLE t1; @@ -145,38 +145,38 @@ END FOR; $$ COMMIT; EXPLAIN SELECT * FROM t1 WHERE a='ff000000-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00ff0000-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='0000ff00-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='000000ff-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-ff00-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-00ff-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-ff00-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-00ff-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-ff00-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-00ff-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-ff0000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index DROP TABLE t1; # # MDEV-26742 Assertion `field->type_handler() == this' failed in FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_item @@ -192,9 +192,9 @@ d pk c Warnings: Warning 1292 Incorrect uuid value: '2' EXPLAIN SELECT * FROM t2 JOIN t1 ON ( t1.pk > t2.d); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 system NULL NULL NULL NULL 1 -1 SIMPLE t2 ALL d NULL NULL NULL 1 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL system NULL NULL NULL NULL 1 +1 SIMPLE t2 NULL ALL d NULL NULL NULL 1 Using where UPDATE t2 JOIN t1 ON ( t1.pk > t2.d) SET t1.c = 1; ERROR 22007: Incorrect uuid value: '2' DROP TABLE t1, t2; diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result index 9d2c27a9e25..9b967fea32c 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result @@ -24,15 +24,15 @@ SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-0000000000ff'; a 00000000-0000-0000-0000-0000000000ff EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-0000000000ff'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 4 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 4 Using where SELECT * FROM t1 WHERE a='garbage'; a Warnings: Warning 1292 Incorrect uuid value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect uuid value: 'garbage' SELECT * FROM t1 WHERE a>='00000000-0000-0000-0000-0000000000fe'; @@ -40,15 +40,15 @@ a 00000000-0000-0000-0000-0000000000fe 00000000-0000-0000-0000-0000000000ff EXPLAIN SELECT * FROM t1 WHERE a>='00000000-0000-0000-0000-0000000000fe'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a>='garbage'; a Warnings: Warning 1292 Incorrect uuid value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a>='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a IN ( '00000000-0000-0000-0000-000000000080', @@ -65,8 +65,8 @@ EXPLAIN SELECT * FROM t1 WHERE a IN '00000000-0000-0000-0000-0000000000a0', '00000000-0000-0000-0000-0000000000f0' ); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 12 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 12 Using where SELECT * FROM t1 WHERE a IN ( '00000000-0000-0000-0000-000000000080', @@ -84,8 +84,8 @@ EXPLAIN SELECT * FROM t1 WHERE a IN '00000000-0000-0000-0000-0000000000a0', 'garbage' ); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 8 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 8 Using where Warnings: Warning 1292 Incorrect uuid value: 'garbage' SELECT * FROM t1 WHERE a BETWEEN @@ -97,8 +97,8 @@ a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND '00000000-0000-0000-0000-000000000081'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND 'garbage'; @@ -171,14 +171,14 @@ Warning 1292 Incorrect uuid value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND 'garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL a NULL NULL NULL 256 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ALL a NULL NULL NULL 256 Using where SELECT * FROM t1 WHERE a=CAST('00000000-0000-0000-0000-0000000000ff' AS UUID); a 00000000-0000-0000-0000-0000000000ff EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=CAST('00000000-0000-0000-0000-0000000000ff' AS UUID); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ref a a 17 const 4 100.00 Using where +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ref a a 17 const 4 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = UUID'00000000-0000-0000-0000-0000000000ff' DROP TABLE t1; @@ -212,38 +212,38 @@ END FOR; $$ COMMIT; EXPLAIN SELECT * FROM t1 WHERE a='ff000000-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00ff0000-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='0000ff00-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='000000ff-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-ff00-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-00ff-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-ff00-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-00ff-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-ff00-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-00ff-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-ff0000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 2 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 2 Using where DROP TABLE t1; # # End of 10.5 tests diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result index 35cc25abfd6..4b545d04b84 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result @@ -24,15 +24,15 @@ SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-0000000000ff'; a 00000000-0000-0000-0000-0000000000ff EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-0000000000ff'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index SELECT * FROM t1 WHERE a='garbage'; a Warnings: Warning 1292 Incorrect uuid value: 'garbage' EXPLAIN SELECT * FROM t1 WHERE a='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect uuid value: 'garbage' SELECT * FROM t1 WHERE a>='00000000-0000-0000-0000-0000000000fe'; @@ -40,13 +40,13 @@ a 00000000-0000-0000-0000-0000000000fe 00000000-0000-0000-0000-0000000000ff EXPLAIN SELECT * FROM t1 WHERE a>='00000000-0000-0000-0000-0000000000fe'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 3 Using where; Using index SELECT * FROM t1 WHERE a>='garbage'; a EXPLAIN SELECT * FROM t1 WHERE a>='garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a IN ( '00000000-0000-0000-0000-000000000080', @@ -63,8 +63,8 @@ EXPLAIN SELECT * FROM t1 WHERE a IN '00000000-0000-0000-0000-0000000000a0', '00000000-0000-0000-0000-0000000000f0' ); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 4 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 4 Using where; Using index SELECT * FROM t1 WHERE a IN ( '00000000-0000-0000-0000-000000000080', @@ -82,8 +82,8 @@ EXPLAIN SELECT * FROM t1 WHERE a IN '00000000-0000-0000-0000-0000000000a0', 'garbage' ); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index Warnings: Warning 1292 Incorrect uuid value: 'garbage' SELECT * FROM t1 WHERE a BETWEEN @@ -95,8 +95,8 @@ a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND '00000000-0000-0000-0000-000000000081'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 17 NULL 2 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL range a a 17 NULL 2 Using where; Using index SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND 'garbage'; @@ -104,14 +104,14 @@ a EXPLAIN SELECT * FROM t1 WHERE a BETWEEN '00000000-0000-0000-0000-000000000080' AND 'garbage'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables SELECT * FROM t1 WHERE a=CAST('00000000-0000-0000-0000-0000000000ff' AS UUID); a 00000000-0000-0000-0000-0000000000ff EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=CAST('00000000-0000-0000-0000-0000000000ff' AS UUID); -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ref a a 17 const 1 100.00 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 NULL ref a a 17 const 1 100.00 Using where; Using index Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where `test`.`t1`.`a` = UUID'00000000-0000-0000-0000-0000000000ff' DROP TABLE t1; @@ -145,38 +145,38 @@ END FOR; $$ COMMIT; EXPLAIN SELECT * FROM t1 WHERE a='ff000000-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00ff0000-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='0000ff00-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='000000ff-0000-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-ff00-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-00ff-0000-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-ff00-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-00ff-0000-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-ff00-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-00ff-000000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index EXPLAIN SELECT * FROM t1 WHERE a='00000000-0000-0000-0000-ff0000000000'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 17 const 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref a a 17 const 1 Using where; Using index DROP TABLE t1; # # Testing index prefix compression diff --git a/storage/connect/mysql-test/connect/r/alter.result b/storage/connect/mysql-test/connect/r/alter.result index 7de43c88329..76258a8d9e8 100644 --- a/storage/connect/mysql-test/connect/r/alter.result +++ b/storage/connect/mysql-test/connect/r/alter.result @@ -13,8 +13,8 @@ c d 3 Three CREATE INDEX xc ON t1(c); DESCRIBE SELECT * FROM t1 WHERE c = 2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref xc xc 4 const 1 +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref xc xc 4 const 1 DROP INDEX xc ON t1; CREATE INDEX xd ON t1(d); DROP INDEX xd ON t1; diff --git a/storage/connect/mysql-test/connect/r/bson.result b/storage/connect/mysql-test/connect/r/bson.result index 8b9a92e4489..ea8e3b65eaa 100644 --- a/storage/connect/mysql-test/connect/r/bson.result +++ b/storage/connect/mysql-test/connect/r/bson.result @@ -199,8 +199,8 @@ ISBN Language Subject AuthorFN AuthorLN Title Translation TranslatorFN Translato 9782212090819 fr applications Fran�ois Knab Construire une application XML NULL NULL NULL Eyrolles Paris 1999 9782840825685 fr applications William J. Pardi XML en Action adapt� de l'anglais par James Guerin Microsoft Press Paris 2001 DESCRIBE SELECT * FROM t1 WHERE ISBN = '9782212090819'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref IX IX 15 const 1 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref IX IX 15 const 1 Using where UPDATE t1 SET AuthorFN = 'Philippe' WHERE ISBN = '9782212090819'; ERROR HY000: Got error 122 'Cannot write expanded column when Pretty is not 2' from CONNECT DROP TABLE t1; diff --git a/storage/connect/mysql-test/connect/r/json.result b/storage/connect/mysql-test/connect/r/json.result index 8cc4e66c2ea..7b2a3b817f7 100644 --- a/storage/connect/mysql-test/connect/r/json.result +++ b/storage/connect/mysql-test/connect/r/json.result @@ -199,8 +199,8 @@ ISBN Language Subject AuthorFN AuthorLN Title Translation TranslatorFN Translato 9782212090819 fr applications Fran�ois Knab Construire une application XML NULL NULL NULL Eyrolles Paris 1999 9782840825685 fr applications William J. Pardi XML en Action adapt� de l'anglais par James Guerin Microsoft Press Paris 2001 DESCRIBE SELECT * FROM t1 WHERE ISBN = '9782212090819'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref IX IX 15 const 1 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t1 NULL ref IX IX 15 const 1 Using where UPDATE t1 SET AuthorFN = 'Philippe' WHERE ISBN = '9782212090819'; ERROR HY000: Got error 122 'Cannot write expanded column when Pretty is not 2' from CONNECT DROP TABLE t1; diff --git a/storage/connect/mysql-test/connect/r/mysql_index.result b/storage/connect/mysql-test/connect/r/mysql_index.result index 54acc7be08d..ebeea414eda 100644 --- a/storage/connect/mysql-test/connect/r/mysql_index.result +++ b/storage/connect/mysql-test/connect/r/mysql_index.result @@ -172,8 +172,8 @@ matricule nom prenom 4080 FOCH SERGE 3368 MOGADOR ALAIN explain SELECT matricule, nom, prenom FROM t2 WHERE nom IN ('FOCH','MOGADOR'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range NP NP 18 NULL 4 Using where +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE t2 NULL range NP NP 18 NULL 4 Using where SELECT matricule, nom, prenom FROM t2 WHERE nom = 'FOCH' OR nom = 'MOGADOR'; matricule nom prenom 1977 FOCH BERNADETTE diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/geometry_contains.result b/storage/mroonga/mysql-test/mroonga/storage/r/geometry_contains.result index 5095232dfb2..7abd7b96050 100644 --- a/storage/mroonga/mysql-test/mroonga/storage/r/geometry_contains.result +++ b/storage/mroonga/mysql-test/mroonga/storage/r/geometry_contains.result @@ -162,6 +162,6 @@ EXPLAIN SELECT id, name, ST_AsText(location) AS location_text FROM shops WHERE MBRContains(ST_GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) ORDER BY id; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE shops range location_index location_index 34 NULL 36 Using where; Using filesort +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE shops NULL range location_index location_index 34 NULL 36 Using where; Using filesort DROP TABLE shops; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_global.result b/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_global.result index 0181fe02d84..574dad2629c 100644 --- a/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_global.result +++ b/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_global.result @@ -14,7 +14,7 @@ INSERT INTO ids VALUES (9); INSERT INTO ids VALUES (10); SET GLOBAL mroonga_max_n_records_for_estimate = 1; EXPLAIN SELECT * FROM ids WHERE id > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE ids range PRIMARY PRIMARY 4 NULL 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE ids NULL range PRIMARY PRIMARY 4 NULL 1 Using where; Using index SET GLOBAL mroonga_max_n_records_for_estimate = DEFAULT; DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_not_found_in_limit.result b/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_not_found_in_limit.result index d318a654c6c..b97aba8153f 100644 --- a/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_not_found_in_limit.result +++ b/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_not_found_in_limit.result @@ -10,7 +10,7 @@ INSERT INTO ids VALUES (4),(5),(6),(7); DELETE FROM ids WHERE id < 2; SET mroonga_max_n_records_for_estimate = 1; EXPLAIN SELECT * FROM ids WHERE id > 0; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE ids range id id 5 NULL 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE ids NULL range id id 5 NULL 1 Using where; Using index SET mroonga_max_n_records_for_estimate = DEFAULT; DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_session.result b/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_session.result index aca9d75c20f..345ee6044c1 100644 --- a/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_session.result +++ b/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_session.result @@ -14,7 +14,7 @@ INSERT INTO ids VALUES (9); INSERT INTO ids VALUES (10); SET mroonga_max_n_records_for_estimate = 1; EXPLAIN SELECT * FROM ids WHERE id > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE ids range PRIMARY PRIMARY 4 NULL 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE ids NULL range PRIMARY PRIMARY 4 NULL 1 Using where; Using index SET mroonga_max_n_records_for_estimate = DEFAULT; DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/count_star_with_index.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/count_star_with_index.result index 1ebd0ba870e..84730f655bc 100644 --- a/storage/mroonga/mysql-test/mroonga/wrapper/r/count_star_with_index.result +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/count_star_with_index.result @@ -17,10 +17,10 @@ INSERT INTO diaries_mroonga (body) VALUES ("will start groonga!"); INSERT INTO diaries_mroonga (body) VALUES ("starting groonga..."); INSERT INTO diaries_mroonga (body) VALUES ("started groonga."); EXPLAIN SELECT COUNT(*) FROM diaries_innodb; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE diaries_innodb index NULL flag 2 NULL # Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE diaries_innodb NULL index NULL flag 2 # 3 Using index EXPLAIN SELECT COUNT(*) FROM diaries_mroonga; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE diaries_mroonga index NULL flag 2 NULL # Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE diaries_mroonga NULL index NULL flag 2 # 3 Using index DROP TABLE diaries_innodb; DROP TABLE diaries_mroonga; diff --git a/storage/sequence/mysql-test/sequence/group_by.result b/storage/sequence/mysql-test/sequence/group_by.result index 795c32c780f..db34299f6e7 100644 --- a/storage/sequence/mysql-test/sequence/group_by.result +++ b/storage/sequence/mysql-test/sequence/group_by.result @@ -14,43 +14,43 @@ select count(*) from seq_1_to_15_step_2; count(*) 8 explain select count(*) from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select count(seq) from seq_1_to_15_step_2; count(seq) 8 explain select count(seq) from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select sum(seq) from seq_1_to_15_step_2; sum(seq) 64 explain select sum(seq) from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select count(seq),sum(seq) from seq_1_to_15_step_2; count(seq) sum(seq) 8 64 explain select count(seq),sum(seq) from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select count(seq) as c from seq_1_to_15_step_2 having c > 5; c 8 explain select count(seq) as c from seq_1_to_15_step_2 having c > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select count(seq) as c from seq_1_to_15_step_2 having c > 1000; c explain select count(seq) as c from seq_1_to_15_step_2 having c > 1000; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select distinct count(*) from seq_1_to_15_step_2; count(*) 8 explain select distinct count(*) from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1; seq count(*) 1 8 @@ -62,10 +62,10 @@ seq count(*) 13 8 15 8 explain select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY seq_1_to_15_step_2 index NULL PRIMARY 8 NULL # Using index -1 PRIMARY <derived2> ALL NULL NULL NULL NULL # Using join buffer (flat, BNL join) -2 DERIVED NULL NULL NULL NULL NULL NULL # Storage engine handles GROUP BY +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY seq_1_to_15_step_2 NULL index NULL PRIMARY 8 NULL # Using index +1 PRIMARY <derived2> NULL ALL NULL NULL NULL NULL # Using join buffer (flat, BNL join) +2 DERIVED NULL NULL NULL NULL NULL NULL NULL # Storage engine handles GROUP BY create view v1 as select count(*) from seq_1_to_15_step_2; select * from v1; count(*) @@ -78,18 +78,18 @@ select count(seq),sum(seq),1 from seq_1_to_15_step_2; count(seq) sum(seq) 1 8 64 1 explain select count(seq),sum(seq),1 from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 index NULL PRIMARY 8 NULL 8 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL index NULL PRIMARY 8 NULL 8 Using index explain select count(*) from seq_1_to_15_step_2, seq_1_to_15_step_2 as t2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 index NULL PRIMARY 8 NULL 8 Using index -1 SIMPLE t2 index NULL PRIMARY 8 NULL 8 Using index; Using join buffer (flat, BNL join) +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL index NULL PRIMARY 8 NULL 8 Using index +1 SIMPLE t2 NULL index NULL PRIMARY 8 NULL 8 Using index; Using join buffer (flat, BNL join) explain select count(*) from seq_1_to_15_step_2 where seq > 0; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 index PRIMARY PRIMARY 8 NULL 8 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL index PRIMARY PRIMARY 8 NULL 8 Using where; Using index explain select count(*) from seq_1_to_15_step_2 group by mod(seq,2); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 index NULL PRIMARY 8 NULL 8 Using index; Using temporary; Using filesort +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL index NULL PRIMARY 8 NULL 8 Using index; Using temporary; Using filesort create temporary table t1 select * from seq_1_to_3; select count(NULL) from t1; count(NULL) diff --git a/storage/sequence/mysql-test/sequence/group_by.test b/storage/sequence/mysql-test/sequence/group_by.test index ca43ba1a5d7..f3e8a683040 100644 --- a/storage/sequence/mysql-test/sequence/group_by.test +++ b/storage/sequence/mysql-test/sequence/group_by.test @@ -27,7 +27,7 @@ explain select count(seq) as c from seq_1_to_15_step_2 having c > 1000; select distinct count(*) from seq_1_to_15_step_2; explain select distinct count(*) from seq_1_to_15_step_2; select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1; ---replace_column 9 # +--replace_column 10 # explain select * from seq_1_to_15_step_2, (select count(*) from seq_1_to_15_step_2) as t1; create view v1 as select count(*) from seq_1_to_15_step_2; diff --git a/storage/sequence/mysql-test/sequence/simple.result b/storage/sequence/mysql-test/sequence/simple.result index d921b80bf0f..5aa9b49c838 100644 --- a/storage/sequence/mysql-test/sequence/simple.result +++ b/storage/sequence/mysql-test/sequence/simple.result @@ -108,8 +108,8 @@ select * from seq_15_to_1_step_12345; seq 15 explain select * from seq_15_to_1_step_12345; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_15_to_1_step_12345 ALL NULL NULL NULL NULL 1 +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_15_to_1_step_12345 NULL ALL NULL NULL NULL NULL 1 show open tables from test; Database Table In_use Name_locked test seq_15_to_1 0 0 @@ -122,29 +122,29 @@ test seq_1_to_15_step_2 0 0 show tables; Tables_in_test explain select * from seq_1_to_15_step_2; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 index NULL PRIMARY 8 NULL 8 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL index NULL PRIMARY 8 NULL 8 Using index explain select * from seq_1_to_15_step_2 where seq > 10; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 range PRIMARY PRIMARY 8 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL range PRIMARY PRIMARY 8 NULL 3 Using where; Using index explain select * from seq_1_to_15_step_2 where seq between 4 and 9; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 range PRIMARY PRIMARY 8 NULL 3 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL range PRIMARY PRIMARY 8 NULL 3 Using where; Using index explain select * from seq_1_to_15_step_2 where seq between 20 and 30; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables explain select * from seq_1_to_15_step_2 where seq between 4 and 6; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 range PRIMARY PRIMARY 8 NULL 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL range PRIMARY PRIMARY 8 NULL 1 Using where; Using index explain select * from seq_1_to_15_step_2 where seq between 4 and 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 range PRIMARY PRIMARY 8 NULL 1 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL range PRIMARY PRIMARY 8 NULL 1 Using where; Using index explain select * from seq_1_to_15_step_2 where seq between 4 and 4; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables explain select * from seq_1_to_15_step_2 where seq between 5 and 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE seq_1_to_15_step_2 const PRIMARY PRIMARY 8 const 1 Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 SIMPLE seq_1_to_15_step_2 NULL const PRIMARY PRIMARY 8 const 1 Using index create table t1 (a int, aa int, b varchar(100)); insert t1 select seq, seq*seq, if (seq % 2, 'odd', 'even') from seq_1_to_20; select * from t1; @@ -234,9 +234,9 @@ seq 47 explain select seq from seq_2_to_50 s1 where 0 not in (select s1.seq % s2.seq from seq_2_to_50 s2 where s2.seq <= sqrt(s1.seq)); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY s1 index NULL PRIMARY 8 NULL 49 Using where; Using index -2 DEPENDENT SUBQUERY s2 index PRIMARY PRIMARY 8 NULL 49 Using where; Using index +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY s1 NULL index NULL PRIMARY 8 NULL 49 Using where; Using index +2 DEPENDENT SUBQUERY s2 NULL index PRIMARY PRIMARY 8 NULL 49 Using where; Using index select year(dt) from (select '1901-02-28' + interval seq year as dt from seq_0_to_99) as seqdt where weekday(dt) = 0;