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