diff options
Diffstat (limited to 'mysql-test/main/brackets.result')
| -rw-r--r-- | mysql-test/main/brackets.result | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/main/brackets.result b/mysql-test/main/brackets.result index f87afdc0..1f192241 100644 --- a/mysql-test/main/brackets.result +++ b/mysql-test/main/brackets.result @@ -261,6 +261,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "read_sorted_file": { @@ -269,7 +270,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -291,6 +294,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "read_sorted_file": { @@ -299,7 +303,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -329,12 +335,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "t1.a = 20" } @@ -346,12 +355,15 @@ EXPLAIN "query_block": { "select_id": 2, "operation": "UNION", + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -383,12 +395,15 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "t1.a = 20" } @@ -400,12 +415,15 @@ EXPLAIN "query_block": { "select_id": 2, "operation": "UNION", + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 3, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -445,6 +463,7 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "read_sorted_file": { @@ -453,7 +472,9 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 5, + "cost": "COST_REPLACED", "filtered": 100 } } @@ -466,12 +487,15 @@ EXPLAIN "query_block": { "select_id": 2, "operation": "UNION", + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 5, + "cost": "COST_REPLACED", "filtered": 100, "attached_condition": "t1.pk > 4" } @@ -488,7 +512,7 @@ drop table t1; # MDEV-18689: parenthesis around table names and derived tables # select * from ( mysql.db ); -Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv Trigger_priv Delete_history_priv +Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv Trigger_priv Delete_history_priv Show_create_routine_priv create table t1 (a int); insert into t1 values (7), (2), (7); select * from (t1); |