This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit a640ca5aafae3a26683cc4272f65c4a434b54fa3
Author: starocean999 <40539150+starocean...@users.noreply.github.com>
AuthorDate: Wed Jan 31 13:26:57 2024 +0800
[fix](planner)LateralViewRef's toSql method is not correctly implemented
(#30590)
---
fe/fe-core/src/main/java/org/apache/doris/analysis/LateralViewRef.java | 2 +-
regression-test/suites/query_p0/lateral_view/test_with_view.groovy | 2 ++
2 files changed, 3 insertions(+), 1 deletion(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/analysis/LateralViewRef.java
b/fe/fe-core/src/main/java/org/apache/doris/analysis/LateralViewRef.java
index de54df86320..6ce28290841 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/analysis/LateralViewRef.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/analysis/LateralViewRef.java
@@ -198,7 +198,7 @@ public class LateralViewRef extends TableRef {
@Override
public String toSql() {
- return "lateral view " + expr.toSql() + " " + viewName + " as " +
columnName;
+ return "lateral view " + expr.toSql() + " `" + viewName + "` as `" +
columnName + "`";
}
@Override
diff --git a/regression-test/suites/query_p0/lateral_view/test_with_view.groovy
b/regression-test/suites/query_p0/lateral_view/test_with_view.groovy
index d2f5fba7b6e..f71ad804067 100644
--- a/regression-test/suites/query_p0/lateral_view/test_with_view.groovy
+++ b/regression-test/suites/query_p0/lateral_view/test_with_view.groovy
@@ -57,4 +57,6 @@ suite("lateral_view_with_inline_view") {
group by 1
order by 1;
"""
+ sql """create view xx_lateral as select example1.col1 from (select
col1,`col4`,col2 from t1 where col3<=115411) example1 lateral view
explode([1,2,3]) tmp1 as `e1 aa`;"""
+ sql """drop view xx_lateral"""
}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
