persistentstorage/sql/TEST/t_sqloom2.cpp
author Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
Fri, 22 Jan 2010 11:06:30 +0200
changeset 0 08ec8eefde2f
child 13 211563e4b919
child 17 55f2396f6d25
permissions -rw-r--r--
Revision: 201003 Kit: 201003

// Copyright (c) 2005-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 "t_sqloom.h"

RTest TheTest(_L("t_sqloom2 test"));

const TInt KSqlBufMaxLen = 16 * 1024;
const TInt KBlobStrLen = KSqlBufMaxLen / 2 - 100;
const TInt KBlobLen = KBlobStrLen;

TBuf8<KSqlBufMaxLen> TheSqlBuf;
TBuf8<KBlobStrLen> TheSqlBuf2;

///////////////////////////////////////////////////////////////////////////////////////
///////////////         RSqlStatement OOM tests         ///////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////

_LIT8(KSqlDbString, "BEGIN;\
					 CREATE TABLE BBB(Fld1 INTEGER, Fld2 BIGINT, Fld3 DOUBLE, Fld4 TEXT, Fld5 LONGBLOB);\
                     INSERT INTO BBB(fld1, fld2, fld3, fld4) VALUES(4562, 123456789012345, 78612.0091, 'text data');\
                     COMMIT;");
_LIT8(KSqlDbString2,"INSERT INTO BBB(fld1, fld2, fld3, fld4) VALUES(1, 34, 10.9897, 'data2');");

const TInt KLongColumnSize = 3013;
const TInt KLongParameterSize = 4501;

#define MAX(a, b) ((a) > (b) ? (a) : (b))

static TUint16 TheTextColumnData[MAX(KLongColumnSize, KLongParameterSize)];
static TUint8 TheBinaryColumnData[MAX(KLongColumnSize, KLongParameterSize) * sizeof(TUint16)];

//"RSqlStatement::Prepare()" OOM test (8-bit SELECT SQL statement)
void PrepareStmt8L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString, "SELECT * FROM BBB");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::PrepareL()" OOM test (8-bit SELECT SQL statement)
void PrepareStmt8_2L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString, "SELECT * FROM BBB");
	aStmt.PrepareL(aDb, KSqlString);
	}

//"RSqlStatement::Prepare()" OOM test (8-bit SELECT SQL statement), syntax error
void PrepareBadStmt8L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString, "SELECT123 * FROM BBB");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (8-bit SELECT SQL statement, move next)
void PrepareMoveStmt8L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString, "SELECT * FROM BBB");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	if(err == KErrNone)
		{
		err = aStmt.Next();
		if(err == KSqlAtRow)
			{
			err = KErrNone;
			}
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (8-bit INSERT SQL statement)
void PrepareInsertStmt8L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString, "INSERT INTO BBB(fld1, fld2, fld3, fld4) VALUES(2, 22, 22.2222, '2-2-2-2');");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare(), RSqlStatement::Exec(), RSqlStatement::Next()" OOM test (8-bit INSERT SQL statement, long column)
void ExecInsertNextStmt8L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString1, "INSERT INTO BBB(fld1, fld2, fld3, fld4, fld5) VALUES(10, 100, 100.001, :Prm1, :Prm2);");
	_LIT8(KSqlString2, "SELECT * FROM BBB WHERE fld1 = 10");
	TInt err = aStmt.Prepare(aDb, KSqlString1);
	if(err == KErrNone)
		{
		for(TInt i=0;i<KLongColumnSize;++i)
			{
			TheTextColumnData[i] = (TUint16)i;
			}
		const TPtrC textVal(TheTextColumnData, KLongColumnSize);
		const TPtrC8 binVal((TUint8*)TheTextColumnData, KLongColumnSize * sizeof(TUint16));
		TInt err = aStmt.BindText(0, textVal);
		if(err == KErrNone)
			{
			err = aStmt.BindBinary(1, binVal);
			}
		if(err == KErrNone)
			{
			err = aStmt.Exec();
			}
		}
	if(err >= 0)
		{
		aStmt.Close();
		err = aStmt.Prepare(aDb, KSqlString2);
		if(err == KErrNone)
			{
			err = aStmt.Next();
			}
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (8-bit INSERT SQL statement with parameters)
void PrepareInsertPrmStmt8L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT8(KSqlString, "INSERT INTO BBB(fld1, fld2, fld3, fld4) VALUES(:Prm0, :Prm1, :Prm2, :Prm3);");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (16-bit SELECT SQL statement)
void PrepareStmt16L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString, "SELECT * FROM BBB");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::PrepareL()" OOM test (16-bit SELECT SQL statement)
void PrepareStmt16_2L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString, "SELECT * FROM BBB");
	aStmt.PrepareL(aDb, KSqlString);
	}

