Firebird API Test Suite Copyright MWA Software 2016-2021 Starting Tests Client API Version = 3.0 Firebird Environment Variable = /opt/firebird3.0.5 Firebird Bin Directory = /opt/firebird3.0.5/bin Firebird Conf Directory = /opt/firebird3.0.5/ Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so 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 = 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 = 12 DB ODS Minor Version = 0 User Authentication Method = Srp Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so DB Client Implementation Version = 3.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-V3.0.5.33220 Firebird 3.0" Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C" Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C" on disk structure version 12.0 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 = 12 DB ODS Minor Version = 0 User Authentication Method = Srp Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so DB Client Implementation Version = 3.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 = 12 ODS minor = 0 Attachment ID = 6 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 = 12 DB ODS Minor Version = 0 User Authentication Method = Srp Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so DB Client Implementation Version = 3.0 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 Open Database fails 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 = 12 DB ODS Minor Version = 0 User Authentication Method = Srp Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so DB Client Implementation Version = 3.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: Remote Scrollable cursors test fails feature is not supported 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 = 12 DB ODS Minor Version = 0 User Authentication Method = User name in DPB Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so DB Client Implementation Version = 3.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 = 5005 Transaction is Read/Write Transaction Database Path = inet://localhost/employee Transaction ID = 5005 Oldest Interesting = 5003 Oldest Action = 5004 Oldest Snapshot = 5004 Oldest Interesting = 0 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-V3.0.5.33220 Firebird 3.0" Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:CZ" Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:CZ" on disk structure version 12.0 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,694,032 Delta memory = 4,480 Max memory = 19,755,888 Elapsed time= 0.002 sec Cpu = 0.010 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 = 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 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 = 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 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 = 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 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.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (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.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (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/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus Pages =307 Base Level = 13,4,0,3, Implementation = 11,7,0,3,65,1,65, Reserved = 0 ODS minor = 0 ODS major = 12 Page Size = 8192 Version = 1: LI-V6.3.5.33220 Firebird 3.0 Database is Read/Write Database Created: 09/1/2020 13:13:45 Pages Used = 297 Pages Free = 10 Server Memory = 19196128 Forced Writes = 1 Max Memory = 19316896 Num Buffers = 2048 Sweep Interval = 20000 Logged in Users: SYSDBA, Active Transaction Count = 0 Fetches = 452 Writes = 8 Reads = 57 Page Writes = 4 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 = 3 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 Counts: TESTEVENT, Count = 1 Two more events Call Async Wait Async Wait Called Event Signalled 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-V3.0.5.33220 Firebird 3.0 Implementation = Firebird/Linux/AMD/Intel/x64 Lock Directory = /tmp/firebird/ Message File = /opt/firebird3.0.5/ Security File = security.db 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 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 Value = Test à 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) 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) 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) ------------------------------------------------------ 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: 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 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: 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 ------------------------------------------------------ Running Test 17: Date/Time tests and Firebird 4 extensions FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" Has Local TZ DB = FALSE 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 Skipping Firebird 4 and later test part ------------------------------------------------------ Running Test 18: Firebird 4 Decfloat extensions FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" Skipping test for Firebird 4 and later ------------------------------------------------------ Running Test 19: Batch Update and Insert Queries Opening inet://localhost/employee Skipping test for Firebird 4 and later ------------------------------------------------------ Running Test 20: Stress Test IBatch interface FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" Skipping test for Firebird 4 and later ------------------------------------------------------ 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 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 - Dynamic SQL Error -SQL error code = -303 -conversion error from string "1,000" Expected Error - Dynamic SQL Error -SQL error code = -303 -conversion error from string "10.0.0" 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 ------------------------------------------------------ Running Test 22: Journalling Start Journaling. Session ID = 1 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 = 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 = 9 IBX$OLDTRANSACTIONID = NULL IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) IBX$CREATED = 2021/12/07 09:58:40.6960 IBX$SESSIONID = 1 IBX$TRANSACTIONID = 11 IBX$OLDTRANSACTIONID = 10 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) IBX$CREATED = 2021/12/07 09:58:41.0190 Journal Entries Journal Entry = jeTransStart(Transaction Start) Timestamp = 2021/12/07 09:58:40.7300 Session ID = 1 Transaction ID = 9 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 = 2021/12/07 09:58:40.7970 Session ID = 1 Transaction ID = 9 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 = 2021/12/07 09:58:40.8130 Session ID = 1 Transaction ID = 9 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 = 2021/12/07 09:58:40.8900 Session ID = 1 Transaction ID = 10 Old TransactionID = 9 Journal Entry = jeQuery(Query) Timestamp = 2021/12/07 09:58:40.9150 Session ID = 1 Transaction ID = 10 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) Journal Entry = jeTransRollbackRet(Rollback Retaining) Timestamp = 2021/12/07 09:58:41.0150 Session ID = 1 Transaction ID = 11 Old TransactionID = 10 Journal Entry = jeQuery(Query) Timestamp = 2021/12/07 09:58:41.0390 Session ID = 1 Transaction ID = 11 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 = 2021/12/07 09:58:41.0610 Session ID = 1 Transaction ID = 12 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 = 2021/12/07 09:58:41.1310 Session ID = 1 Transaction ID = 11 Journal Entry = jeQuery(Query) Timestamp = 2021/12/07 09:58:41.1910 Session ID = 1 Transaction ID = 12 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 = 2021/12/07 09:58:41.2100 Session ID = 1 Transaction ID = 12 Query = Insert into TestData(RowID,OtherBlob) Values (6, FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 01000000010000001A01050001000000DA000000 ) Journal Entry = jeQuery(Query) Timestamp = 2021/12/07 09:58:41.2330 Session ID = 1 Transaction ID = 12 Query = Insert into TestData(RowID,MyArray) Values (7, 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 ) Journal Entry = jeTransRollback(Rollback) Timestamp = 2021/12/07 09:58:41.3650 Session ID = 1 Transaction ID = 12 ------------------------------------------------------ Test Suite Ends