summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/set_operation.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/set_operation.result')
-rw-r--r--mysql-test/main/set_operation.result48
1 files changed, 44 insertions, 4 deletions
diff --git a/mysql-test/main/set_operation.result b/mysql-test/main/set_operation.result
index fa0fe21d..f01b6835 100644
--- a/mysql-test/main/set_operation.result
+++ b/mysql-test/main/set_operation.result
@@ -221,7 +221,7 @@ NULL UNIT RESULT <unit8,9,12> ALL NULL NULL NULL NULL NULL NULL
16 EXCEPT NULL NULL NULL NULL NULL NULL NULL NULL No tables used
NULL UNIT RESULT <unit1,15,16> ALL NULL NULL NULL NULL NULL NULL
Warnings:
-Note 1003 /* select#1 */ select `__14`.`1` AS `1` from (/* select#8 */ select `__7`.`1` AS `1` from (/* select#2 */ select 1 AS `1` except /* select#3 */ select 5 AS `5` union /* select#4 */ select 6 AS `6`) `__7` union /* select#9 */ select `__8`.`2` AS `2` from (/* select#5 */ select 2 AS `2` intersect /* select#6 */ select 3 AS `3` intersect /* select#7 */ select 4 AS `4`) `__8` except /* select#12 */ select `__11`.`7` AS `7` from (/* select#10 */ select 7 AS `7` intersect /* select#11 */ select 8 AS `8`) `__11`) `__14` union all /* select#15 */ select `__15`.`9` AS `9` from (/* select#13 */ select 9 AS `9` union all /* select#14 */ select 10 AS `10`) `__15` except all /* select#16 */ select 11 AS `11`
+Note 1003 /* select#1 */ select `__14`.`1` AS `1` from (/* select#8 */ select `__7`.`1` AS `1` from (/* select#2 */ select 1 AS `1` except /* select#3 */ select 5 AS `5` union all /* select#4 */ select 6 AS `6`) `__7` union /* select#9 */ select `__8`.`2` AS `2` from (/* select#5 */ select 2 AS `2` intersect /* select#6 */ select 3 AS `3` intersect /* select#7 */ select 4 AS `4`) `__8` except /* select#12 */ select `__11`.`7` AS `7` from (/* select#10 */ select 7 AS `7` intersect /* select#11 */ select 8 AS `8`) `__11`) `__14` union all /* select#15 */ select `__15`.`9` AS `9` from (/* select#13 */ select 9 AS `9` union all /* select#14 */ select 10 AS `10`) `__15` except all /* select#16 */ select 11 AS `11`
(select 1 union all select 2)
union
(select 3 union all select 4);
@@ -242,7 +242,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra
5 UNION NULL NULL NULL NULL NULL NULL NULL NULL No tables used
NULL UNION RESULT <union1,6> ALL NULL NULL NULL NULL NULL NULL
Warnings:
-Note 1003 /* select#1 */ select `__5`.`1` AS `1` from (/* select#2 */ select 1 AS `1` union /* select#3 */ select 2 AS `2`) `__5` union /* select#6 */ select `__6`.`3` AS `3` from (/* select#4 */ select 3 AS `3` union /* select#5 */ select 4 AS `4`) `__6`
+Note 1003 /* select#1 */ select `__5`.`1` AS `1` from (/* select#2 */ select 1 AS `1` union all /* select#3 */ select 2 AS `2`) `__5` union /* select#6 */ select `__6`.`3` AS `3` from (/* select#4 */ select 3 AS `3` union /* select#5 */ select 4 AS `4`) `__6`
(select 1 intersect all select 2)
except
select 3;
@@ -258,7 +258,7 @@ NULL INTERSECT RESULT <intersect2,3> ALL NULL NULL NULL NULL NULL NULL
4 EXCEPT NULL NULL NULL NULL NULL NULL NULL NULL No tables used
NULL EXCEPT RESULT <except1,4> ALL NULL NULL NULL NULL NULL NULL
Warnings:
-Note 1003 /* select#1 */ select `__4`.`1` AS `1` from (/* select#2 */ select 1 AS `1` intersect /* select#3 */ select 2 AS `2`) `__4` except /* select#4 */ select 3 AS `3`
+Note 1003 /* select#1 */ select `__4`.`1` AS `1` from (/* select#2 */ select 1 AS `1` intersect all /* select#3 */ select 2 AS `2`) `__4` except /* select#4 */ select 3 AS `3`
(select 1 intersect all select 2 intersect all select 3)
intersect
(select 4 intersect all select 5);
@@ -278,7 +278,7 @@ NULL INTERSECT RESULT <intersect2,3,4> ALL NULL NULL NULL NULL NULL NULL
NULL INTERSECT RESULT <intersect5,6> ALL NULL NULL NULL NULL NULL NULL
NULL INTERSECT RESULT <intersect1,7> ALL NULL NULL NULL NULL NULL NULL
Warnings:
-Note 1003 /* select#1 */ select `__6`.`1` AS `1` from (/* select#2 */ select 1 AS `1` intersect /* select#3 */ select 2 AS `2` intersect /* select#4 */ select 3 AS `3`) `__6` intersect /* select#7 */ select `__7`.`4` AS `4` from (/* select#5 */ select 4 AS `4` intersect /* select#6 */ select 5 AS `5`) `__7`
+Note 1003 /* select#1 */ select `__6`.`1` AS `1` from (/* select#2 */ select 1 AS `1` intersect all /* select#3 */ select 2 AS `2` intersect all /* select#4 */ select 3 AS `3`) `__6` intersect /* select#7 */ select `__7`.`4` AS `4` from (/* select#5 */ select 4 AS `4` intersect /* select#6 */ select 5 AS `5`) `__7`
# test set operations with table value constructor
(values (1,1),(1,1),(1,1),(2,2),(2,2),(3,3),(9,9))
INTERSECT ALL
@@ -571,12 +571,15 @@ EXPLAIN
{
"query_block": {
"select_id": 1,
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -587,12 +590,15 @@ EXPLAIN
"query_block": {
"select_id": 8,
"operation": "UNION",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "<derived2>",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100,
"materialized": {
"query_block": {
@@ -603,12 +609,15 @@ EXPLAIN
{
"query_block": {
"select_id": 2,
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 1,
"rows": 6,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -628,12 +637,15 @@ EXPLAIN
"query_block": {
"select_id": 4,
"operation": "INTERSECT",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "<derived5>",
"access_type": "ALL",
+ "loops": 1,
"rows": 10,
+ "cost": "REPLACED",
"filtered": 100,
"materialized": {
"query_block": {
@@ -642,12 +654,15 @@ EXPLAIN
{
"query_block": {
"select_id": 5,
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -658,12 +673,15 @@ EXPLAIN
"query_block": {
"select_id": 6,
"operation": "UNION",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -692,12 +710,15 @@ EXPLAIN
"query_block": {
"select_id": 7,
"operation": "EXCEPT",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -708,12 +729,15 @@ EXPLAIN
"query_block": {
"select_id": 9,
"operation": "UNION",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 1,
"rows": 6,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -724,12 +748,15 @@ EXPLAIN
"query_block": {
"select_id": 10,
"operation": "UNION",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
}
@@ -740,12 +767,15 @@ EXPLAIN
"query_block": {
"select_id": 11,
"operation": "EXCEPT",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
},
@@ -754,7 +784,9 @@ EXPLAIN
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 5,
"rows": 6,
+ "cost": "REPLACED",
"filtered": 100
},
"buffer_type": "flat",
@@ -769,12 +801,15 @@ EXPLAIN
"query_block": {
"select_id": 12,
"operation": "UNION",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t1",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100,
"attached_condition": "t1.a < 4"
}
@@ -784,7 +819,9 @@ EXPLAIN
"table": {
"table_name": "t2",
"access_type": "ALL",
+ "loops": 5,
"rows": 6,
+ "cost": "REPLACED",
"filtered": 100
},
"buffer_type": "flat",
@@ -799,12 +836,15 @@ EXPLAIN
"query_block": {
"select_id": 13,
"operation": "UNION",
+ "cost": "REPLACED",
"nested_loop": [
{
"table": {
"table_name": "t3",
"access_type": "ALL",
+ "loops": 1,
"rows": 5,
+ "cost": "REPLACED",
"filtered": 100
}
}
generated by cgit v1.2.3 (git 2.39.1) at 2024-10-08 00:29:47 +0000