github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/parallel_test/subquery_retry/txn (about)

     1  # This test verifies that the results of the subquery are consistent with the transaction. If we
     2  # inadvertently reuse the previous results of the subquery during a retry, we might insert
     3  # duplicate values.
     4  
     5  repeat 50
     6  statement ok
     7  INSERT INTO T VALUES ((SELECT max(k+1) FROM T))