Method parseWhere

cpp_src/core/query/sql/sqlparser.cc:932–1073

template <SQLParser::Nested nested>
void SQLParser::parseWhere(Tokenizer& parser, TokenizerRange whereLocation) {
	auto tok = peekSqlToken(parser, nested == Nested::Yes ? NestedWhereFieldSqlToken : WhereFieldSqlToken, false);

	OpType nextOp = OpAnd;
	if (iequals(tok.Text(), "not"sv)) {
		nextOp = OpNot;
		parser.SkipToken();
	}
	int openBracketsCount = 0;
	bool expectSecondLogicalOperand = false;
	auto throwIfExpectSecondLogicalOperand = [&tok, &parser, &expectSecondLogicalOperand]() {
		if (expectSecondLogicalOperand) {
			const auto range = parser.Where(tok);
			throw SqlParserError(range, "Expected second logical operand, but found '{}' in query '{}'", tok.Text(), range);
		}
	};
	while (!parser.End()) {
		tok = peekSqlToken(parser, nested == Nested::Yes ? NestedWhereFieldSqlToken : WhereFieldSqlToken, false);
		parser.SkipToken(Tokenizer::Flags::NoFlags);
		while (tok.Type() == TokenName && iequals(tok.Text(), "equal_position"sv)) {
			parseEqualPositions(parser);
			tok = peekSqlToken(parser, nested == Nested::Yes ? NestedWhereFieldSqlToken : WhereFieldSqlToken, false);
			parser.SkipToken(Tokenizer::Flags::NoFlags);
		}
		expectSecondLogicalOperand = false;
		if (tok.Text() == "("sv) {
			tok = peekSqlToken(parser, nested == Nested::Yes ? NestedWhereFieldSqlToken : WhereFieldOrSubquerySqlToken, false);
			// isCondition(parser.peek_second_token().text() to distinguish the token type operator 'select' or field with name 'select'
			if (nested == Nested::No && iequals(tok.Text(), "select"sv) && !isCondition(parser.PeekSecondToken().Text())) {
				parseWhereCondition(parser, parseSubQuery(parser), nextOp);
				nextOp = OpAnd;
			} else {
				if (nextOp != OpAnd && iequals(tok.Text(), "left"sv)) {
					const auto range = parser.Where(tok);
					throw SqlParserError(range, "Left join with {} operation, {}", OpTypeToStr(nextOp), range);
				}
				query_.NextOp(nextOp);
				query_.OpenBracket();
				++openBracketsCount;
				if (iequals(tok.Text(), "not"sv)) {
					nextOp = OpNot;
					parser.SkipToken();
				} else {
					nextOp = OpAnd;
				}
				continue;
			}
		} else if (tok.Type() == TokenName) {
			const auto nextToken = parser.PeekToken();
			if (iequals(tok.Text(), "st_dwithin"sv) && nextToken.Text() == "("sv) {
				parseDWithin(parser, nextOp);
			} else if (iequals(tok.Text(), "knn"sv) && nextToken.Text() == "("sv) {
				parseKnn(parser, nextOp);
			} else if constexpr (nested == Nested::No) {
				if (iequals(tok.Text(), "join"sv)) {
					parseJoin(JoinType::LeftJoin, parser);
				} else if (iequals(tok.Text(), "left"sv)) {
					if (nextOp != OpAnd) {