morningman opened a new issue, #70529:
URL: https://github.com/apache/doris/issues/70529
Track the engine failure reported in apache/doris-website#3828. The
documentation issue will be closed in favor of this engine issue.
The reporter says the direct query succeeds:
```sql
SELECT yjsj FROM es_.default_db.theme_jzxxb LIMIT 10;
```
But the equivalent CTE query fails:
```sql
WITH node_xxx AS (
SELECT yjsj FROM es_.default_db.theme_jzxxb
)
SELECT * FROM node_xxx LIMIT 10;
```
Relevant error/plan excerpt:
```text
Input slot(s) not in child's output: yjsj#18
LogicalProject (projects=[yjsj#18 AS `yjsj`#9])
child output: [address#19, content#20, fssj#21, groupName#22, mtype#23,
rawContent#24, tzzhm#25, tzzlx#26, yjsj#27]
+--LogicalEsScan (qualified=es_.default_db.theme_jzxxb)
```
Expected: both queries return data without a slot-validation error.
The report does not supply the Doris version/build, ES version, catalog DDL,
or index mapping. The slot identifiers indicate a planner mapping mismatch in
the reported plan, but the cause and affected versions have not been
independently established. A previous analysis mentioned #63315 / #63708 as
potentially related; that is a hypothesis to check against the exact build, not
a confirmed fix for this report.
Original report, full stack trace, and prior discussion:
https://github.com/apache/doris-website/issues/3828
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
