persistentstorage/sql/TEST/t_sqlsecurity5.cpp
changeset 15 3eacc0623088
parent 0 08ec8eefde2f
child 55 44f437012c90
--- 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);