Materialized View Tables Incompatible with Table Command Regex #6
Description
The regex used to parse table commands identified below does not currently allow for creating a table based on a query. This prevents the use of tables as materialized views.
Example
create_table :long_query,
as: "SELECT * FROM orders INNER JOIN line_items ON order_id=orders.id")generates:
CREATE TABLE "long_query" AS
SELECT * FROM orders INNER JOIN line_items ON order_id=orders.id