--- a/persistentstorage/sql/TEST/t_sqlsecurity5.cpp Fri Mar 19 10:00:55 2010 +0200
+++ b/persistentstorage/sql/TEST/t_sqlsecurity5.cpp Fri Apr 16 16:49:27 2010 +0300
@@ -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);