drizzle-team / drizzle-team/drizzle-orm

[BUG]: Parse error in migration file generated with introspect

Open
#4,157 3 comments 0 reactions 0 assignees View on GitHub
bug bug/fixed-in-beta db/mysql drizzle/kit priority
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.39.3

### What version of `drizzle-kit` are you using?

0.30.4

### Other packages

_No response_

### Describe the Bug

When running the first migration, the migration generated by introspect command it fails with a parse error message

```
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*\n"
```
It seems like it doesn't recognize multi-line comments

### Reproduction Sandbox
You can use this repo https://github.com/pedro757/example-drizzle-issue-4115

### Steps to reproduce
1. Create an empty new mysql database
1. Import into that database the file `initial.sql` of the repository
1. Set the `DATABASE_URL` in a **.env** file
1. Run: `bun install`
1. Run: `bunx drizzle-kit introspect`
1. Make a simple change to `drizzle/schema.ts`
1. Run: `bunx drizzle-kit generate`
1. Run: `bunx drizzle-kit migrate`
It errors

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.