//"RSqlStatement::Prepare()" OOM test (16-bit SELECT SQL statement), syntax error
void PrepareBadStmt16L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString, "23478SELECT * FROM BBB");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (16-bit SELECT SQL statement, move next)
void PrepareMoveStmt16L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString, "SELECT * FROM BBB");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	if(err == KErrNone)
		{
		err = aStmt.Next();
		if(err == KSqlAtRow)
			{
			err = KErrNone;
			}
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (16-bit INSERT SQL statement)
void PrepareInsertStmt16L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString, "INSERT INTO BBB(fld1, fld2, fld3, fld4) VALUES(2, 22, 22.2222, '2-2-2-2');");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare(), RSqlStatement::Exec(), RSqlStatement::Next()" OOM test (16-bit INSERT SQL statement, long column)
void ExecInsertNextStmt16L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString1, "INSERT INTO BBB(fld1, fld2, fld3, fld4, fld5) VALUES(10, 100, 100.001, :Prm1, :Prm2);");
	_LIT(KSqlString2, "SELECT * FROM BBB WHERE fld1 = 10");
	TInt err = aStmt.Prepare(aDb, KSqlString1);
	if(err == KErrNone)
		{
		for(TInt i=0;i<KLongColumnSize;++i)
			{
			TheTextColumnData[i] = (TUint16)i;
			}
		const TPtrC textVal(TheTextColumnData, KLongColumnSize);
		const TPtrC8 binVal((TUint8*)TheTextColumnData, KLongColumnSize * sizeof(TUint16));
		TInt err = aStmt.BindText(0, textVal);
		if(err == KErrNone)
			{
			err = aStmt.BindBinary(1, binVal);
			}
		if(err == KErrNone)
			{
			err = aStmt.Exec();
			}
		}
	if(err >= 0)
		{
		aStmt.Close();
		err = aStmt.Prepare(aDb, KSqlString2);
		if(err == KErrNone)
			{
			err = aStmt.Next();
			}
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::Prepare()" OOM test (16-bit INSERT SQL statement with parameters)
void PrepareInsertPrmStmt16L(RSqlDatabase& aDb, RSqlStatement& aStmt)
	{
	_LIT(KSqlString, "INSERT INTO BBB(fld1, fld2, fld3, fld4) VALUES(:Prm0, :Prm1, :Prm2, :Prm3);");
	TInt err = aStmt.Prepare(aDb, KSqlString);
	User::LeaveIfError(err);
	}

/**
@SYMTestCaseID			SYSLIB-SQL-CT-1617
@SYMTestCaseDesc		RSqlStatement::Prepare() OOM test
						Precondition: the database exists, opened, some record(s) inserted.
						The test calls the given as an argument function while simulating OOM failures
						and checks that there are no memory and resource leaks.
@SYMTestPriority		High
@SYMTestActions			RSqlStatement::Prepare() OOM test
@SYMTestExpectedResults Test must not fail
@SYMREQ					REQ5792
                        REQ5793
*/
void DoStmtPrepareOomTestL(TStmtFuncPtrL aStmtFuncPtrL, const TDesC& aDbFileName, TDbType aDbType, TInt aExpectedError = KErrNone)
	{
	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-1617 RSqlStatement::Prepare() - OOM test"));
	RSqlSecurityPolicy securityPolicy;
	CreateTestSecurityPolicy(securityPolicy);
	for(TInt i=0;i<(TInt)(sizeof(TheOomTestType)/sizeof(TheOomTestType[0]));++i)
		{
		RSqlDatabase::Delete(aDbFileName);
		RSqlDatabase db;
		TInt err = aDbType == ESecureDb ? db.Create(aDbFileName, securityPolicy) : db.Create(aDbFileName);
		TEST2(err, KErrNone);
		err = db.Exec(KSqlDbString);
		TEST(err >= 0);
		//The next operation is executed to force the SQL server side session to make one memory allocation
		//for the statement handle in its RDbObjContainer contrainer data member. Otherwise the OOM test will fail,
		//because the server side session will do one additional allocation, which stays alive untill the
		//session gets closed.
		RSqlStatement dummyStmt;
		err = dummyStmt.Prepare(db, _L("SELECT * FROM BBB"));
		TEST2(err, KErrNone);
		dummyStmt.Close();

		err = KErrNoMemory;
		const TInt KMaxAllocation = TheOomTestType[i] == EServerSideTest ? KStmtOomTestAllocLimitServer : KStmtOomTestAllocLimitClient;
		TInt allocationNo = 0;
		TInt failingAllocationNo = 0;
		while(allocationNo < KMaxAllocation)
			{
			MarkHandles();
			MarkAllocatedCells();

			__UHEAP_MARK;

			SetHeapFailure(TheOomTestType[i], ++allocationNo);

	    	RSqlStatement stmt;
			TRAP(err, (*aStmtFuncPtrL)(db, stmt));
			stmt.Close();
			if(err != KErrNoMemory)
				{
				TEST2(err, aExpectedError);
				}
			else
				{
				failingAllocationNo = allocationNo;	
				}

			ResetHeapFailure(TheOomTestType[i]);

			__UHEAP_MARKEND;

			CheckAllocatedCells();
			CheckHandles();
			}

		db.Close();
		TEST2(err, aExpectedError);
		PrintEndOfOomTest(TheOomTestType[i], failingAllocationNo);
		}
	//Delete the database file
	RSqlDatabase::Delete(aDbFileName);
	securityPolicy.Close();
	}

//"RSqlStatement::Reset()" OOM test
void ResetStmtL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.Next();
	if(err == KErrNone)
		{
		err = aStmt.Reset();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::Exec()" OOM test
void ExecStmtL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.Exec();
	User::LeaveIfError(err);
	}

//"RSqlStatement::Next()" OOM test
void NextStmtL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.Next();
	if(err == KErrNone)
		{
		err = aStmt.Next();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::ParameterIndex()" OOM test
void StmtParameterIndexL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.ParameterIndex(_L(":Prm2"));
	if(err == 1) //":Prm2" index is 1
		{
		err = KErrNone;
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::ParameterName()" OOM test
void StmtParameterNameL(RSqlStatement& aStmt)
	{
	// _LIT(KExcpected, ":Prm2");
	TPtrC paramName;
	TInt err = aStmt.ParameterName(1, paramName);
	User::LeaveIfError(err);
	}

//"RSqlStatement::ParamName()" OOM test
void StmtParamNameL(RSqlStatement& aStmt)
	{
	TPtrC paramName;
	TInt err = aStmt.ParamName(1, paramName);
	User::LeaveIfError(err);
	}

//"RSqlStatement::ColumnIndex()" OOM test
void StmtColumnIndexL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.ColumnIndex(_L("fLd3"));
	if(err == 2) //"fLd3" index is 2
		{
		err = KErrNone;
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::ColumnName()" OOM test
void StmtColumnNameL(RSqlStatement& aStmt)
	{
	//_LIT(KExpected, "fLd3");
	TPtrC colName;
	TInt err = aStmt.ColumnName(2, colName);
	User::LeaveIfError(err);
	}


//"RSqlStatement::ColumnType()" OOM test
void StmtColumnTypeL(RSqlStatement& aStmt)
	{
	TSqlColumnType coltype = aStmt.ColumnType(2);
	TEST(coltype == ESqlReal);
	}

//"RSqlStatement::ColumnSize()" OOM test
void StmtColumnSizeL(RSqlStatement& aStmt)
	{
	TInt colsize = aStmt.ColumnSize(2);
	TEST(colsize == sizeof(TReal));
	}

//"RSqlStatement::BindNull()" OOM test
void StmtBindNullL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.BindNull(1);
	//The bindings will be transferred on the server side right before Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::BindInt()" OOM test
void StmtBindIntL(RSqlStatement& aStmt)
	{
	TInt val = 184;
	TInt err = aStmt.BindInt(0, val);
	//The bindings will be transferred on the server side right before Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::BindInt64()" OOM test
void StmtBindInt64L(RSqlStatement& aStmt)
	{
	TInt64 val = MAKE_TINT64(0x00FF00FF, 0x12345678);
	TInt err = aStmt.BindInt64(1, val);
	//The bindings will be transferred on the server side right before Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::BindReal()" OOM test
void StmtBindRealL(RSqlStatement& aStmt)
	{
	TReal val = 25.2423;
	TInt err = aStmt.BindReal(2, val);
	//The bindings will be transferred on the server side right before Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::BindText()" OOM test
void StmtBindTextL(RSqlStatement& aStmt)
	{
	for(TInt i=0;i<KLongParameterSize;++i)
		{
		TheTextColumnData[i] = (TUint16)i;
		}
	const TPtrC val(TheTextColumnData, KLongParameterSize);
	TInt err = aStmt.BindText(3, val);
	//The bindings will be transferred on the server side right before a Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::BindBinary()" OOM test
void StmtBindBinaryL(RSqlStatement& aStmt)
	{
	for(TInt i=0;i<KLongParameterSize;++i)
		{
		TheBinaryColumnData[i] = (TUint8)i;
		}
	const TPtrC8 val(TheBinaryColumnData, KLongParameterSize);
	TInt err = aStmt.BindBinary(3, val);
	//The bindings will be transferred on the server side right before a Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::BindZeroBlob()" OOM test
void StmtBindZeroBlobL(RSqlStatement& aStmt)
	{
	TInt err = aStmt.BindZeroBlob(3, KLongParameterSize);
	//The bindings will be transferred on the server side right before a Next() or Exec() call
	if(err == KErrNone)
		{
		err = aStmt.Exec();
		}
	User::LeaveIfError(err);
	}

//"RSqlStatement::IsNull()" OOM test
void StmtIsNullColumnL(RSqlStatement& aStmt)
	{
	TBool rc = aStmt.IsNull(0);
	TEST(!rc);
	}

//"RSqlStatement::ColumnInt()" OOM test
void StmtColumnIntL(RSqlStatement& aStmt)
	{
	TInt val = aStmt.ColumnInt(0);
	TEST(val == 10);
	}

//"RSqlStatement::ColumnInt64()" OOM test
void StmtColumnInt64L(RSqlStatement& aStmt)
	{
	TInt64 val = aStmt.ColumnInt64(1);
	TEST(val == 100);
	}

//"RSqlStatement::ColumnReal()" OOM test
void StmtColumnRealL(RSqlStatement& aStmt)
	{
	TReal val = aStmt.ColumnReal(2);
	TEST(Abs(val - 100.001) < 0.000001);
	}

//"RSqlStatement::ColumnTextL()" OOM test
void StmtColumnText1L(RSqlStatement& aStmt)
	{
	TPtrC val = aStmt.ColumnTextL(3);
	TEST(val.Length() == KLongColumnSize);
	for(TInt i=0;i<KLongColumnSize;++i)
		{
		TEST(val[i] == (TUint16)i);
		}
	}

//"RSqlStatement::ColumnText()" OOM test
void StmtColumnText2L(RSqlStatement& aStmt)
	{
	TPtrC val;
	TInt err = aStmt.ColumnText(3, val);
	User::LeaveIfError(err);
	TEST(val.Length() == KLongColumnSize);
	for(TInt i=0;i<KLongColumnSize;++i)
		{
		TEST(val[i] == (TUint16)i);
		}
	}

//"RSqlStatement::ColumnText()" OOM test
void StmtColumnText3L(RSqlStatement& aStmt)
	{
	TPtr val(TheTextColumnData, KLongColumnSize);
	TInt err = aStmt.ColumnText(3, val);
	User::LeaveIfError(err);
	TEST(val.Length() == KLongColumnSize);
	for(TInt i=0;i<KLongColumnSize;++i)
		{
		TEST(val[i] == (TUint16)i);
		}
	}

//"RSqlStatement::ColumnBinaryL()" OOM test
void StmtColumnBinary1L(RSqlStatement& aStmt)
	{
	TPtrC8 val = aStmt.ColumnBinaryL(4);
	TEST(val.Length() == KLongColumnSize * sizeof(TUint16));
	for(TInt i=0,j=0;i<KLongColumnSize;++i,j+=2)
		{
		TUint8 valLow = val[j];
		TUint8 valHigh = val[j + 1];
		TEST(valLow == (TUint8)(i & 0xFF));
		TEST(valHigh == (TUint8)(((TUint)i >> 8) & 0xFF));
		}
	}

//"RSqlStatement::ColumnBinary()" OOM test
void StmtColumnBinary2L(RSqlStatement& aStmt)
	{
	TPtrC8 val;
	TInt err = aStmt.ColumnBinary(4, val);
	User::LeaveIfError(err);
	TEST(val.Length() == KLongColumnSize * sizeof(TUint16));
	for(TInt i=0,j=0;i<KLongColumnSize;++i,j+=2)
		{
		TUint8 valLow = val[j];
		TUint8 valHigh = val[j + 1];
		TEST(valLow == (TUint8)(i & 0xFF));
		TEST(valHigh == (TUint8)(((TUint)i >> 8) & 0xFF));
		}
	}

//"RSqlStatement::ColumnBinary()" OOM test
void StmtColumnBinary3L(RSqlStatement& aStmt)
	{
	TPtr8 val(TheBinaryColumnData, KLongColumnSize * sizeof(TUint16));
	TInt err = aStmt.ColumnBinary(4, val);
	User::LeaveIfError(err);
	TEST(val.Length() == KLongColumnSize * sizeof(TUint16));
	for(TInt i=0,j=0;i<KLongColumnSize;++i,j+=2)
		{
		TUint8 valLow = val[j];
		TUint8 valHigh = val[j + 1];
		TEST(valLow == (TUint8)(i & 0xFF));
		TEST(valHigh == (TUint8)(((TUint)i >> 8) & 0xFF));
		}
	}

//"RSqlStatement::ColumnCount()" OOM test
void StmtColumnCount(RSqlStatement& aStmt)
	{
	TInt cnt = aStmt.ColumnCount();
	TEST2(cnt, 5);
	}

//"RSqlStatement::DeclaredColumnType()" OOM test
void StmtDeclaredColumnTypeL(RSqlStatement& aStmt)
	{
	TInt cnt = aStmt.ColumnCount();
	TEST2(cnt, 5);
	const TSqlColumnType KColTypes[] = {ESqlInt, ESqlInt, ESqlReal, ESqlText, ESqlBinary};
	for(TInt i=0;i<cnt;++i)
		{
		TSqlColumnType colType;
		TInt err = aStmt.DeclaredColumnType(i, colType);
		User::LeaveIfError(err);
		TEST2(colType, KColTypes[i]);
		}
	}

//"RSqlColumnReadStream::ColumnBinary()" OOM test
void StmtColumnBinaryStreamL(RSqlStatement& aStmt)
	{
	RSqlColumnReadStream strm;
	CleanupClosePushL(strm);
	TInt err = strm.ColumnBinary(aStmt, 4);
	User::LeaveIfError(err);
	strm.ReadL(TheBinaryColumnData, KLongColumnSize * sizeof(TUint16));
	CleanupStack::PopAndDestroy(&strm);
	for(TInt i=0,j=0;i<KLongColumnSize;++i,j+=2)
		{
		TUint8 valLow = TheBinaryColumnData[j];
		TUint8 valHigh = TheBinaryColumnData[j + 1];
		TEST(valLow == (TUint8)(i & 0xFF));
		TEST(valHigh == (TUint8)(((TUint)i >> 8) & 0xFF));
		}
	}

//"RSqlColumnReadStream::ColumnText()" OOM test
void StmtColumnTextStreamL(RSqlStatement& aStmt)
	{
	RSqlColumnReadStream strm;
	CleanupClosePushL(strm);
	TInt err = strm.ColumnText(aStmt, 3);
	User::LeaveIfError(err);
	strm.ReadL(TheTextColumnData, KLongColumnSize);
	CleanupStack::PopAndDestroy(&strm);
	for(TInt i=0;i<KLongColumnSize;++i)
		{
		TEST(TheTextColumnData[i] == (TUint16)i);
		}
	}

//"RSqlParamWriteStream::BindBinary()" OOM test
void StmtParamBinaryStreamL(RSqlStatement& aStmt)
	{
	for(TInt i=0;i<KLongParameterSize;++i)
		{
		TheTextColumnData[i] = (TUint16)i;
		}

	RSqlParamWriteStream strm;
	CleanupClosePushL(strm);
	TInt err = strm.BindBinary(aStmt, 3);
	User::LeaveIfError(err);
	strm.WriteL((TUint8*)TheTextColumnData, KLongColumnSize * sizeof(TUint16));
	CleanupStack::PopAndDestroy(&strm);
	}

//"RSqlParamWriteStream::BindText()" OOM test
void StmtParamTextStreamL(RSqlStatement& aStmt)
	{
	for(TInt i=0;i<KLongParameterSize;++i)
		{
		TheTextColumnData[i] = (TUint16)i;
		}

	RSqlParamWriteStream strm;
	CleanupClosePushL(strm);
	TInt err = strm.BindText(aStmt, 3);
	User::LeaveIfError(err);
	strm.WriteL(TheTextColumnData, KLongColumnSize);
	CleanupStack::PopAndDestroy(&strm);
	}

/**
@SYMTestCaseID			SYSLIB-SQL-CT-1618
@SYMTestCaseDesc		RSqlStatement methods OOM tests
						Precondition: the database exists, opened, some record(s) inserted.
						The test calls the given as an argument function while simulating OOM failures
						and checks that there are no memory and resource leaks.
@SYMTestPriority		High
@SYMTestActions			RSqlStatement methods OOM tests
@SYMTestExpectedResults Test must not fail
@SYMREQ					REQ5792
                        REQ5793
*/
void DoStmtOomTestL(TStmtFuncPtrL aStmtPrepareFuncPtrL, TStmtFuncPtr2L aStmtTestFuncPtrL, const TDesC& aDbFileName, TDbType aDbType)
	{
	//This is not really an OOM test, because:
	//(A) The test forces the server to simulate heap failure on determied allocation step
	//(B) SQL server counts only the number of active statement and stream objects, the allocated memory cells
	//    are not counted.
	//    The reason that the allocated memory cells are not counted and in case of OOM failure - checked is
	//    because the SQL server may make some per-connection persistent memory allocations (cache pages, etc.)
	//    which will not be deallocated when the statement object is closed.

	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-1618 RSqlStatement - OOM test"));
	RSqlSecurityPolicy securityPolicy;
	CreateTestSecurityPolicy(securityPolicy);
	for(TInt i=0;i<(TInt)(sizeof(TheOomTestType)/sizeof(TheOomTestType[0]));++i)
		{
		RSqlDatabase::Delete(aDbFileName);
		RSqlDatabase db;
		TInt err = aDbType == ESecureDb ? db.Create(aDbFileName, securityPolicy) : db.Create(aDbFileName);
		TEST2(err, KErrNone);
		err = db.Exec(KSqlDbString);
		TEST(err >= 0);
		err = db.Exec(KSqlDbString2);
		TEST(err >= 0);

		err = KErrNoMemory;
		const TInt KMaxAllocation = TheOomTestType[i] == EServerSideTest ? KStmtOomTestAllocLimitServer : KStmtOomTestAllocLimitClient;
		TInt allocationNo = 0;
		TInt failingAllocationNo = 0;
		while(allocationNo < KMaxAllocation)
			{
			MarkHandles();
			MarkAllocatedCells();

			__UHEAP_MARK;

	    	RSqlStatement stmt;
			TRAP(err, (*aStmtPrepareFuncPtrL)(db, stmt));
			TEST2(err, KErrNone);

			SetHeapFailure(TheOomTestType[i], ++allocationNo);

			TRAP(err, (*aStmtTestFuncPtrL)(stmt));

			//ResetHeapFailure() has to be called before stmt.Close() because,
			//otherwise it will panic the server (the server resource count, marked by
			//SetHeapFailure() call, is 1 (there is one prepared statement))
			ResetHeapFailure(TheOomTestType[i]);

			stmt.Close();

			if(err != KErrNoMemory)
				{
				TEST2(err, KErrNone);
				}
			else
				{
				failingAllocationNo = allocationNo;	
				}

			__UHEAP_MARKEND;

			CheckAllocatedCells();
			CheckHandles();
			}

		db.Close();
		TEST2(err, KErrNone);
		PrintEndOfOomTest(TheOomTestType[i], failingAllocationNo);
		}
	//Delete the database file
	RSqlDatabase::Delete(aDbFileName);
	securityPolicy.Close();
	}

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////               RSqlBlobReadStream, RSqlBlobWriteStream - OOM tests          /////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////

//RSqlBlobReadStream, RSqlBlobWriteStream - OOM test preparation.
void ExecInsertBlobL(RSqlDatabase& aDb)
	{
	_LIT8(KSqlString1, "CREATE TABLE BBB(Fld1 INTEGER, Fld2 BIGINT, Fld3 DOUBLE, Fld4 TEXT, Fld5 LONGBLOB)");
	TInt err = aDb.Exec(KSqlString1);
	User::LeaveIfError(err);
	_LIT8(KSqlString2, "INSERT INTO BBB(fld1, fld2, fld3, fld4, fld5) VALUES(10, 100, 100.001, 'AAA', x'");
	TheSqlBuf.Copy(KSqlString2);
	for(TInt i=0;i<KBlobStrLen;++i)	
		{
		TheSqlBuf.Append(_L8("A5"));
		}
	TheSqlBuf.Append(_L8("')"));
	err = aDb.Exec(TheSqlBuf);
	User::LeaveIfError(err);
	}

//"RSqlBlobReadStream::OpenL()/RSqlBlobReadStream::ReadL()" OOM test
void BlobReadStreamOpenL(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	RSqlBlobReadStream strm;
	CleanupClosePushL(strm);
	if(aAttachDbName.Length() > 0)
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1, aAttachDbName);
		}
	else
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1);
		}
	const TInt KReadOpCnt = 8;
	for(TInt j=0;j<KReadOpCnt;++j)
		{
		strm.ReadL(TheSqlBuf, KBlobLen / KReadOpCnt);
		TEST2(TheSqlBuf.Length(), (KBlobLen / KReadOpCnt));
		for(TInt i=0;i<(KBlobLen / KReadOpCnt);++i)
			{
			TUint8 val = TheSqlBuf[i];
			TEST2(val, 0xA5);
			}
		}
	CleanupStack::PopAndDestroy(&strm);
	}

//"RSqlBlobReadStream::OpenL()/RSqlBlobReadStream::SizeL()" OOM test
void BlobReadStreamSizeL(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	RSqlBlobReadStream strm;
	CleanupClosePushL(strm);
	if(aAttachDbName.Length() > 0)
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1, aAttachDbName);
		}
	else
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1);
		}
	TInt size = strm.SizeL();	
	TEST2(size, KBlobLen);
	CleanupStack::PopAndDestroy(&strm);
	}

//"RSqlBlobWriteStream::OpenL()/RSqlBlobWriteStream::WriteL()" OOM test
void BlobWriteStreamOpenL(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	RSqlBlobWriteStream strm;
	CleanupClosePushL(strm);
	if(aAttachDbName.Length() > 0)
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1, aAttachDbName);
		}
	else
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1);
		}
	const TInt KWriteOpCnt = 8;
	TheSqlBuf.SetLength(KBlobLen / KWriteOpCnt);
	TheSqlBuf.Fill(TChar('Z'));
	for(TInt j=0;j<KWriteOpCnt;++j)
		{
		strm.WriteL(TheSqlBuf, KBlobLen / KWriteOpCnt);
		}
	strm.CommitL();		
	CleanupStack::PopAndDestroy(&strm);
	}

