Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
None
Description
create table t2 (a int, b int); |
insert into t2 select seq/100, seq from seq_1_to_1000; |
explain format=json select distinct 1+max(b) from t2 group by a; |
gives
"query_block": {
|
"select_id": 1,
|
"filesort": {
|
"sort_key": "t2.a",
|
"duplicate_removal": {
|
"temporary_table": {
|
"temporary_table": {
|
"nested_loop": [
|
{
|
"table": {
|
"table_name": "t2",
|
"access_type": "ALL",
|
"rows": 1000,
|
"filtered": 100
|
}
|
}
|
]
|
}
|
}
|
}
|
}
|
}
|
}
|
note the
"temporary_table": {
|
"temporary_table": {
|
part.
This doesn't allow one to understand the purpose of the temporary tables.
Attachments
Issue Links
- relates to
-
-
- Closed
-