Firebird API Test Suite
Copyright MWA Software 2016-2021

Starting Tests
Client API Version = 5.0
Firebird Environment Variable = /opt/firebird/5.0.0
Firebird Bin Directory = /opt/firebird/5.0.0/bin
Firebird Conf Directory = /opt/firebird/5.0.0/
Firebird Client Library Path = /opt/firebird/5.0.0/lib/libfbclient.so
Running Test 1: Create and Drop a Database
Creating a Database with empty parameters
Create Database fails (as expected): Engine Code: 335544344
I/O error during "open O_CREAT" operation for file ""
-Error while trying to create file
-No such file or directory
Creating a Database using an SQL Statement
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
SQL Dialect = 3
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
DB Charset ID = 0
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 13
DB ODS Minor Version = 1
User Authentication Method = Srp256
Firebird Library Path = /opt/firebird/5.0.0/lib/libfbclient.so
DB Client Implementation Version = 5.0
DPB: Item Count = 3
  isc_dpb_user_name = SYSDBA
  isc_dpb_password = masterkey
  isc_dpb_set_db_sql_dialect = 3

Firebird Server Version Info
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.0.1306 Firebird 5.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.0.1306 Firebird 5.0/tcp (zeus)/P18:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.0.1306 Firebird 5.0/tcp (zeus)/P18:C"
on disk structure version 13.1

Dropping Database
Creating a Database with a DPD
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
DB Charset ID = 4
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 13
DB ODS Minor Version = 1
User Authentication Method = Srp256
Firebird Library Path = /opt/firebird/5.0.0/lib/libfbclient.so
DB Client Implementation Version = 5.0
Dropping Database
DPB: Item Count = 4
  isc_dpb_user_name = SYSDBA
  isc_dpb_password = masterkey
  isc_dpb_lc_ctype = UTF8
  isc_dpb_set_db_sql_dialect = 3

Creating a Database with a DPD
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
ODS major = 13
ODS minor = 1
Attachment ID = 4
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
DB Charset ID = 4
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 13
DB ODS Minor Version = 1
User Authentication Method = Srp256
Firebird Library Path = /opt/firebird/5.0.0/lib/libfbclient.so
DB Client Implementation Version = 5.0
RDB$DESCRIPTION = 
RDB$RELATION_ID = 128
RDB$SECURITY_CLASS = SQL$453
RDB$CHARACTER_SET_NAME = UTF8
RDB$LINGER = 
RDB$SQL_SECURITY = 
Test Firebird coercion of implementation object from interface
Success: returned object is a TVersionCallback
Dropping Database


------------------------------------------------------
Running Test 2: Open the employee database and run a query
Open Database fails Engine Code: 335544472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Opening inet://localhost/employee
Database Open, SQL Dialect = 3
TPB: Item Count = 3
  isc_tpb_read
  isc_tpb_nowait
  isc_tpb_concurrency

Metadata
SQLType =SQL_SHORT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = EMP_NO
Alias Name = EMP_NO
Field Name = EMP_NO
Scale = 0
Charset id = 0
Not Null
Size = 2

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = FIRST_NAME
Alias Name = FIRST_NAME
Field Name = FIRST_NAME
Scale = 0
Charset id = 0
Not Null
Size = 15

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = LAST_NAME
Alias Name = LAST_NAME
Field Name = LAST_NAME
Scale = 0
Charset id = 0
Not Null
Size = 20

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = PHONE_EXT
Alias Name = PHONE_EXT
Field Name = PHONE_EXT
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_TIMESTAMP
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = HIRE_DATE
Alias Name = HIRE_DATE
Field Name = HIRE_DATE
Scale = 0
Charset id = 0
Not Null
Size = 8

SQLType =SQL_TEXT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = DEPT_NO
Alias Name = DEPT_NO
Field Name = DEPT_NO
Scale = 0
Charset id = 0
Not Null
Size = 3

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_CODE
Alias Name = JOB_CODE
Field Name = JOB_CODE
Scale = 0
Charset id = 0
Not Null
Size = 5

SQLType =SQL_SHORT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_GRADE
Alias Name = JOB_GRADE
Field Name = JOB_GRADE
Scale = 0
Charset id = 0
Not Null
Size = 2

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_COUNTRY
Alias Name = JOB_COUNTRY
Field Name = JOB_COUNTRY
Scale = 0
Charset id = 0
Not Null
Size = 15

SQLType =SQL_INT64
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = SALARY
Alias Name = SALARY
Field Name = SALARY
Scale = -2
Charset id = 0
Not Null
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = FULL_NAME
Alias Name = FULL_NAME
Field Name = FULL_NAME
Scale = 0
Charset id = 0
Nullable
Size = 37

Plan = 
Select Expression
    -> First N Records
        -> Table "EMPLOYEE" Full Scan
-- SQL style inline comment
/* this is a comment */ Select First 3 * from EMPLOYEE

EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
EMP_NO = 4
FIRST_NAME = Bruce
LAST_NAME = Young
PHONE_EXT = 233
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 621
JOB_CODE = Eng
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 97,500.00
FULL_NAME = Young, Bruce
EMP_NO = 5
FIRST_NAME = Kim
LAST_NAME = Lambert
PHONE_EXT = 22
HIRE_DATE = 1989/02/06 00:00:00.0000
DEPT_NO = 130
JOB_CODE = Eng
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 102,750.00
FULL_NAME = Lambert, Kim

Select * from EMPLOYEE Where EMP_NO = ?
SQL Params
SQLType =SQL_SHORT
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 2
Value = 0

EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

With param names
Select * from EMPLOYEE Where EMP_NO = :EMP_NO
SQL Params
SQLType =SQL_SHORT
sub type = 0
Field Name = EMP_NO
Scale = 0
Charset id = 0
Not Null
Size = 2
Value = 0

Results for Cursor: Test Cursor
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Scollable Cursors
DB Connect String = inet://localhost/employee
DB Charset ID = 4
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 13
DB ODS Minor Version = 1
User Authentication Method = Srp256
Firebird Library Path = /opt/firebird/5.0.0/lib/libfbclient.so
DB Client Implementation Version = 5.0
Do Fetch Next:
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
Do Fetch Last:
EMP_NO = 145
FIRST_NAME = Mark
LAST_NAME = Guckenheimer
PHONE_EXT = 221
HIRE_DATE = 1994/05/02 00:00:00.0000
DEPT_NO = 622
JOB_CODE = Eng
JOB_GRADE = 5
JOB_COUNTRY = USA
SALARY = 32,000.00
FULL_NAME = Guckenheimer, Mark
Do Fetch Prior:
EMP_NO = 144
FIRST_NAME = John
LAST_NAME = Montgomery
PHONE_EXT = 820
HIRE_DATE = 1994/03/30 00:00:00.0000
DEPT_NO = 672
JOB_CODE = Eng
JOB_GRADE = 5
JOB_COUNTRY = USA
SALARY = 35,000.00
FULL_NAME = Montgomery, John
Do Fetch First:
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
Do Fetch Abs 8 :
EMP_NO = 14
FIRST_NAME = Stewart
LAST_NAME = Hall
PHONE_EXT = 227
HIRE_DATE = 1990/06/04 00:00:00.0000
DEPT_NO = 900
JOB_CODE = Finan
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 69,482.63
FULL_NAME = Hall, Stewart
Do Fetch Relative -2 :
EMP_NO = 11
FIRST_NAME = K. J.
LAST_NAME = Weston
PHONE_EXT = 34
HIRE_DATE = 1990/01/17 00:00:00.0000
DEPT_NO = 130
JOB_CODE = SRep
JOB_GRADE = 4
JOB_COUNTRY = USA
SALARY = 86,292.94
FULL_NAME = Weston, K. J.
Do Fetch beyond EOF :
Fetch returned false
Now open the employee database as a local database
TPB: Item Count = 3
  isc_tpb_read
  isc_tpb_nowait
  isc_tpb_concurrency

Metadata
SQLType =SQL_SHORT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = EMP_NO
Alias Name = EMP_NO
Field Name = EMP_NO
Scale = 0
Charset id = 0
Not Null
Size = 2

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = FIRST_NAME
Alias Name = FIRST_NAME
Field Name = FIRST_NAME
Scale = 0
Charset id = 0
Not Null
Size = 15

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = LAST_NAME
Alias Name = LAST_NAME
Field Name = LAST_NAME
Scale = 0
Charset id = 0
Not Null
Size = 20

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = PHONE_EXT
Alias Name = PHONE_EXT
Field Name = PHONE_EXT
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_TIMESTAMP
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = HIRE_DATE
Alias Name = HIRE_DATE
Field Name = HIRE_DATE
Scale = 0
Charset id = 0
Not Null
Size = 8

SQLType =SQL_TEXT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = DEPT_NO
Alias Name = DEPT_NO
Field Name = DEPT_NO
Scale = 0
Charset id = 0
Not Null
Size = 3

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_CODE
Alias Name = JOB_CODE
Field Name = JOB_CODE
Scale = 0
Charset id = 0
Not Null
Size = 5

SQLType =SQL_SHORT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_GRADE
Alias Name = JOB_GRADE
Field Name = JOB_GRADE
Scale = 0
Charset id = 0
Not Null
Size = 2

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_COUNTRY
Alias Name = JOB_COUNTRY
Field Name = JOB_COUNTRY
Scale = 0
Charset id = 0
Not Null
Size = 15

SQLType =SQL_INT64
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = SALARY
Alias Name = SALARY
Field Name = SALARY
Scale = -2
Charset id = 0
Not Null
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = FULL_NAME
Alias Name = FULL_NAME
Field Name = FULL_NAME
Scale = 0
Charset id = 0
Nullable
Size = 37

Plan = 
Select Expression
    -> First N Records
        -> Table "EMPLOYEE" Full Scan
-- SQL style inline comment
/* this is a comment */ Select First 3 * from EMPLOYEE

EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
EMP_NO = 4
FIRST_NAME = Bruce
LAST_NAME = Young
PHONE_EXT = 233
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 621
JOB_CODE = Eng
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 97,500.00
FULL_NAME = Young, Bruce
EMP_NO = 5
FIRST_NAME = Kim
LAST_NAME = Lambert
PHONE_EXT = 22
HIRE_DATE = 1989/02/06 00:00:00.0000
DEPT_NO = 130
JOB_CODE = Eng
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 102,750.00
FULL_NAME = Lambert, Kim

