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