github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_partition_range.align-only.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 24: 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 PARTITION graduated 63 VALUES FROM ( 64 minvalue 65 ) 66 TO ( 67 '2017-08-15' 68 ), 69 PARTITION current 70 VALUES FROM ( 71 '2017-08-15' 72 ) 73 TO ( 74 maxvalue 75 ) 76 ) 77 78 25: 79 ------------------------- 80 CREATE TABLE students_by_range ( 81 id 82 SERIAL8, 83 name 84 STRING, 85 email 86 STRING, 87 country 88 STRING, 89 expected_graduation_date 90 DATE, 91 PRIMARY KEY ( 92 expected_graduation_date, 93 id 94 ) 95 ) 96 PARTITION BY RANGE ( 97 expected_graduation_date 98 ) ( 99 PARTITION graduated 100 VALUES FROM ( 101 minvalue 102 ) 103 TO ( 104 '2017-08-15' 105 ), 106 PARTITION current 107 VALUES FROM ( 108 '2017-08-15' 109 ) 110 TO (maxvalue) 111 ) 112 113 30: 114 ------------------------------ 115 CREATE TABLE students_by_range ( 116 id 117 SERIAL8, 118 name 119 STRING, 120 email 121 STRING, 122 country 123 STRING, 124 expected_graduation_date 125 DATE, 126 PRIMARY KEY ( 127 expected_graduation_date, 128 id 129 ) 130 ) 131 PARTITION BY RANGE ( 132 expected_graduation_date 133 ) ( 134 PARTITION graduated 135 VALUES FROM ( 136 minvalue 137 ) 138 TO ('2017-08-15'), 139 PARTITION current 140 VALUES FROM ( 141 '2017-08-15' 142 ) 143 TO (maxvalue) 144 ) 145 146 32: 147 -------------------------------- 148 CREATE TABLE students_by_range ( 149 id 150 SERIAL8, 151 name 152 STRING, 153 email 154 STRING, 155 country 156 STRING, 157 expected_graduation_date 158 DATE, 159 PRIMARY KEY ( 160 expected_graduation_date, 161 id 162 ) 163 ) PARTITION BY RANGE ( 164 expected_graduation_date 165 ) ( 166 PARTITION graduated 167 VALUES FROM ( 168 minvalue 169 ) 170 TO ('2017-08-15'), 171 PARTITION current 172 VALUES FROM ( 173 '2017-08-15' 174 ) 175 TO (maxvalue) 176 ) 177 178 34: 179 ---------------------------------- 180 CREATE TABLE students_by_range ( 181 id 182 SERIAL8, 183 name 184 STRING, 185 email 186 STRING, 187 country 188 STRING, 189 expected_graduation_date 190 DATE, 191 PRIMARY KEY ( 192 expected_graduation_date, 193 id 194 ) 195 ) PARTITION BY RANGE ( 196 expected_graduation_date 197 ) ( 198 PARTITION graduated 199 VALUES FROM (minvalue) 200 TO ('2017-08-15'), 201 PARTITION current 202 VALUES FROM ( 203 '2017-08-15' 204 ) 205 TO (maxvalue) 206 ) 207 208 37: 209 ------------------------------------- 210 CREATE TABLE students_by_range ( 211 id SERIAL8, 212 name STRING, 213 email STRING, 214 country STRING, 215 expected_graduation_date DATE, 216 PRIMARY KEY ( 217 expected_graduation_date, 218 id 219 ) 220 ) PARTITION BY RANGE ( 221 expected_graduation_date 222 ) ( 223 PARTITION graduated 224 VALUES FROM (minvalue) 225 TO ('2017-08-15'), 226 PARTITION current 227 VALUES FROM ( 228 '2017-08-15' 229 ) 230 TO (maxvalue) 231 ) 232 233 38: 234 -------------------------------------- 235 CREATE TABLE students_by_range ( 236 id SERIAL8, 237 name STRING, 238 email STRING, 239 country STRING, 240 expected_graduation_date DATE, 241 PRIMARY KEY ( 242 expected_graduation_date, 243 id 244 ) 245 ) PARTITION BY RANGE ( 246 expected_graduation_date 247 ) ( 248 PARTITION graduated 249 VALUES FROM (minvalue) 250 TO ('2017-08-15'), 251 PARTITION current 252 VALUES FROM ('2017-08-15') 253 TO (maxvalue) 254 ) 255 256 39: 257 --------------------------------------- 258 CREATE TABLE students_by_range ( 259 id SERIAL8, 260 name STRING, 261 email STRING, 262 country STRING, 263 expected_graduation_date DATE, 264 PRIMARY KEY ( 265 expected_graduation_date, 266 id 267 ) 268 ) PARTITION BY RANGE ( 269 expected_graduation_date 270 ) ( 271 PARTITION graduated 272 VALUES FROM (minvalue) 273 TO ('2017-08-15'), 274 PARTITION current VALUES FROM ( 275 '2017-08-15' 276 ) 277 TO (maxvalue) 278 ) 279 280 41: 281 ----------------------------------------- 282 CREATE TABLE students_by_range ( 283 id SERIAL8, 284 name STRING, 285 email STRING, 286 country STRING, 287 expected_graduation_date DATE, 288 PRIMARY KEY ( 289 expected_graduation_date, 290 id 291 ) 292 ) PARTITION BY RANGE ( 293 expected_graduation_date 294 ) ( 295 PARTITION graduated VALUES FROM ( 296 minvalue 297 ) 298 TO ( 299 '2017-08-15' 300 ), 301 PARTITION current VALUES FROM ( 302 '2017-08-15' 303 ) 304 TO (maxvalue) 305 ) 306 307 46: 308 ---------------------------------------------- 309 CREATE TABLE students_by_range ( 310 id SERIAL8, 311 name STRING, 312 email STRING, 313 country STRING, 314 expected_graduation_date DATE, 315 PRIMARY KEY (expected_graduation_date, id) 316 ) PARTITION BY RANGE ( 317 expected_graduation_date 318 ) ( 319 PARTITION graduated VALUES FROM ( 320 minvalue 321 ) 322 TO ('2017-08-15'), 323 PARTITION current VALUES FROM ( 324 '2017-08-15' 325 ) 326 TO (maxvalue) 327 ) 328 329 49: 330 ------------------------------------------------- 331 CREATE TABLE students_by_range ( 332 id SERIAL8, 333 name STRING, 334 email STRING, 335 country STRING, 336 expected_graduation_date DATE, 337 PRIMARY KEY (expected_graduation_date, id) 338 ) PARTITION BY RANGE (expected_graduation_date) ( 339 PARTITION graduated 340 VALUES FROM ( 341 minvalue 342 ) 343 TO ( 344 '2017-08-15' 345 ), 346 PARTITION current 347 VALUES FROM ( 348 '2017-08-15' 349 ) 350 TO ( 351 maxvalue 352 ) 353 ) 354 355 69: 356 --------------------------------------------------------------------- 357 CREATE TABLE students_by_range ( 358 id SERIAL8, 359 name STRING, 360 email STRING, 361 country STRING, 362 expected_graduation_date DATE, 363 PRIMARY KEY (expected_graduation_date, id) 364 ) PARTITION BY RANGE (expected_graduation_date) ( 365 PARTITION graduated 366 VALUES FROM ( 367 minvalue 368 ) 369 TO ( 370 '2017-08-15' 371 ), 372 PARTITION current 373 VALUES FROM ( 374 '2017-08-15' 375 ) 376 TO (maxvalue) 377 ) 378 379 74: 380 -------------------------------------------------------------------------- 381 CREATE TABLE students_by_range ( 382 id SERIAL8, 383 name STRING, 384 email STRING, 385 country STRING, 386 expected_graduation_date DATE, 387 PRIMARY KEY (expected_graduation_date, id) 388 ) PARTITION BY RANGE (expected_graduation_date) ( 389 PARTITION graduated 390 VALUES FROM ( 391 minvalue 392 ) 393 TO ('2017-08-15'), 394 PARTITION current 395 VALUES FROM ( 396 '2017-08-15' 397 ) 398 TO (maxvalue) 399 ) 400 401 78: 402 ------------------------------------------------------------------------------ 403 CREATE TABLE students_by_range ( 404 id SERIAL8, 405 name STRING, 406 email STRING, 407 country STRING, 408 expected_graduation_date DATE, 409 PRIMARY KEY (expected_graduation_date, id) 410 ) PARTITION BY RANGE (expected_graduation_date) ( 411 PARTITION graduated 412 VALUES FROM (minvalue) 413 TO ('2017-08-15'), 414 PARTITION current 415 VALUES FROM ( 416 '2017-08-15' 417 ) 418 TO (maxvalue) 419 ) 420 421 82: 422 ---------------------------------------------------------------------------------- 423 CREATE TABLE students_by_range ( 424 id SERIAL8, 425 name STRING, 426 email STRING, 427 country STRING, 428 expected_graduation_date DATE, 429 PRIMARY KEY (expected_graduation_date, id) 430 ) PARTITION BY RANGE (expected_graduation_date) ( 431 PARTITION graduated 432 VALUES FROM (minvalue) 433 TO ('2017-08-15'), 434 PARTITION current 435 VALUES FROM ('2017-08-15') 436 TO (maxvalue) 437 ) 438 439 83: 440 ----------------------------------------------------------------------------------- 441 CREATE TABLE students_by_range ( 442 id SERIAL8, 443 name STRING, 444 email STRING, 445 country STRING, 446 expected_graduation_date DATE, 447 PRIMARY KEY (expected_graduation_date, id) 448 ) PARTITION BY RANGE (expected_graduation_date) ( 449 PARTITION graduated 450 VALUES FROM (minvalue) 451 TO ('2017-08-15'), 452 PARTITION current VALUES FROM ( 453 '2017-08-15' 454 ) 455 TO (maxvalue) 456 ) 457 458 85: 459 ------------------------------------------------------------------------------------- 460 CREATE TABLE students_by_range ( 461 id SERIAL8, 462 name STRING, 463 email STRING, 464 country STRING, 465 expected_graduation_date DATE, 466 PRIMARY KEY (expected_graduation_date, id) 467 ) PARTITION BY RANGE (expected_graduation_date) ( 468 PARTITION graduated VALUES FROM ( 469 minvalue 470 ) 471 TO ( 472 '2017-08-15' 473 ), 474 PARTITION current VALUES FROM ( 475 '2017-08-15' 476 ) 477 TO (maxvalue) 478 ) 479 480 89: 481 ----------------------------------------------------------------------------------------- 482 CREATE TABLE students_by_range ( 483 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 484 PRIMARY KEY (expected_graduation_date, id) 485 ) PARTITION BY RANGE (expected_graduation_date) ( 486 PARTITION graduated VALUES FROM ( 487 minvalue 488 ) 489 TO ( 490 '2017-08-15' 491 ), 492 PARTITION current VALUES FROM ( 493 '2017-08-15' 494 ) 495 TO (maxvalue) 496 ) 497 498 90: 499 ------------------------------------------------------------------------------------------ 500 CREATE TABLE students_by_range ( 501 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 502 PRIMARY KEY (expected_graduation_date, id) 503 ) PARTITION BY RANGE (expected_graduation_date) ( 504 PARTITION graduated VALUES FROM ( 505 minvalue 506 ) 507 TO ('2017-08-15'), 508 PARTITION current VALUES FROM ( 509 '2017-08-15' 510 ) 511 TO (maxvalue) 512 ) 513 514 94: 515 ---------------------------------------------------------------------------------------------- 516 CREATE TABLE students_by_range ( 517 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 518 PRIMARY KEY (expected_graduation_date, id) 519 ) PARTITION BY RANGE (expected_graduation_date) ( 520 PARTITION graduated VALUES FROM (minvalue) 521 TO ('2017-08-15'), 522 PARTITION current VALUES FROM ( 523 '2017-08-15' 524 ) 525 TO (maxvalue) 526 ) 527 528 96: 529 ------------------------------------------------------------------------------------------------ 530 CREATE TABLE students_by_range ( 531 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 532 PRIMARY KEY (expected_graduation_date, id) 533 ) PARTITION BY RANGE (expected_graduation_date) ( 534 PARTITION graduated VALUES FROM (minvalue) 535 TO ('2017-08-15'), 536 PARTITION current VALUES FROM ('2017-08-15') 537 TO (maxvalue) 538 ) 539 540 110: 541 -------------------------------------------------------------------------------------------------------------- 542 CREATE TABLE students_by_range ( 543 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 544 PRIMARY KEY (expected_graduation_date, id) 545 ) PARTITION BY RANGE (expected_graduation_date) ( 546 PARTITION graduated VALUES FROM (minvalue) 547 TO ('2017-08-15'), 548 PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue) 549 ) 550 551 113: 552 ----------------------------------------------------------------------------------------------------------------- 553 CREATE TABLE students_by_range ( 554 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 555 PRIMARY KEY (expected_graduation_date, id) 556 ) PARTITION BY RANGE (expected_graduation_date) ( 557 PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), 558 PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue) 559 ) 560 561 170: 562 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 563 CREATE TABLE students_by_range ( 564 id SERIAL8, name STRING, email STRING, country STRING, expected_graduation_date DATE, 565 PRIMARY KEY (expected_graduation_date, id) 566 ) PARTITION BY RANGE (expected_graduation_date) (PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue)) 567 568 182: 569 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 570 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 ( 571 expected_graduation_date 572 ) ( 573 PARTITION graduated 574 VALUES FROM ( 575 minvalue 576 ) 577 TO ( 578 '2017-08-15' 579 ), 580 PARTITION current 581 VALUES FROM ( 582 '2017-08-15' 583 ) 584 TO ( 585 maxvalue 586 ) 587 ) 588 589 185: 590 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 591 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 ( 592 expected_graduation_date 593 ) ( 594 PARTITION graduated 595 VALUES FROM ( 596 minvalue 597 ) 598 TO ( 599 '2017-08-15' 600 ), 601 PARTITION current 602 VALUES FROM ( 603 '2017-08-15' 604 ) 605 TO (maxvalue) 606 ) 607 608 190: 609 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 610 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 ( 611 expected_graduation_date 612 ) ( 613 PARTITION graduated 614 VALUES FROM ( 615 minvalue 616 ) 617 TO ('2017-08-15'), 618 PARTITION current 619 VALUES FROM ( 620 '2017-08-15' 621 ) 622 TO (maxvalue) 623 ) 624 625 194: 626 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 627 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 ( 628 expected_graduation_date 629 ) ( 630 PARTITION graduated 631 VALUES FROM (minvalue) 632 TO ('2017-08-15'), 633 PARTITION current 634 VALUES FROM ( 635 '2017-08-15' 636 ) 637 TO (maxvalue) 638 ) 639 640 198: 641 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 642 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 ( 643 expected_graduation_date 644 ) ( 645 PARTITION graduated 646 VALUES FROM (minvalue) 647 TO ('2017-08-15'), 648 PARTITION current 649 VALUES FROM ('2017-08-15') 650 TO (maxvalue) 651 ) 652 653 199: 654 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 655 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 ( 656 expected_graduation_date 657 ) ( 658 PARTITION graduated 659 VALUES FROM (minvalue) 660 TO ('2017-08-15'), 661 PARTITION current VALUES FROM ( 662 '2017-08-15' 663 ) 664 TO (maxvalue) 665 ) 666 667 201: 668 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 669 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 ( 670 expected_graduation_date 671 ) ( 672 PARTITION graduated VALUES FROM ( 673 minvalue 674 ) 675 TO ( 676 '2017-08-15' 677 ), 678 PARTITION current VALUES FROM ( 679 '2017-08-15' 680 ) 681 TO (maxvalue) 682 ) 683 684 206: 685 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 686 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 ( 687 expected_graduation_date 688 ) ( 689 PARTITION graduated VALUES FROM ( 690 minvalue 691 ) 692 TO ('2017-08-15'), 693 PARTITION current VALUES FROM ( 694 '2017-08-15' 695 ) 696 TO (maxvalue) 697 ) 698 699 209: 700 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 701 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) ( 702 PARTITION graduated 703 VALUES FROM ( 704 minvalue 705 ) 706 TO ( 707 '2017-08-15' 708 ), 709 PARTITION current 710 VALUES FROM ( 711 '2017-08-15' 712 ) 713 TO ( 714 maxvalue 715 ) 716 ) 717 718 229: 719 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 720 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) ( 721 PARTITION graduated 722 VALUES FROM ( 723 minvalue 724 ) 725 TO ( 726 '2017-08-15' 727 ), 728 PARTITION current 729 VALUES FROM ( 730 '2017-08-15' 731 ) 732 TO (maxvalue) 733 ) 734 735 234: 736 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 737 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) ( 738 PARTITION graduated 739 VALUES FROM ( 740 minvalue 741 ) 742 TO ('2017-08-15'), 743 PARTITION current 744 VALUES FROM ( 745 '2017-08-15' 746 ) 747 TO (maxvalue) 748 ) 749 750 238: 751 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 752 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) ( 753 PARTITION graduated 754 VALUES FROM (minvalue) 755 TO ('2017-08-15'), 756 PARTITION current 757 VALUES FROM ( 758 '2017-08-15' 759 ) 760 TO (maxvalue) 761 ) 762 763 242: 764 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 765 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) ( 766 PARTITION graduated 767 VALUES FROM (minvalue) 768 TO ('2017-08-15'), 769 PARTITION current 770 VALUES FROM ('2017-08-15') 771 TO (maxvalue) 772 ) 773 774 243: 775 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 776 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) ( 777 PARTITION graduated 778 VALUES FROM (minvalue) 779 TO ('2017-08-15'), 780 PARTITION current VALUES FROM ( 781 '2017-08-15' 782 ) 783 TO (maxvalue) 784 ) 785 786 245: 787 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 788 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) ( 789 PARTITION graduated VALUES FROM ( 790 minvalue 791 ) 792 TO ( 793 '2017-08-15' 794 ), 795 PARTITION current VALUES FROM ( 796 '2017-08-15' 797 ) 798 TO (maxvalue) 799 ) 800 801 250: 802 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 803 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) ( 804 PARTITION graduated VALUES FROM ( 805 minvalue 806 ) 807 TO ('2017-08-15'), 808 PARTITION current VALUES FROM ( 809 '2017-08-15' 810 ) 811 TO (maxvalue) 812 ) 813 814 254: 815 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 816 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) ( 817 PARTITION graduated VALUES FROM (minvalue) 818 TO ('2017-08-15'), 819 PARTITION current VALUES FROM ( 820 '2017-08-15' 821 ) 822 TO (maxvalue) 823 ) 824 825 256: 826 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 827 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) ( 828 PARTITION graduated VALUES FROM (minvalue) 829 TO ('2017-08-15'), 830 PARTITION current VALUES FROM ('2017-08-15') 831 TO (maxvalue) 832 ) 833 834 270: 835 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 836 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) ( 837 PARTITION graduated VALUES FROM (minvalue) 838 TO ('2017-08-15'), 839 PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue) 840 ) 841 842 273: 843 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 844 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) ( 845 PARTITION graduated VALUES FROM (minvalue) TO ('2017-08-15'), 846 PARTITION current VALUES FROM ('2017-08-15') TO (maxvalue) 847 ) 848 849 330: 850 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 851 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)) 852 853