Select * from EMPLOYEE Where EMP_NO = ?
SQL Params
SQLType =SQL_SHORT
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 2
Value = 0

EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

With param names
Select * from EMPLOYEE Where EMP_NO = :EMP_NO
SQL Params
SQLType =SQL_SHORT
sub type = 0
Field Name = EMP_NO
Scale = 0
Charset id = 0
Not Null
Size = 2
Value = 0

Results for Cursor: Test Cursor
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Scollable Cursors
DB Connect String = employee
DB Charset ID = 4
DB SQL Dialect = 3
DB Remote Protocol = 
DB ODS Major Version = 13
DB ODS Minor Version = 1
User Authentication Method = User name in DPB
Firebird Library Path = /opt/firebird/5.0.0/lib/libfbclient.so
DB Client Implementation Version = 5.0
Do Fetch Next:
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
Do Fetch Last:
EMP_NO = 145
FIRST_NAME = Mark
LAST_NAME = Guckenheimer
PHONE_EXT = 221
HIRE_DATE = 1994/05/02 00:00:00.0000
DEPT_NO = 622
JOB_CODE = Eng
JOB_GRADE = 5
JOB_COUNTRY = USA
SALARY = 32,000.00
FULL_NAME = Guckenheimer, Mark
Do Fetch Prior:
EMP_NO = 144
FIRST_NAME = John
LAST_NAME = Montgomery
PHONE_EXT = 820
HIRE_DATE = 1994/03/30 00:00:00.0000
DEPT_NO = 672
JOB_CODE = Eng
JOB_GRADE = 5
JOB_COUNTRY = USA
SALARY = 35,000.00
FULL_NAME = Montgomery, John
Do Fetch First:
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
Do Fetch Abs 8 :
EMP_NO = 14
FIRST_NAME = Stewart
LAST_NAME = Hall
PHONE_EXT = 227
HIRE_DATE = 1990/06/04 00:00:00.0000
DEPT_NO = 900
JOB_CODE = Finan
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 69,482.63
FULL_NAME = Hall, Stewart
Do Fetch Relative -2 :
EMP_NO = 11
FIRST_NAME = K. J.
LAST_NAME = Weston
PHONE_EXT = 34
HIRE_DATE = 1990/01/17 00:00:00.0000
DEPT_NO = 130
JOB_CODE = SRep
JOB_GRADE = 4
JOB_COUNTRY = USA
SALARY = 86,292.94
FULL_NAME = Weston, K. J.
Do Fetch beyond EOF :
Fetch returned false


------------------------------------------------------
Running Test 3: ad hoc queries
Opening inet://localhost/employee
Database Open
Employee Count = 42
Transaction ID = 275
Transaction is Read/Write
Transaction Database Path = inet://localhost/employee
Transaction ID = 275
Oldest Interesting = 273
Oldest Action = 274
Oldest Snapshot = 274
Oldest Snapshot Number = 2
Lock Timeout = 0
Transaction Access = isc_info_tra_readwrite
Isolation Type = isc_info_tra_concurrency
Employee Count = 41
Employee Count = 42
Employee Count = 41
Employee Count = 42
Constrained Employee Count = 3
"Johnson" Employee Count = 2
"Yanowski" Employee Count = 1


------------------------------------------------------
Running Test 4: Update, Insert and Delete Queries
Opening inet://localhost/employee
Database Open
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.0.1306 Firebird 5.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.0.1306 Firebird 5.0/tcp (zeus)/P18:CZ"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.0.1306 Firebird 5.0/tcp (zeus)/P18:CZ"
on disk structure version 13.1
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Current memory = 19,416,352
Delta memory = 2,528
Max memory = 19,442,800
Elapsed time= 0.000 sec
Cpu = 0.000 sec
Buffers = 2048
Reads = 0
Writes = 0
Fetches = 3
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
Relation Name = EMPLOYEE
Metadata
SQLType =SQL_SHORT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = EMP_NO
Alias Name = EMP_NO
Field Name = EMP_NO
Scale = 0
Charset id = 0
Not Null
Size = 2

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = FIRST_NAME
Alias Name = FIRST_NAME
Field Name = FIRST_NAME
Scale = 0
Charset id = 0
Not Null
Size = 15

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = LAST_NAME
Alias Name = LAST_NAME
Field Name = LAST_NAME
Scale = 0
Charset id = 0
Not Null
Size = 20

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = PHONE_EXT
Alias Name = PHONE_EXT
Field Name = PHONE_EXT
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_TIMESTAMP
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = HIRE_DATE
Alias Name = HIRE_DATE
Field Name = HIRE_DATE
Scale = 0
Charset id = 0
Not Null
Size = 8

SQLType =SQL_TEXT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = DEPT_NO
Alias Name = DEPT_NO
Field Name = DEPT_NO
Scale = 0
Charset id = 0
Not Null
Size = 3

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_CODE
Alias Name = JOB_CODE
Field Name = JOB_CODE
Scale = 0
Charset id = 0
Not Null
Size = 5

SQLType =SQL_SHORT
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_GRADE
Alias Name = JOB_GRADE
Field Name = JOB_GRADE
Scale = 0
Charset id = 0
Not Null
Size = 2

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = JOB_COUNTRY
Alias Name = JOB_COUNTRY
Field Name = JOB_COUNTRY
Scale = 0
Charset id = 0
Not Null
Size = 15

SQLType =SQL_INT64
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = SALARY
Alias Name = SALARY
Field Name = SALARY
Scale = -2
Charset id = 0
Not Null
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = EMPLOYEE
Owner = SYSDBA
Column Name = FULL_NAME
Alias Name = FULL_NAME
Field Name = FULL_NAME
Scale = 0
Charset id = 0
Nullable
Size = 37

EMP_NO = 150
FIRST_NAME = John
LAST_NAME = Doe
PHONE_EXT = 
HIRE_DATE = 2015/04/01 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, John

Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
EMP_NO = 151
FIRST_NAME = Major
LAST_NAME = Major
PHONE_EXT = 
HIRE_DATE = 2015/04/01 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 40,000.59
FULL_NAME = Major, Major

Now Delete the rows
Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
Inserting
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
EMP_NO = 150
FIRST_NAME = Jane
LAST_NAME = Doe
PHONE_EXT = NULL
HIRE_DATE = 2015/04/01 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, Jane

Employee Count = 43
Updating
Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 0
Prepare Query again

EMP_NO = 150
FIRST_NAME = Jayne's
LAST_NAME = Doe
PHONE_EXT = NULL
HIRE_DATE = 2015/04/01 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, Jayne's

Prepare Query again with a different transaction

EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Open Cursor with a different transaction

EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie
Same Statement - updated params
EMP_NO = 9
FIRST_NAME = Phil
LAST_NAME = Forest
PHONE_EXT = 229
HIRE_DATE = 1989/04/17 00:00:00.0000
DEPT_NO = 622
JOB_CODE = Mngr
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 75,060.00
FULL_NAME = Forest, Phil

Test using Execute Block
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 2015/01/31 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie



------------------------------------------------------
Running Test 5: Update Returning and Activity Check
Opening inet://localhost/employee
Database Open
Database Closed
Database Open
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
Last Name = Johnson
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 2016/01/31 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Inserting
Full Name = Doe, John
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
Database Activity = TRUE
Transaction Activity = TRUE
Database Activity = FALSE
Transaction Activity = FALSE
Employee Count = 43
Database Activity = TRUE
Transaction Activity = TRUE
Transaction Active
Transaction inactive


------------------------------------------------------
Running Test 6: Blob Handling
Metadata
SQLType =SQL_TEXT
sub type = 0
Table = RDB$CHARACTER_SETS
Owner = SYSDBA
Column Name = RDB$CHARACTER_SET_NAME
Alias Name = RDB$CHARACTER_SET_NAME
Field Name = RDB$CHARACTER_SET_NAME
Scale = 0
Charset id = 4
Nullable
Size = 252

SQLType =SQL_SHORT
sub type = 0
Table = RDB$CHARACTER_SETS
Owner = SYSDBA
Column Name = RDB$CHARACTER_SET_ID
Alias Name = RDB$CHARACTER_SET_ID
Field Name = RDB$CHARACTER_SET_ID
Scale = 0
Charset id = 0
Nullable
Size = 2

RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 0
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 1
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 2
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 3
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 4
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 5
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 6
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 9
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 10
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 11
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 12
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 13
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 14
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 15
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 16
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 17
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 18
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 19
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 21
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 22
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 23
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 34
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 35
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 36
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 37
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 38
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 39
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 40
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 44
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 45
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 46
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 47
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 48
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 49
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 50
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 51
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 52
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 53
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 54
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 55
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 56
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 57
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 58
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 59
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 60
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 63
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 64
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 65
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 66
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 67
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 68
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 69

Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = FIXEDPOINT
Alias Name = FIXEDPOINT
Field Name = FIXEDPOINT
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = FLOATINGPOINT
Alias Name = FLOATINGPOINT
Field Name = FLOATINGPOINT
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_BLOB
sub type = 1
Table = TESTDATA
Owner = SYSDBA
Column Name = BLOBDATA
Alias Name = BLOBDATA
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8

Blob Meta Data
SQL SubType =1
Table = TESTDATA
Column = BLOBDATA
CharSetID = 4
Segment Size = 80


SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_LONG
sub type = 0
Field Name = FP
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Field Name = DP
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA = NULL

SQL Params
SQLType =SQL_BLOB
sub type = 1
Field Name = 
Scale = 0
Charset id = 4
Nullable
Size = 8

SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered


SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_LONG
sub type = 0
Field Name = FP
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Field Name = DP
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered

ROWID = 2
FIXEDPOINT = NULL
FLOATINGPOINT = NULL
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered


Testing Blob as stored proc parameter
Metadata
SQLType =SQL_BLOB
sub type = 1
Table = TESTPROC
Owner = SYSDBA
Column Name = BLOBDATA
Alias Name = BLOBDATA
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8

Blob Meta Data
SQL SubType =1
Table = TESTPROC
Column = BLOBDATA
CharSetID = 4
Segment Size = 80


BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered

Metadata
SQLType =SQL_TEXT
sub type = 0
Table = RDB$CHARACTER_SETS
Owner = SYSDBA
Column Name = RDB$CHARACTER_SET_NAME
Alias Name = RDB$CHARACTER_SET_NAME
Field Name = RDB$CHARACTER_SET_NAME
Scale = 0
Charset id = 53
Nullable
Size = 63

