1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/constraints.ini	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,20 @@
     1.4 +[constraints]
     1.5 +Delete0=c:\test2.db
     1.6 +ExpectedError0=KErrNotFound
     1.7 +Create1=c:\test2.db
     1.8 +NewBlock2=test
     1.9 +Close3=
    1.10 +EndBlock4=
    1.11 +
    1.12 +[test]
    1.13 +Exec0=create table names(pkey int primary key, fname text, lname text NOT NULL, age int, UNIQUE(fname, lname), CHECK(age < 100));
    1.14 +Exec1=insert into names(pkey, fname, lname, age) values(1, "fred", "smith", 25);
    1.15 +Exec2=insert into names(pkey, fname, lname) values(1, "tom", "jones");
    1.16 +ExpectedError2=KSqlErrConstraint
    1.17 +Exec3=insert into names(pkey, fname, lname) values(2, "fred", "smith");
    1.18 +ExpectedError3=KSqlErrConstraint
    1.19 +Exec4=insert into names(pkey, fname) values(3, "fred");
    1.20 +ExpectedError4=KSqlErrConstraint
    1.21 +Exec5=insert into names(pkey, fname, lname, age) values(2, "tom", "jones", 101);
    1.22 +ExpectedError5=KSqlErrConstraint
    1.23 +EndBlock6=