error_on_nondeterministic_update - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

error_on_nondeterministic_update

Values (default in bold)

false, true

Description

Specifies whether UPDATE queries with multiple matches per row return an error.

Example

SET error_on_nondeterministic_update TO true; CREATE TABLE t1(x1 int, y1 int); CREATE TABLE t2(x2 int, y2 int); INSERT INTO t1 VALUES (1,10), (2,20), (3,30); INSERT INTO t2 VALUES (2,40), (2,50); UPDATE t1 SET y1=y2 FROM t2 WHERE x1=x2; ERROR: Found multiple matches to update the same tuple.