//"RSqlBlobWriteStream::OpenL()/RSqlBlobWriteStream::SizeL()" OOM test
void BlobWriteStreamSizeL(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	RSqlBlobWriteStream strm;
	CleanupClosePushL(strm);
	if(aAttachDbName.Length() > 0)
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1, aAttachDbName);
		}
	else
		{
		strm.OpenL(aDb, _L("BBB"), _L("fld5"), 1);
		}
	TInt size = strm.SizeL();	
	TEST2(size, KBlobLen);
	CleanupStack::PopAndDestroy(&strm);
	}
	
//"TSqlBlob::GetLC()" OOM test
void BlobWholeGet1L(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	HBufC8* buf = NULL;
	if(aAttachDbName.Length() > 0)
		{
		buf = TSqlBlob::GetLC(aDb, _L("BBB"), _L("fld5"), 1, aAttachDbName);
		}
	else
		{
		buf = TSqlBlob::GetLC(aDb, _L("BBB"), _L("fld5"), 1);
		}
	TEST(buf->Length() == KBlobStrLen);
	CleanupStack::PopAndDestroy(buf);
	}
	
//"TSqlBlob::Get()" OOM test
void BlobWholeGet2L(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	if(aAttachDbName.Length() > 0)
		{
		TSqlBlob::Get(aDb, _L("BBB"), _L("fld5"), TheSqlBuf2, 1, aAttachDbName);
		}
	else
		{
		TSqlBlob::Get(aDb, _L("BBB"), _L("fld5"), TheSqlBuf2, 1);
		}
	}

