summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/intersect_all.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/intersect_all.result')
-rw-r--r--mysql-test/main/intersect_all.result57
1 files changed, 57 insertions, 0 deletions
diff --git a/mysql-test/main/intersect_all.result b/mysql-test/main/intersect_all.result
index b1afcee2..ad4ade45 100644
--- a/mysql-test/main/intersect_all.result
+++ b/mysql-test/main/intersect_all.result
@@ -63,12 +63,15 @@ EXPLAIN
{
"query_block": {
"select_id": 1,
+ "cost": "COST_REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 4,
+ "cost": "COST_REPLACED",
"filtered": 100
}
}
@@ -79,12 +82,15 @@ EXPLAIN
"query_block": {
"select_id": 2,
"operation": "INTERSECT",
+ "cost": "COST_REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 1,
"rows": 4,
+ "cost": "COST_REPLACED",
"filtered": 100
}
}
@@ -95,12 +101,15 @@ EXPLAIN
"query_block": {
"select_id": 3,
"operation": "INTERSECT",
+ "cost": "COST_REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"rows": 4,
+ "cost": "COST_REPLACED",
"filtered": 100
}
}
@@ -127,6 +136,7 @@ ANALYZE
{
"query_block": {
"select_id": 1,
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -134,9 +144,11 @@ ANALYZE
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 4,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -151,6 +163,7 @@ ANALYZE
"query_block": {
"select_id": 2,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -158,9 +171,11 @@ ANALYZE
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 4,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -175,6 +190,7 @@ ANALYZE
"query_block": {
"select_id": 3,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -182,9 +198,11 @@ ANALYZE
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 4,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -207,6 +225,7 @@ ANALYZE
},
"query_block": {
"select_id": 1,
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -214,9 +233,11 @@ ANALYZE
"table": {
"table_name": "<derived2>",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 2,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"filtered": 100,
@@ -232,6 +253,7 @@ ANALYZE
{
"query_block": {
"select_id": 2,
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -239,9 +261,11 @@ ANALYZE
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 4,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -256,6 +280,7 @@ ANALYZE
"query_block": {
"select_id": 3,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -263,9 +288,11 @@ ANALYZE
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 4,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -280,6 +307,7 @@ ANALYZE
"query_block": {
"select_id": 4,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -287,9 +315,11 @@ ANALYZE
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 4,
"r_rows": 4,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -383,12 +413,15 @@ EXPLAIN
{
"query_block": {
"select_id": 1,
+ "cost": "COST_REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 6,
+ "cost": "COST_REPLACED",
"filtered": 100
}
}
@@ -399,12 +432,15 @@ EXPLAIN
"query_block": {
"select_id": 2,
"operation": "INTERSECT",
+ "cost": "COST_REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "COST_REPLACED",
"filtered": 100
}
},
@@ -413,7 +449,9 @@ EXPLAIN
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 5,
"rows": 7,
+ "cost": "COST_REPLACED",
"filtered": 100
},
"buffer_type": "flat",
@@ -444,6 +482,7 @@ ANALYZE
{
"query_block": {
"select_id": 1,
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -451,9 +490,11 @@ ANALYZE
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 6,
"r_rows": 6,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -468,6 +509,7 @@ ANALYZE
"query_block": {
"select_id": 2,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -475,9 +517,11 @@ ANALYZE
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 5,
"r_rows": 5,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -490,9 +534,11 @@ ANALYZE
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 5,
"r_loops": 1,
"rows": 7,
"r_rows": 7,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -524,6 +570,7 @@ ANALYZE
},
"query_block": {
"select_id": 1,
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -531,9 +578,11 @@ ANALYZE
"table": {
"table_name": "<derived2>",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 6,
"r_rows": 3,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"filtered": 100,
@@ -549,6 +598,7 @@ ANALYZE
{
"query_block": {
"select_id": 2,
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -556,9 +606,11 @@ ANALYZE
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 6,
"r_rows": 6,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -573,6 +625,7 @@ ANALYZE
"query_block": {
"select_id": 3,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"r_loops": 1,
"r_total_time_ms": "REPLACED",
"nested_loop": [
@@ -580,9 +633,11 @@ ANALYZE
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"r_loops": 1,
"rows": 5,
"r_rows": 5,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
@@ -595,9 +650,11 @@ ANALYZE
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 5,
"r_loops": 1,
"rows": 7,
"r_rows": 7,
+ "cost": "REPLACED",
"r_table_time_ms": "REPLACED",
"r_other_time_ms": "REPLACED",
"r_engine_stats": REPLACED,
generated by cgit v1.2.3 (git 2.39.1) at 2024-10-08 00:26:19 +0000