SQLType =SQL_SHORT
sub type = 0
Table = RDB$CHARACTER_SETS
Owner = SYSDBA
Column Name = RDB$CHARACTER_SET_ID
Alias Name = RDB$CHARACTER_SET_ID
Field Name = RDB$CHARACTER_SET_ID
Scale = 0
Charset id = 0
Nullable
Size = 2

RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 0
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 1
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 2
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 3
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 4
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 5
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 6
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 9
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 10
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 11
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 12
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 13
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 14
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 15
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 16
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 17
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 18
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 19
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 21
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 22
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 23
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 34
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 35
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 36
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 37
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 38
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 39
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 40
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 44
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 45
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 46
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 47
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 48
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 49
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 50
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 51
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 52
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 53
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 54
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 55
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 56
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 57
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 58
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 59
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 60
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 63
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 64
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 65
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 66
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 67
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 68
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
RDB$CHARACTER_SET_ID = 69

Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = FIXEDPOINT
Alias Name = FIXEDPOINT
Field Name = FIXEDPOINT
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = FLOATINGPOINT
Alias Name = FLOATINGPOINT
Field Name = FLOATINGPOINT
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 53
Nullable
Size = 32

SQLType =SQL_BLOB
sub type = 1
Table = TESTDATA
Owner = SYSDBA
Column Name = BLOBDATA
Alias Name = BLOBDATA
Field Name = BLOBDATA
Scale = 0
Charset id = 53
Nullable
Size = 8

Blob Meta Data
SQL SubType =1
Table = TESTDATA
Column = BLOBDATA
CharSetID = 53
Segment Size = 80


SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 53
Nullable
Size = 32

SQLType =SQL_LONG
sub type = 0
Field Name = FP
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Field Name = DP
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
BLOBDATA = NULL

SQL Params
SQLType =SQL_BLOB
sub type = 1
Field Name = 
Scale = 0
Charset id = 53
Nullable
Size = 8

SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
BLOBDATA (Charset Id = 53 Codepage = 1252)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered


SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 53
Nullable
Size = 32

SQLType =SQL_LONG
sub type = 0
Field Name = FP
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Field Name = DP
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
BLOBDATA (Charset Id = 53 Codepage = 1252)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered

ROWID = 2
FIXEDPOINT = NULL
FLOATINGPOINT = NULL
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
BLOBDATA (Charset Id = 53 Codepage = 1252)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered


Testing Blob as stored proc parameter
Metadata
SQLType =SQL_BLOB
sub type = 1
Table = TESTPROC
Owner = SYSDBA
Column Name = BLOBDATA
Alias Name = BLOBDATA
Field Name = BLOBDATA
Scale = 0
Charset id = 53
Nullable
Size = 8

Blob Meta Data
SQL SubType =1
Table = TESTPROC
Column = BLOBDATA
CharSetID = 53
Segment Size = 80


BLOBDATA (Charset Id = 53 Codepage = 1252)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered

Metadata
SQLType =SQL_TEXT
sub type = 0
Table = RDB$CHARACTER_SETS
Owner = SYSDBA
Column Name = RDB$CHARACTER_SET_NAME
Alias Name = RDB$CHARACTER_SET_NAME
Field Name = RDB$CHARACTER_SET_NAME
Scale = 0
Charset id = 4
Nullable
Size = 252

SQLType =SQL_SHORT
sub type = 0
Table = RDB$CHARACTER_SETS
Owner = SYSDBA
Column Name = RDB$CHARACTER_SET_ID
Alias Name = RDB$CHARACTER_SET_ID
Field Name = RDB$CHARACTER_SET_ID
Scale = 0
Charset id = 0
Nullable
Size = 2

RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 0
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 1
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 2
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 3
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 4
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 5
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 6
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 9
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 10
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 11
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 12
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 13
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 14
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 15
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 16
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 17
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 18
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 19
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 21
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 22
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 23
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 34
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 35
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 36
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 37
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 38
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 39
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 40
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 44
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 45
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 46
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 47
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 48
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 49
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 50
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 51
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 52
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 53
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 54
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 55
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 56
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 57
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 58
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 59
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 60
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 63
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 64
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 65
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 66
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 67
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 68
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
RDB$CHARACTER_SET_ID = 69

Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = FIXEDPOINT
Alias Name = FIXEDPOINT
Field Name = FIXEDPOINT
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = FLOATINGPOINT
Alias Name = FLOATINGPOINT
Field Name = FLOATINGPOINT
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_BLOB
sub type = 1
Table = TESTDATA
Owner = SYSDBA
Column Name = BLOBDATA
Alias Name = BLOBDATA
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8

Blob Meta Data
SQL SubType =1
Table = TESTDATA
Column = BLOBDATA
CharSetID = 4
Segment Size = 80


SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_LONG
sub type = 0
Field Name = FP
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Field Name = DP
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA = NULL

SQL Params
SQLType =SQL_BLOB
sub type = 1
Field Name = 
Scale = 0
Charset id = 4
Nullable
Size = 8

SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered


SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_LONG
sub type = 0
Field Name = FP
Scale = -2
Charset id = 0
Nullable
Size = 4

SQLType =SQL_DOUBLE
sub type = 0
Field Name = DP
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
FIXEDPOINT = 20.28
FLOATINGPOINT = 3.14
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered

ROWID = 2
FIXEDPOINT = NULL
FLOATINGPOINT = NULL
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered


Testing Blob as stored proc parameter
Metadata
SQLType =SQL_BLOB
sub type = 1
Table = TESTPROC
Owner = SYSDBA
Column Name = BLOBDATA
Alias Name = BLOBDATA
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8

Blob Meta Data
SQL SubType =1
Table = TESTPROC
Column = BLOBDATA
CharSetID = 4
Segment Size = 80


BLOBDATA (Charset Id = 4 Codepage = 65001)

To be or not to be-that is the question:
Whether 'tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-'tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there's the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There's the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th' oppressor's wrong, the proud man's contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o'er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered



------------------------------------------------------
Running Test 7: Create and read back an Array
Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_TIMESTAMP
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = DATED
Alias Name = DATED
Field Name = DATED
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = NOTES
Alias Name = NOTES
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY
Alias Name = MYARRAY
Field Name = MYARRAY
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_LONG
Scale = 0
Charset id = 0
Size = 4
Table = TESTDATA
Column = MYARRAY
Dimensions = 1
Bounds: (0:16) 

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY2
Alias Name = MYARRAY2
Field Name = MYARRAY2
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_TIMESTAMP
Scale = 0
Charset id = 0
Size = 8
Table = TESTDATA
Column = MYARRAY2
Dimensions = 1
Bounds: (0:16) 

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY3
Alias Name = MYARRAY3
Field Name = MYARRAY3
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_INT64
Scale = -2
Charset id = 0
Size = 8
Table = TESTDATA
Column = MYARRAY3
Dimensions = 1
Bounds: (0:16) 

SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_TIMESTAMP
sub type = 0
Field Name = DATED
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256

Param Name = ROWID
Param Name = TITLE
Param Name = DATED
Param Name = NOTES
ROWID = 1
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
DATED = 2016/04/01 09:30:00.1000
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
MYARRAY = NULL
MYARRAY2 = NULL
MYARRAY3 = NULL

SQL Params
SQLType =SQL_ARRAY
sub type = 0
Field Name = MYARRAY
Scale = 0
Charset id = 0
Nullable
Size = 8

SQL Params
SQLType =SQL_ARRAY
sub type = 0
Field Name = MYARRAY2
Scale = 0
Charset id = 0
Nullable
Size = 8

SQL Params
SQLType =SQL_ARRAY
sub type = 0
Field Name = MYARRAY3
Scale = 0
Charset id = 0
Nullable
Size = 8

Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_TIMESTAMP
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = DATED
Alias Name = DATED
Field Name = DATED
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = NOTES
Alias Name = NOTES
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY
Alias Name = MYARRAY
Field Name = MYARRAY
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_LONG
Scale = 0
Charset id = 0
Size = 4
Table = TESTDATA
Column = MYARRAY
Dimensions = 1
Bounds: (0:16) 

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY2
Alias Name = MYARRAY2
Field Name = MYARRAY2
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_TIMESTAMP
Scale = 0
Charset id = 0
Size = 8
Table = TESTDATA
Column = MYARRAY2
Dimensions = 1
Bounds: (0:16) 

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY3
Alias Name = MYARRAY3
Field Name = MYARRAY3
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_INT64
Scale = -2
Charset id = 0
Size = 8
Table = TESTDATA
Column = MYARRAY3
Dimensions = 1
Bounds: (0:16) 

ROWID = 1
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
DATED = 2016/04/01 09:30:00.1000
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
MYARRAY = Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) 

MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) 

MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) 


Shrink to 2:10
Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) 

Write updated reduced slice
Show update array
ROWID = 1
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
DATED = 2016/04/01 09:30:00.1000
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
MYARRAY = Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) 

MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) 

MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) 




------------------------------------------------------
Running Test 8: Create and read back an Array with 2 dimensions
Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_VARYING
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_ARRAY
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = MYARRAY
Alias Name = MYARRAY
Field Name = MYARRAY
Scale = 0
Charset id = 4
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_VARYING
Scale = 0
Charset id = 4
Size = 16
Table = TESTDATA
Column = MYARRAY
Dimensions = 2
Bounds: (0:16) (-1:7) 

SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

ROWID = 1
TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
MYARRAY = NULL

ROWID = 1
TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
MYARRAY = Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202) 




------------------------------------------------------
Running Test 9: Database Information tests
Database ID = 4 FB = /opt/firebird/5.0.0/examples/empbuild/employee.fdb SN = zeus
Pages =346
Base Level = 13,4,0,3,
Implementation = 11,7,0,3,66,1,66,
Reserved = 0
ODS minor = 1
ODS major = 13
Page Size = 8192
Version = 1: LI-V6.3.0.1306 Firebird 5.0
Database is Read/Write
Database Created: 11/1/2024 10:32:44
Pages Used = 319
Pages Free = 27
Server Memory = 19074736
Forced Writes  = 1
Max Memory  = 19106064
Num Buffers  = 2048
Sweep Interval  = 20000
Logged in Users: SYSDBA,
Active Transaction Count = 0
Fetches  = 2051
Writes  = 3
Reads  = 95
Page Writes  = 2
Record Version Removals Operation Counts

Deletes Operation Counts

Expunge Count Operation Counts

