-
-
Notifications
You must be signed in to change notification settings - Fork 2.3k
Open
Description
What did you do?
I exported a database to an SQL file. In the CREATE TABLE statement for tables with TEXT fields having default values, the default value is not quoted. For example,
CREATE TABLE IF NOT EXISTS "content" (
...
"WishlistedDate" TEXT DEFAULT 0000-00-00T00:00:00.000,
...
);
What did you expect to see?
"WishlistedDate" TEXT DEFAULT "0000-00-00T00:00:00.000",
The failure to quote the value causes an error when the file is re-imported.
What did you see instead?
"WishlistedDate" TEXT DEFAULT 0000-00-00T00:00:00.000,
DB4S Version
3.13.1
What OS are you seeing the problem on?
Windows
OS version
Windows 11
Relevant log output
Prevention against duplicate issues
- I have searched for similar issues
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels