SQL block does not support block magic comments

[babyfish-ct]

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.

[slorber]

Looks like we don't support multi-line comments for SQL, only single-line -- syntax.

This works:

```sql
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 think it should be pretty easy to add SQL multi-line comments, if anyone from the community want to contribute that in packages/docusaurus-theme-common/src/utils/codeBlockUtils.ts

[Rajvardhan222]

I want to contribute to this is it still open ?

[slorber]

You can submit a PR directly

[Rajvardhan222]

i made the changes but how i test those by viewing them,so that i can confirm

[Josh-Cena]

https://github.com/facebook/docusaurus/blob/main/CONTRIBUTING.md#development

[Rajvardhan222]

i am not sure how to view it even after changes it looks it is not taking effect
here is what i tried
added a new comment pattern
sql:{start:'/*',end:'*/'},

created a seprate case for sql inside getAllMagicCommentDirectiveStyles function

 case 'sql':
      return getCommentPattern(['sql','lua'], magicCommentDirectives);

[slorber]

We can't help you without seeing a PR including all your code and how it renders in the Netlify preview sorry. Please submit a draft PR and we'll review your attempt.