58 bool strip_indirection);
66 bool isTopLevel,
List **targetlist);
83 #ifdef RAW_EXPRESSION_COVERAGE_TEST 84 static bool test_raw_expression_coverage(
Node *node,
void *context);
101 Oid *paramTypes,
int numParams,
107 Assert(sourceText != NULL);
119 (*post_parse_analyze_hook) (pstate, query);
135 Oid **paramTypes,
int *numParams)
140 Assert(sourceText != NULL);
152 (*post_parse_analyze_hook) (pstate, query);
166 bool locked_from_parent,
167 bool resolve_unknowns)
230 ctas->
query = parseTree;
242 parseTree = (
Node *) ctas;
263 #ifdef RAW_EXPRESSION_COVERAGE_TEST 270 (void) test_raw_expression_coverage(parseTree, NULL);
474 bool isGeneralSelect;
484 bool isOnConflictUpdate;
515 isGeneralSelect = (selectStmt && (selectStmt->
valuesLists ==
NIL ||
551 if (isOnConflictUpdate)
554 false,
false, targetPerms);
563 if (selectStmt == NULL)
572 else if (isGeneralSelect)
610 elog(
ERROR,
"unexpected non-SELECT command in INSERT ... SELECT");
660 exprList =
lappend(exprList, expr);
681 int sublist_length = -1;
682 bool lateral =
false;
684 Assert(selectStmt->intoClause == NULL);
686 foreach(lc, selectStmt->valuesLists)
702 if (sublist_length < 0)
710 (
errcode(ERRCODE_SYNTAX_ERROR),
711 errmsg(
"VALUES lists must all be the same length"),
745 exprsLists =
lappend(exprsLists, sublist);
778 coltypes, coltypmods, colcollations,
779 NULL, lateral,
true);
784 pstate->p_joinlist =
lappend(pstate->p_joinlist, rtr);
789 expandRTE(rte, rtr->rtindex, 0, -1,
false, NULL, &exprList);
807 List *valuesLists = selectStmt->valuesLists;
810 Assert(selectStmt->intoClause == NULL);
832 rte = pstate->p_target_rangetblentry;
833 qry->targetList =
NIL;
835 forthree(lc, exprList, icols, icolumns, attnos, attrnos)
846 qry->targetList =
lappend(qry->targetList, tle);
853 if (stmt->onConflictClause)
855 stmt->onConflictClause);
863 if (stmt->returningList)
865 pstate->p_namespace =
NIL;
869 stmt->returningList);
873 qry->rtable = pstate->p_rtable;
876 qry->hasTargetSRFs = pstate->p_hasTargetSRFs;
877 qry->hasSubLinks = pstate->p_hasSubLinks;
897 bool strip_indirection)
913 (
errcode(ERRCODE_SYNTAX_ERROR),
914 errmsg(
"INSERT has more expressions than target columns"),
918 if (stmtcols !=
NIL &&
931 (
errcode(ERRCODE_SYNTAX_ERROR),
932 errmsg(
"INSERT has more target columns than expressions"),
936 errhint(
"The insertion source is a row expression containing the same number of columns expected by the INSERT. Did you accidentally use extra parentheses?") : 0),
946 forthree(lc, exprlist, icols, icolumns, attnos, attrnos)
959 if (strip_indirection)
983 result =
lappend(result, expr);
999 Oid arbiterConstraint;
1001 Node *onConflictWhere = NULL;
1003 int exclRelIndex = 0;
1009 &arbiterWhere, &arbiterConstraint);
1033 exclRte->
relkind = RELKIND_COMPOSITE_TYPE;
1103 if (attr->attisdropped)
1114 var =
makeVar(exclRelIndex, attno + 1,
1115 attr->atttypid, attr->atttypmod,
1137 targetrel->
rd_rel->reltype,
1167 if (attnum > 0 && var->
vartype == RECORDOID)
1178 if (ste == NULL || ste->
resjunk)
1217 (
errcode(ERRCODE_SYNTAX_ERROR),
1218 errmsg(
"SELECT ... INTO is not allowed here"),
1343 List **colexprs = NULL;
1344 int sublist_length = -1;
1345 bool lateral =
false;
1396 if (sublist_length < 0)
1406 (
errcode(ERRCODE_SYNTAX_ERROR),
1407 errmsg(
"VALUES lists must all be the same length"),
1414 foreach(lc2, sublist)
1418 colexprs[
i] =
lappend(colexprs[i], col);
1440 for (i = 0; i < sublist_length; i++)
1443 int32 coltypmod = -1;
1449 foreach(lc, colexprs[i])
1454 lfirst(lc) = (
void *) col;
1463 if (coltypmod >= 0 && coltypmod !=
exprTypmod(col))
1472 colcollations =
lappend_oid(colcollations, colcoll);
1479 foreach(lc, colexprs[0])
1485 exprsLists =
lappend(exprsLists, sublist);
1488 for (i = 1; i < sublist_length; i++)
1490 forboth(lc, colexprs[i], lc2, exprsLists)
1515 coltypes, coltypmods, colcollations,
1516 NULL, lateral,
true);
1546 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1549 errmsg(
"%s cannot be applied to VALUES",
1579 Query *leftmostQuery;
1584 List *lockingClause;
1595 int sv_rtable_length;
1609 leftmostSelect = stmt->
larg;
1610 while (leftmostSelect && leftmostSelect->
op !=
SETOP_NONE)
1611 leftmostSelect = leftmostSelect->
larg;
1613 leftmostSelect->
larg == NULL);
1616 (
errcode(ERRCODE_SYNTAX_ERROR),
1617 errmsg(
"SELECT ... INTO is not allowed here"),
1641 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1644 errmsg(
"%s is not allowed with UNION/INTERSECT/EXCEPT",
1646 linitial(lockingClause))->strength))));
1667 node = sostmt->
larg;
1673 Assert(leftmostQuery != NULL);
1717 targetvars =
lappend(targetvars, var);
1766 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1767 errmsg(
"invalid UNION/INTERSECT/EXCEPT ORDER BY clause"),
1768 errdetail(
"Only result column names can be used, not expressions or functions."),
1769 errhint(
"Add the expression/function to every SELECT, or move the UNION into a FROM clause."),
1786 foreach(l, lockingClause)
1817 bool isTopLevel,
List **targetlist)
1831 (
errcode(ERRCODE_SYNTAX_ERROR),
1832 errmsg(
"INTO is only allowed on first SELECT of UNION/INTERSECT/EXCEPT"),
1839 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1842 errmsg(
"%s is not allowed with UNION/INTERSECT/EXCEPT",
1871 char selectName[32];
1891 NULL,
false,
false);
1903 (
errcode(ERRCODE_INVALID_COLUMN_REFERENCE),
1904 errmsg(
"UNION/INTERSECT/EXCEPT member statement cannot refer to other relations of same query level"),
1920 *targetlist =
lappend(*targetlist, tle);
1927 snprintf(selectName,
sizeof(selectName),
"*SELECT* %d",
1942 return (
Node *) rtr;
1952 const char *context;
1992 (
errcode(ERRCODE_SYNTAX_ERROR),
1993 errmsg(
"each %s query must have the same number of columns",
2004 forboth(ltl, ltargetlist, rtl, rtargetlist)
2027 if (lcoltype == rcoltype && lcoltypmod == rcoltypmod)
2028 rescoltypmod = lcoltypmod;
2059 if (lcoltype != UNKNOWNOID)
2061 rescoltype, context);
2066 rescoltype, context);
2070 if (rcoltype != UNKNOWNOID)
2072 rescoltype, context);
2077 rescoltype, context);
2118 &sortop, &eqop, NULL,
2143 rescolnode->
typeId = rescoltype;
2144 rescolnode->
typeMod = rescoltypmod;
2146 rescolnode->
location = bestlocation;
2151 *targetlist =
lappend(*targetlist, restle);
2168 Query *leftmostQuery;
2183 Assert(leftmostQuery != NULL);
2205 targetList =
lappend(targetList, tle);
2321 if (orig_tl == NULL)
2322 elog(
ERROR,
"UPDATE target count mismatch --- internal error");
2326 origTarget->
name,
true);
2329 (
errcode(ERRCODE_UNDEFINED_COLUMN),
2330 errmsg(
"column \"%s\" of relation \"%s\" does not exist",
2344 orig_tl =
lnext(origTlist, orig_tl);
2346 if (orig_tl != NULL)
2347 elog(
ERROR,
"UPDATE target count mismatch --- internal error");
2386 int save_next_resno;
2388 if (returningList ==
NIL)
2410 (
errcode(ERRCODE_SYNTAX_ERROR),
2411 errmsg(
"RETURNING must have at least one column"),
2451 (
errcode(ERRCODE_INVALID_CURSOR_DEFINITION),
2452 errmsg(
"cannot specify both SCROLL and NO SCROLL")));
2461 elog(
ERROR,
"unexpected non-SELECT command in DECLARE CURSOR");
2470 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2471 errmsg(
"DECLARE CURSOR must not contain data-modifying statements in WITH")));
2476 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2479 errmsg(
"DECLARE CURSOR WITH HOLD ... %s is not supported",
2482 errdetail(
"Holdable cursors must be READ ONLY.")));
2487 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2490 errmsg(
"DECLARE SCROLL CURSOR ... %s is not supported",
2493 errdetail(
"Scrollable cursors must be READ ONLY.")));
2498 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2501 errmsg(
"DECLARE INSENSITIVE CURSOR ... %s is not supported",
2504 errdetail(
"Insensitive cursors must be READ ONLY.")));
2569 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2570 errmsg(
"materialized views must not use data-modifying statements in WITH")));
2579 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2580 errmsg(
"materialized views must not use temporary tables or views")));
2589 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2590 errmsg(
"materialized views may not be defined using bound parameters")));
2601 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2602 errmsg(
"materialized views cannot be unlogged")));
2674 return "FOR KEY SHARE";
2678 return "FOR NO KEY UPDATE";
2680 return "FOR UPDATE";
2697 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2700 errmsg(
"%s is not allowed with UNION/INTERSECT/EXCEPT",
2704 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2707 errmsg(
"%s is not allowed with DISTINCT clause",
2711 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2714 errmsg(
"%s is not allowed with GROUP BY clause",
2718 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2721 errmsg(
"%s is not allowed with HAVING clause",
2725 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2728 errmsg(
"%s is not allowed with aggregate functions",
2732 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2735 errmsg(
"%s is not allowed with window functions",
2739 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2742 errmsg(
"%s is not allowed with set-returning functions in the target list",
2772 if (lockedRels ==
NIL)
2811 foreach(l, lockedRels)
2818 (
errcode(ERRCODE_SYNTAX_ERROR),
2821 errmsg(
"%s must specify unqualified relation names",
2849 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2852 errmsg(
"%s cannot be applied to a join",
2858 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2861 errmsg(
"%s cannot be applied to a function",
2867 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2870 errmsg(
"%s cannot be applied to a table function",
2876 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2879 errmsg(
"%s cannot be applied to VALUES",
2885 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2888 errmsg(
"%s cannot be applied to a WITH query",
2894 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2897 errmsg(
"%s cannot be applied to a named tuplestore",
2905 elog(
ERROR,
"unrecognized RTE type: %d",
2917 errmsg(
"relation \"%s\" in %s clause not found in FROM clause",
2986 #ifdef RAW_EXPRESSION_COVERAGE_TEST 2989 test_raw_expression_coverage(
Node *node,
void *context)
2994 test_raw_expression_coverage,
#define list_make2(x1, x2)
Value * makeString(char *str)
static void transformLockingClause(ParseState *pstate, Query *qry, LockingClause *lc, bool pushedDown)
static List * transformUpdateTargetList(ParseState *pstate, List *targetList)
FromExpr * makeFromExpr(List *fromlist, Node *quals)
#define IsA(nodeptr, _type_)
static Query * transformCreateTableAsStmt(ParseState *pstate, CreateTableAsStmt *stmt)
const char * LCS_asString(LockClauseStrength strength)
int errhint(const char *fmt,...)
static Query * transformDeclareCursorStmt(ParseState *pstate, DeclareCursorStmt *stmt)
#define forboth(cell1, list1, cell2, list2)
bool analyze_requires_snapshot(RawStmt *parseTree)
#define ERRCODE_UNDEFINED_TABLE
bool isQueryUsingTempRelation(Query *query)
List * transformDistinctOnClause(ParseState *pstate, List *distinctlist, List **targetlist, List *sortClause)
RowMarkClause * get_parse_rowmark(Query *qry, Index rtindex)
int exprLocation(const Node *expr)
RangeTblEntry * addRangeTableEntryForJoin(ParseState *pstate, List *colnames, JoinType jointype, List *aliasvars, Alias *alias, bool inFromCl)
Expr * transformAssignedExpr(ParseState *pstate, Expr *expr, ParseExprKind exprKind, const char *colname, int attrno, List *indirection, int location)
static ListCell * lnext(const List *l, const ListCell *c)
#define castNode(_type_, nodeptr)
#define RelationGetNumberOfAttributes(relation)
QueryEnvironment * p_queryEnv
int32 exprTypmod(const Node *expr)
void analyzeCTETargetList(ParseState *pstate, CommonTableExpr *cte, List *tlist)
List * transformSortClause(ParseState *pstate, List *orderlist, List **targetlist, ParseExprKind exprKind, bool useSQL99)
#define TupleDescAttr(tupdesc, i)
#define forthree(cell1, list1, cell2, list2, cell3, list3)
char * pstrdup(const char *in)
List * BuildOnConflictExcludedTargetlist(Relation targetrel, Index exclRelIndex)
Node * transformExpr(ParseState *pstate, Node *expr, ParseExprKind exprKind)
Var * makeVarFromTargetEntry(Index varno, TargetEntry *tle)
static Query * transformUpdateStmt(ParseState *pstate, UpdateStmt *stmt)
List * list_truncate(List *list, int new_size)
void parse_variable_parameters(ParseState *pstate, Oid **paramTypes, int *numParams)
static Query * transformValuesClause(ParseState *pstate, SelectStmt *stmt)
static int count_rowexpr_columns(ParseState *pstate, Node *expr)
int errcode(int sqlerrcode)
void * stringToNode(const char *str)
void transformOnConflictArbiter(ParseState *pstate, OnConflictClause *onConflictClause, List **arbiterExpr, Node **arbiterWhere, Oid *constraint)
Query * parse_analyze_varparams(RawStmt *parseTree, const char *sourceText, Oid **paramTypes, int *numParams)
#define CURSOR_OPT_INSENSITIVE
#define FirstLowInvalidHeapAttributeNumber
static List * transformReturningList(ParseState *pstate, List *returningList)
Node * transformLimitClause(ParseState *pstate, Node *clause, ParseExprKind exprKind, const char *constructName)
List * lappend_oid(List *list, Oid datum)
CommonTableExpr * p_parent_cte
void parseCheckAggregates(ParseState *pstate, Query *qry)
#define CURSOR_OPT_NO_SCROLL
void pull_varattnos(Node *node, Index varno, Bitmapset **varattnos)
LockClauseStrength strength
OnConflictClause * onConflictClause
Const * makeNullConst(Oid consttype, int32 consttypmod, Oid constcollid)
bool p_locked_from_parent
ParseState * make_parsestate(ParseState *parentParseState)
void assign_expr_collations(ParseState *pstate, Node *expr)
List * transformTargetList(ParseState *pstate, List *targetlist, ParseExprKind exprKind)
Alias * makeAlias(const char *aliasname, List *colnames)
int locate_var_of_level(Node *node, int levelsup)
bool has_generated_stored
Bitmapset * extraUpdatedCols
void CheckSelectLocking(Query *qry, LockClauseStrength strength)
void cancel_parser_errposition_callback(ParseCallbackState *pcbstate)
bool raw_expression_tree_walker(Node *node, bool(*walker)(), void *context)
Node * ParseFuncOrColumn(ParseState *pstate, List *funcname, List *fargs, Node *last_srf, FuncCall *fn, bool proc_call, int location)
static void * list_nth(const List *list, int n)
#define lfirst_node(type, lc)
void assign_list_collations(ParseState *pstate, List *exprs)
static Query * transformExplainStmt(ParseState *pstate, ExplainStmt *stmt)
void check_stack_depth(void)
int errdetail(const char *fmt,...)
RangeTblEntry * addRangeTableEntryForRelation(ParseState *pstate, Relation rel, int lockmode, Alias *alias, bool inh, bool inFromCl)
LockClauseStrength strength
Oid select_common_collation(ParseState *pstate, List *exprs, bool none_ok)
List * transformGroupClause(ParseState *pstate, List *grouplist, List **groupingSets, List **targetlist, List *sortClause, ParseExprKind exprKind, bool useSQL99)
#define RelationGetRelationName(relation)
static Query * transformSelectStmt(ParseState *pstate, SelectStmt *stmt)
static ListCell * list_head(const List *l)
FormData_pg_attribute * Form_pg_attribute
const char * p_sourcetext
List * expandRelAttrs(ParseState *pstate, RangeTblEntry *rte, int rtindex, int sublevels_up, int location)
#define ereport(elevel, rest)
#define rt_fetch(rangetable_index, rangetable)
static Node * transformSetOperationTree(ParseState *pstate, SelectStmt *stmt, bool isTopLevel, List **targetlist)
TargetEntry * makeTargetEntry(Expr *expr, AttrNumber resno, char *resname, bool resjunk)
Var * makeVar(Index varno, AttrNumber varattno, Oid vartype, int32 vartypmod, Oid varcollid, Index varlevelsup)
void setup_parser_errposition_callback(ParseCallbackState *pcbstate, ParseState *pstate, int location)
void addRTEtoQuery(ParseState *pstate, RangeTblEntry *rte, bool addToJoinList, bool addToRelNameSpace, bool addToVarNameSpace)
List * lappend_int(List *list, int datum)
Query * transformStmt(ParseState *pstate, Node *parseTree)
Node * coerce_to_common_type(ParseState *pstate, Node *node, Oid targetTypeId, const char *context)
List * lappend(List *list, void *datum)
RangeTblEntry * addRangeTableEntryForSubquery(ParseState *pstate, Query *subquery, Alias *alias, bool lateral, bool inFromCl)
void expandRTE(RangeTblEntry *rte, int rtindex, int sublevels_up, int location, bool include_dropped, List **colnames, List **colvars)
List * transformWindowDefinitions(ParseState *pstate, List *windowdefs, List **targetlist)
void * palloc0(Size size)
List * transformExpressionList(ParseState *pstate, List *exprlist, ParseExprKind exprKind, bool allowDefault)
void resolveTargetListUnknowns(ParseState *pstate, List *targetlist)
RangeTblEntry * GetRTEByRangeTablePosn(ParseState *pstate, int varno, int sublevels_up)
RangeTblEntry * p_target_rangetblentry
void transformFromClause(ParseState *pstate, List *frmList)
static Query * transformInsertStmt(ParseState *pstate, InsertStmt *stmt)
int setTargetTable(ParseState *pstate, RangeVar *relation, bool inh, bool alsoSource, AclMode requiredPerms)
Query * parse_sub_analyze(Node *parseTree, ParseState *parentParseState, CommonTableExpr *parentCTE, bool locked_from_parent, bool resolve_unknowns)
Query * parse_analyze(RawStmt *parseTree, const char *sourceText, Oid *paramTypes, int numParams, QueryEnvironment *queryEnv)
RangeTblEntry * addRangeTableEntryForValues(ParseState *pstate, List *exprs, List *coltypes, List *coltypmods, List *colcollations, Alias *alias, bool lateral, bool inFromCl)
int attnameAttNum(Relation rd, const char *attname, bool sysColOK)
#define Assert(condition)
void get_sort_group_operators(Oid argtype, bool needLT, bool needEQ, bool needGT, Oid *ltOpr, Oid *eqOpr, Oid *gtOpr, bool *isHashable)
void markTargetListOrigins(ParseState *pstate, List *targetlist)
void parse_fixed_parameters(ParseState *pstate, Oid *paramTypes, int numParams)
Node * transformWhereClause(ParseState *pstate, Node *clause, ParseExprKind exprKind, const char *constructName)
bool contain_vars_of_level(Node *node, int levelsup)
Query * transformTopLevelStmt(ParseState *pstate, RawStmt *parseTree)
#define ACL_SELECT_FOR_UPDATE
List * checkInsertTargets(ParseState *pstate, List *cols, List **attrnos)
List * transformWithClause(ParseState *pstate, WithClause *withClause)
static Query * transformDeleteStmt(ParseState *pstate, DeleteStmt *stmt)
Oid exprType(const Node *expr)
static int list_length(const List *l)
int parser_errposition(ParseState *pstate, int location)
static OnConflictExpr * transformOnConflictClause(ParseState *pstate, OnConflictClause *onConflictClause)
LockWaitPolicy waitPolicy
Bitmapset * bms_add_member(Bitmapset *a, int x)
static Query * transformSetOperationStmt(ParseState *pstate, SelectStmt *stmt)
void(* post_parse_analyze_hook_type)(ParseState *pstate, Query *query)
bool query_contains_extern_params(Query *query)
#define InvalidAttrNumber
#define forfour(cell1, list1, cell2, list2, cell3, list3, cell4, list4)
bool bms_overlap(const Bitmapset *a, const Bitmapset *b)
int errmsg(const char *fmt,...)
void assign_query_collations(ParseState *pstate, Query *query)
Relation p_target_relation
static Query * transformOptionalSelectInto(ParseState *pstate, Node *parseTree)
void list_free(List *list)
#define CURSOR_OPT_SCROLL
TargetEntry * get_tle_by_resno(List *tlist, AttrNumber resno)
void check_variable_parameters(ParseState *pstate, Query *query)
Oid select_common_type(ParseState *pstate, List *exprs, const char *context, Node **which_expr)
static Query * transformCallStmt(ParseState *pstate, CallStmt *stmt)
static void determineRecursiveColTypes(ParseState *pstate, Node *larg, List *nrtargetlist)
List * transformDistinctClause(ParseState *pstate, List **targetlist, List *sortClause, bool is_agg)
#define PG_USED_FOR_ASSERTS_ONLY
void free_parsestate(ParseState *pstate)
void updateTargetListEntry(ParseState *pstate, TargetEntry *tle, char *colname, int attrno, List *indirection, int location)
LockWaitPolicy waitPolicy
post_parse_analyze_hook_type post_parse_analyze_hook
void applyLockingClause(Query *qry, Index rtindex, LockClauseStrength strength, LockWaitPolicy waitPolicy, bool pushedDown)
static List * transformInsertRow(ParseState *pstate, List *exprlist, List *stmtcols, List *icolumns, List *attrnos, bool strip_indirection)