You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
'alter table `user` drop constraint check_constraint1, drop constraint check_constraint2'
);
});
will always fail since there isn't support for alter table foo drop constraint in sqlite3 directly.
$ sqlite3
SQLite version 3.37.22022-01-0613:25:41
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table foo (id integerprimary key, bar integercheck(bar >1));
sqlite>insert into foo values (1, 2);
sqlite>insert into foo values (1, -1);
Error: stepping, CHECKconstraint failed: bar >1 (19)
sqlite> alter table foo drop constraint;
Error: in prepare, near "constraint": syntax error (1)
sqlite> alter table foo drop constraint bar;
Error: in prepare, near "constraint": syntax error (1)
sqlite> alter table foo drop constraint1;
Error: in prepare, near "constraint": syntax error (1)
sqlite>
knex/test/unit/schema-builder/sqlite3.js
Lines 4641 to 4651 in 864530c
will always fail since there isn't support for
alter table foo drop constraint
in sqlite3 directly.relates to #4874
The text was updated successfully, but these errors were encountered: