diff -r 8dc8494f1e0e -r 839ea9debada persistentstorage/sql/TEST/t_sqldefect2.cpp --- a/persistentstorage/sql/TEST/t_sqldefect2.cpp Wed Sep 15 14:05:58 2010 +0300 +++ b/persistentstorage/sql/TEST/t_sqldefect2.cpp Wed Oct 13 16:30:44 2010 +0300 @@ -416,93 +416,6 @@ TEST2(err, KErrAlreadyExists); } -/** -@SYMTestCaseID PDS-SQL-CT-4213 -@SYMTestCaseDesc Tests the ability of the SQL server to store empty strings and retrieve them as - text column values, not NULLs. - Change: ou1cimx1#504388. -@SYMTestPriority High -@SYMTestActions The test creates a database and a table and stores there empty strings. - Then the test retrieves the stored column values and verifies that the column type is - "text", not "null". -@SYMTestExpectedResults Test must not fail -*/ -void EmptyTextColumnTest() - { - _LIT8(KEncUtf16, "encoding=\"UTF-16\""); - _LIT8(KEncUtf8, "encoding=\"UTF-8\""); - TPtrC8 enc[] = {KEncUtf16(), KEncUtf8()}; - for(TInt i=0;i<(sizeof(enc)/sizeof(enc[0]));++i) - { - (void)RSqlDatabase::Delete(KTestDatabase1); - TInt err = TheDb1.Create(KTestDatabase1, &enc[i]); - TEST2(err, KErrNone); - //Insert records with empty text column values using RSqlDatabase::Exec() - err = TheDb1.Exec(_L("CREATE TABLE A(ID INTEGER, T TEXT)")); - TEST(err >= 0); - err = TheDb1.Exec(_L("INSERT INTO A VALUES(1, '')")); - TEST2(err, 1); - err = TheDb1.Exec(_L8("INSERT INTO A VALUES(2, '')")); - TEST2(err, 1); - //Insert a record with empty text column value using RSqlParamWriteStream - RSqlStatement stmt; - err = stmt.Prepare(TheDb1, _L("INSERT INTO A(ID, T) VALUES(:P1, :P2)")); - TEST2(err, KErrNone); - err = stmt.BindInt(0, 3); - TEST2(err, KErrNone); - RSqlParamWriteStream strm; - err = strm.BindText(stmt, 1); - TEST2(err, KErrNone); - TRAP(err, strm.WriteL(KNullDesC)); - TEST2(err, KErrNone); - strm.Close(); - err = stmt.Exec(); - TEST2(err, 1); - stmt.Close(); - //Insert records with empty text column values using RSqlStatement::Bind() - err = stmt.Prepare(TheDb1, _L("INSERT INTO A(ID, T) VALUES(:P1, :P2)")); - TEST2(err, KErrNone); - err = stmt.BindInt(0, 4); - TEST2(err, KErrNone); - err = stmt.BindText(1, KNullDesC); - TEST2(err, KErrNone); - err = stmt.Exec(); - TEST2(err, 1); - // - err = stmt.Reset(); - TEST2(err, KErrNone); - err = stmt.BindInt(0, 5); - TEST2(err, KErrNone); - _LIT(KEmptyStr, ""); - err = stmt.BindText(1, KEmptyStr); - TEST2(err, KErrNone); - err = stmt.Exec(); - TEST2(err, 1); - stmt.Close(); - //Read the empty text column values - err = stmt.Prepare(TheDb1, _L("SELECT T FROM A")); - TEST2(err, KErrNone); - TInt cnt = 0; - while((err = stmt.Next()) == KSqlAtRow) - { - ++cnt; - TPtrC val; - err = stmt.ColumnText(0, val); - TEST2(err, KErrNone); - TEST2(val.Length(), 0); - TSqlColumnType type = stmt.ColumnType(0); - TEST2(type, ESqlText); - } - stmt.Close(); - TEST2(err, KSqlAtEnd); - TEST2(cnt, 5); - // - TheDb1.Close(); - err = RSqlDatabase::Delete(KTestDatabase1); - TEST2(err, KErrNone); - } - } - void DoTestsL() { TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4154 DEF143062: SQL, \"CREATE INDEX\" sql crashes SQL server")); @@ -520,9 +433,6 @@ TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4211 Temp files created during sql operations are not deleted after rebooting the phone - 2")); TempFileTest(); - TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-CT-4213 No support to store an empty string in symbian's sqlite.")); - EmptyTextColumnTest(); - TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4214 After *#7370# Java apps are not preinstalled again")); DeleteTempFolder(); }