//"TSqlBlob::SetL()" OOM test
void BlobWholeSetL(RSqlDatabase& aDb, const TDesC& aAttachDbName = KNullDesC)
	{
	if(aAttachDbName.Length() > 0)
		{
		TSqlBlob::SetL(aDb, _L("BBB"), _L("fld5"), TheSqlBuf, 1, aAttachDbName);
		}
	else
		{
		TSqlBlob::Get(aDb, _L("BBB"), _L("fld5"), TheSqlBuf, 1);
		}
	}

/**
@SYMTestCaseID			SYSLIB-SQL-UT-4091
@SYMTestCaseDesc		RSqlBlobReadStream, RSqlBlobWriteStream methods OOM tests
						Precondition: the database exists, opened, some record(s) inserted.
						The test calls the given as an argument function while simulating OOM failures
						and checks that there are no memory and resource leaks.
@SYMTestPriority		High
@SYMTestActions			RSqlBlobReadStream, RSqlBlobWriteStream methods OOM tests
@SYMTestExpectedResults Test must not fail
@SYMREQ					REQ5792
                        REQ10410
                        REQ10411
                        REQ10418
*/
void DoBlobOomTestL(TBlobPrepareFuncPtrL aBlobPrepareFuncPtrL, TBlobTestFuncPtrL aBlobTestFuncPtrL, 
					const TDesC& aDbFileName, TDbType aDbType, TBool aAttachDb = EFalse)
	{
	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-4091 RSqlBlobReadStream, RSqlBlobWriteStream - OOM test"));
	RSqlSecurityPolicy securityPolicy;
	CreateTestSecurityPolicy(securityPolicy);
	for(TInt i=0;i<(TInt)(sizeof(TheOomTestType)/sizeof(TheOomTestType[0]));++i)
		{
		RSqlDatabase::Delete(aDbFileName);
		RSqlDatabase db;
		TInt err = aDbType == ESecureDb ? db.Create(aDbFileName, securityPolicy) : db.Create(aDbFileName);
		TEST2(err, KErrNone);
		TRAP(err, (*aBlobPrepareFuncPtrL)(db));
		TEST2(err, KErrNone);
		_LIT(KAttachDbName, "AttachDb");
		if(aAttachDb)
			{
			err = db.Attach(aDbFileName, KAttachDbName);
			TEST2(err, KErrNone);
			}

		err = KErrNoMemory;
		const TInt KMaxAllocation = TheOomTestType[i] == EServerSideTest ? KBlobOomTestAllocLimitServer : KBlobOomTestAllocLimitClient;
		TInt allocationNo = 0;
		TInt failingAllocationNo = 0;
		while(allocationNo < KMaxAllocation)
			{
			MarkHandles();
			MarkAllocatedCells();

			__UHEAP_MARK;

			SetHeapFailure(TheOomTestType[i], ++allocationNo);
			if(aAttachDb)
				{
				TRAP(err, (*aBlobTestFuncPtrL)(db, KAttachDbName));
				}
			else
				{
				TRAP(err, (*aBlobTestFuncPtrL)(db));
				}

			ResetHeapFailure(TheOomTestType[i]);

			if(err != KErrNoMemory)
				{
				if(err != KErrNone)
					{
					TPtrC errmsg = db.LastErrorMessage();
					if(errmsg.Length() > 0)
						{
						TheTest.Printf(_L("\r\n@@@ error %d, error message: %S\r\n"), err, &errmsg);	
						}
					}
				TEST2(err, KErrNone);
				}
			else
				{
				failingAllocationNo = allocationNo;
				}				

			__UHEAP_MARKEND;

			CheckAllocatedCells();
			CheckHandles();
			}
		TEST2(err, KErrNone);

		if(aAttachDb)
			{
			(void)db.Detach(KAttachDbName);
			}

		db.Close();
		err = RSqlDatabase::Delete(aDbFileName);
		TEST2(err, KErrNone);
		PrintEndOfOomTest(TheOomTestType[i], failingAllocationNo);
		}
	securityPolicy.Close();
	}

