yuzefovich/24.2 QA: CREATE STATISTICS default AS OF SYSTEM TIME.md

## 24.2 QA: CREATE STATISTICS default AS OF SYSTEM TIME.md

      
    Raw
  

              24.2 QA: CREATE STATISTICS default AS OF SYSTEM TIME.md
            
          
    Add the AOST information into the DistSQL diagram (cockroachdb/cockroach#127583)
to make it easier to confirm that the AOST is added implicitly.
CREATE TABLE t (k INT PRIMARY KEY);
INSERT INTO t SELECT generate_series(1, 100);
Test that in miscellaneous scenarios the inconsistent scan is used:
EXPLAIN (DISTSQL) CREATE STATISTICS s FROM t;
EXPLAIN (DISTSQL) CREATE STATISTICS s FROM t AS OF SYSTEM TIME '-1s';
EXPLAIN (DISTSQL) CREATE STATISTICS s FROM t AS OF SYSTEM TIME '+1s';
EXPLAIN (DISTSQL) CREATE STATISTICS s FROM t WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME '-1s';
EXPLAIN (DISTSQL) CREATE STATISTICS s FROM t WITH OPTIONS THROTTLING 0.9;
EXPLAIN (DISTSQL) CREATE STATISTICS s ON k FROM t;