github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/testutils/reduce/reducesql/testdata/simple (about)

     1  contains
     2  division by zero
     3  ----
     4  
     5  reduce
     6  WITH
     7  	with_t1 (c1, c2)
     8  		AS (
     9  			SELECT 1, 1/0
    10  		)
    11  SELECT * FROM with_t1
    12  ----
    13  SELECT 1 / 0;
    14  
    15  reduce
    16  WITH
    17  	w
    18  		AS (
    19  			VALUES
    20  				(1),
    21  				(2),
    22  				((1 / 0)::INT8)
    23  		)
    24  SELECT
    25  	*
    26  FROM
    27  	w;
    28  ----
    29  VALUES (1 / 0);
    30  
    31  reduce
    32  SELECT
    33  	1 / 0
    34  FROM
    35  	(SELECT 1), (SELECT 2);
    36  ----
    37  SELECT 1 / 0;
    38  
    39  reduce
    40  CREATE TABLE a (i) AS VALUES (1);
    41  
    42  CREATE TABLE b (j) AS VALUES (0);
    43  
    44  SELECT
    45  	c.i / j
    46  FROM
    47  	a, a AS c JOIN b ON true;
    48  ----
    49  ----
    50  CREATE TABLE a (i) AS VALUES (1);
    51  
    52  CREATE TABLE b (j) AS VALUES (0);
    53  
    54  SELECT c.i / j FROM a AS c JOIN b ON true;
    55  ----
    56  ----
    57  
    58  contains
    59  no data source matches prefix
    60  ----
    61  
    62  reduce
    63  SELECT
    64  	set_masklen(
    65  		'4ac:ded4:393a:a371:7690:9d0f:4817:3371/43',
    66  		tab_1226.col5
    67  	);
    68  ----
    69  SELECT set_masklen(NULL, tab_1226.col5);