[Bug] Fe http api response "Select statement must not embed another statement"

[comodohusky]

Search before asking

• I had searched in the issues and found no similar issues.

Version

doris version : 2.1.6

What's Wrong?

When using fe http api to get _query_plan, I found that the "distributed by random buckets auto" would respond "Select statement must not embed another statement".

Table Structure

create table `test6`
(
    `id`    int null,
    `time`  date null,
    `name`  varchar(10) null,
    `count` int sum null
) engine=olap
aggregate key(`id`, `time`, `name`)
distributed by random buckets auto
properties (
"replication_allocation" = "tag.location.default: 1"
);

HTTP Request

POST http://FE_IP:HTTP_PORT/api/test/test6/_query_plan
{"sql": "select * from test.test6;"}

Response Code

{
  "msg": "success",
  "code": 0,
  "data": {
    "exception": "Select statement must not embed another statement",
    "status": 400
  },
  "count": 0
}

What You Expected?

What is the cause of this problem? How can I avoid it?

How to Reproduce?

create table `test6`
(
    `id`    int null,
    `time`  date null,
    `name`  varchar(10) null,
    `count` int sum null
) engine=olap
aggregate key(`id`, `time`, `name`)
distributed by random buckets auto
properties (
"replication_allocation" = "tag.location.default: 1"
);

curl -X POST -u 'root:' -H 'Content-Type:application/json' 'http://fe_host:http_port/api/test/test6/_query_plan' -d '{"sql": "select * from test.test6;"}'

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct