Error: [libs\sql-schema-describer\src\mssql.rs:336:30] called Result::unwrap() on an Err value: "Couldn't parse default value: \r\ncreate default [va_nulla] as 0\r\n"

[jkomyno]

Command: prisma introspect
Version: 4.8.1
Binary Version: d6e67a83f971b175a593ccc12e15c4a757f93ffe
Report: https://prisma-errors.netlify.app/report/14503
OS: x64 win32 10.0.19045

JS Stacktrace:

Error: [libs\sql-schema-describer\src\mssql.rs:336:30] called `Result::unwrap()` on an `Err` value: "Couldn't parse default value: `\r\ncreate default [va_nulla] as 0\r\n`"

---

In here, we have:

  let default_string = DEFAULT_NON_STRING
      .captures_iter(&default_string)
      .next()
      .or_else(|| DEFAULT_STRING.captures_iter(&default_string).next())
      .or_else(|| DEFAULT_DB_GEN.captures_iter(&default_string).next())
      .map(|cap| cap[1].to_string())
      .ok_or_else(|| format!("Couldn't parse default value: `{}`", default_string))
      .unwrap();

[jkomyno]

This was already happening in prisma@3.15.2: https://prisma-errors.netlify.app/report/14761

[jkomyno]

Other report (from a user): #19971

[janpio]

We still do not know how to make Introspection crash because of the existence of such an index.
We need a SQL dump of a database that reproduces this behavior to replicate this behavior.

(For us the default is just ignored and not represented in the Prisma schema: #12150)

[janpio]

Reproduced: The line breaks cause this, see #24275