Firebird API Test Suite Copyright MWA Software 2016 Starting Tests Client API Version = 3.768 Running Test 1: Create and Drop a Database Creating a Database with empty parameters Create Database fails (as expected): I/O error during "open O_CREAT" operation for file "" Error while trying to create file No such file or directory Creating a Database using an SQL Statement Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3 SQL Dialect = 3 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb DB Charset ID = 0 DB SQL Dialect = 3 DB Remote Protocol = TCPv4 DB ODS Major Version = 12 DB ODS Minor Version = 0 User Authentication Method = Srp DPB Count = 3 28 = SYSDBA 29 = masterkey 65 = 3 Dropping Database Creating a Database with a DPD DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb DB Charset ID = 4 DB SQL Dialect = 3 DB Remote Protocol = TCPv4 DB ODS Major Version = 12 DB ODS Minor Version = 0 User Authentication Method = Srp Dropping Database DPB Count = 4 28 = SYSDBA 29 = masterkey 48 = UTF8 65 = 3 Creating a Database with a DPD Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3 ODS major = 12 ODS minor = 0 DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb DB Charset ID = 4 DB SQL Dialect = 3 DB Remote Protocol = TCPv4 DB ODS Major Version = 12 DB ODS Minor Version = 0 User Authentication Method = Srp RDB$DESCRIPTION = RDB$RELATION_ID = 128 RDB$SECURITY_CLASS = SQL$363 RDB$CHARACTER_SET_NAME = UTF8 RDB$LINGER = Dropping Database Running Test 2: Open the employee database and run a query Opening localhost:employee Database Open, SQL Dialect = 3 Metadata SQLType =SQL_SHORT sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = EMP_NO Alias Name = EMP_NO Field Name = EMP_NO Scale = 0 Charset id = 0 Not Null Size = 2 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = FIRST_NAME Alias Name = FIRST_NAME Field Name = FIRST_NAME Scale = 0 Charset id = 0 Not Null Size = 15 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = LAST_NAME Alias Name = LAST_NAME Field Name = LAST_NAME Scale = 0 Charset id = 0 Not Null Size = 20 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = PHONE_EXT Alias Name = PHONE_EXT Field Name = PHONE_EXT Scale = 0 Charset id = 0 Nullable Size = 4 SQLType =SQL_TIMESTAMP sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = HIRE_DATE Alias Name = HIRE_DATE Field Name = HIRE_DATE Scale = 0 Charset id = 0 Not Null Size = 8 SQLType =SQL_TEXT sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = DEPT_NO Alias Name = DEPT_NO Field Name = DEPT_NO Scale = 0 Charset id = 0 Not Null Size = 3 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = JOB_CODE Alias Name = JOB_CODE Field Name = JOB_CODE Scale = 0 Charset id = 0 Not Null Size = 5 SQLType =SQL_SHORT sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = JOB_GRADE Alias Name = JOB_GRADE Field Name = JOB_GRADE Scale = 0 Charset id = 0 Not Null Size = 2 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = JOB_COUNTRY Alias Name = JOB_COUNTRY Field Name = JOB_COUNTRY Scale = 0 Charset id = 0 Not Null Size = 15 SQLType =SQL_INT64 sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = SALARY Alias Name = SALARY Field Name = SALARY Scale = -2 Charset id = 0 Not Null Size = 8 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = FULL_NAME Alias Name = FULL_NAME Field Name = FULL_NAME Scale = 0 Charset id = 0 Nullable Size = 37 Plan = Select Expression -> First N Records -> Table "EMPLOYEE" Full Scan Select First 3 * from EMPLOYEE EMP_NO = 2 FIRST_NAME = Robert LAST_NAME = Nelson PHONE_EXT = 250 HIRE_DATE = 28/12/1988 00:00:00.000 DEPT_NO = 600 JOB_CODE = VP JOB_GRADE = 2 JOB_COUNTRY = USA SALARY = 105,900.00 FULL_NAME = Nelson, Robert EMP_NO = 4 FIRST_NAME = Bruce LAST_NAME = Young PHONE_EXT = 233 HIRE_DATE = 28/12/1988 00:00:00.000 DEPT_NO = 621 JOB_CODE = Eng JOB_GRADE = 2 JOB_COUNTRY = USA SALARY = 97,500.00 FULL_NAME = Young, Bruce EMP_NO = 5 FIRST_NAME = Kim LAST_NAME = Lambert PHONE_EXT = 22 HIRE_DATE = 6/2/1989 00:00:00.000 DEPT_NO = 130 JOB_CODE = Eng JOB_GRADE = 2 JOB_COUNTRY = USA SALARY = 102,750.00 FULL_NAME = Lambert, Kim Select * from EMPLOYEE Where EMP_NO = ? SQL Params SQLType =SQL_SHORT sub type = 0 Field Name = Scale = 0 Charset id = 0 Not Null Size = 2 EMP_NO = 8 FIRST_NAME = Leslie LAST_NAME = Johnson PHONE_EXT = 410 HIRE_DATE = 5/4/1989 00:00:00.000 DEPT_NO = 180 JOB_CODE = Mktg JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie With param names Select * from EMPLOYEE Where EMP_NO = :EMP_NO SQL Params SQLType =SQL_SHORT sub type = 0 Field Name = EMP_NO Scale = 0 Charset id = 0 Not Null Size = 2 EMP_NO = 8 FIRST_NAME = Leslie LAST_NAME = Johnson PHONE_EXT = 410 HIRE_DATE = 5/4/1989 00:00:00.000 DEPT_NO = 180 JOB_CODE = Mktg JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie Running Test 3: ad hoc queries Opening localhost:employee Database Open Employee Count = 42 Employee Count = 41 Employee Count = 42 Employee Count = 41 Employee Count = 42 Constrained Employee Count = 3 "Johnson" Employee Count = 2 "Yanowski" Employee Count = 1 Running Test 4: Update, Insert and Delete Queries Opening localhost:employee Database Open Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 EMP_NO = 8 FIRST_NAME = Leslie LAST_NAME = Johnson PHONE_EXT = 410 HIRE_DATE = 5/4/1989 00:00:00.000 DEPT_NO = 180 JOB_CODE = Mktg JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie Current memory = 1.960269600000000000E+0007 Delta memory = 2.616000000000000000E+0003 Max memory = 1.966627200000000000E+0007 Elapsed time= 0.000 sec Cpu = 0.000 sec Buffers = 2.048000000000000000E+0003 Reads = 0.000000000000000000E+0000 Writes = 0.000000000000000000E+0000 Fetches = 2.000000000000000000E+0000 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 Relation Name = EMPLOYEE Metadata SQLType =SQL_SHORT sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = EMP_NO Alias Name = EMP_NO Field Name = EMP_NO Scale = 0 Charset id = 0 Not Null Size = 2 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = FIRST_NAME Alias Name = FIRST_NAME Field Name = FIRST_NAME Scale = 0 Charset id = 0 Not Null Size = 15 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = LAST_NAME Alias Name = LAST_NAME Field Name = LAST_NAME Scale = 0 Charset id = 0 Not Null Size = 20 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = PHONE_EXT Alias Name = PHONE_EXT Field Name = PHONE_EXT Scale = 0 Charset id = 0 Nullable Size = 4 SQLType =SQL_TIMESTAMP sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = HIRE_DATE Alias Name = HIRE_DATE Field Name = HIRE_DATE Scale = 0 Charset id = 0 Not Null Size = 8 SQLType =SQL_TEXT sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = DEPT_NO Alias Name = DEPT_NO Field Name = DEPT_NO Scale = 0 Charset id = 0 Not Null Size = 3 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = JOB_CODE Alias Name = JOB_CODE Field Name = JOB_CODE Scale = 0 Charset id = 0 Not Null Size = 5 SQLType =SQL_SHORT sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = JOB_GRADE Alias Name = JOB_GRADE Field Name = JOB_GRADE Scale = 0 Charset id = 0 Not Null Size = 2 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = JOB_COUNTRY Alias Name = JOB_COUNTRY Field Name = JOB_COUNTRY Scale = 0 Charset id = 0 Not Null Size = 15 SQLType =SQL_INT64 sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = SALARY Alias Name = SALARY Field Name = SALARY Scale = -2 Charset id = 0 Not Null Size = 8 SQLType =SQL_VARYING sub type = 0 Table = EMPLOYEE Owner = SYSDBA Column Name = FULL_NAME Alias Name = FULL_NAME Field Name = FULL_NAME Scale = 0 Charset id = 0 Nullable Size = 37 EMP_NO = 150 FIRST_NAME = John LAST_NAME = Doe PHONE_EXT = HIRE_DATE = 1/4/2015 00:00:00.000 DEPT_NO = 600 JOB_CODE = Eng JOB_GRADE = 4 JOB_COUNTRY = England SALARY = 41,000.89 FULL_NAME = Doe, John Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 EMP_NO = 151 FIRST_NAME = Major LAST_NAME = Major PHONE_EXT = HIRE_DATE = 1/4/2015 00:00:00.000 DEPT_NO = 600 JOB_CODE = Eng JOB_GRADE = 4 JOB_COUNTRY = England SALARY = 40,000.59 FULL_NAME = Major, Major Now Delete the rows Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1 Inserting Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 EMP_NO = 150 FIRST_NAME = Jane LAST_NAME = Doe PHONE_EXT = NULL HIRE_DATE = 1/4/2015 00:00:00.000 DEPT_NO = 600 JOB_CODE = Eng JOB_GRADE = 4 JOB_COUNTRY = England SALARY = 41,000.89 FULL_NAME = Doe, Jane Employee Count = 43 Prepare Query again EMP_NO = 150 FIRST_NAME = Jane LAST_NAME = Doe PHONE_EXT = NULL HIRE_DATE = 1/4/2015 00:00:00.000 DEPT_NO = 600 JOB_CODE = Eng JOB_GRADE = 4 JOB_COUNTRY = England SALARY = 41,000.89 FULL_NAME = Doe, Jane Prepare Query again with a different transaction EMP_NO = 8 FIRST_NAME = Leslie LAST_NAME = Johnson PHONE_EXT = 410 HIRE_DATE = 5/4/1989 00:00:00.000 DEPT_NO = 180 JOB_CODE = Mktg JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie Open Cursor with a different transaction EMP_NO = 8 FIRST_NAME = Leslie LAST_NAME = Johnson PHONE_EXT = 410 HIRE_DATE = 5/4/1989 00:00:00.000 DEPT_NO = 180 JOB_CODE = Mktg JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie Same Statement - updated params EMP_NO = 9 FIRST_NAME = Phil LAST_NAME = Forest PHONE_EXT = 229 HIRE_DATE = 17/4/1989 00:00:00.000 DEPT_NO = 622 JOB_CODE = Mngr JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 75,060.00 FULL_NAME = Forest, Phil Running Test 5: Update Returning and Activity Check Opening localhost:employee Database Open Database Closed Database Open Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 Last Name = Johnson EMP_NO = 8 FIRST_NAME = Leslie LAST_NAME = Johnson PHONE_EXT = 410 HIRE_DATE = 31/1/2016 00:00:00.000 DEPT_NO = 180 JOB_CODE = Mktg JOB_GRADE = 3 JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie Inserting Full Name = Doe, John Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 Database Activity = TRUE Transaction Activity = TRUE Database Activity = FALSE Transaction Activity = FALSE Employee Count = 43 Database Activity = TRUE Transaction Activity = TRUE Transaction Active Transaction inactive Running Test 6: Blob Handling Metadata SQLType =SQL_TEXT sub type = 0 Table = RDB$CHARACTER_SETS Owner = SYSDBA Column Name = RDB$CHARACTER_SET_NAME Alias Name = RDB$CHARACTER_SET_NAME Field Name = RDB$CHARACTER_SET_NAME Scale = 0 Charset id = 4 Nullable Size = 124 SQLType =SQL_SHORT sub type = 0 Table = RDB$CHARACTER_SETS Owner = SYSDBA Column Name = RDB$CHARACTER_SET_ID Alias Name = RDB$CHARACTER_SET_ID Field Name = RDB$CHARACTER_SET_ID Scale = 0 Charset id = 0 Nullable Size = 2 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 0 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 1 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 2 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 3 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 4 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 5 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 6 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 9 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 10 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 11 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 12 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 13 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 14 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 15 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 16 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 17 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 18 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 19 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 21 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 22 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 23 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 34 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 35 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 36 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 37 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 38 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 39 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 40 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 44 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 45 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 46 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 47 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 48 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 49 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 50 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 51 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 52 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 53 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 54 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 55 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 56 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 57 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 58 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 59 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 60 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 63 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 64 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 65 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 66 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 67 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 68 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001) RDB$CHARACTER_SET_ID = 69 Metadata SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = ROWID Alias Name = ROWID Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = FIXEDPOINT Alias Name = FIXEDPOINT Field Name = FIXEDPOINT Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = FLOATINGPOINT Alias Name = FLOATINGPOINT Field Name = FLOATINGPOINT Scale = 0 Charset id = 0 Nullable Size = 8 SQLType =SQL_VARYING sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = TITLE Alias Name = TITLE Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_BLOB sub type = 1 Table = TESTDATA Owner = SYSDBA Column Name = BLOBDATA Alias Name = BLOBDATA Field Name = BLOBDATA Scale = 0 Charset id = 4 Nullable Size = 8 Blob Meta Data SQL SubType =1 Table = TESTDATA Column = BLOBDATA CharSetID = 4 Segment Size = 80 SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_LONG sub type = 0 Field Name = FP Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Field Name = DP Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA = NULL SQL Params SQLType =SQL_BLOB sub type = 1 Field Name = Scale = 0 Charset id = 4 Nullable Size = 8 SQLType =SQL_LONG sub type = 0 Field Name = Scale = 0 Charset id = 0 Not Null Size = 4 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_LONG sub type = 0 Field Name = FP Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Field Name = DP Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered ROWID = 2 FIXEDPOINT = NULL FLOATINGPOINT = NULL TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered Testing Blob as stored proc parameter Metadata SQLType =SQL_BLOB sub type = 1 Table = TESTPROC Owner = SYSDBA Column Name = BLOBDATA Alias Name = BLOBDATA Field Name = BLOBDATA Scale = 0 Charset id = 4 Nullable Size = 8 Blob Meta Data SQL SubType =1 Table = TESTPROC Column = BLOBDATA CharSetID = 4 Segment Size = 80 BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered Metadata SQLType =SQL_TEXT sub type = 0 Table = RDB$CHARACTER_SETS Owner = SYSDBA Column Name = RDB$CHARACTER_SET_NAME Alias Name = RDB$CHARACTER_SET_NAME Field Name = RDB$CHARACTER_SET_NAME Scale = 0 Charset id = 53 Nullable Size = 31 SQLType =SQL_SHORT sub type = 0 Table = RDB$CHARACTER_SETS Owner = SYSDBA Column Name = RDB$CHARACTER_SET_ID Alias Name = RDB$CHARACTER_SET_ID Field Name = RDB$CHARACTER_SET_ID Scale = 0 Charset id = 0 Nullable Size = 2 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 0 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 1 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 2 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 3 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 4 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 5 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 6 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 9 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 10 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 11 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 12 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 13 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 14 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 15 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 16 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 17 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 18 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 19 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 21 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 22 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 23 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 34 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 35 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 36 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 37 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 38 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 39 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 40 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 44 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 45 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 46 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 47 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 48 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 49 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 50 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 51 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 52 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 53 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 54 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 55 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 56 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 57 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 58 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 59 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 60 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 63 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 64 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 65 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 66 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 67 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 68 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252) RDB$CHARACTER_SET_ID = 69 Metadata SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = ROWID Alias Name = ROWID Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = FIXEDPOINT Alias Name = FIXEDPOINT Field Name = FIXEDPOINT Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = FLOATINGPOINT Alias Name = FLOATINGPOINT Field Name = FLOATINGPOINT Scale = 0 Charset id = 0 Nullable Size = 8 SQLType =SQL_VARYING sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = TITLE Alias Name = TITLE Field Name = TITLE Scale = 0 Charset id = 53 Nullable Size = 32 SQLType =SQL_BLOB sub type = 1 Table = TESTDATA Owner = SYSDBA Column Name = BLOBDATA Alias Name = BLOBDATA Field Name = BLOBDATA Scale = 0 Charset id = 53 Nullable Size = 8 Blob Meta Data SQL SubType =1 Table = TESTDATA Column = BLOBDATA CharSetID = 53 Segment Size = 80 SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 53 Nullable Size = 32 SQLType =SQL_LONG sub type = 0 Field Name = FP Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Field Name = DP Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) BLOBDATA = NULL SQL Params SQLType =SQL_BLOB sub type = 1 Field Name = Scale = 0 Charset id = 53 Nullable Size = 8 SQLType =SQL_LONG sub type = 0 Field Name = Scale = 0 Charset id = 0 Not Null Size = 4 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) BLOBDATA (Charset Id = 53 Codepage = 1252) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 53 Nullable Size = 32 SQLType =SQL_LONG sub type = 0 Field Name = FP Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Field Name = DP Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) BLOBDATA (Charset Id = 53 Codepage = 1252) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered ROWID = 2 FIXEDPOINT = NULL FLOATINGPOINT = NULL TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) BLOBDATA (Charset Id = 53 Codepage = 1252) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered Testing Blob as stored proc parameter Metadata SQLType =SQL_BLOB sub type = 1 Table = TESTPROC Owner = SYSDBA Column Name = BLOBDATA Alias Name = BLOBDATA Field Name = BLOBDATA Scale = 0 Charset id = 53 Nullable Size = 8 Blob Meta Data SQL SubType =1 Table = TESTPROC Column = BLOBDATA CharSetID = 53 Segment Size = 80 BLOBDATA (Charset Id = 53 Codepage = 1252) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered Metadata SQLType =SQL_TEXT sub type = 0 Table = RDB$CHARACTER_SETS Owner = SYSDBA Column Name = RDB$CHARACTER_SET_NAME Alias Name = RDB$CHARACTER_SET_NAME Field Name = RDB$CHARACTER_SET_NAME Scale = 0 Charset id = 3 Nullable Size = 93 SQLType =SQL_SHORT sub type = 0 Table = RDB$CHARACTER_SETS Owner = SYSDBA Column Name = RDB$CHARACTER_SET_ID Alias Name = RDB$CHARACTER_SET_ID Field Name = RDB$CHARACTER_SET_ID Scale = 0 Charset id = 0 Nullable Size = 2 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 0 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 1 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 2 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 3 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 4 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 5 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 6 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 9 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 10 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 11 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 12 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 13 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 14 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 15 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 16 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 17 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 18 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 19 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 21 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 22 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 23 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 34 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 35 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 36 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 37 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 38 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 39 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 40 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 44 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 45 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 46 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 47 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 48 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 49 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 50 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 51 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 52 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 53 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 54 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 55 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 56 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 57 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 58 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 59 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 60 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 63 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 64 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 65 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 66 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 67 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 68 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001) RDB$CHARACTER_SET_ID = 69 Metadata SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = ROWID Alias Name = ROWID Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = FIXEDPOINT Alias Name = FIXEDPOINT Field Name = FIXEDPOINT Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = FLOATINGPOINT Alias Name = FLOATINGPOINT Field Name = FLOATINGPOINT Scale = 0 Charset id = 0 Nullable Size = 8 SQLType =SQL_VARYING sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = TITLE Alias Name = TITLE Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_BLOB sub type = 1 Table = TESTDATA Owner = SYSDBA Column Name = BLOBDATA Alias Name = BLOBDATA Field Name = BLOBDATA Scale = 0 Charset id = 4 Nullable Size = 8 Blob Meta Data SQL SubType =1 Table = TESTDATA Column = BLOBDATA CharSetID = 4 Segment Size = 80 SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_LONG sub type = 0 Field Name = FP Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Field Name = DP Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA = NULL SQL Params SQLType =SQL_BLOB sub type = 1 Field Name = Scale = 0 Charset id = 4 Nullable Size = 8 SQLType =SQL_LONG sub type = 0 Field Name = Scale = 0 Charset id = 0 Not Null Size = 4 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_LONG sub type = 0 Field Name = FP Scale = -2 Charset id = 0 Nullable Size = 4 SQLType =SQL_DOUBLE sub type = 0 Field Name = DP Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 FIXEDPOINT = 20.28 FLOATINGPOINT = 3.14 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered ROWID = 2 FIXEDPOINT = NULL FLOATINGPOINT = NULL TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered Testing Blob as stored proc parameter Metadata SQLType =SQL_BLOB sub type = 1 Table = TESTPROC Owner = SYSDBA Column Name = BLOBDATA Alias Name = BLOBDATA Field Name = BLOBDATA Scale = 0 Charset id = 4 Nullable Size = 8 Blob Meta Data SQL SubType =1 Table = TESTPROC Column = BLOBDATA CharSetID = 4 Segment Size = 80 BLOBDATA (Charset Id = 4 Codepage = 65001) To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered Running Test 7: Create and read back an Array Metadata SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = ROWID Alias Name = ROWID Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = TITLE Alias Name = TITLE Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_TIMESTAMP sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = DATED Alias Name = DATED Field Name = DATED Scale = 0 Charset id = 0 Nullable Size = 8 SQLType =SQL_VARYING sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = NOTES Alias Name = NOTES Field Name = NOTES Scale = 0 Charset id = 4 Nullable Size = 256 SQLType =SQL_ARRAY sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = MYARRAY Alias Name = MYARRAY Field Name = MYARRAY Scale = 0 Charset id = 0 Nullable Size = 8 Array Meta Data: SQLType =SQL_LONG Scale = 0 Charset id = 0 Size = 4 Table = TESTDATA Column = MYARRAY Dimensions = 1 Bounds: (0:16) SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_TIMESTAMP sub type = 0 Field Name = DATED Scale = 0 Charset id = 0 Nullable Size = 8 SQLType =SQL_VARYING sub type = 0 Field Name = NOTES Scale = 0 Charset id = 4 Nullable Size = 256 Param Name = ROWID Param Name = TITLE Param Name = DATED Param Name = NOTES ROWID = 1 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) DATED = 1/4/2016 09:30:00.100 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) MYARRAY = NULL SQL Params SQLType =SQL_ARRAY sub type = 0 Field Name = MYARRAY Scale = 0 Charset id = 0 Nullable Size = 8 ROWID = 1 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) DATED = 1/4/2016 09:30:00.100 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) Shrink to 2:10 Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) Write updated reduced slice Show update array ROWID = 1 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) DATED = 1/4/2016 09:30:00.100 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) Running Test 8: Create and read back an Array with 2 dimensions Metadata SQLType =SQL_LONG sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = ROWID Alias Name = ROWID Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = TITLE Alias Name = TITLE Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_ARRAY sub type = 0 Table = TESTDATA Owner = SYSDBA Column Name = MYARRAY Alias Name = MYARRAY Field Name = MYARRAY Scale = 0 Charset id = 4 Nullable Size = 8 Array Meta Data: SQLType =SQL_VARYING Scale = 0 Charset id = 4 Size = 16 Table = TESTDATA Column = MYARRAY Dimensions = 2 Bounds: (0:16) (-1:7) SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 ROWID = 1 TITLE = 2D Array (Charset Id = 4 Codepage = 65001) MYARRAY = NULL ROWID = 1 TITLE = 2D Array (Charset Id = 4 Codepage = 65001) Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202) Running Test 9: Database Information tests Database ID = 4 FB = /opt/firebird/examples/empbuild/employee.fdb SN = mint18-FB3 Pages =307 Base Level = 13,4,0,3, Implementation = 11,7,0,3,66,1,66, Reserved = 0 ODS minor = 0 ODS major = 12 Page Size = 8192 Version = 1: LI-V6.3.1.32609 Firebird 3.0 Database is Read/Write Database Created: 27/9/2016 12:08:46 Pages Used = 297 Pages Free = 10 Server Memory = 19122232 Forced Writes = 1 Max Memory = 19235672 Num Buffers = 2048 Sweep Interval = 20000 Logged in Users: SYSDBA, Active Transaction Count = 0 Fetches = 546 Writes = 8 Reads = 54 Page Writes = 5 Record Version Removals Operation Counts Deletes Operation Counts Expunge Count Operation Counts Insert Count Operation Counts Purge Count Countites Operation Counts Indexed Reads Count Operation Counts Table ID = 4 Count = 28 Table ID = 6 Count = 15 Table ID = 9 Count = 2 Table ID = 11 Count = 1 Table ID = 12 Count = 15 Table ID = 28 Count = 1 Table ID = 29 Count = 1 Sequential Table Scans Operation Counts Table ID = 0 Count = 94 Table ID = 1 Count = 2 Update Count Operation Counts Page Size = 8192 Running Test 10: Event Handling Call Async Wait Async Wait Called Event Signalled First Event - usually ignored Signal Event Event Signalled Event Counts: TESTEVENT, Count = 1 Two more events Call Async Wait Async Wait Called Event Signalled Deferred Events Caught Event Counts: TESTEVENT, Count = 2 Signal Event Event Signalled Event Counts: TESTEVENT, Count = 1 Async Wait: Test Cancel Async Wait Called Event Cancelled Time Out - Cancel Worked! Sync wait Event Signalled Event Counts: TESTEVENT, Count = 1 Running Test 11: Services API Service Manager Version = 2 Server Version = LI-V3.0.1.32609 Firebird 3.0 Implementation = Firebird/Linux/AMD/Intel/x64 Lock Directory = /tmp/firebird/ Message File = /opt/firebird/ Security File = /opt/firebird/security3.fdb DB Attachments No. of Attachments = 0 Databases In Use = 0 Sec. Database User User Name = SYSDBA First Name = Middle Name = Last Name = User ID = 0 Group ID = 0 Licence Info: feature is not supported feature is not supported Licence Mask Info: feature is not supported Capabilities = 6 Get Limbo transactions Limbo Transactions Local Backup Local Backup Complete Local Restore Local Restore Complete Open Database Check Database OK Database Dropped Running Test 12: Character Sets SQL Params SQLType =SQL_LONG sub type = 0 Field Name = ROWID Scale = 0 Charset id = 0 Not Null Size = 4 SQLType =SQL_VARYING sub type = 0 Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 SQLType =SQL_VARYING sub type = 0 Field Name = NOTES Scale = 0 Charset id = 4 Nullable Size = 256 SQLType =SQL_BLOB sub type = 1 Field Name = BLOBDATA Scale = 0 Charset id = 4 Nullable Size = 8 SQLType =SQL_BLOB sub type = 1 Field Name = BLOBDATA2 Scale = 0 Charset id = 4 Nullable Size = 8 SQLType =SQL_VARYING sub type = 0 Field Name = INCLEAR Scale = 0 Charset id = 1 Nullable Size = 16 Connection Character Set UTF8 ROWID = 1 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) Connection Character Set NONE ROWID = 1 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) Connection Character Set WIN1252 ROWID = 1 TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252) NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) Running Test 13: Transaction over two databases Init Database 1 ROWID = 1 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) Init Database 2 ROWID = 1 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) ROWID = 1 TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001) NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) ROWID = 1 TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001) NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) Running Test 14: Non select procedures Default Character set Name = UTF8 Metadata SQLType =SQL_LONG sub type = 0 Table = SHOWDATA Owner = SYSDBA Column Name = ROWID Alias Name = ROWID Field Name = ROWID Scale = 0 Charset id = 0 Nullable Size = 4 SQLType =SQL_VARYING sub type = 0 Table = SHOWDATA Owner = SYSDBA Column Name = TITLE Alias Name = TITLE Field Name = TITLE Scale = 0 Charset id = 4 Nullable Size = 128 ROWID = 1 TITLE = Testing (Charset Id = 4 Codepage = 65001) Repeat with a different execute transaction ROWID = 1 TITLE = Testing (Charset Id = 4 Codepage = 65001) Repeat with a original transaction ROWID = 1 TITLE = Testing (Charset Id = 4 Codepage = 65001) Running Test 15: Blob Handling and BPBs Testdata ROWID = 1 TITLE = Blob Test (Charset Id = 4 Codepage = 65001) BLOBDATA = (blob), Length = 92514 Testdata 2 ROWID = 1 TITLE = Blob Test (Charset Id = 4 Codepage = 65001) BLOBDATA (Charset Id = 4 Codepage = 65001) Écoute moi Running Test 16: Error handling Invalid Database Name Test Error Handled: I/O error during "open" operation for file "Malformed Name" Error while trying to open file No such file or directory Invalid User Name Test Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login Invalid password Test Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login Invalid Prepare SQL Test Error Handled: Dynamic SQL Error SQL error code = -206 Column unknown UNKNOWN_DATE At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? Invalid Open Cursor SQL Test Error Handled: Dynamic SQL Error SQL error code = -206 Column unknown X At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE Transaction not started Test Error Handled: Transaction is not active Invalid Param SQL Type Test Error Handled: Field "EMP_NO" not found Invalid Server Name Test Error Handled: Unable to complete network request to host "unknown". Failed to locate host machine. The specified name was not found in the hosts file or Domain Name Services Invalid User Name Test Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login Invalid password Test Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login Test Suite Ends