Variable SqlConditionTriggerModeConst
SqlConditionTriggerMode: {
QUERY_RETURNS_ROWS: "QUERY_RETURNS_ROWS";
RESULT_VALUE_CHANGES: "RESULT_VALUE_CHANGES";
SQL_CONDITION_TRIGGER_MODE_UNSPECIFIED: "";
} = ...
Type Declaration
ReadonlyQUERY_RETURNS_ROWS: "QUERY_RETURNS_ROWS"
ReadonlyRESULT_VALUE_CHANGES: "RESULT_VALUE_CHANGES"
ReadonlySQL_CONDITION_TRIGGER_MODE_UNSPECIFIED: ""
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).