--- ibx/trunk/fbintf/testsuite/reference.log 2018/01/18 14:37:51 110 +++ ibx/trunk/fbintf/testsuite/reference.log 2018/01/18 14:37:53 111 @@ -285,10 +285,10 @@ JOB_COUNTRY = USA SALARY = 64,635.00 FULL_NAME = Johnson, Leslie -Current memory = 1.959857600000000000E+0007 -Delta memory = 2.952000000000000000E+0003 -Max memory = 1.966170400000000000E+0007 -Elapsed time= 0.007 sec +Current memory = 1.959863200000000000E+0007 +Delta memory = 2.616000000000000000E+0003 +Max memory = 1.966220800000000000E+0007 +Elapsed time= 0.000 sec Cpu = 0.000 sec Buffers = 2.048000000000000000E+0003 Reads = 0.000000000000000000E+0000 @@ -978,6 +978,542 @@ 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 @@ -1394,6 +1930,66 @@ 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