[SPARK-16937] Confusing behaviors when View and Temp View sharing the same names

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.0.0
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Unassigned
• Reporter: Xiao Li
• Created: 07/Aug/16 07:31
• Updated: 21/May/19 04:36
• Resolved: 21/May/19 04:36

Description

        sql(s"CREATE TEMPORARY VIEW $viewName AS SELECT * FROM $tabName WHERE ID < 3")
        sql(s"CREATE VIEW $viewName AS SELECT * FROM $tabName")
        // This returns the contents of the temp view.
        sql(s"select * from $viewName").show(false)
        // This returns the contents of the view.
        sql(s"select * from default.$viewName").show(false)

        // Below is to drop the temp view
        sql(s"DROP VIEW $viewName")
        // Both results are non-temp view
        sql(s"select * from $viewName").show(false)
        sql(s"select * from default.$viewName").show(false)

        // After another drop, the non-temp view is dropped.
        sql(s"DROP VIEW $viewName")