diff -r 000000000000 -r 08ec8eefde2f persistentstorage/sql/TEST/testexecute/SQLite/config/Configuration.ini
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/sql/TEST/testexecute/SQLite/config/Configuration.ini	Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,299 @@
+
+// //////////////////////////////////////////////////////////////////////// 
+//
+// Configuration tests - try changing the values of the default encoding
+// and cache_size and page_size. From an integration test we can't really
+// detect an effect of the _size settings, though we can read them back
+// with the 'pragma' syntax.
+//
+// First check the defaults. If these change it will confuse the other tests
+// so we might as well detect that change and generate a failure ASAP...
+[CheckDefaults]
+// First open a zero length database to check the defaults.
+NoOperation0=
+Open1=Z:\TEF_SQL\TestData\ReadOnly.db
+Function2=ScalarFullSelect
+Method2=SelectTextL
+Result2=UTF-16le
+Use_Set2=0
+Statement2=PRAGMA encoding;
+
+Function3=ScalarFullSelect
+Method3=SelectIntL
+Result3=1024
+Use_Set3=1
+Statement3=PRAGMA page_size;
+
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=1024
+Use_Set4=1
+Statement4=PRAGMA cache_size;
+Close5=
+EndBlock6=
+
+// Check that gibberish in the configuration string prevents Create from
+// working.
+[CheckOverride1]
+DefineConfig0=this is a load of old rubbish which should have no effect on settings
+Delete1=C:\ConfigTest1.db
+ExpectedError1=KErrNotFound
+Create2=C:\ConfigTest1.db
+ExpectedError2=KErrArgument
+// The next line will PANIC the client because the Create will have failed due
+// to the bad configuration line. That's ok, we're expecting it.
+Exec3=Select * from SomeTable;
+EndBlock4=
+
+// Check that properly formatted configuration options work, but that
+// page_size can't be changed for a pre-existing db, and a bad encoding
+// has no effect. The cache_size is also not affected.
+[CheckOverride2]
+DefineConfig0=page_size=2048;cache_size=64;encoding=hatstand
+// On a pre-existing database we can't change the page size, plus the
+// bad encoding will have been ignored.
+Open1=Z:\TEF_SQL\TestData\ReadOnly.db
+
+// encoding will not have been changed from its default of utf-16
+Function2=ScalarFullSelect
+Method2=SelectTextL
+Result2=UTF-16le
+Use_Set2=1
+Statement2=PRAGMA encoding;
+
+// page_size will not have been changed from its default of 1024..
+Function3=ScalarFullSelect
+Method3=SelectIntL
+Result3=1024
+Use_Set3=1
+Statement3=PRAGMA page_size;
+
+// cache_size WILL NOT have changed.
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=64
+Use_Set4=1
+Statement4=PRAGMA cache_size;
+
+Close5=
+EndBlock6=
+
+// Try changing all three config items to legal values, and check them.
+[CheckOverride3]
+DefineConfig0=page_size=2048;cache_size=34;encoding=UTF-8
+// On a new database we can change the page size and the encoding.
+// Not the cache_size.
+Delete1=C:\ConfigTest2.db
+ExpectedError1=KErrNotFound
+
+Create2=C:\ConfigTest2.db
+
+// encoding will not have been changed from its default of utf-16
+Function3=ScalarFullSelect
+Method3=SelectTextL
+Result3=UTF-8
+Use_Set3=1
+Statement3=PRAGMA encoding;
+
+// page_size will have been changed from its default of 1024..
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=2048
+Use_Set4=1
+Statement4=PRAGMA page_size;
+
+// cache_size WILL have changed to 34..
+Function5=ScalarFullSelect
+Method5=SelectIntL
+Result5=34
+Use_Set5=1
+Statement5=PRAGMA cache_size;
+
+Close6=
+Delete7=C:\ConfigTest2.db
+EndBlock8=
+
+// Try setting page_size to a non-power-of-two (no effect), stick in some
+// properly formatted by useless extras (no effect) and attempt to set
+// cache_size (works) and an unsupported encoding (doesn't work).
+[CheckOverride4]
+DefineConfig0=page_size=4095;x=y;i=j;cache_size=43;encoding=UTF-16be
+// On a new database we can change the page size and the encoding.
+// But page_size is supposed to be a power of 2.
+Delete1=C:\ConfigTest3.db
+ExpectedError1=KErrNotFound
+
+Create2=C:\ConfigTest3.db
+
+// encoding will not have been changed from its default of utf-16
+Function3=ScalarFullSelect
+Method3=SelectTextL
+Result3=UTF-16le
+Use_Set3=1
+Statement3=PRAGMA encoding;
+
+// page_size will not have been changed from its default of 1024..
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=1024
+Use_Set4=1
+Statement4=PRAGMA page_size;
+
+// cache_size WILL have changed.
+Function5=ScalarFullSelect
+Method5=SelectIntL
+Result5=43
+Use_Set5=1
+Statement5=PRAGMA cache_size;
+
+Close6=
+Delete7=C:\ConfigTest3.db
+EndBlock8=
+
+
+// Try setting a legal page_size (works), a cache_size (doesn't work) and
+// a legal character encoding (works).
+[CheckOverride5]
+DefineConfig0=page_size=512;cache_size=432;encoding=UTF-8
+// On a new database we can change the page size, cache size and the
+// encoding.
+Delete1=C:\ConfigTest4.db
+ExpectedError1=KErrNotFound
+
+Create2=C:\ConfigTest4.db
+
+// encoding will not have been changed from its default of utf-16
+Function3=ScalarFullSelect
+Method3=SelectTextL
+Result3=UTF-8
+Use_Set3=1
+Statement3=PRAGMA encoding;
+
+// page_size will not have been changed from its default of 1024..
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=512
+Use_Set4=1
+Statement4=PRAGMA page_size;
+
+// cache_size WILL have changed.
+Function5=ScalarFullSelect
+Method5=SelectIntL
+Result5=432
+Use_Set5=1
+Statement5=PRAGMA cache_size;
+
+Close6=
+Delete7=C:\ConfigTest4.db
+EndBlock8=
+
+// /////////////////////////////////////////////////////////////////////////
+
+// The following tests create two functionally identical databases but one
+// block uses UTF-8. Then check that the file sizes differ.
+
+// Create a database with a single table containing a single cell containing
+// the text content of the reference1.txt text file. Set UTF-16.
+[WriteTextDB-16bit]
+Delete0=C:\ConfigTest5.db
+ExpectedError0=KErrNotFound
+Create1=C:\ConfigTest5.db
+
+// First check for our expected defaults.
+Function2=ScalarFullSelect
+Method2=SelectTextL
+Result2=UTF-16le
+Use_Set2=1
+Statement2=PRAGMA encoding;
+
+Function3=ScalarFullSelect
+Method3=SelectIntL
+Result3=1024
+Use_Set3=1
+Statement3=PRAGMA page_size;
+
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=1024
+Use_Set4=1
+Statement4=PRAGMA cache_size;
+
+Exec5=Create Table Sometable(f1 text);
+Prepare6=Insert into Sometable values(:val);
+ParameterIndex7=:val
+StreamWriteBindText8=0,Z:\TEF_SQL\TestData\reference1.txt
+St_Exec9=
+Reset10=
+St_Close11=
+
+Prepare12=select f1 from Sometable;
+ColumnIndex13=f1
+Next14=KSqlAtRow
+ColumnSize15=0,3626
+St_Close16=
+Close17=
+EndBlock18=
+
+// Create a database with a single table containing a single cell containing
+// the text content of the reference1.txt text file. Set UTF-8.
+[WriteTextDB-8bit]
+Delete0=C:\ConfigTest6.db
+ExpectedError0=KErrNotFound
+DefineConfig1=encoding=UTF-8
+Create2=C:\ConfigTest6.db
+
+// Check the defaults (plus our changed character encoding)
+Function3=ScalarFullSelect
+Method3=SelectTextL
+Result3=UTF-8
+Use_Set3=1
+Statement3=PRAGMA encoding;
+
+Function4=ScalarFullSelect
+Method4=SelectIntL
+Result4=1024
+Use_Set4=1
+Statement4=PRAGMA page_size;
+
+Function5=ScalarFullSelect
+Method5=SelectIntL
+Result5=1024
+Use_Set5=1
+Statement5=PRAGMA cache_size;
+
+Exec6=Create Table Sometable(f1 text);
+Prepare7=Insert into Sometable values(:val);
+ParameterIndex8=:val
+StreamWriteBindText9=0,Z:\TEF_SQL\TestData\reference1.txt
+St_Exec10=
+Reset11=
+St_Close12=
+
+Prepare13=select f1 from Sometable;
+ColumnIndex14=f1
+Next15=KSqlAtRow
+ColumnSize16=0,3626
+St_Close17=
+Close18=
+EndBlock19=
+
+// Check that the two databases created above (which are exactly equivalent)
+// differ in size. That will suggest that the UTF-8/UTF-16
+// encoding options have done their work. Through the SQLite APIs they generate
+// identical output. It seems kind of overkill to have a whole code-driven
+// test function to do this but I see no other way..
+// Attempt an attach of UTF-16 to UTF-8 database - it will fail, that's an
+// illegal operation.
+[FilesDiffer]
+Function0=FilesDifferBySize
+FileA0=C:\ConfigTest5.db
+FileB0=C:\ConfigTest6.db
+Open1=C:\ConfigTest5.db
+Exec2=Attach "C:\ConfigTest6.db" as ThatOne;
+ExpectedError2=KSqlErrGeneral
+LastErrorMessage3=attached databases must use the same text encoding as main database
+// Delete will succeed because the attach didn't.
+Delete4=C:\ConfigTest6.db
+Close5=
+Delete6=C:\ConfigTest5.db
+EndBlock7=