workers-sdk 🐛 BUG: Unable to apply D1 migration: syntax error

trafficstars

Which Cloudflare product(s) does this pertain to?

D1, Wrangler core

What version(s) of the tool(s) are you using?

3.48.0

What version of Node are you using?

20.12.1

What operating system and version are you using?

Windows 11

Describe the Bug

Observed behavior

When applying a migration locally, the migration fails with the following error:

X [ERROR] near "INSERT": syntax error at offset 370

Expected behavior

The migration should apply correctly.

Steps to reproduce

Create a migration (npx wrangler d1 migrations create db-name init)

Add the following SQL into the migration:

CREATE TABLE Users (
    UserId INTEGER PRIMARY KEY,
    FullName TEXT NOT NULL,
    EmailAddress TEXT NOT NULL UNIQUE,
    DateCreated DATE NOT NULL,
    DateUpdated DATE
)

Run npx wrangler d1 migrations apply db-name

Please provide a link to a minimal reproduction

No response

Please provide any relevant error logs

--- 2024-04-09T09:10:28.946Z debug
🪵  Writing logs to "C:\Users\REDACTED\AppData\Roaming\xdg.config\.wrangler\logs\wrangler-2024-04-09_09-10-28_769.log"
---

--- 2024-04-09T09:10:28.946Z debug
Failed to load .env file ".env": Error: ENOENT: no such file or directory, open 'G:\REDACTED\REDACTED\.env'
    at Object.openSync (node:fs:582:18)
    at Object.readFileSync (node:fs:461:35)
    at tryLoadDotEnv (G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:124895:72)
    at loadDotEnv (G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:124904:12)
    at G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:166830:20
    at G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:132321:16
    at maybeAsyncResult (G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:130542:44)
    at G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:132320:14
    at G:\REDACTED\REDACTED\node_modules\wrangler\wrangler-dist\cli.js:130529:22
    at Array.reduce (<anonymous>) {
  errno: -4058,
  code: 'ENOENT',
  syscall: 'open',
  path: 'G:\\REDACTED\\REDACTED\\.env'
}
---

--- 2024-04-09T09:10:28.957Z log
 ⛅️ wrangler 3.48.0
[38;2;255;136;0m-------------------[39m
---

--- 2024-04-09T09:10:28.959Z log
🌀 Mapping SQL input into an array of statements
---

--- 2024-04-09T09:10:28.959Z log
🌀 Executing on local database REDACTED (REDACTED) from .wrangler\state\v3\d1:
---

--- 2024-04-09T09:10:28.959Z log
🌀 To execute on your remote database, add a --remote flag to your wrangler command.
---

--- 2024-04-09T09:10:29.217Z log
🌀 Mapping SQL input into an array of statements
---

--- 2024-04-09T09:10:29.218Z log
🌀 Executing on local database REDACTED (REDACTED) from .wrangler\state\v3\d1:
---

--- 2024-04-09T09:10:29.218Z log
🌀 To execute on your remote database, add a --remote flag to your wrangler command.
---

--- 2024-04-09T09:10:29.446Z log
Migrations to be applied:
[1m┌[22m[1m───────────────[22m[1m┐[22m
[1m│[22m[1m[34m name          [22m[39m[1m│[22m
[1m├[22m[1m───────────────[22m[1m┤[22m
[1m│[22m 0001_init.sql [1m│[22m
[1m└[22m[1m───────────────[22m[1m┘[22m
---

--- 2024-04-09T09:10:30.685Z debug
Retrieving cached values for account from node_modules\.cache\wrangler
---

--- 2024-04-09T09:10:30.685Z debug
-- START CF API REQUEST: GET https://api.cloudflare.com/client/v4/accounts/<REDACTED>/d1/database/<REDACTED>
---

--- 2024-04-09T09:10:30.685Z debug
HEADERS: omitted; set WRANGLER_LOG_SANITIZE=false to include sanitized data
---

--- 2024-04-09T09:10:30.685Z debug
INIT: omitted; set WRANGLER_LOG_SANITIZE=false to include sanitized data
---

--- 2024-04-09T09:10:30.685Z debug
-- END CF API REQUEST
---

--- 2024-04-09T09:10:32.913Z debug
-- START CF API RESPONSE: OK 200
---

--- 2024-04-09T09:10:32.913Z debug
HEADERS: omitted; set WRANGLER_LOG_SANITIZE=false to include sanitized data
---

--- 2024-04-09T09:10:32.913Z debug
RESPONSE: omitted; set WRANGLER_LOG_SANITIZE=false to include sanitized data
---

--- 2024-04-09T09:10:32.913Z debug
-- END CF API RESPONSE
---

--- 2024-04-09T09:10:32.913Z log
🌀 Mapping SQL input into an array of statements
---

--- 2024-04-09T09:10:32.913Z log
🌀 Executing on local database REDACTED (REDACTED) from .wrangler\state\v3\d1:
---

--- 2024-04-09T09:10:32.914Z log
🌀 To execute on your remote database, add a --remote flag to your wrangler command.
---

--- 2024-04-09T09:10:33.170Z log
[1m┌[22m[1m───────────────[22m[1m┬[22m[1m────────[22m[1m┐[22m
[1m│[22m[1m[34m name          [22m[39m[1m│[22m[1m[34m status [22m[39m[1m│[22m
[1m├[22m[1m───────────────[22m[1m┼[22m[1m────────[22m[1m┤[22m
[1m│[22m 0001_init.sql [1m│[22m ❌       [1m│[22m
[1m└[22m[1m───────────────[22m[1m┴[22m[1m────────[22m[1m┘[22m

❌ Migration 0001_init.sql failed with the following errors:
---