← Back to Overview

src/backend/parser/parse_expr.c

Coverage: 2/7 lines (28.6%)
Total Lines
7
modified
Covered
2
28.6%
Uncovered
5
71.4%
키보드 네비게이션
↑W 이전 미실행
↓S 다음 미실행
←A 이전 수정
→D 다음 수정
PgUpQ 이전함수
PgDnE 다음함수
HomeC-A 시작
EndC-E 끝
ESCBS 목록
transformColumnRef() lines 510-888
Modified Lines Coverage: 2/2 lines (100.0%)
LineHitsSourceCommit
510 - transformColumnRef(ParseState *pstate, ColumnRef *cref) -
511 - { -
512 - Node *node = NULL; -
513 - char *nspname = NULL; -
514 - char *relname = NULL; -
515 - char *colname = NULL; -
516 - ParseNamespaceItem *nsitem; -
517 - int levels_up; -
518 - enum -
519 - { -
520 - CRERR_NO_COLUMN, -
521 - CRERR_NO_RTE, -
522 - CRERR_WRONG_DB, -
523 - CRERR_TOO_MANY -
524 - } crerr = CRERR_NO_COLUMN; -
525 - const char *err; -
526 - -
527 - /* -
528 - * Check to see if the column reference is in an invalid place within the -
529 - * query. We allow column references in most places, except in default -
530 - * expressions and partition bound expressions. -
531 - */ -
532 - err = NULL; -
533 - switch (pstate->p_expr_kind) -
534 - { -
535 - case EXPR_KIND_NONE: -
536 - Assert(false); /* can't happen */ -
537 - break; -
538 - case EXPR_KIND_OTHER: -
539 - case EXPR_KIND_JOIN_ON: -
540 - case EXPR_KIND_JOIN_USING: -
541 - case EXPR_KIND_FROM_SUBSELECT: -
542 - case EXPR_KIND_FROM_FUNCTION: -
543 - case EXPR_KIND_WHERE: -
544 - case EXPR_KIND_POLICY: -
545 - case EXPR_KIND_HAVING: -
546 - case EXPR_KIND_FILTER: -
547 - case EXPR_KIND_WINDOW_PARTITION: -
548 - case EXPR_KIND_WINDOW_ORDER: -
549 - case EXPR_KIND_WINDOW_FRAME_RANGE: -
550 - case EXPR_KIND_WINDOW_FRAME_ROWS: -
551 - case EXPR_KIND_WINDOW_FRAME_GROUPS: -
552 - case EXPR_KIND_SELECT_TARGET: -
553 - case EXPR_KIND_INSERT_TARGET: -
554 - case EXPR_KIND_UPDATE_SOURCE: -
555 - case EXPR_KIND_UPDATE_TARGET: -
556 - case EXPR_KIND_MERGE_WHEN: -
557 - case EXPR_KIND_GROUP_BY: -
558 - case EXPR_KIND_ORDER_BY: -
559 - case EXPR_KIND_DISTINCT_ON: -
560 - case EXPR_KIND_LIMIT: -
561 - case EXPR_KIND_OFFSET: -
562 - case EXPR_KIND_RETURNING: -
563 - case EXPR_KIND_MERGE_RETURNING: -
564 - case EXPR_KIND_VALUES: -
565 - case EXPR_KIND_VALUES_SINGLE: -
566 - case EXPR_KIND_CHECK_CONSTRAINT: -
567 - case EXPR_KIND_DOMAIN_CHECK: -
568 - case EXPR_KIND_FUNCTION_DEFAULT: -
569 - case EXPR_KIND_INDEX_EXPRESSION: -
570 - case EXPR_KIND_INDEX_PREDICATE: -
571 - case EXPR_KIND_STATS_EXPRESSION: -
572 - case EXPR_KIND_ALTER_COL_TRANSFORM: -
573 - case EXPR_KIND_EXECUTE_PARAMETER: -
574 - case EXPR_KIND_TRIGGER_WHEN: -
575 - case EXPR_KIND_PARTITION_EXPRESSION: -
576 - case EXPR_KIND_CALL_ARGUMENT: -
577 - case EXPR_KIND_COPY_WHERE: -
578 - case EXPR_KIND_GENERATED_COLUMN: -
579 - case EXPR_KIND_CYCLE_MARK: -
580 - case EXPR_KIND_PROPGRAPH_PROPERTY: 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
581 - /* okay */ -
582 - break; -
583 - -
584 - case EXPR_KIND_COLUMN_DEFAULT: -
585 - err = _("cannot use column reference in DEFAULT expression"); -
586 - break; -
587 - case EXPR_KIND_PARTITION_BOUND: -
588 - err = _("cannot use column reference in partition bound expression"); -
589 - break; -
590 - -
591 - /* -
592 - * There is intentionally no default: case here, so that the -
593 - * compiler will warn if we add a new ParseExprKind without -
594 - * extending this switch. If we do see an unrecognized value at -
595 - * runtime, the behavior will be the same as for EXPR_KIND_OTHER, -
596 - * which is sane anyway. -
597 - */ -
598 - } -
599 - if (err) -
600 - ereport(ERROR, -
601 - (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), -
602 - errmsg_internal("%s", err), -
603 - parser_errposition(pstate, cref->location))); -
604 - -
605 - /* -
606 - * Give the PreParseColumnRefHook, if any, first shot. If it returns -
607 - * non-null then that's all, folks. -
608 - */ -
609 - if (pstate->p_pre_columnref_hook != NULL) -
610 - { -
611 - node = pstate->p_pre_columnref_hook(pstate, cref); -
612 - if (node != NULL) -
613 - return node; -
614 - } -
615 - -
616 - /*---------- -
617 - * The allowed syntaxes are: -
618 - * -
619 - * A First try to resolve as unqualified column name; -
620 - * if no luck, try to resolve as unqualified table name (A.*). -
621 - * A.B A is an unqualified table name; B is either a -
622 - * column or function name (trying column name first). -
623 - * A.B.C schema A, table B, col or func name C. -
624 - * A.B.C.D catalog A, schema B, table C, col or func D. -
625 - * A.* A is an unqualified table name; means whole-row value. -
626 - * A.B.* whole-row value of table B in schema A. -
627 - * A.B.C.* whole-row value of table C in schema B in catalog A. -
628 - * -
629 - * We do not need to cope with bare "*"; that will only be accepted by -
630 - * the grammar at the top level of a SELECT list, and transformTargetList -
631 - * will take care of it before it ever gets here. Also, "A.*" etc will -
632 - * be expanded by transformTargetList if they appear at SELECT top level, -
633 - * so here we are only going to see them as function or operator inputs. -
634 - * -
635 - * Currently, if a catalog name is given then it must equal the current -
636 - * database name; we check it here and then discard it. -
637 - *---------- -
638 - */ -
639 - switch (list_length(cref->fields)) -
640 - { -
641 - case 1: -
642 - { -
643 - Node *field1 = (Node *) linitial(cref->fields); -
644 - -
645 - colname = strVal(field1); -
646 - -
647 - /* Try to identify as an unqualified column */ -
648 - node = colNameToVar(pstate, colname, false, cref->location); -
649 - -
650 - if (node == NULL) -
651 - { -
652 - /* -
653 - * Not known as a column of any range-table entry. -
654 - * -
655 - * Try to find the name as a relation. Note that only -
656 - * relations already entered into the rangetable will be -
657 - * recognized. -
658 - * -
659 - * This is a hack for backwards compatibility with -
660 - * PostQUEL-inspired syntax. The preferred form now is -
661 - * "rel.*". -
662 - */ -
663 - nsitem = refnameNamespaceItem(pstate, NULL, colname, -
664 - cref->location, -
665 - &levels_up); -
666 - if (nsitem) -
667 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
668 - cref->location); -
669 - } -
670 - break; -
671 - } -
672 - case 2: -
673 - { -
674 - Node *field1 = (Node *) linitial(cref->fields); -
675 - Node *field2 = (Node *) lsecond(cref->fields); -
676 - -
677 - relname = strVal(field1); -
678 - -
679 - /* Locate the referenced nsitem */ -
680 - nsitem = refnameNamespaceItem(pstate, nspname, relname, -
681 - cref->location, -
682 - &levels_up); -
683 - if (nsitem == NULL) -
684 - { -
685 - crerr = CRERR_NO_RTE; -
686 - break; -
687 - } -
688 - -
689 - /* Whole-row reference? */ -
690 - if (IsA(field2, A_Star)) -
691 - { -
692 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
693 - cref->location); -
694 - break; -
695 - } -
696 - -
697 - colname = strVal(field2); -
698 - -
699 - /* Try to identify as a column of the nsitem */ -
700 - node = scanNSItemForColumn(pstate, nsitem, levels_up, colname, -
701 - cref->location); -
702 - if (node == NULL) -
703 - { -
704 - /* Try it as a function call on the whole row */ -
705 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
706 - cref->location); -
707 - node = ParseFuncOrColumn(pstate, -
708 - list_make1(makeString(colname)), -
709 - list_make1(node), -
710 - pstate->p_last_srf, -
711 - NULL, -
712 - false, -
713 - cref->location); -
714 - } -
715 - break; -
716 - } -
717 - case 3: -
718 - { -
719 - Node *field1 = (Node *) linitial(cref->fields); -
720 - Node *field2 = (Node *) lsecond(cref->fields); -
721 - Node *field3 = (Node *) lthird(cref->fields); -
722 - -
723 - nspname = strVal(field1); -
724 - relname = strVal(field2); -
725 - -
726 - /* Locate the referenced nsitem */ -
727 - nsitem = refnameNamespaceItem(pstate, nspname, relname, -
728 - cref->location, -
729 - &levels_up); -
730 - if (nsitem == NULL) -
731 - { -
732 - crerr = CRERR_NO_RTE; -
733 - break; -
734 - } -
735 - -
736 - /* Whole-row reference? */ -
737 - if (IsA(field3, A_Star)) -
738 - { -
739 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
740 - cref->location); -
741 - break; -
742 - } -
743 - -
744 - colname = strVal(field3); -
745 - -
746 - /* Try to identify as a column of the nsitem */ -
747 - node = scanNSItemForColumn(pstate, nsitem, levels_up, colname, -
748 - cref->location); -
749 - if (node == NULL) -
750 - { -
751 - /* Try it as a function call on the whole row */ -
752 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
753 - cref->location); -
754 - node = ParseFuncOrColumn(pstate, -
755 - list_make1(makeString(colname)), -
756 - list_make1(node), -
757 - pstate->p_last_srf, -
758 - NULL, -
759 - false, -
760 - cref->location); -
761 - } -
762 - break; -
763 - } -
764 - case 4: -
765 - { -
766 - Node *field1 = (Node *) linitial(cref->fields); -
767 - Node *field2 = (Node *) lsecond(cref->fields); -
768 - Node *field3 = (Node *) lthird(cref->fields); -
769 - Node *field4 = (Node *) lfourth(cref->fields); -
770 - char *catname; -
771 - -
772 - catname = strVal(field1); -
773 - nspname = strVal(field2); -
774 - relname = strVal(field3); -
775 - -
776 - /* -
777 - * We check the catalog name and then ignore it. -
778 - */ -
779 - if (strcmp(catname, get_database_name(MyDatabaseId)) != 0) -
780 - { -
781 - crerr = CRERR_WRONG_DB; -
782 - break; -
783 - } -
784 - -
785 - /* Locate the referenced nsitem */ -
786 - nsitem = refnameNamespaceItem(pstate, nspname, relname, -
787 - cref->location, -
788 - &levels_up); -
789 - if (nsitem == NULL) -
790 - { -
791 - crerr = CRERR_NO_RTE; -
792 - break; -
793 - } -
794 - -
795 - /* Whole-row reference? */ -
796 - if (IsA(field4, A_Star)) -
797 - { -
798 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
799 - cref->location); -
800 - break; -
801 - } -
802 - -
803 - colname = strVal(field4); -
804 - -
805 - /* Try to identify as a column of the nsitem */ -
806 - node = scanNSItemForColumn(pstate, nsitem, levels_up, colname, -
807 - cref->location); -
808 - if (node == NULL) -
809 - { -
810 - /* Try it as a function call on the whole row */ -
811 - node = transformWholeRowRef(pstate, nsitem, levels_up, -
812 - cref->location); -
813 - node = ParseFuncOrColumn(pstate, -
814 - list_make1(makeString(colname)), -
815 - list_make1(node), -
816 - pstate->p_last_srf, -
817 - NULL, -
818 - false, -
819 - cref->location); -
820 - } -
821 - break; -
822 - } -
823 - default: -
824 - crerr = CRERR_TOO_MANY; /* too many dotted names */ -
825 - break; -
826 - } -
827 - -
828 - /* Try it as a graph table property reference. */ 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
829 919107 if (node == NULL) 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
830 19173 node = transformGraphTablePropertyRef(pstate, cref); 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
831 - 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
832 - /* -
833 - * Now give the PostParseColumnRefHook, if any, a chance. We pass the -
834 - * translation-so-far so that it can throw an error if it wishes in the -
835 - * case that it has a conflicting interpretation of the ColumnRef. (If it -
836 - * just translates anyway, we'll throw an error, because we can't undo -
837 - * whatever effects the preceding steps may have had on the pstate.) If it -
838 - * returns NULL, use the standard translation, or throw a suitable error -
839 - * if there is none. -
840 - */ -
841 - if (pstate->p_post_columnref_hook != NULL) -
842 - { -
843 - Node *hookresult; -
844 - -
845 - hookresult = pstate->p_post_columnref_hook(pstate, cref, node); -
846 - if (node == NULL) -
847 - node = hookresult; -
848 - else if (hookresult != NULL) -
849 - ereport(ERROR, -
850 - (errcode(ERRCODE_AMBIGUOUS_COLUMN), -
851 - errmsg("column reference \"%s\" is ambiguous", -
852 - NameListToString(cref->fields)), -
853 - parser_errposition(pstate, cref->location))); -
854 - } -
855 - -
856 - /* -
857 - * Throw error if no translation found. -
858 - */ -
859 - if (node == NULL) -
860 - { -
861 - switch (crerr) -
862 - { -
863 - case CRERR_NO_COLUMN: -
864 - errorMissingColumn(pstate, relname, colname, cref->location); -
865 - break; -
866 - case CRERR_NO_RTE: -
867 - errorMissingRTE(pstate, makeRangeVar(nspname, relname, -
868 - cref->location)); -
869 - break; -
870 - case CRERR_WRONG_DB: -
871 - ereport(ERROR, -
872 - (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), -
873 - errmsg("cross-database references are not implemented: %s", -
874 - NameListToString(cref->fields)), -
875 - parser_errposition(pstate, cref->location))); -
876 - break; -
877 - case CRERR_TOO_MANY: -
878 - ereport(ERROR, -
879 - (errcode(ERRCODE_SYNTAX_ERROR), -
880 - errmsg("improper qualified name (too many dotted names): %s", -
881 - NameListToString(cref->fields)), -
882 - parser_errposition(pstate, cref->location))); -
883 - break; -
884 - } -
885 - } -
886 - -
887 - return node; -
888 - } -
transformSubLink() lines 1779-2015
Modified Lines Coverage: 0/3 lines (0.0%)
LineHitsSourceCommit
1779 - transformSubLink(ParseState *pstate, SubLink *sublink) -
1780 - { -
1781 - Node *result = (Node *) sublink; -
1782 - Query *qtree; -
1783 - const char *err; -
1784 - -
1785 - /* -
1786 - * Check to see if the sublink is in an invalid place within the query. We -
1787 - * allow sublinks everywhere in SELECT/INSERT/UPDATE/DELETE/MERGE, but -
1788 - * generally not in utility statements. -
1789 - */ -
1790 - err = NULL; -
1791 - switch (pstate->p_expr_kind) -
1792 - { -
1793 - case EXPR_KIND_NONE: -
1794 - Assert(false); /* can't happen */ -
1795 - break; -
1796 - case EXPR_KIND_OTHER: -
1797 - /* Accept sublink here; caller must throw error if wanted */ -
1798 - break; -
1799 - case EXPR_KIND_JOIN_ON: -
1800 - case EXPR_KIND_JOIN_USING: -
1801 - case EXPR_KIND_FROM_SUBSELECT: -
1802 - case EXPR_KIND_FROM_FUNCTION: -
1803 - case EXPR_KIND_WHERE: -
1804 - case EXPR_KIND_POLICY: -
1805 - case EXPR_KIND_HAVING: -
1806 - case EXPR_KIND_FILTER: -
1807 - case EXPR_KIND_WINDOW_PARTITION: -
1808 - case EXPR_KIND_WINDOW_ORDER: -
1809 - case EXPR_KIND_WINDOW_FRAME_RANGE: -
1810 - case EXPR_KIND_WINDOW_FRAME_ROWS: -
1811 - case EXPR_KIND_WINDOW_FRAME_GROUPS: -
1812 - case EXPR_KIND_SELECT_TARGET: -
1813 - case EXPR_KIND_INSERT_TARGET: -
1814 - case EXPR_KIND_UPDATE_SOURCE: -
1815 - case EXPR_KIND_UPDATE_TARGET: -
1816 - case EXPR_KIND_MERGE_WHEN: -
1817 - case EXPR_KIND_GROUP_BY: -
1818 - case EXPR_KIND_ORDER_BY: -
1819 - case EXPR_KIND_DISTINCT_ON: -
1820 - case EXPR_KIND_LIMIT: -
1821 - case EXPR_KIND_OFFSET: -
1822 - case EXPR_KIND_RETURNING: -
1823 - case EXPR_KIND_MERGE_RETURNING: -
1824 - case EXPR_KIND_VALUES: -
1825 - case EXPR_KIND_VALUES_SINGLE: -
1826 - case EXPR_KIND_CYCLE_MARK: -
1827 - /* okay */ -
1828 - break; -
1829 - case EXPR_KIND_CHECK_CONSTRAINT: -
1830 - case EXPR_KIND_DOMAIN_CHECK: -
1831 - err = _("cannot use subquery in check constraint"); -
1832 - break; -
1833 - case EXPR_KIND_COLUMN_DEFAULT: -
1834 - case EXPR_KIND_FUNCTION_DEFAULT: -
1835 - err = _("cannot use subquery in DEFAULT expression"); -
1836 - break; -
1837 - case EXPR_KIND_INDEX_EXPRESSION: -
1838 - err = _("cannot use subquery in index expression"); -
1839 - break; -
1840 - case EXPR_KIND_INDEX_PREDICATE: -
1841 - err = _("cannot use subquery in index predicate"); -
1842 - break; -
1843 - case EXPR_KIND_STATS_EXPRESSION: -
1844 - err = _("cannot use subquery in statistics expression"); -
1845 - break; -
1846 - case EXPR_KIND_ALTER_COL_TRANSFORM: -
1847 - err = _("cannot use subquery in transform expression"); -
1848 - break; -
1849 - case EXPR_KIND_EXECUTE_PARAMETER: -
1850 - err = _("cannot use subquery in EXECUTE parameter"); -
1851 - break; -
1852 - case EXPR_KIND_TRIGGER_WHEN: -
1853 - err = _("cannot use subquery in trigger WHEN condition"); -
1854 - break; -
1855 - case EXPR_KIND_PARTITION_BOUND: -
1856 - err = _("cannot use subquery in partition bound"); -
1857 - break; -
1858 - case EXPR_KIND_PARTITION_EXPRESSION: -
1859 - err = _("cannot use subquery in partition key expression"); -
1860 - break; -
1861 - case EXPR_KIND_CALL_ARGUMENT: -
1862 - err = _("cannot use subquery in CALL argument"); -
1863 - break; -
1864 - case EXPR_KIND_COPY_WHERE: -
1865 - err = _("cannot use subquery in COPY FROM WHERE condition"); -
1866 - break; -
1867 - case EXPR_KIND_GENERATED_COLUMN: -
1868 - err = _("cannot use subquery in column generation expression"); -
1869 - break; -
1870 0 case EXPR_KIND_PROPGRAPH_PROPERTY: 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
1871 0 err = _("cannot use subquery in property definition expression"); 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
1872 0 break; 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
1873 - -
1874 - /* -
1875 - * There is intentionally no default: case here, so that the -
1876 - * compiler will warn if we add a new ParseExprKind without -
1877 - * extending this switch. If we do see an unrecognized value at -
1878 - * runtime, the behavior will be the same as for EXPR_KIND_OTHER, -
1879 - * which is sane anyway. -
1880 - */ -
1881 - } -
1882 - if (err) -
1883 - ereport(ERROR, -
1884 - (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), -
1885 - errmsg_internal("%s", err), -
1886 - parser_errposition(pstate, sublink->location))); -
1887 - -
1888 - pstate->p_hasSubLinks = true; -
1889 - -
1890 - /* -
1891 - * OK, let's transform the sub-SELECT. -
1892 - */ -
1893 - qtree = parse_sub_analyze(sublink->subselect, pstate, NULL, false, true); -
1894 - -
1895 - /* -
1896 - * Check that we got a SELECT. Anything else should be impossible given -
1897 - * restrictions of the grammar, but check anyway. -
1898 - */ -
1899 - if (!IsA(qtree, Query) || -
1900 - qtree->commandType != CMD_SELECT) -
1901 - elog(ERROR, "unexpected non-SELECT command in SubLink"); -
1902 - -
1903 - sublink->subselect = (Node *) qtree; -
1904 - -
1905 - if (sublink->subLinkType == EXISTS_SUBLINK) -
1906 - { -
1907 - /* -
1908 - * EXISTS needs no test expression or combining operator. These fields -
1909 - * should be null already, but make sure. -
1910 - */ -
1911 - sublink->testexpr = NULL; -
1912 - sublink->operName = NIL; -
1913 - } -
1914 - else if (sublink->subLinkType == EXPR_SUBLINK || -
1915 - sublink->subLinkType == ARRAY_SUBLINK) -
1916 - { -
1917 - /* -
1918 - * Make sure the subselect delivers a single column (ignoring resjunk -
1919 - * targets). -
1920 - */ -
1921 - if (count_nonjunk_tlist_entries(qtree->targetList) != 1) -
1922 - ereport(ERROR, -
1923 - (errcode(ERRCODE_SYNTAX_ERROR), -
1924 - errmsg("subquery must return only one column"), -
1925 - parser_errposition(pstate, sublink->location))); -
1926 - -
1927 - /* -
1928 - * EXPR and ARRAY need no test expression or combining operator. These -
1929 - * fields should be null already, but make sure. -
1930 - */ -
1931 - sublink->testexpr = NULL; -
1932 - sublink->operName = NIL; -
1933 - } -
1934 - else if (sublink->subLinkType == MULTIEXPR_SUBLINK) -
1935 - { -
1936 - /* Same as EXPR case, except no restriction on number of columns */ -
1937 - sublink->testexpr = NULL; -
1938 - sublink->operName = NIL; -
1939 - } -
1940 - else -
1941 - { -
1942 - /* ALL, ANY, or ROWCOMPARE: generate row-comparing expression */ -
1943 - Node *lefthand; -
1944 - List *left_list; -
1945 - List *right_list; -
1946 - ListCell *l; -
1947 - -
1948 - /* -
1949 - * If the source was "x IN (select)", convert to "x = ANY (select)". -
1950 - */ -
1951 - if (sublink->operName == NIL) -
1952 - sublink->operName = list_make1(makeString("=")); -
1953 - -
1954 - /* -
1955 - * Transform lefthand expression, and convert to a list -
1956 - */ -
1957 - lefthand = transformExprRecurse(pstate, sublink->testexpr); -
1958 - if (lefthand && IsA(lefthand, RowExpr)) -
1959 - left_list = ((RowExpr *) lefthand)->args; -
1960 - else -
1961 - left_list = list_make1(lefthand); -
1962 - -
1963 - /* -
1964 - * Build a list of PARAM_SUBLINK nodes representing the output columns -
1965 - * of the subquery. -
1966 - */ -
1967 - right_list = NIL; -
1968 - foreach(l, qtree->targetList) -
1969 - { -
1970 - TargetEntry *tent = (TargetEntry *) lfirst(l); -
1971 - Param *param; -
1972 - -
1973 - if (tent->resjunk) -
1974 - continue; -
1975 - -
1976 - param = makeNode(Param); -
1977 - param->paramkind = PARAM_SUBLINK; -
1978 - param->paramid = tent->resno; -
1979 - param->paramtype = exprType((Node *) tent->expr); -
1980 - param->paramtypmod = exprTypmod((Node *) tent->expr); -
1981 - param->paramcollid = exprCollation((Node *) tent->expr); -
1982 - param->location = -1; -
1983 - -
1984 - right_list = lappend(right_list, param); -
1985 - } -
1986 - -
1987 - /* -
1988 - * We could rely on make_row_comparison_op to complain if the list -
1989 - * lengths differ, but we prefer to generate a more specific error -
1990 - * message. -
1991 - */ -
1992 - if (list_length(left_list) < list_length(right_list)) -
1993 - ereport(ERROR, -
1994 - (errcode(ERRCODE_SYNTAX_ERROR), -
1995 - errmsg("subquery has too many columns"), -
1996 - parser_errposition(pstate, sublink->location))); -
1997 - if (list_length(left_list) > list_length(right_list)) -
1998 - ereport(ERROR, -
1999 - (errcode(ERRCODE_SYNTAX_ERROR), -
2000 - errmsg("subquery has too few columns"), -
2001 - parser_errposition(pstate, sublink->location))); -
2002 - -
2003 - /* -
2004 - * Identify the combining operator(s) and generate a suitable -
2005 - * row-comparison expression. -
2006 - */ -
2007 - sublink->testexpr = make_row_comparison_op(pstate, -
2008 - sublink->operName, -
2009 - left_list, -
2010 - right_list, -
2011 - sublink->location); -
2012 - } -
2013 - -
2014 - return result; -
2015 - } -
ParseExprKindName() lines 3143-3243
Modified Lines Coverage: 0/2 lines (0.0%)
LineHitsSourceCommit
3143 - ParseExprKindName(ParseExprKind exprKind) -
3144 - { -
3145 - switch (exprKind) -
3146 - { -
3147 - case EXPR_KIND_NONE: -
3148 - return "invalid expression context"; -
3149 - case EXPR_KIND_OTHER: -
3150 - return "extension expression"; -
3151 - case EXPR_KIND_JOIN_ON: -
3152 - return "JOIN/ON"; -
3153 - case EXPR_KIND_JOIN_USING: -
3154 - return "JOIN/USING"; -
3155 - case EXPR_KIND_FROM_SUBSELECT: -
3156 - return "sub-SELECT in FROM"; -
3157 - case EXPR_KIND_FROM_FUNCTION: -
3158 - return "function in FROM"; -
3159 - case EXPR_KIND_WHERE: -
3160 - return "WHERE"; -
3161 - case EXPR_KIND_POLICY: -
3162 - return "POLICY"; -
3163 - case EXPR_KIND_HAVING: -
3164 - return "HAVING"; -
3165 - case EXPR_KIND_FILTER: -
3166 - return "FILTER"; -
3167 - case EXPR_KIND_WINDOW_PARTITION: -
3168 - return "window PARTITION BY"; -
3169 - case EXPR_KIND_WINDOW_ORDER: -
3170 - return "window ORDER BY"; -
3171 - case EXPR_KIND_WINDOW_FRAME_RANGE: -
3172 - return "window RANGE"; -
3173 - case EXPR_KIND_WINDOW_FRAME_ROWS: -
3174 - return "window ROWS"; -
3175 - case EXPR_KIND_WINDOW_FRAME_GROUPS: -
3176 - return "window GROUPS"; -
3177 - case EXPR_KIND_SELECT_TARGET: -
3178 - return "SELECT"; -
3179 - case EXPR_KIND_INSERT_TARGET: -
3180 - return "INSERT"; -
3181 - case EXPR_KIND_UPDATE_SOURCE: -
3182 - case EXPR_KIND_UPDATE_TARGET: -
3183 - return "UPDATE"; -
3184 - case EXPR_KIND_MERGE_WHEN: -
3185 - return "MERGE WHEN"; -
3186 - case EXPR_KIND_GROUP_BY: -
3187 - return "GROUP BY"; -
3188 - case EXPR_KIND_ORDER_BY: -
3189 - return "ORDER BY"; -
3190 - case EXPR_KIND_DISTINCT_ON: -
3191 - return "DISTINCT ON"; -
3192 - case EXPR_KIND_LIMIT: -
3193 - return "LIMIT"; -
3194 - case EXPR_KIND_OFFSET: -
3195 - return "OFFSET"; -
3196 - case EXPR_KIND_RETURNING: -
3197 - case EXPR_KIND_MERGE_RETURNING: -
3198 - return "RETURNING"; -
3199 - case EXPR_KIND_VALUES: -
3200 - case EXPR_KIND_VALUES_SINGLE: -
3201 - return "VALUES"; -
3202 - case EXPR_KIND_CHECK_CONSTRAINT: -
3203 - case EXPR_KIND_DOMAIN_CHECK: -
3204 - return "CHECK"; -
3205 - case EXPR_KIND_COLUMN_DEFAULT: -
3206 - case EXPR_KIND_FUNCTION_DEFAULT: -
3207 - return "DEFAULT"; -
3208 - case EXPR_KIND_INDEX_EXPRESSION: -
3209 - return "index expression"; -
3210 - case EXPR_KIND_INDEX_PREDICATE: -
3211 - return "index predicate"; -
3212 - case EXPR_KIND_STATS_EXPRESSION: -
3213 - return "statistics expression"; -
3214 - case EXPR_KIND_ALTER_COL_TRANSFORM: -
3215 - return "USING"; -
3216 - case EXPR_KIND_EXECUTE_PARAMETER: -
3217 - return "EXECUTE"; -
3218 - case EXPR_KIND_TRIGGER_WHEN: -
3219 - return "WHEN"; -
3220 - case EXPR_KIND_PARTITION_BOUND: -
3221 - return "partition bound"; -
3222 - case EXPR_KIND_PARTITION_EXPRESSION: -
3223 - return "PARTITION BY"; -
3224 - case EXPR_KIND_CALL_ARGUMENT: -
3225 - return "CALL"; -
3226 - case EXPR_KIND_COPY_WHERE: -
3227 - return "WHERE"; -
3228 - case EXPR_KIND_GENERATED_COLUMN: -
3229 - return "GENERATED AS"; -
3230 - case EXPR_KIND_CYCLE_MARK: -
3231 - return "CYCLE"; -
3232 0 case EXPR_KIND_PROPGRAPH_PROPERTY: 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
3233 0 return "property definition expression"; 86c14eaWIP: SQL Property Graph Queries (SQL/PGQ)
3234 - -
3235 - /* -
3236 - * There is intentionally no default: case here, so that the -
3237 - * compiler will warn if we add a new ParseExprKind without -
3238 - * extending this switch. If we do see an unrecognized value at -
3239 - * runtime, we'll fall through to the "unrecognized" return. -
3240 - */ -
3241 - } -
3242 - return "unrecognized expression kind"; -
3243 - } -