DISCARD

Calculates SELECT without returning the result neither to 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;