Method BindSelectNode

src/planner/binder/query_node/bind_select_node.cpp:421–707

}

BoundStatement Binder::BindSelectNode(SelectNode &statement, BoundStatement from_table) {
	D_ASSERT(from_table.plan);
	D_ASSERT(!statement.from_table);
	auto result_ptr = make_uniq<BoundSelectNode>();
	auto &result = *result_ptr;
	result.projection_index = GenerateTableIndex();
	result.group_index = GenerateTableIndex();
	result.aggregate_index = GenerateTableIndex();
	result.groupings_index = GenerateTableIndex();
	result.window_index = GenerateTableIndex();
	result.prune_index = GenerateTableIndex();

	result.from_table = std::move(from_table);
	// bind the sample clause
	if (statement.sample) {
		result.sample_options = std::move(statement.sample);
	}

	// visit the select list and expand any "*" statements
	vector<unique_ptr<ParsedExpression>> new_select_list;
	ExpandStarExpressions(statement.select_list, new_select_list);

	if (new_select_list.empty()) {
		throw BinderException("SELECT list is empty after resolving * expressions!");
	}
	statement.select_list = std::move(new_select_list);

	auto &bind_state = result.bind_state;
	for (idx_t i = 0; i < statement.select_list.size(); i++) {
		auto &expr = statement.select_list[i];
		result.names.push_back(expr->GetName());
		ExpressionBinder::QualifyColumnNames(*this, expr);
		if (!expr->GetAlias().empty()) {
			bind_state.alias_map[expr->GetAlias()] = i;
			result.names[i] = expr->GetAlias();
		}
		bind_state.projection_map[*expr] = i;
		bind_state.original_expressions.push_back(expr->Copy());
	}
	result.column_count = statement.select_list.size();

	// first visit the WHERE clause
	// the WHERE clause happens before the GROUP BY, PROJECTION or HAVING clauses
	if (statement.where_clause) {
		// bind any star expressions in the WHERE clause
		BindWhereStarExpression(statement.where_clause);

		ColumnAliasBinder alias_binder(bind_state);
		WhereBinder where_binder(*this, context, &alias_binder);
		unique_ptr<ParsedExpression> condition = std::move(statement.where_clause);
		result.where_clause = where_binder.Bind(condition);
	}

	// now bind all the result modifiers; including DISTINCT and ORDER BY targets
	OrderBinder order_binder({*this}, statement, bind_state);
	PrepareModifiers(order_binder, statement, result);

	vector<unique_ptr<ParsedExpression>> unbound_groups;