blob: f3397db5e6e3ac77b18906efc52e1ff71d59b308 [file] [log] [blame]
-- @Description Tests that DML operatins change the modification count.
--
DROP TABLE IF EXISTS ao;
CREATE TABLE ao (a INT, b INT) USING @amname@;
INSERT INTO ao SELECT i as a, i as b FROM generate_series(1,10) AS i;
SELECT state, tupcount, modcount FROM gp_ao_or_aocs_seg('ao');
INSERT INTO ao VALUES (11, 11);
SELECT state, tupcount, modcount FROM gp_ao_or_aocs_seg('ao');
DELETE FROM ao WHERE a = 11;
SELECT state, tupcount, modcount FROM gp_ao_or_aocs_seg('ao');
UPDATE AO SET b = 0 WHERE a = 10;
SELECT state, tupcount, modcount FROM gp_ao_or_aocs_seg('ao');