Error introspecting a MySQL database

Hey guys!! I'm getting the following error when using npx drizzle-kit pull against a MySQL database:

code: 'ER_UNKNOWN_TABLE',
errno: 1109,
sqlState: '42S02',
sqlMessage: "Unknown table 'check_constraints' in information_schema"

code: 'ER_UNKNOWN_TABLE',
errno: 1109,
sqlState: '42S02',
sqlMessage: "Unknown table 'check_constraints' in information_schema"

These are the versions I'm using for the relevant packages:

"mysql2": "^3.11.3"
"drizzle-orm": "^0.35.3",
"drizzle-kit": "^0.26.2",

"mysql2": "^3.11.3"
"drizzle-orm": "^0.35.3",
"drizzle-kit": "^0.26.2",

Anyone have any idea how to go about it?

1 Reply

Shaidan•5d ago

i got the same error with mysql 5.6. downgrading drizzle-kit to 0.25.0 and drizzle-orm to 0.35.0 worked for me