File: test_parse_expression.cpp

package info (click to toggle)
duckdb 1.5.1-3
  • links: PTS, VCS
  • area: main
  • in suites:
  • size: 299,196 kB
  • sloc: cpp: 865,414; ansic: 57,292; python: 18,871; sql: 12,663; lisp: 11,751; yacc: 7,412; lex: 1,682; sh: 747; makefile: 564
file content (33 lines) | stat: -rw-r--r-- 1,330 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#include "catch.hpp"
#include "duckdb/parser/parser.hpp"
#include "test_helpers.hpp"

using namespace duckdb;
using namespace std;

TEST_CASE("Parse Expression List valid expressions", "[parse_expression]") {
	auto result = Parser::ParseExpressionList("x");
	REQUIRE(result.size() == 1);

	result = Parser::ParseExpressionList("x, y, z");
	REQUIRE(result.size() == 3);

	result = Parser::ParseExpressionList("FIRST(x) AS x");
	REQUIRE(result.size() == 1);

	result = Parser::ParseExpressionList("x + 1, y * 2");
	REQUIRE(result.size() == 2);
}

TEST_CASE("Parse Expression List rejects invalid clauses", "[parse_expression]") {
#ifdef DUCKDB_CRASH_ON_ASSERT
	return;
#endif
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("FIRST(x) AS x WHERE x = 'bad'"), ParserException);
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("first(x) AS x HAVING x"), ParserException);
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("first(x) AS x QUALIFY x"), ParserException);
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("first(x) AS x USING SAMPLE 1 ROWS"), ParserException);
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("first(x) AS x GROUP BY x"), ParserException);
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("first(x) AS x ORDER BY x"), ParserException);
	REQUIRE_THROWS_AS(Parser::ParseExpressionList("x LIMIT 1"), ParserException);
}