diff -r 5ffdb8f2067f -r fa9941cf3867 persistentstorage/sql/TEST/t_sqlsecurity5.cpp --- a/persistentstorage/sql/TEST/t_sqlsecurity5.cpp Sat Feb 20 00:33:55 2010 +0200 +++ b/persistentstorage/sql/TEST/t_sqlsecurity5.cpp Fri Mar 12 15:51:02 2010 +0200 @@ -115,6 +115,23 @@ //Attempt to modify the database schema err = TheDb.Exec(_L("CREATE TABLE IF NOT EXISTS C(FFF TEXT)")); TEST(err >= 0); + //Index operations + err = TheDb.Exec(_L("CREATE INDEX Cidx ON C(FFF)")); + TEST(err >= 0); + err = TheDb.Exec(_L("ANALYZE C")); + TEST(err >= 0); + err = TheDb.Exec(_L("DROP INDEX Cidx")); + TEST(err >= 0); + //Trigger operations + err = TheDb.Exec(_L("CREATE TRIGGER T1 AFTER INSERT ON C BEGIN INSERT INTO B VALUES(1, 2); END;")); + TEST(err >= 0); + err = TheDb.Exec(_L("DROP TRIGGER T1")); + TEST(err >= 0); + //View operations + err = TheDb.Exec(_L("CREATE VIEW V1 AS SELECT * FROM C")); + TEST(err >= 0); + err = TheDb.Exec(_L("DROP VIEW V1")); + TEST(err >= 0); //Attempt to update the user data (but it includes a READ operation) err = TheDb.Exec(_L("UPDATE A SET F1 = 11 WHERE F1 = 1")); TEST(err >= 0);