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

     1  statement ok
     2  CREATE TABLE bools (a INT, b BOOL)
     3  
     4  query BB
     5  SELECT bool_and(b), bool_or(b) FROM bools
     6  ----
     7  NULL NULL
     8  
     9  query BB
    10  SELECT bool_and(b), bool_or(b) FROM bools GROUP BY a
    11  ----
    12  
    13  statement OK
    14  INSERT INTO bools VALUES
    15  (0, NULL),
    16  (1, true),  (1, true),
    17  (2, false), (2, false),
    18  (3, false), (3, true), (3, true),
    19  (4, NULL),  (4, true),
    20  (5, false), (5, NULL)
    21  
    22  query BB rowsort
    23  SELECT bool_and(b), bool_or(b) FROM bools GROUP BY a;
    24  ----
    25  NULL NULL
    26  true true
    27  false false
    28  false true
    29  true true
    30  false false