Skip to content

[Bug](Lateral View) Create incorrect view when view includes the lateral view #9529

@EmmyMiao87

Description

@EmmyMiao87

Search before asking

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

Version

Doris 1.0.0

What's Wrong?

ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'topic_id' in 't'

What You Expected?

Return result

How to Reproduce?

  1. create table dwd_content_create_base with column topic_ids
  2. create view
 CREATE VIEW `tmp_1` AS SELECT `t`.`topic_id` AS `topic_id` FROM (SELECT `topic_ids` AS `topic_ids` FROM `dwd_content_create_base`) t1 lateral view explode_split(`t1`.`topic_ids`, ',') t as topic_id;
  1. query
select topic_id from tmp_1

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    area/lateral-viewarea/plannerIssues or PRs related to the query plannerarea/viewIssues or PRS related to viewkind/fixCategorizes issue or PR as related to a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions