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

     1  statement ok
     2  CREATE TABLE a (a INT PRIMARY KEY, b INT)
     3  
     4  query error statement source "INSERT INTO a VALUES \(1, 2\)" does not return any columns
     5  SELECT 1 FROM [INSERT INTO a VALUES (1, 2)]
     6  
     7  query error statement source "DELETE FROM a" does not return any columns
     8  SELECT 1 FROM [DELETE FROM a]
     9  
    10  query II
    11  SELECT @1, a+b FROM [INSERT INTO a VALUES (1,2) RETURNING b,a]
    12  ----
    13  2 3
    14  
    15  # Check that LIMIT does not apply to mutation statements
    16  query II
    17    WITH a AS (INSERT INTO a VALUES (2,3), (3,4) RETURNING a,b)
    18  SELECT * FROM a LIMIT 0
    19  ----
    20  
    21  query II
    22  SELECT * FROM [INSERT INTO a VALUES (4,5), (5,6) RETURNING a,b] LIMIT 0
    23  ----
    24  
    25  query II
    26    WITH a AS (UPSERT INTO a VALUES (2,3), (6,7) RETURNING a,b)
    27  SELECT * FROM a LIMIT 0
    28  ----
    29  
    30  query II
    31  SELECT * FROM [UPSERT INTO a VALUES (4,5), (7,8) RETURNING a,b] LIMIT 0
    32  ----
    33  
    34  
    35  query II
    36    WITH a AS (UPDATE a SET a = -a WHERE b % 2 = 1 RETURNING a,b)
    37  SELECT * FROM a LIMIT 0
    38  ----
    39  
    40  query II
    41  SELECT * FROM [UPDATE a SET a = a*100 WHERE b < 3 RETURNING a,b] LIMIT 0
    42  ----
    43  
    44  query II
    45  SELECT * FROM a ORDER BY b
    46  ----
    47  100  2
    48  -2   3
    49  3    4
    50  -4   5
    51  5    6
    52  -6   7
    53  7    8
    54  
    55  query II
    56    WITH a AS (DELETE FROM a WHERE b IN (4,5) RETURNING a,b)
    57  SELECT * FROM a LIMIT 0
    58  ----
    59  
    60  query II
    61  SELECT * FROM [DELETE FROM a WHERE b IN (6,7) RETURNING a,b] LIMIT 0
    62  ----
    63  
    64  
    65  query II
    66  SELECT * FROM a ORDER BY b
    67  ----
    68  100  2
    69  -2   3
    70  7    8
    71  
    72  # Regression for #30936: ensure that wrapped planNodes with non-needed columns work ok
    73  
    74  statement ok
    75  CREATE TABLE b (a int, b int);
    76  
    77  query II
    78  SELECT * FROM (VALUES (1, 2)) WHERE EXISTS (SELECT * FROM [INSERT INTO b VALUES (1,2) RETURNING a,b]);
    79  ----
    80  1 2
    81  
    82  query I
    83  SELECT 1 FROM [INSERT INTO b VALUES(2,3) RETURNING b] JOIN [INSERT INTO b VALUES(4,5) RETURNING b] ON true;
    84  ----
    85  1
    86  
    87  query III
    88  SELECT * FROM [INSERT INTO b VALUES(2,3) RETURNING b] JOIN [INSERT INTO b VALUES(4,5) RETURNING b, a] ON true;
    89  ----
    90  3 5 4
    91  
    92  subtest unsupported_47333
    93  
    94  query error unimplemented: cannot use SHOW SAVEPOINT STATUS as a statement source
    95  SELECT * FROM [SHOW SAVEPOINT STATUS]