void ScalarFullSelectInt_8L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TInt val = query.SelectIntL(_L8("SELECT F1 FROM A WHERE F3 < 0"));
	TEST2(val, 2);
	}

void ScalarFullSelectInt64_8L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TInt64 val = query.SelectInt64L(_L8("SELECT F2 FROM A WHERE F1 = 1"));
	TEST2(val, 10000000000LL);
	}

void ScalarFullSelectReal_8L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TReal val = query.SelectRealL(_L8("SELECT F3 FROM A WHERE F1 = 1"));
	TEST(val > 2.0 && val < 3.0);
	}

void ScalarFullSelectText_8L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TBuf<20> buf;
	TInt err = query.SelectTextL(_L8("SELECT F4 FROM A WHERE F1 = 1"), buf);
	TEST2(err, KErrNone);
	_LIT(KText, "NAME1234567890");
	TEST(buf == KText);
	}

void ScalarFullSelectBinary_8L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TBuf8<20> buf;
	TInt err = query.SelectBinaryL(_L8("SELECT F5 FROM A WHERE F1 = 1"), buf);
	TEST2(err, KErrNone);
	TEST(buf.Length() == 0);
	}

void ScalarFullSelectInt_16L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TInt val = query.SelectIntL(_L16("SELECT F1 FROM A WHERE F3 < 0"));
	TEST2(val, 2);
	}

