Broken on running eslint --fix on MacOS Sonoma

[PPan1215]

Description

It keeps appending perl locale issue to my sql:

select
    c.*
    exclude (xxx, xxx)
from
    current_records c
    left join historical_records h on c.xxx = h.xxx
where
    c.xxx != h._h_hashed perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LC_ALL = "C.UTF-8", LANG = (unset) are supported
    and installed on your system. perl: warning: Falling back to the standard locale ("C").perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LC_ALL = "C.UTF-8"...

where perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LC_ALL = "C.UTF-8", LANG = (unset) are supported gets appended after formatted sql.

Config

...
  {
    files: ["lib/**/*.ts"],
    plugins: { "sql" },
    rules: {
      "sql/format": [
        "error",
        {
          ignoreInline: true,
          ignoreTagless: true,
        }, {
          functionCase: "lowercase",
          keywordCase: "lowercase",
          spaces: 4,
        },
      ],
    },
  },
...

System version

macOS Sonoma 14.3.1 @ Apple M1 Pro

Expected behaviour

Format well without appending any warnings.

Attempted solutions in StackOverflow

• [x] Export LANG=xx in rc profile file
• [x] Configure locale terminal app

[ecosse3]

I have same issue. This plugin is unusable by this.

[UgurGumushan]

Same issue. Unusable