DROP and CREATE TABLE

[jarulraj]

Search before asking

• I have searched the EvaDB issues and found no similar bug report.

Bug

-- No error if it the table exists
-- Error as the table does not exist
DROP TABLE StargazerDetails;

-- No error if it the table exists
-- No error if it the table does not exist
DROP TABLE IF EXISTS StargazerDetails;

-- Error if the table already exists
-- No error if the table does not exist
CREATE TABLE StargazerDetails AS
SELECT GithubUserdetails(github_username, "{github_pat}")
FROM StargazerList;

-- No error if the table already exists
-- No error if the table does not exist
CREATE TABLE IF NOT EXISTS StargazerDetails AS
SELECT GithubUserdetails(github_username, "{github_pat}")
FROM StargazerList;

Environment

Need to add unit tests for all four cases.

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!