You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE hello(a INTEGER, b VARCHAR, c VARCHAR);
-- note that table hello has no data
CREATE VIEW test AS (SELECT SUM(a), COUNT(c), b FROM hello WHERE b = 'true' GROUP BY b);
PRAGMA ivm_upsert('memory', 'main', 'test');
The logical plan that we modify to incrementally maintain view test is for query SELECT SUM(a), COUNT(c), b FROM hello WHERE b = 'true' GROUP BY b. It will look like below, because the FILTER gets pushed down. This happens becausehello has no data, and also happens if the filter clause produces no data.
Assume the following series of queries:
The logical plan that we modify to incrementally maintain view
test
is for querySELECT SUM(a), COUNT(c), b FROM hello WHERE b = 'true' GROUP BY b
. It will look like below, because theFILTER
gets pushed down. This happens becausehello
has no data, and also happens if the filter clause produces no data.The text was updated successfully, but these errors were encountered: