On 25 Nov 2019, at 11:02am, Jaroslav Homisin <[email protected]> wrote:
> I have expected a list of the two constraints: of Primary key and of Unique.
> But I can find only Primary Key Constraint.
Where are you getting your list of constraints from ?
SQLite version 3.28.0 2019-04-15 14:49:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE XRelations (
...> XRID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
...> XID1 TEXT (100) NOT NULL ,
...> XID2 TEXT (100) NOT NULL ,
...> RelationType TEXT (100) NULL ,
...> CONSTRAINT unq UNIQUE ( XID1, XID2)
...> );
sqlite> INSERT INTO XRelations VALUES (1,'a','n','first');
sqlite> INSERT INTO XRelations VALUES (2,'a','n','first');
Error: UNIQUE constraint failed: XRelations.XID1, XRelations.XID2
sqlite> INSERT INTO XRelations VALUES (1,'b','m','first');
Error: UNIQUE constraint failed: XRelations.XRID
sqlite> .mode column
sqlite> PRAGMA index_list('XRelations');
0 sqlite_autoindex_XRelations_1 1 u 0
sqlite> PRAGMA index_info('sqlite_autoindex_XRelations_1');
0 1 XID1
1 2 XID2
sqlite> PRAGMA index_xinfo('sqlite_autoindex_XRelations_1');
0 1 XID1 0 BINARY 1
1 2 XID2 0 BINARY 1
2 -1 0 BINARY 0
This shows details of the index automatically made by SQLite so it can quickly
find violations of CONSTRAINT unq .
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
