[ https://issues.apache.org/jira/browse/SPARK-29660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li resolved SPARK-29660. ----------------------------- Resolution: Invalid > Dropping columns and changing column names/types are prohibited in VIEW > definition > ---------------------------------------------------------------------------------- > > Key: SPARK-29660 > URL: https://issues.apache.org/jira/browse/SPARK-29660 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Takeshi Yamamuro > Priority: Major > > In PostgreSQL, the three DDL syntaxes for VIEW cannot be accepted; > {code:java} > -- should fail > CREATE OR REPLACE VIEW viewtest AS > SELECT a FROM viewtest_tbl WHERE a <> 20; > ERROR: cannot drop columns from view > -- should fail > CREATE OR REPLACE VIEW viewtest AS > SELECT 1, * FROM viewtest_tbl; > ERROR: cannot change name of view column "a" to "?column?" > -- should fail > CREATE OR REPLACE VIEW viewtest AS > SELECT a, b::numeric FROM viewtest_tbl; > ERROR: cannot change data type of view column "b" from integer to numeric > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org