Insert Count Operation Counts

Purge Count Countites Operation Counts

Indexed Reads Count Operation Counts
Table ID = 4
Count = 57
Table ID = 6
Count = 13
Table ID = 9
Count = 1
Table ID = 11
Count = 2
Table ID = 12
Count = 21
Table ID = 18
Count = 1343
Table ID = 20
Count = 5
Table ID = 28
Count = 2
Table ID = 29
Count = 2
Table ID = 31
Count = 1

Sequential Table Scans Operation Counts
Table ID = 0
Count = 98
Table ID = 1
Count = 14

Update Count Operation Counts

Page Size = 8192


------------------------------------------------------
Running Test 10: Event Handling
Call Async Wait
Async Wait Called
Event Signalled
First Event - usually ignored
Signal Event
Event Signalled
Event Counts: TESTEVENT, Count = 1
Two more events
Call Async Wait
Async Wait Called
Event Signalled
Deferred Events Caught
Event Counts: TESTEVENT, Count = 2
Signal Event
Event Counts: TESTEVENT, Count = 1
Async Wait: Test Cancel
Event Signalled
Async Wait Called
Event Cancelled
Time Out - Cancel Worked!
Sync wait
Event Signalled
Event Counts: TESTEVENT, Count = 1


------------------------------------------------------
Running Test 11: Services API
SPB: Item Count = 2
  user_name = SYSDBA
  password = masterkey

Service Manager Version = 2
Server Version = LI-V5.0.0.1306 Firebird 5.0
Implementation = Firebird/Linux/AMD/Intel/x64

Lock Directory = /tmp/firebird/
Message File = /opt/firebird/5.0.0/
Security File = /opt/firebird/5.0.0/security5.fdb

DB Attachments
No. of Attachments = 0
Databases In Use = 0

Sec. Database User
User Name = SYSDBA
First Name = 
Middle Name = 
Last Name = 
User ID = 0
Group ID = 0


Licence Info: Engine Code: 335544378
feature is not supported
-feature is not supported

Licence Mask Info: Engine Code: 335544378
feature is not supported

Capabilities = 6


Get Limbo transactions

Limbo Transactions


Local Backup



Local Backup Complete

Local Restore






Local Restore Complete

Open Database Check
Database OK
Database Dropped


------------------------------------------------------
Running Test 12: Character Sets
Transliteration Tests
Default System Code Page = 65001
Actual System Code Page = 65001
Input String = WIN1252 Characters ÖÄÜöäüß, Character Set = 65001 Hex Values:
57 49 4E 31 32 35 32 20 43 68 61 72 61 63 74 65 72 73 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F 
Code Page = 1252
57 49 4E 31 32 35 32 20 43 68 61 72 61 63 74 65 72 73 20 D6 C4 DC F6 E4 FC DF 
Back to UTF8
Code Page = 65001
WIN1252 Characters ÖÄÜöäüß
57 49 4E 31 32 35 32 20 43 68 61 72 61 63 74 65 72 73 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F 
ANSI(1252) to ANSI(1251) Test
Input String = Я Écoute moi, Character Set = 65001 Hex Values:
D0 AF 20 C3 89 63 6F 75 74 65 20 6D 6F 69 
After conversion to 1251
Code Page = 1251
DF 20 3F 63 6F 75 74 65 20 6D 6F 69 
Now Transliterate to WIN1252
Code Page = 1252
3F 20 3F 63 6F 75 74 65 20 6D 6F 69 
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_VARYING
sub type = 0
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256

SQLType =SQL_BLOB
sub type = 1
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8

SQLType =SQL_BLOB
sub type = 1
Field Name = BLOBDATA2
Scale = 0
Charset id = 4
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Field Name = INCLEAR
Scale = 0
Charset id = 1
Nullable
Size = 16

SQLType =SQL_TEXT
sub type = 0
Field Name = FIXEDWIDTH
Scale = 0
Charset id = 4
Nullable
Size = 16

Show Param Values
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 1

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128
Value = Blob Test ©€

SQLType =SQL_VARYING
sub type = 0
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256
Value = Écoute moi

SQLType =SQL_VARYING
sub type = 1
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8192
Value = Some German Special Characters like ÖÄÜöäüß

SQLType =SQL_BLOB
sub type = 1
Field Name = BLOBDATA2
Scale = 0
Charset id = 4
Nullable
Size = 8
Value = Some German Special Characters like ÖÄÜöäüß

SQLType =SQL_VARYING
sub type = 0
Field Name = INCLEAR
Scale = 0
Charset id = 1
Nullable
Size = 16
1 54 65 73 74 D C3 

SQLType =SQL_VARYING
sub type = 0
Field Name = FIXEDWIDTH
Scale = 0
Charset id = 4
Nullable
Size = 16
Value = É

Connection Character Set UTF8
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)

Test Exception Message = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F 
Exception returned: Engine Code: 335544517
exception 1
-CHARSETTEST
-Some German Special Characters like ÖÄÜöäüß
-At procedure 'DOEXCEPTION' line: 1, col: 39
Connection Character Set NONE
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)

Test Exception Message = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F 
Exception returned: Engine Code: 335544517
exception 1
-CHARSETTEST
-Some German Special Characters like ÖÄÜöäüß
-At procedure 'DOEXCEPTION' line: 1, col: 39
Connection Character Set WIN1252
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)

Test Exception Message = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F 
Exception returned: Engine Code: 335544517
exception 1
-CHARSETTEST
-Some German Special Characters like ÖÄÜöäüß
-At procedure 'DOEXCEPTION' line: 1, col: 39
Recreate Database with WIN1252 as the connection character set
Query Database with UTF8, NONE and WIN1252 connections
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

SQLType =SQL_VARYING
sub type = 0
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256

SQLType =SQL_BLOB
sub type = 1
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8

SQLType =SQL_BLOB
sub type = 1
Field Name = BLOBDATA2
Scale = 0
Charset id = 4
Nullable
Size = 8

SQLType =SQL_VARYING
sub type = 0
Field Name = INCLEAR
Scale = 0
Charset id = 1
Nullable
Size = 16

SQLType =SQL_TEXT
sub type = 0
Field Name = FIXEDWIDTH
Scale = 0
Charset id = 4
Nullable
Size = 16

Show Param Values
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 1

SQLType =SQL_VARYING
sub type = 0
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128
Value = Blob Test ©€

SQLType =SQL_VARYING
sub type = 0
Field Name = NOTES
Scale = 0
Charset id = 4
Nullable
Size = 256
Value = Écoute moi

SQLType =SQL_VARYING
sub type = 1
Field Name = BLOBDATA
Scale = 0
Charset id = 4
Nullable
Size = 8192
Value = Some German Special Characters like ÖÄÜöäüß

SQLType =SQL_BLOB
sub type = 1
Field Name = BLOBDATA2
Scale = 0
Charset id = 4
Nullable
Size = 8
Value = Some German Special Characters like ÖÄÜöäüß

SQLType =SQL_VARYING
sub type = 0
Field Name = INCLEAR
Scale = 0
Charset id = 1
Nullable
Size = 16
1 54 65 73 74 D C3 

SQLType =SQL_VARYING
sub type = 0
Field Name = FIXEDWIDTH
Scale = 0
Charset id = 4
Nullable
Size = 16
Value = É

Connection Character Set UTF8
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)

Test Exception Message = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF 
Exception returned: Engine Code: 335544517
exception 1
-CHARSETTEST
-Some German Special Characters like ???????
-At procedure 'DOEXCEPTION' line: 1, col: 39
Connection Character Set NONE
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)

Test Exception Message = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF 
Exception returned: Engine Code: 335544517
exception 1
-CHARSETTEST
-Some German Special Characters like ???????
-At procedure 'DOEXCEPTION' line: 1, col: 39
Connection Character Set WIN1252
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)

Test Exception Message = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF 
Exception returned: Engine Code: 335544517
exception 1
-CHARSETTEST
-Some German Special Characters like ÖÄÜöäüß
-At procedure 'DOEXCEPTION' line: 1, col: 39


------------------------------------------------------
Running Test 13: Transaction over two databases
Init Database 1
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)

Init Database 2
ROWID = 1
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)

ROWID = 1
TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)

ROWID = 1
TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)



------------------------------------------------------
Running Test 14: Non select procedures
Default Character set Name = UTF8
Metadata
SQLType =SQL_LONG
sub type = 0
Table = SHOWDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_VARYING
sub type = 0
Table = SHOWDATA
Owner = SYSDBA
Column Name = TITLE
Alias Name = TITLE
Field Name = TITLE
Scale = 0
Charset id = 4
Nullable
Size = 128

ROWID = 1
TITLE = Testing (Charset Id = 4 Codepage = 65001)

Repeat with a different execute transaction

ROWID = 1
TITLE = Testing (Charset Id = 4 Codepage = 65001)

Repeat with a original transaction

ROWID = 1
TITLE = Testing (Charset Id = 4 Codepage = 65001)


------------------------------------------------------
Running Test 15: Blob Handling and BPBs

Testdata

ROWID = 1
TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
BLOBDATA = (blob), Length = 92514

ROWID = 2
TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
BLOBDATA = (blob), Length = 13
0 9 A C9 63 6F 75 74 65 20 6D 6F 69 

Testdata 2

ROWID = 1
TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
BLOBDATA (Charset Id = 4 Codepage = 65001)

Écoute moi



------------------------------------------------------
Running Test 16: Error handling
Invalid Database Name Test
Error Handled: SQLCODE: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code: 335544344
I/O error during "open" operation for file "Malformed Name"
-Error while trying to open file
-No such file or directory
Invalid User Name Test
Error Handled: SQLCODE: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code: 335544472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Invalid password Test
Error Handled: SQLCODE: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code: 335544472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Invalid Prepare SQL Test
Error Handled: SQLCODE: -206
Column does not belong to referenced table
Engine Code: 335544569
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-UNKNOWN_DATE
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
Invalid Open Cursor SQL Test
Error Handled: SQLCODE: -206
Column does not belong to referenced table
Engine Code: 335544569
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-X
-At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
Transaction not started Test
Error Handled: Transaction is not active
Invalid Param SQL Type Test
Error Handled: Field "EMP_NO" not found
Case sensitive Param SQL  Test
Error Handled: Field "EMP_NO" not found
Stale Reference Check
First test correct usage
COUNTER = 42

