github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/logictestccl/testdata/logic_test/case_sensitive_names (about) 1 # LogicTest: local 2 3 statement ok 4 CREATE TABLE p (a INT PRIMARY KEY) PARTITION BY LIST (a) ( 5 PARTITION P1 VALUES IN (1), 6 PARTITION "P1" VALUES IN (2), 7 PARTITION "Amélie" VALUES IN (3) 8 ) 9 10 query TT 11 SHOW CREATE TABLE p 12 ---- 13 p CREATE TABLE p ( 14 a INT8 NOT NULL, 15 CONSTRAINT "primary" PRIMARY KEY (a ASC), 16 FAMILY "primary" (a) 17 ) PARTITION BY LIST (a) ( 18 PARTITION p1 VALUES IN ((1)), 19 PARTITION "P1" VALUES IN ((2)), 20 PARTITION "Amélie" VALUES IN ((3)) 21 ) 22 -- Warning: Partitioned table with no zone configurations.