Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Prerequisites

• I'm using the latest version of Docusaurus.
• I have tried the npm run clear or yarn clear command.
• I have tried rm -rf node_modules yarn.lock package-lock.json and re-installing packages.
• I have tried creating a repro with https://new.docusaurus.io.
• I have read the console error message carefully (if applicable).

Description

I write sql code block like this

insert into BOOK(
    ID, NAME, EDITION, PRICE, STORE_ID
) values(?, ?, ?, ?, ?)
/* batch-0: [100, SQL in Action, 1, 59.9, 2] */
/* highlight-next-line */
/* batch-1: [7, LINQ in Action, 3, 49.9, 2] */

I used /* highlight-next-line */ to highlight the last line, but it is actually not highlighted

This magic comment works normally for all languages except sql.

Reproducible demo

No response

Steps to reproduce

Just write a code block

• Language is SQL
• Use highlight-next-line

Expected behavior

The next lien should be highlighted

Actual behavior

The next line is not highlighted

This bug only appears when language is SQL

Your environment

OS: Mac-M1
Docusaurus: 3.6.3
Node version: 22.2.0

Self-service

• I'd be willing to fix this bug myself.