New Transaction before param set
Error Handled: This interface is no longer up-to-date
New Transaction before Open Cursor
Error Handled: This interface is no longer up-to-date
Stop Stale Reference Checks
New Transaction before param set
COUNTER = 42

New Transaction before Open Cursor
COUNTER = 42

Invalid Server Name Test
Error Handled: SQLCODE: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code: 335544721
Unable to complete network request to host "unknown".
-Failed to locate host machine.
-The specified name was not found in the hosts file or Domain Name Services
Invalid User Name Test
Error Handled: SQLCODE: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code: 335544472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Invalid password Test
Error Handled: SQLCODE: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code: 335544472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login


------------------------------------------------------
Running Test 17: Date/Time tests and Firebird 4 extensions
 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.0.1306 Firebird 5.0"
Has Local TZ DB = TRUE

Testdata

Metadata
SQLType =SQL_LONG
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_TYPE_DATE
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = DATECOL
Alias Name = DATECOL
Field Name = DATECOL
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_TYPE_TIME
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TIMECOL
Alias Name = TIMECOL
Field Name = TIMECOL
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_TIMESTAMP
sub type = 0
Table = TESTDATA
Owner = SYSDBA
Column Name = TIMESTAMPCOL
Alias Name = TIMESTAMPCOL
Field Name = TIMESTAMPCOL
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
DATECOL = 2019/04/01
TIMECOL = 11:31:05.0001
TIMESTAMPCOL = 2016/02/29 22:02:35.0001
ROWID = 2
DATECOL = 1939/09/03
TIMECOL = 15:40:00.0002
TIMESTAMPCOL = 1918/11/11 11:11:00.0000
ROWID = 3
DATECOL = 1066/10/14
TIMECOL = 23:59:59.9994
TIMESTAMPCOL = 1918/11/11 11:11:00.0000
ROWID = 4
DATECOL = 1815/06/18
TIMECOL = 00:01:40.1115
TIMESTAMPCOL = 1945/05/08 22:10:00.0010


Testdata - second pass

1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1

Firebird 4 extension types
==========================


Using local FB Client with server TZ database

Local Time Zone Name = Europe/London, ID = 65071
Test Time Zone Setting
Time Zone GMT = GMT
Time Zone Zagreb = Europe/Zagreb
Time Zone Offset -08:00 = -08:00
Time Zone Offset +13:39 = +13:39
Time Zone ID = 1799
Time Zone ID = 959, UTC Time = 23/1/2020 10:30:00
Time Zone ID = 64920
Local Time Zone ID = 65071
Local Time = 22/1/2020 18:30:00, Time Zone = -08:00
Time Zone Offset = 60
Time Zone Offset = 60
Time Zone Offset = 60
Time Zone Offset = 0
Time Zone Offset = 60
Time Zone Offset = Bad Timestamp or missing time zone DB entry (26/3/1989 01:30:00) TZ ID = 65071
Date = 29/11/1969 23:30:00, TimeZone = GMT
Date = 01/4/2001 22:30:10.0010, TimeZone = -08:00
Time = 23:59:10.2000, TimeZone = Europe/London
Show Parameter 2
 =
  AsString  = 11/11/1918 00:11:00.0000 +04:00
  Formatted = 1918/11/11 00:11:00.0000 +04:00
  TimeZoneID = 1679
  Time Zone Name = +04:00
  UTC Time = 10/11/1918 20:11:00
  DST Offset = 240

FB4 Testdata_TZ

Metadata
SQLType =SQL_LONG
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_TIME_TZ
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = TIMECOL
Alias Name = TIMECOL
Field Name = TIMECOL
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_TIMESTAMP_TZ
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = TIMESTAMPCOL
Alias Name = TIMESTAMPCOL
Field Name = TIMESTAMPCOL
Scale = 0
Charset id = 0
Nullable
Size = 12

SQLType =SQL_SHORT
sub type = 0
Table = 
Owner = 
Column Name = EXTRACT
Alias Name = TZ_HOUR
Field Name = TZ_HOUR
Scale = 0
Charset id = 0
Nullable
Size = 2

SQLType =SQL_SHORT
sub type = 0
Table = 
Owner = 
Column Name = EXTRACT
Alias Name = TZ_MINUTE
Field Name = TZ_MINUTE
Scale = 0
Charset id = 0
Nullable
Size = 2

ROWID = 1
TIMECOL =
  AsString =  11:32:10.0002 -05:00
  Formatted = 11:32:10.0002 -05:00
  TimeZoneID = 1139
  Time Zone Name = -05:00
  UTC Time = 16:32:10
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 01/4/2020 11:31:05.0001 +01:00
  Formatted = 2020/04/01 11:31:05.0001 +01:00
  TimeZoneID = 1499
  Time Zone Name = +01:00
  UTC Time = 01/4/2020 10:31:05
  DST Offset = 60
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 2
TIMECOL =
  AsString =  14:02:10.0050 -08:00
  Formatted = 14:02:10.0050 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 22:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 11:11:00.0000 +00:00
  Formatted = 1918/11/11 11:11:00.0000 Europe/London
  TimeZoneID = 65071
  Time Zone Name = Europe/London
  UTC Time = 11/11/1918 11:11:00
  DST Offset = 0
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 3
TIMECOL =
  AsString =  22:02:10.0050 -08:00
  Formatted = 22:02:10.0050 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 06:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 00:11:00.0000 +04:00
  Formatted = 1918/11/11 00:11:00.0000 +04:00
  TimeZoneID = 1679
  Time Zone Name = +04:00
  UTC Time = 10/11/1918 20:11:00
  DST Offset = 240
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 4
TIMECOL =
  AsString =  14:02:10.5000 -08:00
  Formatted = 14:02:10.5000 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 22:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 11:11:00.0000 +00:00
  Formatted = 1918/11/11 11:11:00.0000 Europe/London
  TimeZoneID = 65071
  Time Zone Name = Europe/London
  UTC Time = 11/11/1918 11:11:00
  DST Offset = 0
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 5
TIMECOL =
  AsString =  11:31:05.0001 -05:00
  Formatted = 11:31:05.0001 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 16:31:05
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 04/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/04 07:00:00.0000 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 04/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 6
TIMECOL =
  AsString =  11:31:05.0001 -05:00
  Formatted = 11:31:05.0001 EST5EDT
  TimeZoneID = 65135
  Time Zone Name = EST5EDT
  UTC Time = 16:31:05
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 01/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/01 07:00:00.0000 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 7
TIMECOL =
  AsString =  11:31:05.0001 +06:00
  Formatted = 11:31:05.0001 BST
  TimeZoneID = 65162
  Time Zone Name = BST
  UTC Time = 05:31:05
  DST Offset = 360
TIMESTAMPCOL =
  AsString  = 01/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/01 07:00:00.0000 EST5EDT
  TimeZoneID = 65135
  Time Zone Name = EST5EDT
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = 6
TZ_MINUTE = 0
ROWID = 8
TIMECOL =
  AsString =  11:31:05.0001 +01:00
  Formatted = 11:31:05.0001 Europe/Paris
  TimeZoneID = 65061
  Time Zone Name = Europe/Paris
  UTC Time = 10:31:05
  DST Offset = 60
TIMESTAMPCOL =
  AsString  = 01/7/2020 06:00:00.0000 -05:00
  Formatted = 2020/07/01 06:00:00.0000 EST
  TimeZoneID = 65136
  Time Zone Name = EST
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -300
TZ_HOUR = 1
TZ_MINUTE = 0


Using local TZ database

Test Time Zone Setting
Time Zone GMT = GMT
Time Zone Zagreb = Europe/Zagreb
Time Zone Offset -08:00 = -08:00
Time Zone Offset +13:39 = +13:39
Time Zone ID = 1799
Time Zone ID = 959, UTC Time = 23/1/2020 10:30:00
Time Zone ID = 64920
Local Time Zone ID = 65071
Local Time = 23/1/2020 10:30:00, Time Zone = -08:00
Time Zone Offset = 60
Time Zone Offset = 60
Time Zone Offset = 60
Time Zone Offset = 0
Time Zone Offset = 60
Time Zone Offset = 0
Date = 29/11/1969 23:30:00, TimeZone = GMT
Date = 01/4/2001 22:30:10.0010, TimeZone = -08:00
Time = 23:59:10.2000, TimeZone = Europe/London
Show Parameter 2
 =
  AsString  = 11/11/1918 00:11:00.0000 +04:00
  Formatted = 1918/11/11 00:11:00.0000 +04:00
  TimeZoneID = 1679
  Time Zone Name = +04:00
  UTC Time = 10/11/1918 20:11:00
  DST Offset = 240

FB4 Testdata_TZ

Metadata
SQLType =SQL_LONG
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_TIME_TZ
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = TIMECOL
Alias Name = TIMECOL
Field Name = TIMECOL
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_TIMESTAMP_TZ
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = TIMESTAMPCOL
Alias Name = TIMESTAMPCOL
Field Name = TIMESTAMPCOL
Scale = 0
Charset id = 0
Nullable
Size = 12

SQLType =SQL_SHORT
sub type = 0
Table = 
Owner = 
Column Name = EXTRACT
Alias Name = TZ_HOUR
Field Name = TZ_HOUR
Scale = 0
Charset id = 0
Nullable
Size = 2

SQLType =SQL_SHORT
sub type = 0
Table = 
Owner = 
Column Name = EXTRACT
Alias Name = TZ_MINUTE
Field Name = TZ_MINUTE
Scale = 0
Charset id = 0
Nullable
Size = 2

