Function SplitSQL

backend/plugin/parser/mysql/split.go:20–29

SplitSQL splits the given SQL statement into multiple SQL statements. It uses omni's lexical splitter which handles quotes, comments, compound statements (BEGIN...END, IF...END IF, etc.) and DELIMITER without requiring valid SQL.

(statement string)

// statements (BEGIN...END, IF...END IF, etc.) and DELIMITER without
// requiring valid SQL.
func SplitSQL(statement string) ([]base.Statement, error) {
	segments := mysqlparser.Split(statement)

	result := make([]base.Statement, 0, len(segments))
	positionMapper := base.NewByteOffsetPositionMapper(statement)
	for _, seg := range segments {
		result = append(result, base.NewStatementFromRange(statement, positionMapper, seg.ByteStart, seg.ByteEnd, seg.Empty()))
	}
	return result, nil
}