GeezerVison

In MySQL mode, SELECT 1--2 currently becomes SELECT 1, and SELECT 1 /*! +2 */ loses executable SQL. Handle the MySQL double-dash whitespace rule and executable-comment boundaries in the shared character stream so String, Reader, InputStream, expression and statement APIs use the same rules. Quoted content and optimizer hints retain their existing behavior.

Unversioned /*! ... */ contents become regular SQL tokens. Conditional comments require an explicit withMySqlServerVersion(90702) (or 260700) target; eligible contents are parsed and later-version contents are skipped. Missing targets fail with a lexical diagnostic instead of silently dropping SQL. Output represents SQL for the selected target. This behavior is confined to the MYSQL dialect; documentation explains the configuration and nested executable-comment limitation.

Validation:

• Full Java 17 Gradle check: 8,988 tests, zero failures/errors, 25 skipped, including 33 focused comment tests; grammar ambiguity, formatting and static analysis passed.
• MySQL 9.7.2 and 26.7.0: 176 case/profile combinations × original, toString() and deparser output (528 executions), with matching result sets. Profiles: default, ANSI_QUOTES, NO_BACKSLASH_ESCAPES and PIPES_AS_CONCAT.
• Tests cover expression ASTs and mutation, five/six-digit version prefixes, quote/escape overrides, unterminated comments, rejection without fallback, API consistency, statement boundaries, original token positions, buffer expansion/reinitialization, and other dialects.

Reference: MySQL comment syntax.

Performance smoke checks used the existing JMH SQL corpus plus configured MySQL/PostgreSQL scripts, two forks with GC allocation profiling. Existing-corpus allocation was approximately 7.80 MB/op versus 7.77 MB/op at the base; the configured MySQL script increased by approximately 0.6% in this short run. Timing confidence intervals were wide, so these measurements are not a speed claim. A separate 5,000-executable-comment script preserved both statement boundaries and completed without pathological growth.