ROWID = 1
TIMECOL =
  AsString =  11:32:10.0002 -05:00
  Formatted = 11:32:10.0002 -05:00
  TimeZoneID = 1139
  Time Zone Name = -05:00
  UTC Time = 16:32:10
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 01/4/2020 11:31:05.0001 +01:00
  Formatted = 2020/04/01 11:31:05.0001 +01:00
  TimeZoneID = 1499
  Time Zone Name = +01:00
  UTC Time = 01/4/2020 10:31:05
  DST Offset = 60
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 2
TIMECOL =
  AsString =  14:02:10.0050 -08:00
  Formatted = 14:02:10.0050 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 22:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 11:11:00.0000 +00:00
  Formatted = 1918/11/11 11:11:00.0000 Europe/London
  TimeZoneID = 65071
  Time Zone Name = Europe/London
  UTC Time = 11/11/1918 11:11:00
  DST Offset = 0
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 3
TIMECOL =
  AsString =  22:02:10.0050 -08:00
  Formatted = 22:02:10.0050 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 06:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 00:11:00.0000 +04:00
  Formatted = 1918/11/11 00:11:00.0000 +04:00
  TimeZoneID = 1679
  Time Zone Name = +04:00
  UTC Time = 10/11/1918 20:11:00
  DST Offset = 240
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 4
TIMECOL =
  AsString =  14:02:10.5000 -08:00
  Formatted = 14:02:10.5000 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 22:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 11:11:00.0000 +00:00
  Formatted = 1918/11/11 11:11:00.0000 Europe/London
  TimeZoneID = 65071
  Time Zone Name = Europe/London
  UTC Time = 11/11/1918 11:11:00
  DST Offset = 0
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 5
TIMECOL =
  AsString =  11:31:05.0001 -05:00
  Formatted = 11:31:05.0001 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 16:31:05
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 04/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/04 07:00:00.0000 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 04/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 6
TIMECOL =
  AsString =  11:31:05.0001 -05:00
  Formatted = 11:31:05.0001 EST5EDT
  TimeZoneID = 65135
  Time Zone Name = EST5EDT
  UTC Time = 16:31:05
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 01/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/01 07:00:00.0000 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 7
TIMECOL =
  AsString =  11:31:05.0001 +06:00
  Formatted = 11:31:05.0001 BST
  TimeZoneID = 65162
  Time Zone Name = BST
  UTC Time = 05:31:05
  DST Offset = 360
TIMESTAMPCOL =
  AsString  = 01/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/01 07:00:00.0000 EST5EDT
  TimeZoneID = 65135
  Time Zone Name = EST5EDT
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = 6
TZ_MINUTE = 0
ROWID = 8
TIMECOL =
  AsString =  11:31:05.0001 +01:00
  Formatted = 11:31:05.0001 Europe/Paris
  TimeZoneID = 65061
  Time Zone Name = Europe/Paris
  UTC Time = 10:31:05
  DST Offset = 60
TIMESTAMPCOL =
  AsString  = 01/7/2020 06:00:00.0000 -05:00
  Formatted = 2020/07/01 06:00:00.0000 EST
  TimeZoneID = 65136
  Time Zone Name = EST
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -300
TZ_HOUR = 1
TZ_MINUTE = 0


Using Extended TZ Data Type

Show Parameter 2
 =
  AsString  = 11/11/1918 00:11:00.0000 +04:00
  Formatted = 1918/11/11 00:11:00.0000 +04:00
  TimeZoneID = 1679
  Time Zone Name = +04:00
  UTC Time = 10/11/1918 20:11:00
  DST Offset = 240

FB4 Testdata_TZ

Metadata
SQLType =SQL_LONG
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_TIME_TZ_EX
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = TIMECOL
Alias Name = TIMECOL
Field Name = TIMECOL
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_TIMESTAMP_TZ_EX
sub type = 0
Table = FB4TESTDATA_TZ
Owner = SYSDBA
Column Name = TIMESTAMPCOL
Alias Name = TIMESTAMPCOL
Field Name = TIMESTAMPCOL
Scale = 0
Charset id = 0
Nullable
Size = 12

SQLType =SQL_SHORT
sub type = 0
Table = 
Owner = 
Column Name = EXTRACT
Alias Name = TZ_HOUR
Field Name = TZ_HOUR
Scale = 0
Charset id = 0
Nullable
Size = 2

SQLType =SQL_SHORT
sub type = 0
Table = 
Owner = 
Column Name = EXTRACT
Alias Name = TZ_MINUTE
Field Name = TZ_MINUTE
Scale = 0
Charset id = 0
Nullable
Size = 2

ROWID = 1
TIMECOL =
  AsString =  11:32:10.0002 -05:00
  Formatted = 11:32:10.0002 -05:00
  TimeZoneID = 1139
  Time Zone Name = -05:00
  UTC Time = 16:32:10
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 01/4/2020 11:31:05.0001 +01:00
  Formatted = 2020/04/01 11:31:05.0001 +01:00
  TimeZoneID = 1499
  Time Zone Name = +01:00
  UTC Time = 01/4/2020 10:31:05
  DST Offset = 60
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 2
TIMECOL =
  AsString =  14:02:10.0050 -08:00
  Formatted = 14:02:10.0050 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 22:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 11:11:00.0000 +00:00
  Formatted = 1918/11/11 11:11:00.0000 Europe/London
  TimeZoneID = 65071
  Time Zone Name = Europe/London
  UTC Time = 11/11/1918 11:11:00
  DST Offset = 0
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 3
TIMECOL =
  AsString =  22:02:10.0050 -08:00
  Formatted = 22:02:10.0050 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 06:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 00:11:00.0000 +04:00
  Formatted = 1918/11/11 00:11:00.0000 +04:00
  TimeZoneID = 1679
  Time Zone Name = +04:00
  UTC Time = 10/11/1918 20:11:00
  DST Offset = 240
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 4
TIMECOL =
  AsString =  14:02:10.5000 -08:00
  Formatted = 14:02:10.5000 -08:00
  TimeZoneID = 959
  Time Zone Name = -08:00
  UTC Time = 22:02:10
  DST Offset = -480
TIMESTAMPCOL =
  AsString  = 11/11/1918 11:11:00.0000 +00:00
  Formatted = 1918/11/11 11:11:00.0000 Europe/London
  TimeZoneID = 65071
  Time Zone Name = Europe/London
  UTC Time = 11/11/1918 11:11:00
  DST Offset = 0
TZ_HOUR = -8
TZ_MINUTE = 0
ROWID = 5
TIMECOL =
  AsString =  11:31:05.0001 -05:00
  Formatted = 11:31:05.0001 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 16:31:05
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 04/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/04 07:00:00.0000 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 04/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 6
TIMECOL =
  AsString =  11:31:05.0001 -05:00
  Formatted = 11:31:05.0001 EST5EDT
  TimeZoneID = 65135
  Time Zone Name = EST5EDT
  UTC Time = 16:31:05
  DST Offset = -300
TIMESTAMPCOL =
  AsString  = 01/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/01 07:00:00.0000 America/New_York
  TimeZoneID = 65361
  Time Zone Name = America/New_York
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = -5
TZ_MINUTE = 0
ROWID = 7
TIMECOL =
  AsString =  11:31:05.0001 +06:00
  Formatted = 11:31:05.0001 BST
  TimeZoneID = 65162
  Time Zone Name = BST
  UTC Time = 05:31:05
  DST Offset = 360
TIMESTAMPCOL =
  AsString  = 01/7/2020 07:00:00.0000 -04:00
  Formatted = 2020/07/01 07:00:00.0000 EST5EDT
  TimeZoneID = 65135
  Time Zone Name = EST5EDT
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -240
TZ_HOUR = 6
TZ_MINUTE = 0
ROWID = 8
TIMECOL =
  AsString =  11:31:05.0001 +01:00
  Formatted = 11:31:05.0001 Europe/Paris
  TimeZoneID = 65061
  Time Zone Name = Europe/Paris
  UTC Time = 10:31:05
  DST Offset = 60
TIMESTAMPCOL =
  AsString  = 01/7/2020 06:00:00.0000 -05:00
  Formatted = 2020/07/01 06:00:00.0000 EST
  TimeZoneID = 65136
  Time Zone Name = EST
  UTC Time = 01/7/2020 11:00:00
  DST Offset = -300
TZ_HOUR = 1
TZ_MINUTE = 0



------------------------------------------------------
Running Test 18: Firebird 4 Decfloat extensions
 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.0.1306 Firebird 5.0"

FB4 Testdata_DECFloat

Metadata
SQLType =SQL_LONG
sub type = 0
Table = FB4TESTDATA_DECFLOAT
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_DEC16
sub type = 0
Table = FB4TESTDATA_DECFLOAT
Owner = SYSDBA
Column Name = FLOAT16
Alias Name = FLOAT16
Field Name = FLOAT16
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_DEC34
sub type = 0
Table = FB4TESTDATA_DECFLOAT
Owner = SYSDBA
Column Name = FLOAT34
Alias Name = FLOAT34
Field Name = FLOAT34
Scale = 0
Charset id = 0
Nullable
Size = 16

SQLType =SQL_INT128
sub type = 0
Table = FB4TESTDATA_DECFLOAT
Owner = SYSDBA
Column Name = BIGNUMBER
Alias Name = BIGNUMBER
Field Name = BIGNUMBER
Scale = -6
Charset id = 0
Nullable
Size = 16

SQLType =SQL_INT128
sub type = 0
Table = FB4TESTDATA_DECFLOAT
Owner = SYSDBA
Column Name = BIGGERNUMBER
Alias Name = BIGGERNUMBER
Field Name = BIGGERNUMBER
Scale = -4
Charset id = 0
Nullable
Size = 16

SQLType =SQL_INT128
sub type = 0
Table = FB4TESTDATA_DECFLOAT
Owner = SYSDBA
Column Name = BIGINTEGER
Alias Name = BIGINTEGER
Field Name = BIGINTEGER
Scale = 0
Charset id = 0
Nullable
Size = 16

RowID = 1
Float16 = 64000000000.01
  Precision = 13
  Sign = 0
  Special = 0
  Places = 2
  Digits = 64 00 00 00 00 00 10 
Float34 = 123456789123456789.12345678
  Precision = 26
  Sign = 0
  Special = 0
  Places = 8
  Digits = 12 34 56 78 91 23 45 67 89 12 34 56 78 
BigNumber = 123456123456.123456
  Precision = 18
  Sign = 0
  Special = 0
  Places = 6
  Digits = 12 34 56 12 34 56 12 34 56 
BigInteger = 123456789123456789
  Precision = 18
  Sign = 0
  Special = 0
  Places = 0
  Digits = 12 34 56 78 91 23 45 67 89 

RowID = 2
Float16 = -64000000000.01
  Precision = 13
  Sign = 1
  Special = 0
  Places = 2
  Digits = 64 00 00 00 00 00 10 
Float34 = -123456789123456789.12345678
  Precision = 26
  Sign = 1
  Special = 0
  Places = 8
  Digits = 12 34 56 78 91 23 45 67 89 12 34 56 78 
BigNumber = -123456123456.123456
  Precision = 18
  Sign = 1
  Special = 0
  Places = 6
  Digits = 12 34 56 12 34 56 12 34 56 
BigInteger = Null

RowID = 3
Float16 = 64100000000.011
  Precision = 14
  Sign = 0
  Special = 0
  Places = 3
  Digits = 64 10 00 00 00 00 11 
