github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/logictestccl/testdata/logic_test/crdb_internal (about) 1 # LogicTest: local 2 3 query IITTITTTII colnames 4 SELECT * FROM crdb_internal.partitions 5 ---- 6 table_id index_id parent_name name columns column_names list_value range_value zone_id subzone_id 7 8 statement ok 9 CREATE TABLE t1 ( 10 a INT, 11 b INT, 12 c INT, 13 PRIMARY KEY (a, b, c), 14 INDEX (a, b) PARTITION BY LIST (a, b) ( 15 PARTITION p00 VALUES IN ((0, 0)) 16 ) 17 ) PARTITION BY LIST (a) ( 18 PARTITION p12 VALUES IN (1, 2) PARTITION BY LIST (b) ( 19 PARTITION p12p3 VALUES IN (3) PARTITION BY LIST (c) ( 20 PARTITION p12p3p8 VALUES IN (8) 21 ), 22 PARTITION pd VALUES IN (DEFAULT) 23 ), 24 PARTITION p6 VALUES IN (6) PARTITION BY RANGE (b) ( 25 PARTITION p6p7 VALUES FROM (MINVALUE) TO (7), 26 PARTITION p6p8 VALUES FROM (7) TO (8), 27 PARTITION p6px VALUES FROM (8) TO (MAXVALUE) 28 ) 29 ) 30 31 statement ok 32 CREATE table t2 (a STRING PRIMARY KEY) PARTITION BY LIST (a) ( 33 PARTITION pfoo VALUES IN ('foo') 34 ) 35 36 # Since there are no zone configurations on any of these partitions, tables, 37 # or databases, these partitions inherit directly from the default config. 38 query IITTITTTII 39 SELECT * FROM crdb_internal.partitions ORDER BY table_id, index_id, name 40 ---- 41 53 1 NULL p12 1 a (1), (2) NULL 0 0 42 53 1 p12 p12p3 1 b (3) NULL 0 0 43 53 1 p12p3 p12p3p8 1 c (8) NULL 0 0 44 53 1 NULL p6 1 a (6) NULL 0 0 45 53 1 p6 p6p7 1 b NULL (MINVALUE) TO (7) 0 0 46 53 1 p6 p6p8 1 b NULL (7) TO (8) 0 0 47 53 1 p6 p6px 1 b NULL (8) TO (MAXVALUE) 0 0 48 53 1 p12 pd 1 b (DEFAULT) NULL 0 0 49 53 2 NULL p00 2 a, b (0, 0) NULL 0 0 50 54 1 NULL pfoo 1 a ('foo') NULL 0 0 51 52 # Test crdb_internal.zones functions correctly on zoned indexes. 53 subtest privileged_zones_test 54 55 statement ok 56 CREATE DATABASE db2; ALTER DATABASE db2 CONFIGURE ZONE USING num_replicas = 3; 57 58 statement ok 59 CREATE TABLE t3 (a INT PRIMARY KEY, b INT); CREATE INDEX myt3index ON t3 (b); ALTER INDEX myt3index CONFIGURE ZONE USING num_replicas = 5; ALTER TABLE t3 CONFIGURE ZONE USING num_replicas = 8 60 61 statement ok 62 CREATE TABLE t4 (a INT PRIMARY KEY, b INT); CREATE INDEX myt4index ON t4 (b); ALTER TABLE t4 CONFIGURE ZONE USING num_replicas = 7; ALTER INDEX myt4index CONFIGURE ZONE USING num_replicas = 5; GRANT ALL ON t4 TO testuser 63 64 user testuser 65 66 query IT 67 SELECT zone_id, target FROM crdb_internal.zones ORDER BY 1 68 ---- 69 0 RANGE default 70 16 RANGE meta 71 17 RANGE system 72 22 RANGE liveness 73 57 TABLE test.public.t4 74 57 INDEX test.public.t4@myt4index 75 76 query TT 77 SELECT * FROM [SHOW ALL ZONE CONFIGURATIONS] ORDER BY 1 78 ---- 79 INDEX test.public.t4@myt4index ALTER INDEX test.public.t4@myt4index CONFIGURE ZONE USING 80 num_replicas = 5 81 RANGE default ALTER RANGE default CONFIGURE ZONE USING 82 range_min_bytes = 134217728, 83 range_max_bytes = 536870912, 84 gc.ttlseconds = 90000, 85 num_replicas = 3, 86 constraints = '[]', 87 lease_preferences = '[]' 88 RANGE liveness ALTER RANGE liveness CONFIGURE ZONE USING 89 range_min_bytes = 134217728, 90 range_max_bytes = 536870912, 91 gc.ttlseconds = 600, 92 num_replicas = 5, 93 constraints = '[]', 94 lease_preferences = '[]' 95 RANGE meta ALTER RANGE meta CONFIGURE ZONE USING 96 range_min_bytes = 134217728, 97 range_max_bytes = 536870912, 98 gc.ttlseconds = 3600, 99 num_replicas = 5, 100 constraints = '[]', 101 lease_preferences = '[]' 102 RANGE system ALTER RANGE system CONFIGURE ZONE USING 103 range_min_bytes = 134217728, 104 range_max_bytes = 536870912, 105 gc.ttlseconds = 90000, 106 num_replicas = 5, 107 constraints = '[]', 108 lease_preferences = '[]' 109 TABLE test.public.t4 ALTER TABLE test.public.t4 CONFIGURE ZONE USING 110 num_replicas = 7 111 112 query error pq: user testuser has no privileges on database db2 113 SHOW ZONE CONFIGURATION FOR DATABASE db2 114 115 query error pq: user testuser has no privileges on relation t2 116 SHOW ZONE CONFIGURATION FOR TABLE t2 117 118 query error pq: user testuser has no privileges on relation t3 119 SHOW ZONE CONFIGURATION FOR TABLE t3 120 121 query error pq: user testuser has no privileges on relation t3 122 SHOW ZONE CONFIGURATION FOR INDEX myt3index 123 124 query TT 125 SHOW ZONE CONFIGURATION FOR INDEX myt4index 126 ---- 127 INDEX test.public.t4@myt4index ALTER INDEX test.public.t4@myt4index CONFIGURE ZONE USING 128 range_min_bytes = 134217728, 129 range_max_bytes = 536870912, 130 gc.ttlseconds = 90000, 131 num_replicas = 5, 132 constraints = '[]', 133 lease_preferences = '[]' 134 135 query TT 136 SHOW ZONE CONFIGURATION FOR TABLE t4 137 ---- 138 TABLE t4 ALTER TABLE t4 CONFIGURE ZONE USING 139 range_min_bytes = 134217728, 140 range_max_bytes = 536870912, 141 gc.ttlseconds = 90000, 142 num_replicas = 7, 143 constraints = '[]', 144 lease_preferences = '[]' 145 146 query TT 147 SHOW ZONE CONFIGURATION FOR RANGE default 148 ---- 149 RANGE default ALTER RANGE default CONFIGURE ZONE USING 150 range_min_bytes = 134217728, 151 range_max_bytes = 536870912, 152 gc.ttlseconds = 90000, 153 num_replicas = 3, 154 constraints = '[]', 155 lease_preferences = '[]' 156 157 # This test checks that generator backed tables do not concurrently 158 # access transactions. It does this by scanning two virtual tables at a time. 159 # If the background generator functions were performing work when not allowed 160 # to, the background generators would conflict with an error. 161 statement ok 162 SELECT a.* FROM crdb_internal.partitions AS a JOIN crdb_internal.partitions AS b ON a.table_id = b.table_id