Method readBacktickIdentifier

pkg/sql/tokenizer/tokenizer.go:932–978

readBacktickIdentifier reads MySQL-style backtick identifiers

()

// readBacktickIdentifier reads MySQL-style backtick identifiers
func (t *Tokenizer) readBacktickIdentifier() (models.Token, error) {
	startPos := t.pos.Clone()

	// Skip opening backtick
	t.pos.Index++
	t.pos.Column++

	var buf bytes.Buffer
	for t.pos.Index < len(t.input) {
		ch := t.input[t.pos.Index]

		if ch == '`' {
			// Check for escaped backtick
			if t.pos.Index+1 < len(t.input) && t.input[t.pos.Index+1] == '`' {
				// Include one backtick and skip the other
				buf.WriteByte('`')
				t.pos.Index += 2
				t.pos.Column += 2
				continue
			}

			// End of backtick identifier
			t.pos.Index++
			t.pos.Column++

			return models.Token{
				Type:  models.TokenTypeIdentifier, // Backtick identifiers are identifiers
				Value: buf.String(),
			}, nil
		}

		if ch == '\n' {
			t.pos.Line++
			t.pos.Column = 1
		} else {
			t.pos.Column++
		}

		buf.WriteByte(ch)
		t.pos.Index++
	}

	return models.Token{}, errors.UnterminatedStringError(
		t.toSQLPosition(startPos),
		string(t.input),
	)
}

// readQuotedString handles the actual scanning of a single/double-quoted string
func (t *Tokenizer) readQuotedString(quote rune) (models.Token, error) {