[FORMATTING] MySQL "NOT IN ()" removes space before (

[verhovsky]

Input data

SELECT
  a
FROM
  b
WHERE
  x NOT IN(
    SELECT
      y
    FROM
      z
)

Expected Output

SELECT
  a
FROM
  b
WHERE
  x NOT IN (
    SELECT
      y
    FROM
      z
  )

Actual Output

(as is)

SELECT
  a
FROM
  b
WHERE
  x NOT IN(
    SELECT
      y
    FROM
      z
  )

Usage

• How are you calling / using the library? https://sql-formatter-org.github.io/sql-formatter/
• What SQL language(s) does this apply to? MySQL, the other language formatters format it as expected
• Which SQL Formatter version are you using? (The exact version number.) Website doesn't say

[nene]

Thanks for reporting.

[nene]

Fixed in 15.7.1.