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

     1  # LogicTest: fakedist
     2  
     3  # This is a regression test for #43269 - incomplete shutdown of the vectorized
     4  # flows with wrapped processors.
     5  
     6  statement ok
     7  CREATE TABLE square (n INT PRIMARY KEY, sq INT)
     8  
     9  statement ok
    10  INSERT INTO square VALUES (1,1), (2,4), (3,9), (4,16), (5,25), (6,36)
    11  
    12  statement ok
    13  CREATE TABLE pairs (a INT8, b INT8, FAMILY (a), FAMILY (b))
    14  
    15  statement ok
    16  INSERT INTO pairs VALUES (1,1), (1,2), (1,3), (1,4), (1,5), (1,6), (2,3), (2,4), (2,5), (2,6), (3,4), (3,5), (3,6), (4,5), (4,6)
    17  
    18  statement ok
    19  SELECT
    20  	*
    21  FROM
    22  	(
    23  		SELECT
    24  			*
    25  		FROM
    26  			pairs
    27  			LEFT JOIN square ON b = sq AND a > 1 AND n < 6
    28  	)
    29  WHERE
    30  	b > 1 AND (n IS NULL OR n > 1) AND (n IS NULL OR a < sq)