diff -r 000000000000 -r 08ec8eefde2f persistentstorage/sql/TEST/t_sqlconfig.cpp
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/sql/TEST/t_sqlconfig.cpp	Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,720 @@
+// Copyright (c) 2007-2009 Nokia Corporation and/or its subsidiary(-ies).
+// All rights reserved.
+// This component and the accompanying materials are made available
+// under the terms of "Eclipse Public License v1.0"
+// which accompanies this distribution, and is available
+// at the URL "http://www.eclipse.org/legal/epl-v10.html".
+//
+// Initial Contributors:
+// Nokia Corporation - initial contribution.
+//
+// Contributors:
+//
+// Description:
+//
+
+#include <e32test.h>
+#include <bautils.h>
+#include <sqldb.h>
+#include "SqlSrvConfig.h"
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+RTest TheTest(_L("t_sqlconfig test"));
+_LIT(KTestDir, "c:\\test\\");
+_LIT(KTestDbName, "c:\\test\\t_sqlconfig_1.db");
+_LIT(KTestDbName2, "c:\\test\\t_sqlconfig_2.db");
+_LIT(KTestDbName3, "c:[1111C1C1]t_sqlconfig_3.db");
+_LIT(KTestDbName4, "c:\\private\\1111C1C1\\t_sqlconfig_4.db");
+_LIT(KSqlSrvConfigFile, "c:\\test\\t_sqlserver.cfg");
+RFs TheFs;
+RSqlDatabase TheDb;
+RSqlDatabase TheDb2;
+
+enum TConfigParamType {EPrmCacheSize, EPrmPageSize, EPrmDbEncoding};
+
+//Default (build-time) configuration parameter values
+const TInt KDefaultPageSize = 1024;
+const TInt KDefaultCacheSize = (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / KDefaultPageSize;
+const TSqlSrvConfigParams::TDbEncoding KDefaultEncoding = TSqlSrvConfigParams::EEncUtf16;
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+void DestroyTestEnv()
+	{
+	TheDb2.Close();
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName4);
+	(void)RSqlDatabase::Delete(KTestDbName3);
+	(void)RSqlDatabase::Delete(KTestDbName2);
+	(void)RSqlDatabase::Delete(KTestDbName);
+	(void)TheFs.Delete(KSqlSrvConfigFile);
+	TheFs.Close();
+	}
+
+///////////////////////////////////////////////////////////////////////////////////////
+///////////////////////////////////////////////////////////////////////////////////////
+//Test macros and functions
+void Check(TInt aValue, TInt aLine)
+	{
+	if(!aValue)
+		{
+		DestroyTestEnv();
+		TheTest(EFalse, aLine);
+		}
+	}
+void Check(TInt aValue, TInt aExpected, TInt aLine)
+	{
+	if(aValue != aExpected)
+		{
+		DestroyTestEnv();
+		RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
+		TheTest(EFalse, aLine);
+		}
+	}
+#define TEST(arg) ::Check((arg), __LINE__)
+#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+void SetupTestEnv()
+    {
+	TInt err = TheFs.Connect();
+	TEST2(err, KErrNone);
+
+	err = TheFs.MkDir(KTestDir);
+	TEST(err == KErrNone || err == KErrAlreadyExists);
+
+	err = TheFs.CreatePrivatePath(EDriveC);
+	TEST(err == KErrNone || err == KErrAlreadyExists);
+
+	(void)RSqlDatabase::Delete(KTestDbName3);
+	(void)RSqlDatabase::Delete(KTestDbName2);
+	(void)RSqlDatabase::Delete(KTestDbName);
+	(void)TheFs.Delete(KSqlSrvConfigFile);//The test does not work if there is a test config file.
+	}
+
+TInt DoGetConfigParamValueL(RSqlDatabase& aDb, TConfigParamType aPrmType, const TDesC& aLogicalDbName = KNullDesC)
+	{
+	TBuf<100> sql;
+	sql.Copy(_L("PRAGMA "));
+	if(aLogicalDbName.Length() > 0)
+		{
+		sql.Append(aLogicalDbName);
+		sql.Append(_L("."));
+		}
+	
+	TSqlScalarFullSelectQuery q(aDb);
+	TInt res = 0;
+	switch(aPrmType)
+		{
+		case EPrmCacheSize:
+			sql.Append(_L("cache_size"));
+			res = q.SelectIntL(sql);
+			break;
+		case EPrmPageSize:
+			sql.Append(_L("page_size"));
+			res = q.SelectIntL(sql);
+			break;
+		case EPrmDbEncoding:
+			{
+			sql.Append(_L("encoding"));
+			TBuf<20> dbEncodingText;
+			res = q.SelectTextL(sql, dbEncodingText);
+			TEST2(res, KErrNone);
+			if(dbEncodingText.FindF(_L("UTF-16")) >= 0)
+				{
+				res = TSqlSrvConfigParams::EEncUtf16;	
+				}
+			else if(dbEncodingText.FindF(_L("UTF-8")) >= 0)
+				{
+				res = TSqlSrvConfigParams::EEncUtf8;	
+				}
+			else
+				{
+				TEST2(0, 1);
+				}
+			}
+			break;
+		default:
+			TEST2(0, 1);
+			break;
+		}
+	return res;
+	}
+
+TInt GetConfigParamValue(RSqlDatabase& aDb, TConfigParamType aPrmType, const TDesC& aLogicalDbName = KNullDesC)
+	{
+	TInt res = 0;
+	TRAPD(err, res = DoGetConfigParamValueL(aDb, aPrmType, aLogicalDbName));
+	TEST2(err, KErrNone);
+	return res;
+	}
+
+void AssertConfigPrmValues(RSqlDatabase& aDb, TInt aExpectedCacheSize, TInt aExpectedPageSize, TInt aExpectedDbEncoding, 
+		                   const TDesC& aLogicalDbName = KNullDesC)	
+	{
+	TInt cacheSize = GetConfigParamValue(aDb, EPrmCacheSize, aLogicalDbName);
+	TInt pageSize = GetConfigParamValue(aDb, EPrmPageSize ,aLogicalDbName);
+	TInt dbEncoding = GetConfigParamValue(aDb, EPrmDbEncoding, aLogicalDbName);
+	TEST2(cacheSize, aExpectedCacheSize);
+	TEST2(pageSize, aExpectedPageSize);
+	TEST2(dbEncoding, aExpectedDbEncoding);
+	}
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-3436
+@SYMTestCaseDesc		Test for DEF105928 "SQL server ignores config string parameters".
+						The test attempts to create/open a database using different cache size/page size/
+						database encoding configurations and then checks that the configuration parameters
+						have been set properly and have the expected values.
+@SYMTestPriority		High
+@SYMTestActions			Test for DEF105928 "SQL server ignores config string parameters".
+@SYMTestExpectedResults The test must not fail
+@SYMDEF					DEF105928
+*/
+void CfgFunctionalTest()
+	{
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. No config string. The default config parameters will be used.
+	TInt err = TheDb.Create(KTestDbName);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Cache size set.
+	_LIT8(KCfgStr1, "cache_size=32");
+	err = TheDb.Create(KTestDbName, &KCfgStr1);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 32, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Page size set.
+	_LIT8(KCfgStr2, "page_size=2048");
+	err = TheDb.Create(KTestDbName, &KCfgStr2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 2048, 2048, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Cache & Page size set.
+	_LIT8(KCfgStr3, "cache_size=256;page_size=4096");
+	err = TheDb.Create(KTestDbName, &KCfgStr3);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 256, 4096, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Cache size & Page size & db encoding set.
+	_LIT8(KCfgStr4, "cache_size=512;page_size=512;encoding=UTF-8");
+	err = TheDb.Create(KTestDbName, &KCfgStr4);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 512, 512, TSqlSrvConfigParams::EEncUtf8);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Cache size & Page size & db encoding set.
+	_LIT8(KCfgStr5, "cache_size=16;page_size=1024;encoding=UTF-16");
+	err = TheDb.Create(KTestDbName, &KCfgStr5);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 16, 1024, TSqlSrvConfigParams::EEncUtf16);
+	TheDb.Close();
+	//Open the database. Cache size set. The rest of parameter values must be the same as for KCfgStr5.
+	_LIT8(KCfgStr6, "cache_size=80");
+	err = TheDb.Open(KTestDbName, &KCfgStr6);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 80, 1024, TSqlSrvConfigParams::EEncUtf16);
+	TheDb.Close();
+	//Open the database. Attempt to set the page size (impossible when opening a database).
+	_LIT8(KCfgStr7, "page_size=2048");
+	err = TheDb.Open(KTestDbName, &KCfgStr7);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, 1024, TSqlSrvConfigParams::EEncUtf16);
+	TheDb.Close();
+	//Open the database. Attempt to set the encoding (impossible when opening a database).
+	_LIT8(KCfgStr8, "encoding=UTF-8");
+	err = TheDb.Open(KTestDbName, &KCfgStr8);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, 1024, TSqlSrvConfigParams::EEncUtf16);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Empty config string - 1
+	_LIT8(KCfgStr9, "");
+	err = TheDb.Create(KTestDbName, &KCfgStr9);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Empty config string - 2
+	_LIT8(KCfgStr10, "       ");
+	err = TheDb.Create(KTestDbName, &KCfgStr10);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Empty config string - 3
+	_LIT8(KCfgStr11, " ; ;   ;;   ");
+	err = TheDb.Create(KTestDbName, &KCfgStr11);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-3437
+@SYMTestCaseDesc		Test for DEF105928 "SQL server ignores config string parameters".
+						The test attempts to create/open a database using invalid configuration strings,
+						too long configuration string, string with missing parameter values, string with
+						invalid database encodings. The test expects the SQL server will report a failure
+						and will refuse to execute the operation.
+@SYMTestPriority		High
+@SYMTestActions			Test for DEF105928 "SQL server ignores config string parameters".
+@SYMTestExpectedResults The test must not fail
+@SYMDEF					DEF105928
+*/
+void CfgNegativeTest()
+	{
+	//Create a database. Spelling problem in the parameter name. This is not reported as an error by the SQL server
+	//(treated as unknown parameter)
+	_LIT8(KCfgStr1, "casche_size = 32");
+	TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
+	TEST2(err, KErrNone);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Spelling problem in the parameter value. 
+	_LIT8(KCfgStr2, "encoding = UTF-32");
+	err = TheDb.Create(KTestDbName, &KCfgStr2);
+	TEST2(err, KErrNone);//Invalid encoding: KErrNone, but the encoding will not be used
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Invalid config string.
+	_LIT8(KCfgStr3, "dfgjkdfgkdfk; sfkgjhdfgjkdfk; dfgdfetrwer");
+	err = TheDb.Create(KTestDbName, &KCfgStr3);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Too long and invalid config string.
+	_LIT8(KCfgStr4, "A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789");
+	err = TheDb.Create(KTestDbName, &KCfgStr4);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. No parameter value - 1.
+	_LIT8(KCfgStr5, "page_size=");
+	err = TheDb.Create(KTestDbName, &KCfgStr5);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. No parameter value - 2.
+	_LIT8(KCfgStr6, "page_size=;");
+	err = TheDb.Create(KTestDbName, &KCfgStr6);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Non-number parameter value - 1.
+	_LIT8(KCfgStr7, "page_size=aaa;");
+	err = TheDb.Create(KTestDbName, &KCfgStr7);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Non-number parameter value - 2.
+	_LIT8(KCfgStr8, "cache_size=weyu34;");
+	err = TheDb.Create(KTestDbName, &KCfgStr8);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. "soft_heap_limit_kb" in the config string.
+	_LIT8(KCfgStr9, "soft_heap_limit_kb=512;");
+	err = TheDb.Create(KTestDbName, &KCfgStr9);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. "free_space_threshold_kb" in the config string.
+	_LIT8(KCfgStr10, "free_space_threshold_kb=256;");
+	err = TheDb.Create(KTestDbName, &KCfgStr10);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-3438
+@SYMTestCaseDesc		Test for DEF105928 "SQL server ignores config string parameters".
+						The test attempts to create a database with configuration string containing:
+						negative or zero page size and cache size, too small or too big page size,
+						page size, not power of two. The test expects the SQL server will detect those 
+						invalid page size and cache size values and will refuse to execute the operation.
+@SYMTestPriority		High
+@SYMTestActions			Test for DEF105928 "SQL server ignores config string parameters".
+@SYMTestExpectedResults The test must not fail
+@SYMDEF					DEF105928
+*/
+void CfgInvalidCacheAndPageSizeTest()
+	{
+	//Create a database. Page size < 512.
+	_LIT8(KCfgStr1, "page_size=128;");
+	TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
+	TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Page size > 32768.
+	_LIT8(KCfgStr2, "page_size=65535;");
+	err = TheDb.Create(KTestDbName, &KCfgStr2);
+	TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Page size is not power of two.
+	_LIT8(KCfgStr3, "page_size=5000;");
+	err = TheDb.Create(KTestDbName, &KCfgStr3);
+	TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Zero cache size.
+	_LIT8(KCfgStr4, "cache_size=0");
+	err = TheDb.Create(KTestDbName, &KCfgStr4);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 0, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Negative cache size.
+	_LIT8(KCfgStr5, "cache_size=-32");
+	err = TheDb.Create(KTestDbName, &KCfgStr5);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Zero page size.
+	_LIT8(KCfgStr6, "page_size=0");
+	err = TheDb.Create(KTestDbName, &KCfgStr6);
+	TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create a database. Negative page size.
+	_LIT8(KCfgStr7, "page_size=-1024");
+	err = TheDb.Create(KTestDbName, &KCfgStr7);
+	TEST2(err, KErrArgument);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-3439
+@SYMTestCaseDesc		Test for DEF105928 "SQL server ignores config string parameters".
+						The test creates two databases using configuration strings and checks that database 1
+						configuration has no impact on database 2 configuration.
+@SYMTestPriority		High
+@SYMTestActions			Test for DEF105928 "SQL server ignores config string parameters".
+@SYMTestExpectedResults The test must not fail
+@SYMDEF					DEF105928
+*/
+void CfgCrossConnectionTest()
+	{
+	//Create database 1 with cache size = 40, page size = 2048.
+	_LIT8(KCfgStr1, "cache_size = 40; page_size = 2048");
+	TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 40, 2048, KDefaultEncoding);
+	//Without closing database 1, create database 2 without a configuration string.
+	//Check that database 2 uses the default configuration parameters
+	err = TheDb2.Create(KTestDbName2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb2, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
+	//Close database 2. Check the configuration parameters of database 1
+	TheDb2.Close();
+	AssertConfigPrmValues(TheDb, 40, 2048, KDefaultEncoding);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName2);
+	(void)RSqlDatabase::Delete(KTestDbName);
+	//Create 2 databases with different configuration parameters
+	_LIT8(KCfgStr2_1, "cache_size = 50; page_size = 512; encoding = UTF-16");
+	_LIT8(KCfgStr2_2, "cache_size = 80; page_size = 4096; encoding = UTF-8");
+	err = TheDb.Create(KTestDbName, &KCfgStr2_1);
+	TEST2(err, KErrNone);
+	err = TheDb2.Create(KTestDbName2, &KCfgStr2_2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 50, 512, TSqlSrvConfigParams::EEncUtf16);
+	AssertConfigPrmValues(TheDb2, 80, 4096, TSqlSrvConfigParams::EEncUtf8);
+	TheDb2.Close();
+	TheDb.Close();
+	//Reopen the databases and check the configuration parameters
+	err = TheDb.Open(KTestDbName);
+	TEST2(err, KErrNone);
+	err = TheDb2.Open(KTestDbName2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 512, 512, TSqlSrvConfigParams::EEncUtf16);
+	AssertConfigPrmValues(TheDb2, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 4096, 4096, TSqlSrvConfigParams::EEncUtf8);
+	TheDb2.Close();
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName2);
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-3440
+@SYMTestCaseDesc		Test for DEF105928 "SQL server ignores config string parameters".
+						The test creates a secure database with a configuration string. The test must not fail.
+@SYMTestPriority		High
+@SYMTestActions			Test for DEF105928 "SQL server ignores config string parameters".
+@SYMTestExpectedResults The test must not fail
+@SYMDEF					DEF105928
+*/
+void CfgSecureDbTest()
+	{
+	//Create
+	TSecurityPolicy policy(TSecurityPolicy::EAlwaysPass);
+	RSqlSecurityPolicy dbPolicy;
+	TInt err = dbPolicy.Create(policy);
+	TEST2(err, KErrNone);
+	_LIT8(KCfgStr1, "cache_size = 80; page_size = 4096; encoding = UTF-8");
+	err = TheDb.Create(KTestDbName3, dbPolicy, &KCfgStr1);
+	TEST2(err, KErrNone);
+	//Since it is a secure database, PRAGMAs cannot be executed (in order to assert the parameter values)
+	//AssertConfigPrmValues(TheDb, 80, 4096, TSqlSrvConfig::EEncUtf8);
+	TheDb.Close();	
+	dbPolicy.Close();
+	//Open
+	_LIT8(KCfgStr2, "cache_size = 100");
+	err = TheDb.Open(KTestDbName3, &KCfgStr2);
+	TEST2(err, KErrNone);
+	TheDb.Close();	
+	(void)RSqlDatabase::Delete(KTestDbName3);
+	}
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-3441
+@SYMTestCaseDesc		Test for DEF105928 "SQL server ignores config string parameters".
+						The test creates a private database with a configuration string. The test must not fail.
+@SYMTestPriority		High
+@SYMTestActions			Test for DEF105928 "SQL server ignores config string parameters".
+@SYMTestExpectedResults The test must not fail
+@SYMDEF					DEF105928
+*/
+void CfgPrivateDbTest()
+	{
+	//Create
+	_LIT8(KCfgStr1, "cache_size = 80; page_size = 4096; encoding = UTF-8");
+	TInt err = TheDb.Create(KTestDbName4, &KCfgStr1);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 80, 4096, TSqlSrvConfigParams::EEncUtf8);
+	TheDb.Close();	
+	//Open-1. The cache size can be changed.
+	_LIT8(KCfgStr2, "cache_size = 100");
+	err = TheDb.Open(KTestDbName4, &KCfgStr2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 100, 4096, TSqlSrvConfigParams::EEncUtf8);
+	TheDb.Close();	
+	//Open-2. The page size cannot be changed if the database does exist already.
+	_LIT8(KCfgStr3, "page_size = 512");
+	err = TheDb.Open(KTestDbName4, &KCfgStr3);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 4096, 4096, TSqlSrvConfigParams::EEncUtf8);
+	TheDb.Close();	
+	(void)RSqlDatabase::Delete(KTestDbName4);
+	}
+
+/**
+@SYMTestCaseID          SYSLIB-SQL-CT-3480
+@SYMTestCaseDesc		Test for INC106788 - Cannot set SQLite page_size bigger than 4k (4096).
+						The test attempts to create a database with page size 8K, 16K or 32K, which was not
+						possible before (the default page size (1K) has been used).
+@SYMTestPriority        High
+@SYMTestActions			Test for INC106788 - Cannot set SQLite page_size bigger than 4k (4096).
+@SYMTestExpectedResults The test should not fail or panic.
+@SYMDEF INC106788
+*/
+void INC106788()
+	{
+	//Create a database with page size = 8192.
+	(void)RSqlDatabase::Delete(KTestDbName);
+	_LIT8(KCfgStr1, "page_size = 8192");
+	TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 8192, 8192, KDefaultEncoding);
+	TheDb.Close();
+
+	//Create a database with page size = 16384.
+	(void)RSqlDatabase::Delete(KTestDbName);
+	_LIT8(KCfgStr2, "page_size = 16384");
+	err = TheDb.Create(KTestDbName, &KCfgStr2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 16384, 16384, KDefaultEncoding);
+	TheDb.Close();
+	
+	//Create a database with page size = 32768.
+	(void)RSqlDatabase::Delete(KTestDbName);
+	_LIT8(KCfgStr3, "page_size = 32768");
+	err = TheDb.Create(KTestDbName, &KCfgStr3);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 32768, 32768, KDefaultEncoding);
+	TheDb.Close();
+	
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+
+/**
+@SYMTestCaseID			SYSLIB-SQL-UT-4049
+@SYMTestCaseDesc		Database configuration string - injection test.
+						The test attempts to create a database using a configuration string
+						and passing a DELETE SQL statement as a compaction mode name.
+						The database should be created successfully, the invalid compaction mode - ignored,
+						the database system tables content shoud not be corrupted by the call.
+@SYMTestPriority		High
+@SYMTestActions			Database configuration string - injection test.
+@SYMTestExpectedResults Test must not fail
+@SYMREQ					REQ10405
+*/
+void InjectionTest()
+	{
+	(void)RSqlDatabase::Delete(KTestDbName);
+	TInt err = TheDb.Create(KTestDbName);
+	TEST2(err, KErrNone);
+	err = TheDb.Exec(_L("CREATE TABLE A(I INTEGER); INSERT INTO A(I) VALUES(1);"));
+	TEST(err > 0);
+	TheDb.Close();
+	
+	_LIT8(KConfig1, "cache_size=128;DELETE FROM A");
+	err = TheDb.Open(KTestDbName, &KConfig1);
+	TEST2(err, KErrArgument);
+	err = TheDb.Open(KTestDbName);
+	TEST2(err, KErrNone);
+	TSqlScalarFullSelectQuery query(TheDb);
+	TInt recCount = 0;
+	TRAP(err, recCount = query.SelectIntL(_L("SELECT COUNT(*) FROM A")));
+	TEST2(err, KErrNone);
+	TEST2(recCount, 1);
+	TheDb.Close();
+
+	_LIT8(KConfig2, "cache_size=256;compaction=DELETE FROM A;");
+	err = TheDb.Open(KTestDbName, &KConfig2);
+	TEST2(err, KErrNone);
+	query.SetDatabase(TheDb);
+	recCount = 0;
+	TRAP(err, recCount = query.SelectIntL(_L("SELECT COUNT(*) FROM A")));
+	TEST2(err, KErrNone);
+	TEST2(recCount, 1);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+
+	_LIT8(KConfig3, "cache_size=256;compaction=DELETE FROM symbian_settings;");
+	err = TheDb.Create(KTestDbName, &KConfig3);
+	TEST2(err, KErrNone);
+	query.SetDatabase(TheDb);
+	recCount = 0;
+	TRAP(err, recCount = query.SelectIntL(_L("SELECT COUNT(*) FROM symbian_settings")));
+	TEST2(err, KErrNone);
+	TEST2(recCount, 1);
+	TheDb.Close();
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+	
+/**
+@SYMTestCaseID          PDS-SQL-UT-4152
+@SYMTestCaseDesc		Test for DEF142305 - RSqlDatabase::Attach does not use cache_size configuration parameters.
+						The test verifies that when a database is attached, the attached database cache size will be set
+						based on the page size, soft heap limit and default cache size.
+@SYMTestPriority        High
+@SYMTestActions			Test for DEF142305 - RSqlDatabase::Attach does not use cache_size configuration parameters.
+@SYMTestExpectedResults The test must not fail.
+@SYMDEF INC106788
+*/
+void DEF142305()
+	{
+	_LIT8(KConfig, "cache_size=500");
+	
+	//Create main db
+	TInt err = TheDb.Create(KTestDbName, &KConfig);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+	
+	//Create non-secure db that will be attached 
+	err = TheDb.Create(KTestDbName2, &KConfig);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
+	TheDb.Close();
+
+	//Create private db that will be attached 
+	_LIT8(KConfig2, "page_size=2048");
+	err = TheDb.Create(KTestDbName4, &KConfig2);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 2048, 2048, KDefaultEncoding);//2048? - see KConfig2 string
+	TheDb.Close();
+
+	_LIT(KAttachDbName, "Attached");
+	
+	//Attach non-secure db
+	err = TheDb.Open(KTestDbName, &KConfig);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
+	err = TheDb.Attach(KTestDbName2, KAttachDbName);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding, KAttachDbName);
+	err = TheDb.Detach(KAttachDbName);
+	TEST2(err, KErrNone);
+	TheDb.Close();
+	
+	//Attach private db
+	err = TheDb.Open(KTestDbName, &KConfig);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
+	err = TheDb.Attach(KTestDbName4, KAttachDbName);
+	TEST2(err, KErrNone);
+	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 2048, 2048, KDefaultEncoding, KAttachDbName);//2048? - see KConfig2 string
+	err = TheDb.Detach(KAttachDbName);
+	TEST2(err, KErrNone);
+	TheDb.Close();
+	
+	(void)RSqlDatabase::Delete(KTestDbName4);
+	(void)RSqlDatabase::Delete(KTestDbName2);
+	(void)RSqlDatabase::Delete(KTestDbName);
+	}
+
+void DoTests()
+	{
+	TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3436 Sql config string - functional test "));
+	CfgFunctionalTest();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3437 Sql config string - negative test "));
+	CfgNegativeTest();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3438 Sql config string - invalid cache size and page size test "));
+	CfgInvalidCacheAndPageSizeTest();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3439 Sql config string - cross connection test "));
+	CfgCrossConnectionTest();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3440 Sql config string - secure database test "));
+	CfgSecureDbTest();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3441 Sql config string - private database test "));
+	CfgPrivateDbTest();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-3480 INC106788 - Cannot set SQLite page_size bigger than 4k (4096) "));
+	INC106788();
+	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-4049 Config string - injection tests"));
+	InjectionTest();
+	TheTest.Next(_L("@SYMTestCaseID:PDS-SQL-UT-4152: DEF142305 RSqlDatabase::Attach does not use cache_size configuration parameters"));
+	DEF142305();
+	}
+
+TInt E32Main()
+	{
+	TheTest.Title();
+	
+	CTrapCleanup* tc = CTrapCleanup::New();
+	TheTest(tc != NULL);
+	
+	__UHEAP_MARK;
+	
+	SetupTestEnv();
+	DoTests();
+	DestroyTestEnv();
+	
+	__UHEAP_MARKEND;
+	
+	TheTest.End();
+	TheTest.Close();
+	
+	delete tc;
+	
+	User::Heap().Check();
+	return KErrNone;
+	}