[DRILL-1136] Create view replaces the same existing view

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Writer
• Assignee: Venki Korukanti
• Reporter: Krystal
• Created: 11/Jul/14 23:12
• Updated: 15/Sep/15 17:52
• Resolved: 21/Jul/14 02:48

Description

git.commit.id.abbrev=5b57294

Currently, an existing view can be replaced by using "create view" syntax. For example, I have an existing view named student_v . Then I run a create view with the same name:

0: jdbc:drill:schema=dfs> create view student_v as select * from voter;
----------------------+

ok

summary

----------------------+

true	View 'student_v' replaced successfully in 'dfs.default' schema

----------------------+
1 row selected (0.544 seconds)

Like oracle and postgres, this should not be allowed. A user needs to use "create or replace view ..." syntax.