Float34 = 12345678912.1200
  Precision = 15
  Sign = 0
  Special = 0
  Places = 4
  Digits = 12 34 56 78 91 21 20 00 
BigNumber = 1234561234567.123456
  Precision = 19
  Sign = 0
  Special = 0
  Places = 6
  Digits = 12 34 56 12 34 56 71 23 45 60 
BiggerNumber = 11123456123456123456123456123456.1235
  Precision = 36
  Sign = 0
  Special = 0
  Places = 4
  Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35 
BigInteger = Null

RowID = 4
Float16 = 0
  Precision = 0
  Sign = 0
  Special = 0
  Places = 0
  Digits = 
Float34 = -1
  Precision = 1
  Sign = 1
  Special = 0
  Places = 0
  Digits = 10 
BigNumber = 0.000000
  Precision = 0
  Sign = 0
  Special = 0
  Places = 0
  Digits = 
BiggerNumber = 0.0000
  Precision = 0
  Sign = 0
  Special = 0
  Places = 0
  Digits = 
BigInteger = Null

Metadata
SQLType =SQL_LONG
sub type = 0
Table = FB4TESTDATA_DECFLOAT_AR
Owner = SYSDBA
Column Name = ROWID
Alias Name = ROWID
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

SQLType =SQL_ARRAY
sub type = 0
Table = FB4TESTDATA_DECFLOAT_AR
Owner = SYSDBA
Column Name = FLOAT16
Alias Name = FLOAT16
Field Name = FLOAT16
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_DEC16
Scale = 0
Charset id = 0
Size = 8
Table = FB4TESTDATA_DECFLOAT_AR
Column = FLOAT16
Dimensions = 1
Bounds: (0:16) 

SQLType =SQL_ARRAY
sub type = 0
Table = FB4TESTDATA_DECFLOAT_AR
Owner = SYSDBA
Column Name = FLOAT34
Alias Name = FLOAT34
Field Name = FLOAT34
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_DEC34
Scale = 0
Charset id = 0
Size = 16
Table = FB4TESTDATA_DECFLOAT_AR
Column = FLOAT34
Dimensions = 1
Bounds: (0:16) 

SQLType =SQL_ARRAY
sub type = 0
Table = FB4TESTDATA_DECFLOAT_AR
Owner = SYSDBA
Column Name = BIGNUMBER
Alias Name = BIGNUMBER
Field Name = BIGNUMBER
Scale = 0
Charset id = 0
Nullable
Size = 8
Array Meta Data:
SQLType =SQL_INT128
Scale = -6
Charset id = 0
Size = 16
Table = FB4TESTDATA_DECFLOAT_AR
Column = BIGNUMBER
Dimensions = 1
Bounds: (0:16) 


Decfloat Arrays
Row No 1
Float16 Array: (0: 64100000000.011) (1: 64100000001.011) (2: 64100000002.011) (3: 64100000003.011) (4: 64100000004.011) (5: 64100000005.011) (6: 64100000006.011) (7: 64100000007.011) (8: 64100000008.011) (9: 64100000009.011) (10: 64100000010.011) (11: 64100000011.011) (12: 64100000012.011) (13: 64100000013.011) (14: 64100000014.011) (15: 64100000015.011) (16: 64100000016.011) 

Float34 Array: (0: 123456789123456789.12345678) (1: 123456789123456790.12345678) (2: 123456789123456791.12345678) (3: 123456789123456792.12345678) (4: 123456789123456793.12345678) (5: 123456789123456794.12345678) (6: 123456789123456795.12345678) (7: 123456789123456796.12345678) (8: 123456789123456797.12345678) (9: 123456789123456798.12345678) (10: 123456789123456799.12345678) (11: 123456789123456800.12345678) (12: 123456789123456801.12345678) (13: 123456789123456802.12345678) (14: 123456789123456803.12345678) (15: 123456789123456804.12345678) (16: 123456789123456805.12345678) 

BigNumber Array: (0: 123456123400.123456) (1: 123456123401.623456) (2: 123456123403.123456) (3: 123456123404.623456) (4: 123456123406.123456) (5: 123456123407.623456) (6: 123456123409.123456) (7: 123456123410.623456) (8: 123456123412.123456) (9: 123456123413.623456) (10: 123456123415.123456) (11: 123456123416.623456) (12: 123456123418.123456) (13: 123456123419.623456) (14: 123456123421.123456) (15: 123456123422.623456) (16: 123456123424.123456) 



------------------------------------------------------
Running Test 19: Batch Update and Insert Queries
Opening inet://localhost/employee
Database Open
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.0.1306 Firebird 5.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.0.1306 Firebird 5.0/tcp (zeus)/P18:CZ"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.0.1306 Firebird 5.0/tcp (zeus)/P18:CZ"
on disk structure version 13.1
Rows before update
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 1988/12/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 1989/04/05 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
Batch Completion Info
Total rows processed = 2
Updated Records = 2
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcNoMoreErrors Msg = 
Rows after update
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 2018/05/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 2016/01/31 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie


Repeat but with a last dummy row that is ignored
Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
Batch Completion Info
Total rows processed = 2
Updated Records = 2
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcNoMoreErrors Msg = 
Rows after update
EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 2018/05/28 00:00:00.0000
DEPT_NO = 600
JOB_CODE = VP
JOB_GRADE = 2
JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 2016/01/31 00:00:00.0000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie


Insert rows
Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
Batch Completion Info
Total rows processed = 3
Updated Records = 3
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcNoMoreErrors Msg = 
Row 3 State = bcNoMoreErrors Msg = 
Rows after insert
EMP_NO = 150
FIRST_NAME = John
LAST_NAME = Doe
PHONE_EXT = 
HIRE_DATE = 2015/04/01 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, John
EMP_NO = 151
FIRST_NAME = Jane
LAST_NAME = Doe
PHONE_EXT = 
HIRE_DATE = 2015/04/02 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 42,000.89
FULL_NAME = Doe, Jane
EMP_NO = 152
FIRST_NAME = John
LAST_NAME = SmithAndJonesFamily1
PHONE_EXT = 
HIRE_DATE = 2015/04/03 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.99
FULL_NAME = SmithAndJonesFamily1, John


Insert rows - and then cancel
Cancel Batch - note - next step will fail with a duplicate key if cancel fails

Insert rows - ignore last row
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
Batch Completion Info
Total rows processed = 2
Updated Records = 2
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcNoMoreErrors Msg = 
Rows after insert
EMP_NO = 150
FIRST_NAME = John
LAST_NAME = Doe
PHONE_EXT = 
HIRE_DATE = 2015/04/01 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, John
EMP_NO = 151
FIRST_NAME = Jane
LAST_NAME = Doe
PHONE_EXT = 
HIRE_DATE = 2015/04/02 00:00:00.0000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 42,000.89
FULL_NAME = Doe, Jane

Insert with inline blob
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
Batch Completion Info
Total rows processed = 2
Updated Records = 2
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcNoMoreErrors Msg = 
Rows after insert
JOB_CODE = ABC
JOB_GRADE = 3
JOB_COUNTRY = England
JOB_TITLE = Chief Tester
MIN_SALARY = 21,000.00
MAX_SALARY = 24,000.99
JOB_REQUIREMENT (Charset Id = 0 Codepage = 65535)

The quick brown fox jumped over the lazy dog
LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: ) 

JOB_CODE = DEF
JOB_GRADE = 3
JOB_COUNTRY = England
JOB_TITLE = Deputy Tester
MIN_SALARY = 21,000.00
MAX_SALARY = 24,000.99
JOB_REQUIREMENT (Charset Id = 0 Codepage = 65535)

The quick brown fox jumped over the running dog
LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: ) 



Insert with explicit blob
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
Batch Completion Info
Total rows processed = 2
Updated Records = 2
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcNoMoreErrors Msg = 
Rows after insert
JOB_CODE = ABC
JOB_GRADE = 3
JOB_COUNTRY = England
JOB_TITLE = Chief Tester
MIN_SALARY = 21,000.00
MAX_SALARY = 24,000.99
JOB_REQUIREMENT (Charset Id = 0 Codepage = 65535)

The quick brown fox jumped over the lazy dog
LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: ) 

JOB_CODE = DEF
JOB_GRADE = 3
JOB_COUNTRY = England
JOB_TITLE = Deputy Tester
MIN_SALARY = 21,000.00
MAX_SALARY = 24,000.99
JOB_REQUIREMENT (Charset Id = 0 Codepage = 65535)

The quick brown fox jumped over the running dog
LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: ) 


Test Error Handling
Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type
Test Error Handling - Update returning should fail
Error reported (as expected) when defering update returning query: This query type (SQL_Select) cannot be batched
Error handling when Insert rows - duplicate key
Error reported when inserting: SQLCODE: -803
Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
Engine Code: 335544665
violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
-Problematic key value is ("EMP_NO" = 150)
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
Batch Completion Info
Total rows processed = 2
Updated Records = 1
Row 1 State = bcNoMoreErrors Msg = 
Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
-Problematic key value is ("EMP_NO" = 150)


------------------------------------------------------
Running Test 20: Stress Test IBatch interface
 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.0.1306 Firebird 5.0"
10000 rows added
20000 rows added
30000 rows added
40000 rows added
50000 rows added
Batch Execute
Intermediate Apply Batch on row 50001
Batch Completion Info
Total rows processed = 50000
Updated Rows = 50000
Row 50000 State = bcNoMoreErrors Msg = 
60000 rows added
70000 rows added
80000 rows added
90000 rows added
100000 rows added
Batch Execute
Batch Completion Info
Total rows processed = 50000
Updated Rows = 50000
Row 50000 State = bcNoMoreErrors Msg = 
Rows in Dataset = 100000
 Message Hash = 2014887b8ad27fbb20893a22d6e39f26
 Message Hash = 2014887b8ad27fbb20893a22d6e39f26
Test Completed Successfully


