Method parseDropSequenceStatement

pkg/sql/parser/mariadb.go:89–118

parseDropSequenceStatement parses: DROP SEQUENCE [IF EXISTS | IF NOT EXISTS] name The caller has already consumed DROP and SEQUENCE.

()

// parseDropSequenceStatement parses: DROP SEQUENCE [IF EXISTS | IF NOT EXISTS] name
// The caller has already consumed DROP and SEQUENCE.
func (p *Parser) parseDropSequenceStatement() (*ast.DropSequenceStatement, error) {
	stmt := ast.NewDropSequenceStatement()

	if strings.EqualFold(p.currentToken.Token.Value, "IF") {
		p.advance()
		if strings.EqualFold(p.currentToken.Token.Value, "NOT") {
			// IF NOT EXISTS is a non-standard permissive extension (MariaDB only supports
			// IF EXISTS natively). We accept it and reuse the IfExists flag since both
			// forms mean "suppress the error if the sequence is absent".
			p.advance()
			if !strings.EqualFold(p.currentToken.Token.Value, "EXISTS") {
				return nil, p.expectedError("EXISTS")
			}
			p.advance()
			stmt.IfExists = true
		} else if strings.EqualFold(p.currentToken.Token.Value, "EXISTS") {
			p.advance()
			stmt.IfExists = true
		} else {
			return nil, p.expectedError("EXISTS or NOT EXISTS")
		}
	}

	name := p.parseIdent()
	if name == nil || name.Name == "" {
		return nil, p.expectedError("sequence name")
	}
	stmt.Name = name
	return stmt, nil
}

// parseAlterSequenceStatement parses: ALTER SEQUENCE [IF EXISTS] name [options...]
// The caller has already consumed ALTER and SEQUENCE.