|
sl@0
|
1 |
[constraints]
|
|
sl@0
|
2 |
Delete0=c:\test2.db
|
|
sl@0
|
3 |
ExpectedError0=KErrNotFound
|
|
sl@0
|
4 |
Create1=c:\test2.db
|
|
sl@0
|
5 |
NewBlock2=test
|
|
sl@0
|
6 |
Close3=
|
|
sl@0
|
7 |
EndBlock4=
|
|
sl@0
|
8 |
|
|
sl@0
|
9 |
[test]
|
|
sl@0
|
10 |
Exec0=create table names(pkey int primary key, fname text, lname text NOT NULL, age int, UNIQUE(fname, lname), CHECK(age < 100));
|
|
sl@0
|
11 |
Exec1=insert into names(pkey, fname, lname, age) values(1, "fred", "smith", 25);
|
|
sl@0
|
12 |
Exec2=insert into names(pkey, fname, lname) values(1, "tom", "jones");
|
|
sl@0
|
13 |
ExpectedError2=KSqlErrConstraint
|
|
sl@0
|
14 |
Exec3=insert into names(pkey, fname, lname) values(2, "fred", "smith");
|
|
sl@0
|
15 |
ExpectedError3=KSqlErrConstraint
|
|
sl@0
|
16 |
Exec4=insert into names(pkey, fname) values(3, "fred");
|
|
sl@0
|
17 |
ExpectedError4=KSqlErrConstraint
|
|
sl@0
|
18 |
Exec5=insert into names(pkey, fname, lname, age) values(2, "tom", "jones", 101);
|
|
sl@0
|
19 |
ExpectedError5=KSqlErrConstraint
|
|
sl@0
|
20 |
EndBlock6=
|