equal
deleted
inserted
replaced
113 TEST2(err, KErrNone); |
113 TEST2(err, KErrNone); |
114 |
114 |
115 //Attempt to modify the database schema |
115 //Attempt to modify the database schema |
116 err = TheDb.Exec(_L("CREATE TABLE IF NOT EXISTS C(FFF TEXT)")); |
116 err = TheDb.Exec(_L("CREATE TABLE IF NOT EXISTS C(FFF TEXT)")); |
117 TEST(err >= 0); |
117 TEST(err >= 0); |
|
118 //Index operations |
|
119 err = TheDb.Exec(_L("CREATE INDEX Cidx ON C(FFF)")); |
|
120 TEST(err >= 0); |
|
121 err = TheDb.Exec(_L("ANALYZE C")); |
|
122 TEST(err >= 0); |
|
123 err = TheDb.Exec(_L("DROP INDEX Cidx")); |
|
124 TEST(err >= 0); |
|
125 //Trigger operations |
|
126 err = TheDb.Exec(_L("CREATE TRIGGER T1 AFTER INSERT ON C BEGIN INSERT INTO B VALUES(1, 2); END;")); |
|
127 TEST(err >= 0); |
|
128 err = TheDb.Exec(_L("DROP TRIGGER T1")); |
|
129 TEST(err >= 0); |
|
130 //View operations |
|
131 err = TheDb.Exec(_L("CREATE VIEW V1 AS SELECT * FROM C")); |
|
132 TEST(err >= 0); |
|
133 err = TheDb.Exec(_L("DROP VIEW V1")); |
|
134 TEST(err >= 0); |
118 //Attempt to update the user data (but it includes a READ operation) |
135 //Attempt to update the user data (but it includes a READ operation) |
119 err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1")); |
136 err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1")); |
120 TEST(err >= 0); |
137 TEST(err >= 0); |
121 //Attempt to update the user data (unconditional UPDATE, no READ operations) |
138 //Attempt to update the user data (unconditional UPDATE, no READ operations) |
122 err = TheDb.Exec(_L("UPDATE A SET F1 = 11")); |
139 err = TheDb.Exec(_L("UPDATE A SET F1 = 11")); |