prisma: Introspection: Cannot read property 'substring' of undefined [MySQL 8]

Hello, Great project just wanted to let you know there could be an issue on Introspection module. Here is the error i have received when trying to do so:

Introspecting MySQL schema  with 26  tables.
 ERROR  Introspection failed:
Cannot read property 'substring' of undefined

About this issue

Original URL
State: closed
Created 5 years ago
Comments: 28 (13 by maintainers)

Most upvoted comments

Please coordinate with @do4gr that a schema that triggers this is added as a test case for Introspection @pantharshit00 - so we actually know we are good there.

janpio on Oct 29, 2019

@pantharshit00 With mysql 5.7 this issue was gone but there was another issue I was facing on a later stage and it led to not being able to generate model files. As it was unrelated to this issue I didn’t mentioned it in previous comment.

mirnpnh on Oct 24, 2019

@janpio Yes I was testing in mysql 8 too but the thing is the initial schemes I was receiving was for clients so I couldn’t share them publicly so I tried to reproduce the error with a test scheme but same error doesn’t happens (another error happened in later stages). So maybe mysql 8 by nature is not the problem I don’t know

mirnpnh on Sep 18, 2019

Hello i try to use database with only one table in one time to know where the error in i get error in table have

status` enum('Active','Inactive','Closed') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',

so the problem in enum type

AhmedElywa on Sep 18, 2019