github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_subpartition.align-only.golden.short (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 CREATE TABLE students ( 6 id SERIAL8, 7 name STRING, 8 email STRING, 9 country STRING, 10 expected_graduation_date DATE, 11 PRIMARY KEY ( 12 country, 13 expected_graduation_date, 14 id 15 ) 16 ) PARTITION BY LIST (country) ( 17 PARTITION australia 18 VALUES IN ( 19 'AU', 20 'NZ' 21 ) 22 PARTITION BY RANGE ( 23 expected_graduation_date 24 ) 25 ( 26 PARTITION graduated_au 27 VALUES FROM ( 28 minvalue 29 ) 30 TO ( 31 '2017-08-15' 32 ), 33 PARTITION current_au 34 VALUES FROM ( 35 '2017-08-15' 36 ) 37 TO ( 38 maxvalue 39 ) 40 ), 41 PARTITION north_america 42 VALUES IN ( 43 'US', 44 'CA' 45 ) 46 PARTITION BY RANGE ( 47 expected_graduation_date 48 ) 49 ( 50 PARTITION graduated_us 51 VALUES FROM ( 52 minvalue 53 ) 54 TO ( 55 '2017-08-15' 56 ), 57 PARTITION current_us 58 VALUES FROM ( 59 '2017-08-15' 60 ) 61 TO ( 62 maxvalue 63 ) 64 ) 65 ) 66 67