The strategy used to evaluate a SQL condition trigger against a query result set.
SQL_CONDITION_TRIGGER_MODE_UNSPECIFIED: Sentinel zero-value. Not a valid input — the
validator rejects this when sent explicitly. Internally treated as QUERY_RETURNS_ROWS
when reading legacy data that predates this field.
QUERY_RETURNS_ROWS: Fires whenever the result set has at least one row. Zero rows means
the condition is not met. This is the original SQL condition behavior.
RESULT_VALUE_CHANGES: Fires whenever the query's single result value differs from the
previous evaluation. The first evaluation always fires. Queries must return exactly one
cell (one row, one column).
The strategy used to evaluate a SQL condition trigger against a query result set.
SQL_CONDITION_TRIGGER_MODE_UNSPECIFIED: Sentinel zero-value. Not a valid input — the validator rejects this when sent explicitly. Internally treated asQUERY_RETURNS_ROWSwhen reading legacy data that predates this field.QUERY_RETURNS_ROWS: Fires whenever the result set has at least one row. Zero rows means the condition is not met. This is the original SQL condition behavior.RESULT_VALUE_CHANGES: Fires whenever the query's single result value differs from the previous evaluation. The first evaluation always fires. Queries must return exactly one cell (one row, one column).