In memSQL documentation it is written " Running
DROP TABLE on a table referenced by a view will give an error."
But, I am able to drop table which has a view on top of it. Followed below steps…
step 1 : CREATE VIEW rtl.products_test_vw AS SELECT * FROM rtl.products_test
Step 2: select count() from rtl.products_test_vw
Step 3 : DROP TABLE rtl.products_test;
Table rtl.products_test dropped
Step 4: select count(*) from rtl.products_test_vw
An error occurred when executing the SQL command:
(conn=536559) Table ‘rtl.products_test’ doesn’t exist
This behavior is in sync with other databases. But , I am new to memSQL.
Please let know if I am missing something here.