void ScalarFullSelectInt64_16L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TInt64 val = query.SelectInt64L(_L16("SELECT F2 FROM A WHERE F1 = 1"));
	TEST2(val, 10000000000LL);
	}

void ScalarFullSelectReal_16L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TReal val = query.SelectRealL(_L16("SELECT F3 FROM A WHERE F1 = 1"));
	TEST(val > 2.0 && val < 3.0);
	}

void ScalarFullSelectText_16L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TBuf<20> buf;
	TInt err = query.SelectTextL(_L16("SELECT F4 FROM A WHERE F1 = 1"), buf);
	TEST2(err, KErrNone);
	_LIT(KText, "NAME1234567890");
	TEST(buf == KText);
	}

void ScalarFullSelectBinary_16L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	TBuf8<20> buf;
	TInt err = query.SelectBinaryL(_L16("SELECT F5 FROM A WHERE F1 = 1"), buf);
	TEST2(err, KErrNone);
	TEST(buf.Length() == 0);
	}

void ScalarFullSelectText2_8L(RSqlDatabase& aDb)
	{
	TSqlScalarFullSelectQuery query(aDb);
	HBufC* buf = HBufC::NewLC(8);
	TPtr name = buf->Des();
	TInt rc = query.SelectTextL(_L8("SELECT F4 FROM A WHERE F1 = 1"), name);
	TEST(rc >= 0); //the function may return only non-negative values
	if(rc > 0)
		{
		buf = buf->ReAllocL(rc);
		CleanupStack::Pop();
		CleanupStack::PushL(buf);
		name.Set(buf->Des());
		rc = query.SelectTextL(_L8("SELECT F4 FROM A WHERE F1 = 1"), name);
		TEST(rc == 0);
		_LIT(KText, "NAME1234567890");
		TEST(name == KText);
		}
	CleanupStack::PopAndDestroy(buf);
	}

