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