github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_subpartition.ref.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
     7  		SERIAL8,
     8  	name
     9  		STRING,
    10  	email
    11  		STRING,
    12  	country
    13  		STRING,
    14  	expected_graduation_date
    15  		DATE,
    16  	PRIMARY KEY (
    17  		country,
    18  		expected_graduation_date,
    19  		id
    20  	)
    21  )
    22  	PARTITION BY LIST (country)
    23  		(
    24  			PARTITION australia
    25  				VALUES IN ('AU', 'NZ')
    26  				PARTITION BY RANGE (
    27  					expected_graduation_date
    28  				)
    29  					(
    30  						PARTITION graduated_au
    31  							VALUES FROM (
    32  								minvalue
    33  							)
    34  							TO (
    35  								'2017-08-15'
    36  							),
    37  						PARTITION current_au
    38  							VALUES FROM (
    39  								'2017-08-15'
    40  							)
    41  							TO (
    42  								maxvalue
    43  							)
    44  					),
    45  			PARTITION north_america
    46  				VALUES IN ('US', 'CA')
    47  				PARTITION BY RANGE (
    48  					expected_graduation_date
    49  				)
    50  					(
    51  						PARTITION graduated_us
    52  							VALUES FROM (
    53  								minvalue
    54  							)
    55  							TO (
    56  								'2017-08-15'
    57  							),
    58  						PARTITION current_us
    59  							VALUES FROM (
    60  								'2017-08-15'
    61  							)
    62  							TO (
    63  								maxvalue
    64  							)
    65  					)
    66  		)
    67  
    68