-
Notifications
You must be signed in to change notification settings - Fork 2.1k
Crash introspecting MSSQL database with DEFAULTs #11557
Copy link
Copy link
Closed
prisma/prisma-engines
#4884Labels
bug/2-confirmedBug has been reproduced and confirmed.Bug has been reproduced and confirmed.kind/bugA reported bug.A reported bug.tech/enginesIssue for tech Engines.Issue for tech Engines.topic: CREATE DEFAULT ... AS ...topic: defaulttopic: introspectiontopic: sql serverMicrosoft SQL ServerMicrosoft SQL Server
Milestone
Description
Hi Prisma Team! Prisma Migrate just crashed.
Command
introspect
Versions
| Name | Version |
|---|---|
| Platform | darwin-arm64 |
| Node | v14.15.4 |
| Prisma CLI | 3.9.0 |
| Engine | bcc2ff906db47790ee902e7bbc76d7ffb1893009 |
Error
Error: [libs/sql-schema-describer/src/mssql.rs:315:30] called `Result::unwrap()` on an `Err` value: "Couldn't parse default value: `create default [valueZero] as 0`"
Our SQL Server database schema has this in it:
CREATE DEFAULT [dbo].[valueZero]
AS
0
(This DEFAULT isn't referenced by name anywhere, but I can't DROP it because "it is bound to one or more column".)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bug/2-confirmedBug has been reproduced and confirmed.Bug has been reproduced and confirmed.kind/bugA reported bug.A reported bug.tech/enginesIssue for tech Engines.Issue for tech Engines.topic: CREATE DEFAULT ... AS ...topic: defaulttopic: introspectiontopic: sql serverMicrosoft SQL ServerMicrosoft SQL Server