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

     1  statement ok
     2  DROP TABLE IF EXISTS t; CREATE TABLE t (k INT PRIMARY KEY, a INT, b INT)
     3  
     4  statement ok
     5  INSERT INTO t VALUES (1, NULL, NULL), (2, NULL, 1), (3, 1, NULL), (4, 2, 0), (5, 3, 3)
     6  
     7  # Test AND short-circuiting projection logic (check that the right side is not
     8  # evaluated when the left side is false).
     9  query B
    10  SELECT a <> 2 AND 3 / b = 1 FROM t ORDER BY k
    11  ----
    12  NULL
    13  false
    14  NULL
    15  false
    16  true
    17  
    18  # Test AND short-circuiting selection logic (check that the right side is not
    19  # evaluated when the left side is false).
    20  query I
    21  SELECT a FROM t WHERE a <> 2 AND 3 / b = 1 ORDER BY k
    22  ----
    23  3
    24  
    25  # Test OR short-circuiting projection logic (check that the right side is not
    26  # evaluated when the left side is true).
    27  query B
    28  SELECT a = 2 OR 3 / b = 1 FROM t ORDER BY k
    29  ----
    30  NULL
    31  NULL
    32  NULL
    33  true
    34  true
    35  
    36  # Test OR short-circuiting selection logic (check that the right side is not
    37  # evaluated when the left side is true).
    38  query I
    39  SELECT a FROM t WHERE a = 2 OR 3 / b = 1 ORDER BY k
    40  ----
    41  2
    42  3