drizzle-team / drizzle-team/drizzle-orm
[BUG]: Parse error in migration file generated with introspect
- 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
Assessment
This issue has not been assessed yet.