Function TestSelectWithFullJoinCommand

parser/parser_test.go:623–660

(t *testing.T)

}

func TestSelectWithFullJoinCommand(t *testing.T) {
	input := "SELECT tbl.one, tbl2.two FROM tbl FULL JOIN tbl2 ON tbl.one EQUAL tbl2.one;"
	expectedJoinCommand := ast.JoinCommand{
		Token:    token.Token{Type: token.JOIN, Literal: "JOIN"},
		Name:     ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "tbl2"}},
		JoinType: token.Token{Type: token.FULL, Literal: "FULL"},
		Expression: ast.ConditionExpression{
			Left:      ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "tbl.one"}},
			Right:     ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "tbl2.one"}},
			Condition: token.Token{Type: token.EQUAL, Literal: "EQUAL"},
		},
	}
	expectedTableName := "tbl"
	expectedSpaces := []ast.Space{{ColumnName: token.Token{Type: token.IDENT, Literal: "tbl.one"}}, {ColumnName: token.Token{Type: token.IDENT, Literal: "tbl2.two"}}}

	lexer := lexer.RunLexer(input)
	parserInstance := New(lexer)
	sequences, err := parserInstance.ParseSequence()
	if err != nil {
		t.Fatalf("Got error from parser: %s", err)
	}

	if len(sequences.Commands) != 1 {
		t.Fatalf("sequences does not contain 1 statements. got=%d", len(sequences.Commands))
	}

	selectCommand := sequences.Commands[0].(*ast.SelectCommand)

	if !testSelectStatement(t, selectCommand, expectedTableName, expectedSpaces, false) {
		return
	}

	if !selectCommand.HasJoinCommand() {
		t.Fatalf("select command should have join command")
	}

	testJoinCommands(t, expectedJoinCommand, *selectCommand.JoinCommand)
}

func TestSelectWithAggregateFunctions(t *testing.T) {
	input := "SELECT MIN(colOne), MAX(colOne), COUNT(*), COUNT(colOne), SUM(colOne), AVG(colOne) FROM tbl;"