There are three cases where drizzle-kit's introspect:mysql does not work.

[araera111]

1. if default contains line breaks(\n\r)

CREATE TABLE `table_name` (
 `key` varchar(24) NOT NULL DEFAULT '　 aaa\r\nbbbb',
) ENGINE=InnoDB DEFAULT CHARSET=utf8

The newline code causes a line break, which is invalid as typescript.

CREATE TABLE `table_2` (
 `1st_key` tinyint(3) NOT NULL DEFAULT '0',
) 

This is an error because the beginning of the JavaScript key is a number.

 `decimal_test` decimal(6,2) unsigned NOT NULL,

If the value is unsignded in decimal, the output will be as follows and an error will result.

decimal_test: decimal("decimal_test", { precision: 6, scale: 2) unsigne }).notNull(),

The DB I am dealing with was created in ancient times (probably mythical times) and therefore contains a lot of incorrect data.
(ex:0000-00-00 00:00:00)

I expect it to work well.

[Angelelz]

I think this deserves an issue in the drizzle-kit mirror repo

[araera111]

thank you for your advice!