When the table name starts with "set" (e.g. "settings"), the "set" prefix is highlighted as if it was a reserved keyword.

[your-diary]

Steps to Reproduce

1. Type SELECT * FROM settings_123 WHERE id = 123;.

System

• mycli version: 1.70.0
• OS/version: macOS

Discussion

AI says

Cause: mycli uses Pygments MySqlLexer, and that lexer has a special rule:

(r'\b(set)(?!\s*\()', Keyword),

It matches set at a word start, but does not require a word end, so in settings_123 it tokenizes as:

- set -> Keyword (green)
- tings_123 -> Name

I verified this directly by tokenizing SELECT * FROM settings_123 with MySqlLexer, and it produces exactly that split.

(I'm sorry if I should open this issue in the Pygments repo instead.)

---

By the way, I'm not affected by this issue so much; I almost don't care. So it won't hurt me if this issue is closed as not planned :)

[rolandwalker]

Hi! Thanks for the report! It might be a Pygments issue, but I don't see that regex in the Pygments source on first glance. We will check it out.

[rolandwalker]

Fixed upstream in pygments/pygments#3110, but we can leave this issue open until we upgrade the dependency.