DISCARD
Calculates SELECT, PROCESS, or REDUCE, but doesn't return the result to either the client or table.
It's good to combine it with Ensure to check the final calculation result against the user's criteria.
Examples
DISCARD SELECT 1;
INSERT INTO result_table WITH TRUNCATE
SELECT * FROM
my_table
WHERE value % 2 == 0;
COMMIT:
DISCARD SELECT Ensure(
0, -- will discard result anyway
COUNT(*) > 1000,
"Too small result table, got only " || CAST(COUNT(*) AS String) || " rows"
) FROM result_table;