sqldiff does not report foreign key constraint differences

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

sqldiff does not report foreign key constraint differences

Anthony DeRobertis
The "Limitations" section of the sqldiff documentation mentions it
doesn't handle triggers or views, but nothing about constraints. So I
expected this to report something (note how in db1, t3.ref refences t1;
in db2, it references t2):

sqlite> .open db1
sqlite> pragma foreign_keys = 1;
sqlite> create table t1 (a integer not null primary key);
sqlite> create table t2 (b integer not null primary key);
sqlite> create table t3 (c integer not null primary key, ref integer not null references t1);
sqlite> .open db2
sqlite> pragma foreign_keys = 1;
sqlite> create table t1 (a integer not null primary key);
sqlite> create table t2 (b integer not null primary key);
sqlite> create table t3 (c integer not null primary key, ref integer not null references t2);
sqlite> .quit
$ sqldiff db1 db2
$

I expected some output there.

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users