fbintf/testsuite/reference.log

Firebird API Test Suite
Copyright MWA Software 2016

Starting Tests
Client API Version = 3.768
Running Test 1: Create and Drop a Database
Creating a Database with empty parameters
Create Database fails (as expected): 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 = mint18-FB3
SQL Dialect = 3
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
DB Charset ID = 0
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 12
DB ODS Minor Version = 0
User Authentication Method = Srp
DPB
Count = 3
28 = SYSDBA
29 = masterkey
65 = 3

Dropping Database
Creating a Database with a DPD
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
DB Charset ID = 4
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 12
DB ODS Minor Version = 0
User Authentication Method = Srp
Dropping Database
DPB
Count = 4
28 = SYSDBA
29 = masterkey
48 = UTF8
65 = 3

Creating a Database with a DPD
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
ODS major = 12
ODS minor = 0
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
DB Charset ID = 4
DB SQL Dialect = 3
DB Remote Protocol = TCPv4
DB ODS Major Version = 12
DB ODS Minor Version = 0
User Authentication Method = Srp
RDB$DESCRIPTION = 
RDB$RELATION_ID = 128
RDB$SECURITY_CLASS = SQL$363
RDB$CHARACTER_SET_NAME = UTF8
RDB$LINGER = 
Dropping Database


Running Test 2: Open the employee database and run a query
Opening localhost:employee
Database Open, SQL Dialect = 3
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
Select First 3 * from EMPLOYEE

EMP_NO = 2
FIRST_NAME = Robert
LAST_NAME = Nelson
PHONE_EXT = 250
HIRE_DATE = 28/12/1988 00:00:00.000
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 = 28/12/1988 00:00:00.000
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 = 6/2/1989 00:00:00.000
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

EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 5/4/1989 00:00:00.000
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

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


Running Test 3: ad hoc queries
Opening localhost:employee
Database Open
Employee Count = 42
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 localhost:employee
Database Open
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 5/4/1989 00:00:00.000
DEPT_NO = 180
JOB_CODE = Mktg
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 64,635.00
FULL_NAME = Johnson, Leslie

Current memory =  1.960269600000000000E+0007
Delta memory =  2.616000000000000000E+0003
Max memory =  1.966627200000000000E+0007
Elapsed time= 0.000 sec
Cpu = 0.000 sec
Buffers =  2.048000000000000000E+0003
Reads =  0.000000000000000000E+0000
Writes =  0.000000000000000000E+0000
Fetches =  2.000000000000000000E+0000
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 = 1/4/2015 00:00:00.000
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 = 1/4/2015 00:00:00.000
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 = 1/4/2015 00:00:00.000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, Jane

Employee Count = 43
Prepare Query again

EMP_NO = 150
FIRST_NAME = Jane
LAST_NAME = Doe
PHONE_EXT = NULL
HIRE_DATE = 1/4/2015 00:00:00.000
DEPT_NO = 600
JOB_CODE = Eng
JOB_GRADE = 4
JOB_COUNTRY = England
SALARY = 41,000.89
FULL_NAME = Doe, Jane

Prepare Query again with a different transaction

EMP_NO = 8
FIRST_NAME = Leslie
LAST_NAME = Johnson
PHONE_EXT = 410
HIRE_DATE = 5/4/1989 00:00:00.000
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 = 5/4/1989 00:00:00.000
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 = 17/4/1989 00:00:00.000
DEPT_NO = 622
JOB_CODE = Mngr
JOB_GRADE = 3
JOB_COUNTRY = USA
SALARY = 75,060.00
FULL_NAME = Forest, Phil


Running Test 5: Update Returning and Activity Check
Opening 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 = 31/1/2016 00:00:00.000
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 = 124

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

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

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

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 = 31

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

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

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

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 = 3
Nullable
Size = 93

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

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

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

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) 

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

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 = 1/4/2016 09:30:00.100
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
MYARRAY = NULL

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

ROWID = 1
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
DATED = 1/4/2016 09:30:00.100
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
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) 

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 = 1/4/2016 09:30:00.100
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
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) 


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

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)
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/examples/empbuild/employee.fdb SN = mint18-FB3
Pages =307
Base Level = 13,4,0,3,
Implementation = 11,7,0,3,66,1,66,
Reserved = 0
ODS minor = 0
ODS major = 12
Page Size = 8192
Version = 1: LI-V6.3.1.32609 Firebird 3.0
Database is Read/Write
Database Created: 27/9/2016 12:08:46
Pages Used = 297
Pages Free = 10
Server Memory = 19122232
Forced Writes  = 1
Max Memory  = 19235672
Num Buffers  = 2048
Sweep Interval  = 20000
Logged in Users: SYSDBA,
Active Transaction Count = 0
Fetches  = 546
Writes  = 8
Reads  = 54
Page Writes  = 5
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 = 28
Table ID = 6
Count = 15
Table ID = 9
Count = 2
Table ID = 11
Count = 1
Table ID = 12
Count = 15
Table ID = 28
Count = 1
Table ID = 29
Count = 1

Sequential Table Scans Operation Counts
Table ID = 0
Count = 94
Table ID = 1
Count = 2

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 Signalled
Event Counts: TESTEVENT, Count = 1
Async Wait: Test Cancel
Async Wait Called
Event Cancelled
Time Out - Cancel Worked!
Sync wait
Event Signalled
Event Counts: TESTEVENT, Count = 1


Running Test 11: Services API
Service Manager Version = 2
Server Version = LI-V3.0.1.32609 Firebird 3.0
Implementation = Firebird/Linux/AMD/Intel/x64

Lock Directory = /tmp/firebird/
Message File = /opt/firebird/
Security File = /opt/firebird/security3.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: feature is not supported
feature is not supported

Licence Mask Info: 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
SQL Params
SQLType =SQL_LONG
sub type = 0
Field Name = ROWID
Scale = 0
Charset id = 0
Not Null
Size = 4

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

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)

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)

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)


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


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: 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: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Invalid password Test
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Invalid Prepare SQL Test
Error Handled: 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: 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
Invalid Server Name Test
Error Handled: 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: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
Invalid password Test
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login


Test Suite Ends
Revision:	143
Committed:	Fri Feb 23 12:11:21 2018 UTC (6 years, 2 months ago) by tony
File size:	68727 byte(s)
Log Message:	Fixes Merged