// ////////////////////////////////////////////////////////////////////////
//
// 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=DEFAULT_SOFT_HEAP_LIMIT
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=DEFAULT_SOFT_HEAP_LIMIT
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=DEFAULT_SOFT_HEAP_LIMIT
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=