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

     1  # LogicTest: fakedist
     2  
     3  # Regression tests for weird explain analyze cases.
     4  
     5  statement ok
     6  EXPLAIN ANALYZE (DISTSQL) CREATE TABLE a (a INT PRIMARY KEY)
     7  
     8  statement ok
     9  EXPLAIN ANALYZE (DISTSQL) CREATE INDEX ON a(a)
    10  
    11  statement ok
    12  EXPLAIN ANALYZE (DISTSQL) INSERT INTO a VALUES (1)
    13  
    14  # Make sure failures are okay.
    15  statement error duplicate
    16  EXPLAIN ANALYZE (DISTSQL) INSERT INTO a VALUES (1)
    17  
    18  statement error value type string doesn't match type int of column "a"
    19  EXPLAIN ANALYZE (DISTSQL) INSERT INTO a VALUES ('a'::string)
    20  
    21  statement ok
    22  EXPLAIN ANALYZE (DISTSQL) INSERT INTO a SELECT a+1 FROM a
    23  
    24  statement ok
    25  EXPLAIN ANALYZE (DISTSQL) UPDATE a SET a = a*3
    26  
    27  statement ok
    28  EXPLAIN ANALYZE (DISTSQL) UPDATE a SET a = a*3 RETURNING a
    29  
    30  statement ok
    31  EXPLAIN ANALYZE (DISTSQL) UPSERT INTO a VALUES(10)
    32  
    33  statement error EXPLAIN ANALYZE does not support RETURNING NOTHING statements
    34  EXPLAIN ANALYZE (DISTSQL) UPSERT INTO a VALUES(11) RETURNING NOTHING
    35  
    36  statement ok
    37  EXPLAIN ANALYZE (DISTSQL) SELECT (SELECT 1);
    38  
    39  statement ok
    40  EXPLAIN ANALYZE (DISTSQL) DELETE FROM a
    41  
    42  statement ok
    43  EXPLAIN ANALYZE (DISTSQL) DROP TABLE a
    44  
    45  # Tests with EXPLAIN ANALYZE and subqueries.
    46  
    47  statement ok
    48  CREATE TABLE a (a INT PRIMARY KEY)
    49  
    50  statement ok
    51  INSERT INTO a VALUES(1)
    52  
    53  statement ok
    54  PREPARE x AS EXPLAIN ANALYZE(DISTSQL) SELECT 1 WHERE EXISTS (SELECT * FROM a WHERE a = $1) AND EXISTS (SELECT 1 WHERE EXISTS (SELECT * FROM a WHERE a = $2))
    55  
    56  statement ok
    57  EXECUTE x(1, 2)
    58  
    59  statement ok
    60  PREPARE y AS EXPLAIN ANALYZE(DISTSQL) SELECT 1 WHERE EXISTS (SELECT * FROM a WHERE a = $1) AND EXISTS (SELECT 1 WHERE EXISTS (SELECT * FROM a WHERE a = $1))
    61  
    62  statement ok
    63  EXECUTE x(1, 1)
    64  
    65  # Regression test for #34927.
    66  statement ok
    67  EXPLAIN ANALYZE (DISTSQL) DELETE FROM a WHERE true
    68  
    69  # Regression test for #45099 (not running postqueries with EXPLAIN ANALYZE).
    70  statement ok
    71  CREATE TABLE p (p INT8 PRIMARY KEY);
    72  CREATE TABLE c (c INT8 PRIMARY KEY, p INT8 REFERENCES p (p))
    73  
    74  query error pgcode 23503 insert on table \"c\" violates foreign key constraint \"fk_p_ref_p\"
    75  EXPLAIN ANALYZE (DISTSQL) INSERT INTO c SELECT x, x + 1 FROM (VALUES (1), (2)) AS v (x)