/**
@SYMTestCaseID			SYSLIB-SQL-CT-1811
@SYMTestCaseDesc		TSqlScalarFullSelectQuery functions OOM test
						Precondition: the database exists.
						The test simulates OOM failures while calling TSqlScalarFullSelectQuery functions
						and checks that there are no memory and resource leaks.
@SYMTestPriority		High
@SYMTestActions			TSqlScalarFullSelectQuery methods OOM tests
@SYMTestExpectedResults Test must not fail
@SYMREQ					REQ5792
                        REQ5793
*/
void DoFullSelectOomTest(TScalarFullSelectFuncPtrL aTestFunctionPtrL)
	{
	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-1811 TSqlScalarFullSelectQuery - OOM test"));
	//Create test database
	RSqlDatabase db;
	TInt err = db.Create(KTestDb);
	TEST2(err, KErrNone);
	err = db.Exec(_L("CREATE TABLE A(F1 INTEGER, F2 INTEGER, F3 FLOAT, F4 TEXT, F5 BLOB)"));
	TEST(err >= 0);
	err = db.Exec(_L("INSERT INTO A(F1, F2, F3, F4, F5) VALUES(1, 10000000000, 2.54, 'NAME1234567890', NULL)"));
	TEST2(err, 1);
	err = db.Exec(_L("INSERT INTO A(F1, F2, F3, F4) VALUES(2, 200, -1.11, 'ADDRESS')"));
	TEST2(err, 1);
	db.Close();
	//OOM test loop
	for(TInt i=0;i<(TInt)(sizeof(TheOomTestType)/sizeof(TheOomTestType[0]));++i)
		{
		err = KErrNoMemory;
		const TInt KMaxAllocation = TheOomTestType[i] == EServerSideTest ? KStmtOomTestAllocLimitServer : KStmtOomTestAllocLimitClient;
		TInt allocationNo = 0;
		TInt failingAllocationNo = 0;
		while(allocationNo < KMaxAllocation)
			{
			MarkHandles();
			MarkAllocatedCells();

			__UHEAP_MARK;

			if(TheOomTestType[i] == EServerSideTest)
				{//We will delay the heap failure simulation, until the database is opened
				SetDbHeapFailure(TheOomTestType[i], ++allocationNo, ETrue);
				}

			err = db.Open(KTestDb);
			TEST2(err, KErrNone);

			if(TheOomTestType[i] == EClientSideTest)
				{
				SetDbHeapFailure(TheOomTestType[i], ++allocationNo);
				}

			TRAP(err, (*aTestFunctionPtrL)(db));
			db.Close();
			if(err != KErrNoMemory)
				{
				TEST2(err, KErrNone);
				}
			else
				{
				failingAllocationNo = allocationNo;	
				}

			ResetDbHeapFailure(TheOomTestType[i]);

			__UHEAP_MARKEND;

			CheckAllocatedCells();
			CheckHandles();
			}
		TEST2(err, KErrNone);
		PrintEndOfOomTest(TheOomTestType[i], failingAllocationNo);
		}
	//Delete the database file
	RSqlDatabase::Delete(KTestDb);
	}

