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

     1  # Tests for the implicit one row, zero column values operator.
     2  query I
     3  SELECT 1
     4  ----
     5  1
     6  
     7  query I
     8  SELECT 1 + 2
     9  ----
    10  3
    11  
    12  query III colnames
    13  VALUES (1, 2, 3), (4, 5, 6)
    14  ----
    15  column1 column2 column3
    16  1       2       3
    17  4       5       6
    18  
    19  query I
    20  VALUES (length('a')), (1 + length('a')), (length('abc')), (length('ab') * 2)
    21  ----
    22  1
    23  2
    24  3
    25  4
    26  
    27  query I
    28  SELECT a + b FROM (VALUES (1, 2), (3, 4), (5, 6)) AS v(a, b)
    29  ----
    30  3
    31  7
    32  11
    33  
    34  query error pgcode 42601 VALUES lists must all be the same length, expected 1 columns, found 2
    35  VALUES (1), (2, 3)
    36  
    37  query I
    38  VALUES (1), (1), (2), (3) ORDER BY 1 DESC LIMIT 3
    39  ----
    40  3
    41  2
    42  1
    43  
    44  query error pgcode 42703 column "z" does not exist
    45  VALUES (1), (1), (2), (3) ORDER BY z
    46  
    47  # subqueries can be evaluated in VALUES
    48  query I
    49  VALUES ((SELECT 1)), ((SELECT 2))
    50  ----
    51  1
    52  2
    53  
    54  query error pgcode 42804 VALUES types string and int cannot be matched
    55  VALUES (NULL, 1), (2, NULL), (NULL, 'a')
    56  
    57  # subqueries in VALUES don't cause problems in EXPLAIN(DISTSQL), despite forcing
    58  # execution on the gateway.
    59  
    60  statement ok
    61  EXPLAIN(DISTSQL) VALUES((SELECT 1), 3)