github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_partition_range.ref.golden (about)

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5  CREATE TABLE students_by_range (
     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  		expected_graduation_date,
    18  		id
    19  	)
    20  )
    21  	PARTITION BY RANGE (
    22  		expected_graduation_date
    23  	)
    24  		(
    25  			PARTITION graduated
    26  				VALUES FROM (
    27  					minvalue
    28  				)
    29  				TO (
    30  					'2017-08-15'
    31  				),
    32  			PARTITION current
    33  				VALUES FROM (
    34  					'2017-08-15'
    35  				)
    36  				TO (
    37  					maxvalue
    38  				)
    39  		)
    40  
    41  29:
    42  -----------------------------
    43  CREATE TABLE students_by_range (
    44  	id
    45  		SERIAL8,
    46  	name
    47  		STRING,
    48  	email
    49  		STRING,
    50  	country
    51  		STRING,
    52  	expected_graduation_date
    53  		DATE,
    54  	PRIMARY KEY (
    55  		expected_graduation_date,
    56  		id
    57  	)
    58  )
    59  	PARTITION BY RANGE (
    60  		expected_graduation_date
    61  	)
    62  		(
    63  			PARTITION graduated
    64  				VALUES FROM (
    65  					minvalue
    66  				)
    67  				TO (
    68  					'2017-08-15'
    69  				),
    70  			PARTITION current
    71  				VALUES FROM (
    72  					'2017-08-15'
    73  				)
    74  				TO (maxvalue)
    75  		)
    76  
    77  34:
    78  ----------------------------------
    79  CREATE TABLE students_by_range (
    80  	id
    81  		SERIAL8,
    82  	name
    83  		STRING,
    84  	email
    85  		STRING,
    86  	country
    87  		STRING,
    88  	expected_graduation_date
    89  		DATE,
    90  	PRIMARY KEY (
    91  		expected_graduation_date,
    92  		id
    93  	)
    94  )
    95  	PARTITION BY RANGE (
    96  		expected_graduation_date
    97  	)
    98  		(
    99  			PARTITION graduated
   100  				VALUES FROM (
   101  					minvalue
   102  				)
   103  				TO ('2017-08-15'),
   104  			PARTITION current
   105  				VALUES FROM (
   106  					'2017-08-15'
   107  				)
   108  				TO (maxvalue)
   109  		)
   110  
   111  38:
   112  --------------------------------------
   113  CREATE TABLE students_by_range (
   114  	id
   115  		SERIAL8,
   116  	name
   117  		STRING,
   118  	email
   119  		STRING,
   120  	country
   121  		STRING,
   122  	expected_graduation_date
   123  		DATE,
   124  	PRIMARY KEY (
   125  		expected_graduation_date,
   126  		id
   127  	)
   128  )
   129  	PARTITION BY RANGE (
   130  		expected_graduation_date
   131  	)
   132  		(
   133  			PARTITION graduated
   134  				VALUES FROM (minvalue)
   135  				TO ('2017-08-15'),
   136  			PARTITION current
   137  				VALUES FROM (
   138  					'2017-08-15'
   139  				)
   140  				TO (maxvalue)
   141  		)
   142  
   143  42:
   144  ------------------------------------------
   145  CREATE TABLE students_by_range (
   146  	id
   147  		SERIAL8,
   148  	name
   149  		STRING,
   150  	email
   151  		STRING,
   152  	country
   153  		STRING,
   154  	expected_graduation_date
   155  		DATE,
   156  	PRIMARY KEY (
   157  		expected_graduation_date,
   158  		id
   159  	)
   160  )
   161  	PARTITION BY RANGE (
   162  		expected_graduation_date
   163  	)
   164  		(
   165  			PARTITION graduated
   166  				VALUES FROM (minvalue)
   167  				TO ('2017-08-15'),
   168  			PARTITION current
   169  				VALUES FROM ('2017-08-15')
   170  				TO (maxvalue)
   171  		)
   172  
   173  46:
   174  ----------------------------------------------
   175  CREATE TABLE students_by_range (
   176  	id
   177  		SERIAL8,
   178  	name
   179  		STRING,
   180  	email
   181  		STRING,
   182  	country
   183  		STRING,
   184  	expected_graduation_date
   185  		DATE,
   186  	PRIMARY KEY (expected_graduation_date, id)
   187  )
   188  	PARTITION BY RANGE (
   189  		expected_graduation_date
   190  	)
   191  		(
   192  			PARTITION graduated
   193  				VALUES FROM (minvalue)
   194  				TO ('2017-08-15'),
   195  			PARTITION current
   196  				VALUES FROM ('2017-08-15')
   197  				TO (maxvalue)
   198  		)
   199  
   200  49:
   201  -------------------------------------------------
   202  CREATE TABLE students_by_range (
   203  	id
   204  		SERIAL8,
   205  	name
   206  		STRING,
   207  	email
   208  		STRING,
   209  	country
   210  		STRING,
   211  	expected_graduation_date
   212  		DATE,
   213  	PRIMARY KEY (expected_graduation_date, id)
   214  )
   215  	PARTITION BY RANGE (expected_graduation_date)
   216  		(
   217  			PARTITION graduated
   218  				VALUES FROM (minvalue)
   219  				TO ('2017-08-15'),
   220  			PARTITION current
   221  				VALUES FROM ('2017-08-15')
   222  				TO (maxvalue)
   223  		)
   224  
   225  56:
   226  --------------------------------------------------------
   227  CREATE TABLE students_by_range (
   228  	id
   229  		SERIAL8,
   230  	name
   231  		STRING,
   232  	email
   233  		STRING,
   234  	country
   235  		STRING,
   236  	expected_graduation_date
   237  		DATE,
   238  	PRIMARY KEY (expected_graduation_date, id)
   239  )
   240  	PARTITION BY RANGE (expected_graduation_date)
   241  		(
   242  			PARTITION graduated
   243  				VALUES FROM (minvalue)
   244  				TO ('2017-08-15'),
   245  			PARTITION current
   246  				VALUES FROM ('2017-08-15') TO (maxvalue)
   247  		)
   248  
   249  57:
   250  ---------------------------------------------------------
   251  CREATE TABLE students_by_range (
   252  	id
   253  		SERIAL8,
   254  	name
   255  		STRING,
   256  	email
   257  		STRING,
   258  	country
   259  		STRING,
   260  	expected_graduation_date
   261  		DATE,
   262  	PRIMARY KEY (expected_graduation_date, id)
   263  )
   264  	PARTITION BY RANGE (expected_graduation_date)
   265  		(
   266  			PARTITION graduated
   267  				VALUES FROM (minvalue) TO ('2017-08-15'),
   268  			PARTITION current
   269  				VALUES FROM ('2017-08-15') TO (maxvalue)
   270  		)
   271  
   272  70:
   273  ----------------------------------------------------------------------
   274  CREATE TABLE students_by_range (
   275  	id
   276  		SERIAL8,
   277  	name
   278  		STRING,
   279  	email
   280  		STRING,
   281  	country
   282  		STRING,
   283  	expected_graduation_date
   284  		DATE,
   285  	PRIMARY KEY (expected_graduation_date, id)
   286  )
   287  	PARTITION BY RANGE (expected_graduation_date)
   288  		(
   289  			PARTITION graduated
   290  				VALUES FROM (minvalue) TO ('2017-08-15'),
   291  			PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue)
   292  		)
   293  
   294  73:
   295  -------------------------------------------------------------------------
   296  CREATE TABLE students_by_range (
   297  	id
   298  		SERIAL8,
   299  	name
   300  		STRING,
   301  	email
   302  		STRING,
   303  	country
   304  		STRING,
   305  	expected_graduation_date
   306  		DATE,
   307  	PRIMARY KEY (expected_graduation_date, id)
   308  )
   309  	PARTITION BY RANGE (expected_graduation_date)
   310  		(
   311  			PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'),
   312  			PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue)
   313  		)
   314  
   315  89:
   316  -----------------------------------------------------------------------------------------
   317  CREATE TABLE students_by_range (
   318  	id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE,
   319  	PRIMARY KEY (expected_graduation_date, id)
   320  )
   321  	PARTITION BY RANGE (expected_graduation_date)
   322  		(
   323  			PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'),
   324  			PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue)
   325  		)
   326  
   327  130:
   328  ----------------------------------------------------------------------------------------------------------------------------------
   329  CREATE TABLE students_by_range (
   330  	id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE,
   331  	PRIMARY KEY (expected_graduation_date, id)
   332  )
   333  	PARTITION BY RANGE (expected_graduation_date)
   334  		(PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue))
   335  
   336  161:
   337  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
   338  CREATE TABLE students_by_range (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (expected_graduation_date, id))
   339  	PARTITION BY RANGE (expected_graduation_date)
   340  		(PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue))
   341  
   342  172:
   343  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   344  CREATE TABLE students_by_range (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (expected_graduation_date, id))
   345  	PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue))
   346  
   347  330:
   348  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   349  CREATE TABLE students_by_range (id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, PRIMARY KEY (expected_graduation_date, id)) PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue))
   350  
   351