//RSqlStatement OOM tests
void StmtOomTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===RSqlStatement::Prepare(), 8-bit SQL\r\n"));
		DoStmtPrepareOomTestL(&PrepareStmt8L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::PrepareL(), 8-bit SQL\r\n"));
		DoStmtPrepareOomTestL(&PrepareStmt8_2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Prepare(), 16-bit SQL\r\n"));
		DoStmtPrepareOomTestL(&PrepareStmt16L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::PrepareL(), 16-bit SQL\r\n"));
		DoStmtPrepareOomTestL(&PrepareStmt16_2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Reset(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareStmt8L, &ResetStmtL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Reset(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareStmt16L, &ResetStmtL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Exec(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertStmt8L, &ExecStmtL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Exec(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertStmt16L, &ExecStmtL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Next(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareStmt8L, &NextStmtL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::Next(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareStmt16L, &NextStmtL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ParameterIndex(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtParameterIndexL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ParameterIndex(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtParameterIndexL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ParameterName(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtParameterNameL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ParameterName(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtParameterNameL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ParamName(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtParamNameL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ParamName(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtParamNameL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnIndex(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareStmt8L, &StmtColumnIndexL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnIndex(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareStmt16L, &StmtColumnIndexL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnType(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareMoveStmt8L, &StmtColumnTypeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnType(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareMoveStmt16L, &StmtColumnTypeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnSize(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareMoveStmt8L, &StmtColumnSizeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnSize(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareMoveStmt16L, &StmtColumnSizeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnName(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareMoveStmt8L, &StmtColumnNameL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnName(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareMoveStmt16L, &StmtColumnNameL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindNull(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindNullL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindNull(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindNullL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindInt(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindIntL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindInt(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindIntL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindInt64(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindInt64L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindInt64(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindInt64L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindReal(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindRealL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindReal(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindRealL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindText(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindTextL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindText(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindTextL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindBinary(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindBinaryL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindBinary(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindBinaryL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindZeroBlob(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtBindZeroBlobL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::BindZeroBlob(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtBindZeroBlobL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::IsNull(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtIsNullColumnL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::IsNull(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtIsNullColumnL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnInt(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnIntL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnInt(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnIntL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnInt64(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnInt64L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnInt64(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnInt64L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnReal(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnRealL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnReal(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnRealL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnTextL(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnText1L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnTextL(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnText1L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnText()-1, 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnText2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnText()-1, 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnText2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnText()-2, 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnText3L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnText()-2, 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnText3L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnBinaryL(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnBinary1L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnBinaryL(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnBinary1L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnBinary()-1, 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnBinary2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnBinary()-1, 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnBinary2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnBinary()-2, 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnBinary3L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnBinary()-2, 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnBinary3L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnCount(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnCount, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::ColumnCount(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnCount, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::DeclaredColumnType(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtDeclaredColumnTypeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlStatement::DeclaredColumnType(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtDeclaredColumnTypeL, dbFileName[i], dbType[i]);
		}
	}

//RSqlStatement - negative OOM tests
void StmtOomNegativeTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===RSqlStatement::Prepare(), 8-bit SQL\r\n"));
		DoStmtPrepareOomTestL(&PrepareBadStmt8L, dbFileName[i], dbType[i], KSqlErrGeneral);

		TheTest.Printf(_L("===RSqlStatement::Prepare(), 16-bit SQL\r\n"));
		DoStmtPrepareOomTestL(&PrepareBadStmt16L, dbFileName[i], dbType[i], KSqlErrGeneral);
		}
	}

//RSqlColumnReadStream OOM tests
void ColumnReadStreamOomTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===RSqlColumnReadStream::ColumnBinary(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnBinaryStreamL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlColumnReadStream::ColumnBinary(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnBinaryStreamL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlColumnReadStream::ColumnText(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt8L, &StmtColumnTextStreamL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlColumnReadStream::ColumnText(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&ExecInsertNextStmt16L, &StmtColumnTextStreamL, dbFileName[i], dbType[i]);
		}
	}

//RSqlParamWriteStream OOM tests
void ParamWriteStreamOomTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===RSqlParamWriteStream::BindBinary(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtParamBinaryStreamL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlParamWriteStream::BindBinary(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtParamBinaryStreamL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlParamWriteStream::BindText(), 8-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt8L, &StmtParamTextStreamL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlParamWriteStream::BindText(), 16-bit SQL\r\n"));
		DoStmtOomTestL(&PrepareInsertPrmStmt16L, &StmtParamTextStreamL, dbFileName[i], dbType[i]);
		}
	}

//TSqlScalarFullSelectQuery OOM tests
void ScalarFullSelectQueryOomTestsL()
	{
	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectIntL(), 8-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectInt_8L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectInt64L(), 8-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectInt64_8L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectRealL(), 8-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectReal_8L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectTextL(), 8-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectText_8L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectBinaryL(), 8-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectBinary_8L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectIntL(), 16-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectInt_16L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectInt64L(), 16-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectInt64_16L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectRealL(), 16-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectReal_16L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectTextL(), 16-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectText_16L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectBinaryL(), 16-bit SQL\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectBinary_16L);

	TheTest.Printf(_L("===TSqlScalarFullSelectQuery::SelectTextL(), 8-bit SQL, small buffer\r\n"));
	DoFullSelectOomTest(&ScalarFullSelectText2_8L);
	}

void BlobReadStreamOomTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===RSqlBlobReadStream::OpenL()/RSqlBlobReadStream::ReadL()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobReadStreamOpenL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlBlobReadStream::OpenL()/RSqlBlobReadStream::ReadL() + attached database\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobReadStreamOpenL, dbFileName[i], dbType[i], ETrue);

		TheTest.Printf(_L("===RSqlBlobReadStream::OpenL()/RSqlBlobReadStream::SizeL()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobReadStreamSizeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlBlobReadStream::OpenL()/RSqlBlobReadStream::SizeL() + attached database\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobReadStreamSizeL, dbFileName[i], dbType[i], ETrue);
		}
	}

void BlobWriteStreamOomTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===RSqlBlobWriteStream::OpenL()/RSqlBlobWriteStream::WriteL()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWriteStreamOpenL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlBlobWriteStream::OpenL()/RSqlBlobWriteStream::WriteL() + attached database\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWriteStreamOpenL, dbFileName[i], dbType[i], ETrue);

		TheTest.Printf(_L("===RSqlBlobWriteStream::OpenL()/RSqlBlobWriteStream::SizeL()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWriteStreamSizeL, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===RSqlBlobWriteStream::OpenL()/RSqlBlobWriteStream::SizeL() + attached database\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWriteStreamSizeL, dbFileName[i], dbType[i], ETrue);
		}
	}
	
void BlobWholeOomTestsL()
	{
	const TInt KTestCnt = 2;
	const TPtrC dbFileName[KTestCnt] = {KTestDb(), 	KSecureTestDb()};
	TDbType dbType[KTestCnt] = {ENonSecureDb, ESecureDb};

	for(TInt i=0;i<KTestCnt;++i)
		{
		TheTest.Printf(_L("===TSqlBlob::GetLC()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWholeGet1L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===TSqlBlob::Get()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWholeGet2L, dbFileName[i], dbType[i]);

		TheTest.Printf(_L("===TSqlBlob::SetL()\r\n"));
		DoBlobOomTestL(&ExecInsertBlobL, &BlobWholeSetL, dbFileName[i], dbType[i]);
		}
	}

void DoTestsL()
	{
	TheTest.Start(_L("SQL OOM tests - 2"));
	
	StmtOomTestsL();

	StmtOomNegativeTestsL();

	ColumnReadStreamOomTestsL();

	ParamWriteStreamOomTestsL();

	ScalarFullSelectQueryOomTestsL();

	BlobReadStreamOomTestsL();

	BlobWriteStreamOomTestsL();
	
	BlobWholeOomTestsL();
	}

TInt E32Main()
	{
	TheTest.Title();

	CTrapCleanup* tc = CTrapCleanup::New();

	__UHEAP_MARK;

	CreateTestDir();
	DeleteTestFiles();

	TRAPD(err, DoTestsL());
	DeleteTestFiles();
	TEST2(err, KErrNone);

	__UHEAP_MARKEND;

	TheTest.End();
	TheTest.Close();

	delete tc;

	User::Heap().Check();
	return KErrNone;
	}