------------------------------------------------------
Running Test 21: Exercise setting and getting of numeric data types
1234.567 parsed to 1234567 scale = -3
As Float =  1.2345670000000000E+003
-765.4321 parsed to -7654321 scale = -4
As Float = -7.6543209999999999E+002
0.1 parsed to 1 scale = -1
As Float =  1.0000000000000001E-001
0.01 parsed to 1 scale = -2
As Float =  1.0000000000000000E-002
+123 parsed to 123 scale = 0
As Float =  1.2300000000000000E+002
1.23456E308 parsed to 123456 scale = 303
As Float =  1.2345600000000001E+308
-1.2e-02 parsed to -12 scale = -3
As Float = -1.2000000000000000E-002
10. parsed to 10 scale = 0
As Float =  1.0000000000000000E+001
.12 parsed to 12 scale = -2
As Float =  1.2000000000000000E-001
0.12 parsed to 12 scale = -2
As Float =  1.2000000000000000E-001
Parsing of 1.2E1.2 failed
Parsing of 1,000 failed
Parsing of 1e1e1 failed
Parsing of 1.2+3 failed
Validating Numeric Interface - IFBNumeric
Value from Currency = 9999.1235
Raw Value = 99991235 Scale = -4
Value from Currency(rescaled) = 9999.12
Raw Value = 999912 Scale = -2
Value from Double = 9999.12345678
Raw Value = 999912345678 Scale = -8
Value from Integer = 9223372036854775807
Raw Value = 9223372036854775807 Scale = 0
Value from string = 9223372036854775807
Raw Value = 9223372036854775807 Scale = 0
Value from string = 9999.12345678
Raw Value = 999912345678 Scale = -8
Value from string = -0.12
Raw Value = -12 Scale = -3
Value from BCD = 9999.12345678
Raw Value = 999912345678 Scale = -8
Value from Raw Data = 9999123.456780
Raw Value = 9999123456780 Scale = -6
Numeric Operations
Add 2.23 + 24.12345 = 26.35345
Add Double 2.23 + 24.12645 = 26.35645
Add integer 2.23 + 2412345 = 2412347.23
Subtract 2.23 - 24.12345 = -21.89345
Subtract Double 24.12645 - 2.23 = -21.89645
Subtract integer 24123.45 - 223 = -23900.45
Multiply 2.23 * 24.12345 = 53.7952935
Multiply Double 24.12645 * 2.23 = 53.8019835
Multiply integer 241.2345 * 223 = 53795.2935
Divide 24.12345 / 2.23 = 10.81769
Divide Double 2.23 / 24.12645 = 0.09
Divide integer 241.2345 / 223 = 1.0818
Compare 2.23, -24.12345 = 1
Compare integer 2.23, 3 = -1
Compare Double 2.23, 2.23 = 0
Negate 24.12345 = -24.12345
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_INT64
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_INT64
sub type = 0
Field Name = 
Scale = -4
Charset id = 0
Nullable
Size = 8

SQLType =SQL_DOUBLE
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_INT64
sub type = 0
Field Name = 
Scale = -6
Charset id = 0
Nullable
Size = 8

Expected Error - SQLCODE: -303
Incompatible column/host variable data type
Engine Code: 335544569
Dynamic SQL Error
-SQL error code = -303
-conversion error from string "1,000"
Expected Error - SQLCODE: -303
Incompatible column/host variable data type
Engine Code: 335544569
Dynamic SQL Error
-SQL error code = -303
-conversion error from string "10.0.0"
Test Numeric Type
ROWID = 1
ITYPE = 101
I64TYPE = 9223372036854775807
CURRTYPE = 10,000.12340000
DTYPE = 9,999.12345678
FIXEDPOINT = 1,234,567,890.12345700
ROWID = 2
ITYPE = -32457
I64TYPE = -9223372036854775808
CURRTYPE = 1,000,001.12000000
DTYPE = 1.7E308
FIXEDPOINT = -1,234,567,890.12345700
ROWID = 3
ITYPE = 0
I64TYPE = 0
CURRTYPE = .00000000
DTYPE = .00000000
FIXEDPOINT = .00000000
ROWID = 4
ITYPE = 1
I64TYPE = 10
CURRTYPE = .02300000
DTYPE = .00110000
FIXEDPOINT = 233.45600000
ROWID = 7
ITYPE = 1
I64TYPE = 1234567
CURRTYPE = .02300000
DTYPE = .00110000
FIXEDPOINT = 1,234.25000000



------------------------------------------------------
Running Test 22: Journalling
Start Journaling. Session ID = 0
1234.567 parsed to 1234567 scale = -3
As Float =  1.2345670000000000E+003
-765.4321 parsed to -7654321 scale = -4
As Float = -7.6543209999999999E+002
0.1 parsed to 1 scale = -1
As Float =  1.0000000000000001E-001
0.01 parsed to 1 scale = -2
As Float =  1.0000000000000000E-002
+123 parsed to 123 scale = 0
As Float =  1.2300000000000000E+002
1.23456E308 parsed to 123456 scale = 303
As Float =  1.2345600000000001E+308
-1.2e-02 parsed to -12 scale = -3
As Float = -1.2000000000000000E-002
10. parsed to 10 scale = 0
As Float =  1.0000000000000000E+001
.12 parsed to 12 scale = -2
As Float =  1.2000000000000000E-001
0.12 parsed to 12 scale = -2
As Float =  1.2000000000000000E-001
Parsing of 1.2E1.2 failed
Parsing of 1,000 failed
Parsing of 1e1e1 failed
Parsing of 1.2+3 failed
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Nullable
Size = 4

SQLType =SQL_INT64
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_INT64
sub type = 0
Field Name = 
Scale = -4
Charset id = 0
Nullable
Size = 8

SQLType =SQL_DOUBLE
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Nullable
Size = 8

SQLType =SQL_INT64
sub type = 0
Field Name = 
Scale = -6
Charset id = 0
Nullable
Size = 8


Text Tests
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_VARYING
sub type = 0
Field Name = 
Scale = 0
Charset id = 4
Nullable
Size = 1024

SQLType =SQL_BLOB
sub type = 1
Field Name = 
Scale = 0
Charset id = 4
Nullable
Size = 8


Binary Blob Tests

Array Test
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = 
Scale = 0
Charset id = 0
Not Null
Size = 4
Value = 0

SQLType =SQL_ARRAY
sub type = 0
Field Name = MYARRAY
Scale = 0
Charset id = 0
Nullable
Size = 8

ROWID = 1
ITYPE = 101
I64TYPE = 9223372036854775807
CURRTYPE = 10,000.12340000
DTYPE = 9,999.12345678
FIXEDPOINT = 1,234,567,890.12345700
STR = NULL
TEXTBLOB = NULL
OTHERBLOB = NULL
MYARRAY = NULL
ROWID = 2
ITYPE = -32457
I64TYPE = -9223372036854775808
CURRTYPE = 1,000,001.12000000
DTYPE = 1.7E308
FIXEDPOINT = -1,234,567,890.12345700
STR = NULL
TEXTBLOB = NULL
OTHERBLOB = NULL
MYARRAY = NULL
ROWID = 4
ITYPE = 1
I64TYPE = 10
CURRTYPE = .02300000
DTYPE = .00110000
FIXEDPOINT = 233.45600000
STR = NULL
TEXTBLOB = NULL
OTHERBLOB = NULL
MYARRAY = NULL

Journal Table
IBX$SESSIONID = 1
IBX$TRANSACTIONID = 11
IBX$OLDTRANSACTIONID = NULL
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
IBX$CREATED = 2024/05/23 12:33:29.9760
IBX$SESSIONID = 1
IBX$TRANSACTIONID = 13
IBX$OLDTRANSACTIONID = 12
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
IBX$CREATED = 2024/05/23 12:33:30.0020

Journal Entries
Journal Entry = jeTransStart(Transaction Start)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 11
Transaction Name = "Transaction_29_1"
TPB: Item Count = 3
  isc_tpb_write
  isc_tpb_nowait
  isc_tpb_concurrency

Default Completion = TACommit

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 11
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 11
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)

Journal Entry = jeTransCommitRet(Commit Retaining)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 12
Old TransactionID = 11

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 12
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)

Journal Entry = jeTransRollbackRet(Rollback Retaining)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 13
Old TransactionID = 12

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 13
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)

Journal Entry = jeTransStart(Transaction Start)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 14
Transaction Name = "Transaction_29_2"
TPB: Item Count = 3
  isc_tpb_write
  isc_tpb_nowait
  isc_tpb_concurrency

Default Completion = TARollback

Journal Entry = jeTransCommit(Commit)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 13

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 14
Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question:
Whether ''tis nobler in the mind to suffer
The slings and arrows of outrageous fortune,
Or to take arms against a sea of troubles,
And, by opposing, end them. To die, to sleep-
No more-and by a sleep to say we end
The heartache and the thousand natural shocks
That flesh is heir to-''tis a consummation
Devoutly to be wished. To die, to sleep-
To sleep, perchance to dream. Aye, there''s the rub,
For in that sleep of death what dreams may come,
When we have shuffled off this mortal coil,
Must give us pause. There''s the respect
That makes calamity of so long life.
For who would bear the whips and scorns of time,
Th'' oppressor''s wrong, the proud man''s contumely, 
The pangs of despised love, the law’s delay, 
The insolence of office, and the spurns
That patient merit of the unworthy takes,
When he himself might his quietus make
With a bare bodkin? Who would fardels bear, 
To grunt and sweat under a weary life,
But that the dread of something after death,
The undiscovered country from whose bourn
No traveler returns, puzzles the will
And makes us rather bear those ills we have
Than fly to others that we know not of?
Thus conscience does make cowards of us all,
And thus the native hue of resolution
Is sicklied o''er with the pale cast of thought,
And enterprises of great pitch and moment, 
With this regard their currents turn awry, 
And lose the name of action.-Soft you now,
The fair Ophelia.-Nymph, in thy orisons
Be all my sins remembered
')

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 14
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
01000000010000001A01050001000000DA000000
</blob>
)

Journal Entry = jeQuery(Query)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 14
Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16">
 <elt ix="0">100</elt>
 <elt ix="1">99</elt>
 <elt ix="2">98</elt>
 <elt ix="3">97</elt>
 <elt ix="4">96</elt>
 <elt ix="5">95</elt>
 <elt ix="6">94</elt>
 <elt ix="7">93</elt>
 <elt ix="8">92</elt>
 <elt ix="9">91</elt>
 <elt ix="10">90</elt>
 <elt ix="11">89</elt>
 <elt ix="12">88</elt>
 <elt ix="13">87</elt>
 <elt ix="14">86</elt>
 <elt ix="15">85</elt>
 <elt ix="16">84</elt>
</array>
)

Journal Entry = jeTransRollback(Rollback)
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
Attachment ID = 4
Session ID = 1
Transaction ID = 14



------------------------------------------------------
Test Suite Ends