ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/testsuite/FB2reference.log
(Generate patch)

Comparing ibx/branches/journaling/testsuite/FB2reference.log (file contents):
Revision 362 by tony, Tue Dec 7 13:27:39 2021 UTC vs.
Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC

# Line 639 | Line 639 | DEPT_KEY_PATH = 000;900
639  
640   Rows printed = 42
641  
642 < Current memory = 960,816
642 > Current memory = 960,760
643   Delta memory = 9,512
644 < Max memory = 1,012,160
645 < Elapsed time= 0.032 sec
646 < Cpu = 0.003 sec
644 > Max memory = 1,012,104
645 > Elapsed time= 0.027 sec
646 > Cpu = 0.002 sec
647   Buffers = 75
648   Reads = 3
649   Writes = 0
# Line 1443 | Line 1443 | DPB: Item Count = 3
1443    isc_dpb_lc_ctype = UTF8
1444  
1445   Before Disconnect
1446 < localhost:employee Disconnected after 19 ms
1446 > localhost:employee Disconnected after 17 ms
1447   Before Connect
1448   Connected to localhost:employee
1449   DPB: Item Count = 3
# Line 1452 | Line 1452 | DPB: Item Count = 3
1452    isc_dpb_lc_ctype = UTF8
1453  
1454   Before Disconnect
1455 < localhost:employee Disconnected after 3982 ms
1455 > localhost:employee Disconnected after 3979 ms
1456   Idle Timer Expired for Test_Database_02
1457   Database Closed
1458   Transaction Events
# Line 1475 | Line 1475 | TPB: Item Count = 3
1475    isc_tpb_read
1476  
1477   Transaction Ending
1478 < Transaction Ended after 8 ms
1478 > Transaction Ended after 11 ms
1479   Transaction idle timer test
1480   Requested TPB: Item Count = 3
1481    isc_tpb_concurrency
# Line 1489 | Line 1489 | TPB: Item Count = 3
1489    isc_tpb_read
1490  
1491   Transaction Ending
1492 < Transaction Ended after 2020 ms
1492 > Transaction Ended after 2015 ms
1493   Idle Timer Expired for Test_Transaction_02
1494   Before Disconnect
1495 < localhost:employee Disconnected after 2065 ms
1495 > localhost:employee Disconnected after 2066 ms
1496   SQL Dialect Downgrade test
1497   Before Connect
1498   Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb
# Line 1504 | Line 1504 | DPB: Item Count = 4
1504  
1505   localhost:/tmp/ibx-testsuite/testsuite1.fdb created
1506   Before Disconnect
1507 < localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1507 > localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 27 ms
1508   Before Connect
1509   Warning: SQL Dialect Downgrade of localhost:/tmp/ibx-testsuite/testsuite1.fdb
1510   Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb
# Line 1514 | Line 1514 | DPB: Item Count = 3
1514    isc_dpb_lc_ctype = UTF8
1515  
1516   Before Disconnect
1517 < localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1517 > localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms
1518  
1519  
1520   ------------------------------------------------------
# Line 1541 | Line 1541 | ODS Minor Version = 2
1541   ODS Major Version = 11
1542   Page Size = 4096
1543   Version = LI-V6.3.9.27139 Firebird 2.5
1544 < Current Memory = 876896
1544 > Current Memory = 876840
1545   Forced Writes Enabled
1546 < Max Memory = 902656
1546 > Max Memory = 902544
1547   Number of Buffers = 75
1548   Sweep Interval = 20000
1549   User Names: SYSDBA
# Line 3148 | Line 3148 | SALARY = 32,000.00
3148   FULL_NAME = Guckenheimer, Mark
3149   DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance
3150   DEPT_KEY_PATH = 000;600;620;622
3151 < Current memory = 952,680
3151 > Current memory = 952,624
3152   Delta memory = 9,496
3153 < Max memory = 1,013,552
3154 < Elapsed time= 0.027 sec
3155 < Cpu = 0.001 sec
3153 > Max memory = 1,013,496
3154 > Elapsed time= 0.031 sec
3155 > Cpu = 0.002 sec
3156   Buffers = 75
3157   Reads = 3
3158   Writes = 0
# Line 9917 | Line 9917 | Message File Location = /opt/firebird2.5
9917   Database Statistics for employee
9918  
9919   Database "/opt/firebird2.5.9/examples/empbuild/employee.fdb"
9920 < Gstat execution time Sat Oct 23 13:25:30 2021
9920 > Gstat execution time Tue Dec  7 10:51:11 2021
9921  
9922   Database header page information:
9923   Flags                   0
9924   Checksum                12345
9925 < Generation              8221
9925 > Generation              9064
9926   Page size               4096
9927   ODS version             11.2
9928 < Oldest transaction      4613
9929 < Oldest active           4894
9930 < Oldest snapshot         4894
9931 < Next transaction        4894
9928 > Oldest transaction      5405
9929 > Oldest active           5406
9930 > Oldest snapshot         5406
9931 > Next transaction        5406
9932   Bumped transaction      1
9933   Sequence number         0
9934 < Next attachment ID      1665
9934 > Next attachment ID      1824
9935   Implementation ID       24
9936   Shadow count            0
9937   Page buffers            0
# Line 10056 | Line 10056 | zeus   Tue Jun  9 14:31:01 2020
10056   INET/inet_error: connect errno = 111
10057  
10058   Online Validation
10059 < 13:25:31.69 Validation started
10059 > 10:51:12.97 Validation started
10060  
10061 < 13:25:31.69 Relation 128 (COUNTRY)
10062 < 13:25:31.69   process pointer page    0 of    1
10063 < 13:25:31.69 Index 1 (RDB$PRIMARY1)
10064 < 13:25:31.69 Relation 128 (COUNTRY) is ok
10065 <
10066 < 13:25:31.69 Relation 129 (JOB)
10067 < 13:25:31.69   process pointer page    0 of    1
10068 < 13:25:31.70 Index 1 (RDB$PRIMARY2)
10069 < 13:25:31.70 Index 2 (RDB$FOREIGN3)
10070 < 13:25:31.70 Index 3 (MAXSALX)
10071 < 13:25:31.70 Index 4 (MINSALX)
10072 < 13:25:31.70 Relation 129 (JOB) is ok
10073 <
10074 < 13:25:31.70 Relation 130 (DEPARTMENT)
10075 < 13:25:31.70   process pointer page    0 of    1
10076 < 13:25:31.70 Index 1 (RDB$4)
10077 < 13:25:31.70 Index 2 (RDB$PRIMARY5)
10078 < 13:25:31.70 Index 3 (RDB$FOREIGN6)
10079 < 13:25:31.70 Index 4 (BUDGETX)
10080 < 13:25:31.70 Index 5 (RDB$FOREIGN10)
10081 < 13:25:31.70 Relation 130 (DEPARTMENT) is ok
10082 <
10083 < 13:25:31.70 Relation 131 (EMPLOYEE)
10084 < 13:25:31.70   process pointer page    0 of    1
10085 < 13:25:31.70 Index 1 (RDB$PRIMARY7)
10086 < 13:25:31.70 Index 2 (RDB$FOREIGN8)
10087 < 13:25:31.70 Index 3 (RDB$FOREIGN9)
10088 < 13:25:31.70 Index 4 (NAMEX)
10089 < 13:25:31.70 Relation 131 (EMPLOYEE) is ok
10090 <
10091 < 13:25:31.70 Relation 133 (PROJECT)
10092 < 13:25:31.70   process pointer page    0 of    1
10093 < 13:25:31.70 Index 1 (RDB$11)
10094 < 13:25:31.70 Index 2 (RDB$PRIMARY12)
10095 < 13:25:31.70 Index 3 (RDB$FOREIGN13)
10096 < 13:25:31.70 Index 4 (PRODTYPEX)
10097 < 13:25:31.70 Relation 133 (PROJECT) is ok
10098 <
10099 < 13:25:31.70 Relation 134 (EMPLOYEE_PROJECT)
10100 < 13:25:31.70   process pointer page    0 of    1
10101 < 13:25:31.70 Index 1 (RDB$PRIMARY14)
10102 < 13:25:31.70 Index 2 (RDB$FOREIGN15)
10103 < 13:25:31.70 Index 3 (RDB$FOREIGN16)
10104 < 13:25:31.70 Relation 134 (EMPLOYEE_PROJECT) is ok
10105 <
10106 < 13:25:31.70 Relation 135 (PROJ_DEPT_BUDGET)
10107 < 13:25:31.70   process pointer page    0 of    1
10108 < 13:25:31.70 Index 1 (RDB$PRIMARY17)
10109 < 13:25:31.70 Index 2 (RDB$FOREIGN18)
10110 < 13:25:31.70 Index 3 (RDB$FOREIGN19)
10111 < 13:25:31.70 Relation 135 (PROJ_DEPT_BUDGET) is ok
10112 <
10113 < 13:25:31.70 Relation 136 (SALARY_HISTORY)
10114 < 13:25:31.70   process pointer page    0 of    1
10115 < 13:25:31.70 Index 1 (RDB$PRIMARY20)
10116 < 13:25:31.70 Index 2 (RDB$FOREIGN21)
10117 < 13:25:31.70 Index 3 (CHANGEX)
10118 < 13:25:31.70 Index 4 (UPDATERX)
10119 < 13:25:31.71 Relation 136 (SALARY_HISTORY) is ok
10120 <
10121 < 13:25:31.71 Relation 137 (CUSTOMER)
10122 < 13:25:31.71   process pointer page    0 of    1
10123 < 13:25:31.71 Index 1 (RDB$PRIMARY22)
10124 < 13:25:31.71 Index 2 (RDB$FOREIGN23)
10125 < 13:25:31.71 Index 3 (CUSTNAMEX)
10126 < 13:25:31.71 Index 4 (CUSTREGION)
10127 < 13:25:31.71 Relation 137 (CUSTOMER) is ok
10128 <
10129 < 13:25:31.71 Relation 138 (SALES)
10130 < 13:25:31.71   process pointer page    0 of    1
10131 < 13:25:31.71 Index 1 (RDB$PRIMARY24)
10132 < 13:25:31.71 Index 2 (RDB$FOREIGN25)
10133 < 13:25:31.71 Index 3 (RDB$FOREIGN26)
10134 < 13:25:31.71 Index 4 (NEEDX)
10135 < 13:25:31.71 Index 5 (QTYX)
10136 < 13:25:31.71 Index 6 (SALESTATX)
10137 < 13:25:31.71 Relation 138 (SALES) is ok
10061 > 10:51:12.97 Relation 128 (COUNTRY)
10062 > 10:51:12.97   process pointer page    0 of    1
10063 > 10:51:12.98 Index 1 (RDB$PRIMARY1)
10064 > 10:51:12.98 Relation 128 (COUNTRY) is ok
10065 >
10066 > 10:51:12.98 Relation 129 (JOB)
10067 > 10:51:12.98   process pointer page    0 of    1
10068 > 10:51:12.98 Index 1 (RDB$PRIMARY2)
10069 > 10:51:12.98 Index 2 (RDB$FOREIGN3)
10070 > 10:51:12.98 Index 3 (MAXSALX)
10071 > 10:51:12.98 Index 4 (MINSALX)
10072 > 10:51:12.98 Relation 129 (JOB) is ok
10073 >
10074 > 10:51:12.98 Relation 130 (DEPARTMENT)
10075 > 10:51:12.98   process pointer page    0 of    1
10076 > 10:51:12.98 Index 1 (RDB$4)
10077 > 10:51:12.98 Index 2 (RDB$PRIMARY5)
10078 > 10:51:12.98 Index 3 (RDB$FOREIGN6)
10079 > 10:51:12.98 Index 4 (BUDGETX)
10080 > 10:51:12.98 Index 5 (RDB$FOREIGN10)
10081 > 10:51:12.98 Relation 130 (DEPARTMENT) is ok
10082 >
10083 > 10:51:12.98 Relation 131 (EMPLOYEE)
10084 > 10:51:12.98   process pointer page    0 of    1
10085 > 10:51:12.98 Index 1 (RDB$PRIMARY7)
10086 > 10:51:12.98 Index 2 (RDB$FOREIGN8)
10087 > 10:51:12.98 Index 3 (RDB$FOREIGN9)
10088 > 10:51:12.98 Index 4 (NAMEX)
10089 > 10:51:12.98 Relation 131 (EMPLOYEE) is ok
10090 >
10091 > 10:51:12.98 Relation 133 (PROJECT)
10092 > 10:51:12.98   process pointer page    0 of    1
10093 > 10:51:12.98 Index 1 (RDB$11)
10094 > 10:51:12.98 Index 2 (RDB$PRIMARY12)
10095 > 10:51:12.98 Index 3 (RDB$FOREIGN13)
10096 > 10:51:12.98 Index 4 (PRODTYPEX)
10097 > 10:51:12.98 Relation 133 (PROJECT) is ok
10098 >
10099 > 10:51:12.98 Relation 134 (EMPLOYEE_PROJECT)
10100 > 10:51:12.98   process pointer page    0 of    1
10101 > 10:51:12.98 Index 1 (RDB$PRIMARY14)
10102 > 10:51:12.98 Index 2 (RDB$FOREIGN15)
10103 > 10:51:12.98 Index 3 (RDB$FOREIGN16)
10104 > 10:51:12.98 Relation 134 (EMPLOYEE_PROJECT) is ok
10105 >
10106 > 10:51:12.98 Relation 135 (PROJ_DEPT_BUDGET)
10107 > 10:51:12.98   process pointer page    0 of    1
10108 > 10:51:12.98 Index 1 (RDB$PRIMARY17)
10109 > 10:51:12.98 Index 2 (RDB$FOREIGN18)
10110 > 10:51:12.98 Index 3 (RDB$FOREIGN19)
10111 > 10:51:12.98 Relation 135 (PROJ_DEPT_BUDGET) is ok
10112 >
10113 > 10:51:12.98 Relation 136 (SALARY_HISTORY)
10114 > 10:51:12.98   process pointer page    0 of    1
10115 > 10:51:12.98 Index 1 (RDB$PRIMARY20)
10116 > 10:51:12.99 Index 2 (RDB$FOREIGN21)
10117 > 10:51:12.99 Index 3 (CHANGEX)
10118 > 10:51:12.99 Index 4 (UPDATERX)
10119 > 10:51:12.99 Relation 136 (SALARY_HISTORY) is ok
10120 >
10121 > 10:51:12.99 Relation 137 (CUSTOMER)
10122 > 10:51:12.99   process pointer page    0 of    1
10123 > 10:51:12.99 Index 1 (RDB$PRIMARY22)
10124 > 10:51:12.99 Index 2 (RDB$FOREIGN23)
10125 > 10:51:12.99 Index 3 (CUSTNAMEX)
10126 > 10:51:12.99 Index 4 (CUSTREGION)
10127 > 10:51:12.99 Relation 137 (CUSTOMER) is ok
10128 >
10129 > 10:51:12.99 Relation 138 (SALES)
10130 > 10:51:12.99   process pointer page    0 of    1
10131 > 10:51:12.99 Index 1 (RDB$PRIMARY24)
10132 > 10:51:12.99 Index 2 (RDB$FOREIGN25)
10133 > 10:51:12.99 Index 3 (RDB$FOREIGN26)
10134 > 10:51:12.99 Index 4 (NEEDX)
10135 > 10:51:12.99 Index 5 (QTYX)
10136 > 10:51:12.99 Index 6 (SALESTATX)
10137 > 10:51:12.99 Relation 138 (SALES) is ok
10138  
10139 < 13:25:31.71 Validation finished
10139 > 10:51:12.99 Validation finished
10140  
10141  
10142   Normal Validation
# Line 11647 | Line 11647 | Current memory = 966,728
11647   Delta memory = 9,232
11648   Max memory = 1,012,400
11649   Elapsed time= 0.102 sec
11650 < Cpu = 0.001 sec
11650 > Cpu = 0.000 sec
11651   Buffers = 75
11652   Reads = 2
11653   Writes = 0
# Line 12985 | Line 12985 | Create Table LotsOfData (
12985      MyText VarChar(1024),
12986      Primary Key (RowID)
12987    );                
12988 < Loading data into database table. Started at 23/10/2021 13:26:17.370
12989 < Data load completed at 23/10/2021 13:29:17.739 Elapsed Time = 180369 ms, 100000 records loaded
12990 < Message Hash = 31f6aa48fd00beb29b2cd15d825a1f09
12991 < Database Read started at 23/10/2021 13:29:17.744
12992 < Read Dataset completed at 23/10/2021 13:29:47.865 Elapsed Time = 30121 ms, 100000 records read
12993 < Message Hash = 31f6aa48fd00beb29b2cd15d825a1f09
12988 > Loading data into database table. Started at 07/12/2021 10:51:59.868
12989 > Data load completed at 07/12/2021 10:55:16.508 Elapsed Time = 196640 ms, 100000 records loaded
12990 > Message Hash = 108f42c9623d1abdfe93dd78935ea0e2
12991 > Database Read started at 07/12/2021 10:55:16.513
12992 > Read Dataset completed at 07/12/2021 10:55:46.889 Elapsed Time = 30376 ms, 100000 records read
12993 > Message Hash = 108f42c9623d1abdfe93dd78935ea0e2
12994   Test Completed successfully
12995 < 23/10/2021 13:29:47.865 Test 21 passes as long as the checksums are identical
12995 > 07/12/2021 10:55:46.889 Test 21 passes as long as the checksums are identical
12996  
12997  
12998   ------------------------------------------------------
# Line 15000 | Line 15000 | SET TERM ;^
15000  
15001  
15002  
15003 + ------------------------------------------------------
15004 + Running Test 29: Test 29
15005 + Creating Database from resources/Test29.sql
15006 +
15007 + Create Table IBXTest (
15008 + TableKey Integer not null,
15009 + F1 Smallint,
15010 + F2 Float,
15011 + F3 Double Precision,
15012 + F4 Decimal(9,3),
15013 + F5 Decimal(18,4),
15014 + F6 Date,
15015 + F7 Timestamp,
15016 + F8 Char (2),
15017 + F9 VarChar(256),
15018 + F10 Blob,
15019 + F11 BigInt,
15020 + "f12" Integer,
15021 + F13 Time,
15022 + F14 Blob sub_type text,
15023 + MyArray Integer [0:16],
15024 + "GRANTS" VarChar(20),
15025 + "My Field" VarChar(32),
15026 + "MY Field" VarChar(32),
15027 + Primary Key(TableKey)
15028 + );
15029 +
15030 + Create Generator IBXGen;
15031 + Add a record
15032 + Add and edit a record
15033 + Row No = 1
15034 + TABLEKEY = 1
15035 + F1 = 2
15036 + F2 = 0.314000010490
15037 + F3 = 0.314123456780
15038 + F4 = 101.314
15039 + F5 = 101.99
15040 + F6 = 25/12/2007
15041 + F7 = 25/12/2007 12:30:29.130
15042 + F8 = XX (Charset = UTF8 Codepage = 65001)
15043 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15044 + F10 = (blob), Length = 100
15045 + F11 = 9223372036854775807
15046 + F12 = 65566
15047 + F13 = 12:30:45.000
15048 + F14 (Charset  = UTF8 Codepage = 65001)
15049 +
15050 + If music be the food of love, play on;
15051 + Give me excess of it, that, surfeiting,
15052 + The appetite may sicken, and so die.
15053 + That strain again! it had a dying fall:
15054 + O, it came o'er my ear like the sweet south,
15055 + That breathes upon a bank of violets,
15056 + Stealing and giving odour! Enough; no more:
15057 + 'Tis not so sweet now as it was before.
15058 + O spirit of love! how quick and fresh art thou,
15059 + That, notwithstanding thy capacity      10
15060 + Receiveth as the sea, nought enters there,
15061 + Of what validity and pitch soe'er,
15062 + But falls into abatement and low price,
15063 + Even in a minute: so full of shapes is fancy
15064 + That it alone is high fantastical.
15065 +
15066 + Si la musique est la nourriture de l'amour, continuez à jouer;
15067 + Donnez-m'en un excès, que, surexcité,
15068 + L'appétit peut devenir malade et ainsi mourir.
15069 + Cette souche encore! il a eu une chute mourante:
15070 + Oh, ça m'est venu à l'oreille comme le doux sud,
15071 + Qui souffle sur une banque de violettes,
15072 + Voler et donner de l'odeur! Assez; Pas plus:
15073 + «Ce n'est pas si doux maintenant qu'avant.
15074 + O esprit d'amour! comme tu es rapide et fraîche,
15075 + Que, malgré ta capacité 10
15076 + Reçoit comme la mer, rien n'y entre,
15077 + De quelle validité et de quelle hauteur soe'er,
15078 + Mais tombe dans l'abattement et le prix bas,
15079 + Même en une minute: si plein de formes est fantaisie
15080 + Que cela seul est fantastique.
15081 +
15082 +
15083 +
15084 + 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)
15085 +
15086 + GRANTS = NULL
15087 + MYFIELD1 = NULL
15088 + MYFIELD2 = NULL
15089 +
15090 + Row No = 2
15091 + TABLEKEY = 2
15092 + F1 = 2
15093 + F2 = 0.314000010490
15094 + F3 = 0.314123456780
15095 + F4 = 101.314
15096 + F5 = 101.99
15097 + F6 = 25/12/2007
15098 + F7 = 25/12/2007 12:30:29.130
15099 + F8 = XX (Charset = UTF8 Codepage = 65001)
15100 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15101 + F10 = NULL
15102 + F11 = 9223372036854775807
15103 + F12 = 65566
15104 + F13 = 12:30:45.000
15105 + F14 = NULL
15106 + 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)
15107 +
15108 + GRANTS = NULL
15109 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15110 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15111 +
15112 + Rows printed = 2
15113 +
15114 + Delete a record
15115 + Row No = 1
15116 + TABLEKEY = 2
15117 + F1 = 2
15118 + F2 = 0.314000010490
15119 + F3 = 0.314123456780
15120 + F4 = 101.314
15121 + F5 = 101.99
15122 + F6 = 25/12/2007
15123 + F7 = 25/12/2007 12:30:29.130
15124 + F8 = XX (Charset = UTF8 Codepage = 65001)
15125 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15126 + F10 = NULL
15127 + F11 = 9223372036854775807
15128 + F12 = 65566
15129 + F13 = 12:30:45.000
15130 + F14 = NULL
15131 + 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)
15132 +
15133 + GRANTS = NULL
15134 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15135 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15136 +
15137 + Rows printed = 1
15138 +
15139 + Rollback Retaining
15140 + Row No = 1
15141 + TABLEKEY = 1
15142 + F1 = 2
15143 + F2 = 0.314000010490
15144 + F3 = 0.314123456780
15145 + F4 = 101.314
15146 + F5 = 101.99
15147 + F6 = 25/12/2007
15148 + F7 = 25/12/2007 12:30:29.130
15149 + F8 = XX (Charset = UTF8 Codepage = 65001)
15150 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15151 + F10 = (blob), Length = 100
15152 + F11 = 9223372036854775807
15153 + F12 = 65566
15154 + F13 = 12:30:45.000
15155 + F14 (Charset  = UTF8 Codepage = 65001)
15156 +
15157 + If music be the food of love, play on;
15158 + Give me excess of it, that, surfeiting,
15159 + The appetite may sicken, and so die.
15160 + That strain again! it had a dying fall:
15161 + O, it came o'er my ear like the sweet south,
15162 + That breathes upon a bank of violets,
15163 + Stealing and giving odour! Enough; no more:
15164 + 'Tis not so sweet now as it was before.
15165 + O spirit of love! how quick and fresh art thou,
15166 + That, notwithstanding thy capacity      10
15167 + Receiveth as the sea, nought enters there,
15168 + Of what validity and pitch soe'er,
15169 + But falls into abatement and low price,
15170 + Even in a minute: so full of shapes is fancy
15171 + That it alone is high fantastical.
15172 +
15173 + Si la musique est la nourriture de l'amour, continuez à jouer;
15174 + Donnez-m'en un excès, que, surexcité,
15175 + L'appétit peut devenir malade et ainsi mourir.
15176 + Cette souche encore! il a eu une chute mourante:
15177 + Oh, ça m'est venu à l'oreille comme le doux sud,
15178 + Qui souffle sur une banque de violettes,
15179 + Voler et donner de l'odeur! Assez; Pas plus:
15180 + «Ce n'est pas si doux maintenant qu'avant.
15181 + O esprit d'amour! comme tu es rapide et fraîche,
15182 + Que, malgré ta capacité 10
15183 + Reçoit comme la mer, rien n'y entre,
15184 + De quelle validité et de quelle hauteur soe'er,
15185 + Mais tombe dans l'abattement et le prix bas,
15186 + Même en une minute: si plein de formes est fantaisie
15187 + Que cela seul est fantastique.
15188 +
15189 +
15190 +
15191 + 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)
15192 +
15193 + GRANTS = NULL
15194 + MYFIELD1 = NULL
15195 + MYFIELD2 = NULL
15196 +
15197 + Row No = 2
15198 + TABLEKEY = 2
15199 + F1 = 2
15200 + F2 = 0.314000010490
15201 + F3 = 0.314123456780
15202 + F4 = 101.314
15203 + F5 = 101.99
15204 + F6 = 25/12/2007
15205 + F7 = 25/12/2007 12:30:29.130
15206 + F8 = XX (Charset = UTF8 Codepage = 65001)
15207 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15208 + F10 = NULL
15209 + F11 = 9223372036854775807
15210 + F12 = 65566
15211 + F13 = 12:30:45.000
15212 + F14 = NULL
15213 + 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)
15214 +
15215 + GRANTS = NULL
15216 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15217 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15218 +
15219 + Rows printed = 2
15220 +
15221 + Delete a record
15222 + Row No = 1
15223 + TABLEKEY = 2
15224 + F1 = 2
15225 + F2 = 0.314000010490
15226 + F3 = 0.314123456780
15227 + F4 = 101.314
15228 + F5 = 101.99
15229 + F6 = 25/12/2007
15230 + F7 = 25/12/2007 12:30:29.130
15231 + F8 = XX (Charset = UTF8 Codepage = 65001)
15232 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15233 + F10 = NULL
15234 + F11 = 9223372036854775807
15235 + F12 = 65566
15236 + F13 = 12:30:45.000
15237 + F14 = NULL
15238 + 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)
15239 +
15240 + GRANTS = NULL
15241 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15242 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15243 +
15244 + Rows printed = 1
15245 +
15246 + Rollback
15247 + Row No = 1
15248 + TABLEKEY = 1
15249 + F1 = 2
15250 + F2 = 0.314000010490
15251 + F3 = 0.314123456780
15252 + F4 = 101.314
15253 + F5 = 101.99
15254 + F6 = 25/12/2007
15255 + F7 = 25/12/2007 12:30:29.130
15256 + F8 = XX (Charset = UTF8 Codepage = 65001)
15257 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15258 + F10 = (blob), Length = 100
15259 + F11 = 9223372036854775807
15260 + F12 = 65566
15261 + F13 = 12:30:45.000
15262 + F14 (Charset  = UTF8 Codepage = 65001)
15263 +
15264 + If music be the food of love, play on;
15265 + Give me excess of it, that, surfeiting,
15266 + The appetite may sicken, and so die.
15267 + That strain again! it had a dying fall:
15268 + O, it came o'er my ear like the sweet south,
15269 + That breathes upon a bank of violets,
15270 + Stealing and giving odour! Enough; no more:
15271 + 'Tis not so sweet now as it was before.
15272 + O spirit of love! how quick and fresh art thou,
15273 + That, notwithstanding thy capacity      10
15274 + Receiveth as the sea, nought enters there,
15275 + Of what validity and pitch soe'er,
15276 + But falls into abatement and low price,
15277 + Even in a minute: so full of shapes is fancy
15278 + That it alone is high fantastical.
15279 +
15280 + Si la musique est la nourriture de l'amour, continuez à jouer;
15281 + Donnez-m'en un excès, que, surexcité,
15282 + L'appétit peut devenir malade et ainsi mourir.
15283 + Cette souche encore! il a eu une chute mourante:
15284 + Oh, ça m'est venu à l'oreille comme le doux sud,
15285 + Qui souffle sur une banque de violettes,
15286 + Voler et donner de l'odeur! Assez; Pas plus:
15287 + «Ce n'est pas si doux maintenant qu'avant.
15288 + O esprit d'amour! comme tu es rapide et fraîche,
15289 + Que, malgré ta capacité 10
15290 + Reçoit comme la mer, rien n'y entre,
15291 + De quelle validité et de quelle hauteur soe'er,
15292 + Mais tombe dans l'abattement et le prix bas,
15293 + Même en une minute: si plein de formes est fantaisie
15294 + Que cela seul est fantastique.
15295 +
15296 +
15297 +
15298 + 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)
15299 +
15300 + GRANTS = NULL
15301 + MYFIELD1 = NULL
15302 + MYFIELD2 = NULL
15303 +
15304 + Row No = 2
15305 + TABLEKEY = 2
15306 + F1 = 2
15307 + F2 = 0.314000010490
15308 + F3 = 0.314123456780
15309 + F4 = 101.314
15310 + F5 = 101.99
15311 + F6 = 25/12/2007
15312 + F7 = 25/12/2007 12:30:29.130
15313 + F8 = XX (Charset = UTF8 Codepage = 65001)
15314 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15315 + F10 = NULL
15316 + F11 = 9223372036854775807
15317 + F12 = 65566
15318 + F13 = 12:30:45.000
15319 + F14 = NULL
15320 + 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)
15321 +
15322 + GRANTS = NULL
15323 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15324 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15325 +
15326 + Rows printed = 2
15327 +
15328 + Commit Retaining
15329 + Row No = 1
15330 + TABLEKEY = 1
15331 + F1 = 2
15332 + F2 = 0.314000010490
15333 + F3 = 0.314123456780
15334 + F4 = 101.314
15335 + F5 = 101.99
15336 + F6 = 25/12/2007
15337 + F7 = 25/12/2007 12:30:29.130
15338 + F8 = XX (Charset = UTF8 Codepage = 65001)
15339 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15340 + F10 = (blob), Length = 100
15341 + F11 = 9223372036854775807
15342 + F12 = 65566
15343 + F13 = 12:30:45.000
15344 + F14 (Charset  = UTF8 Codepage = 65001)
15345 +
15346 + If music be the food of love, play on;
15347 + Give me excess of it, that, surfeiting,
15348 + The appetite may sicken, and so die.
15349 + That strain again! it had a dying fall:
15350 + O, it came o'er my ear like the sweet south,
15351 + That breathes upon a bank of violets,
15352 + Stealing and giving odour! Enough; no more:
15353 + 'Tis not so sweet now as it was before.
15354 + O spirit of love! how quick and fresh art thou,
15355 + That, notwithstanding thy capacity      10
15356 + Receiveth as the sea, nought enters there,
15357 + Of what validity and pitch soe'er,
15358 + But falls into abatement and low price,
15359 + Even in a minute: so full of shapes is fancy
15360 + That it alone is high fantastical.
15361 +
15362 + Si la musique est la nourriture de l'amour, continuez à jouer;
15363 + Donnez-m'en un excès, que, surexcité,
15364 + L'appétit peut devenir malade et ainsi mourir.
15365 + Cette souche encore! il a eu une chute mourante:
15366 + Oh, ça m'est venu à l'oreille comme le doux sud,
15367 + Qui souffle sur une banque de violettes,
15368 + Voler et donner de l'odeur! Assez; Pas plus:
15369 + «Ce n'est pas si doux maintenant qu'avant.
15370 + O esprit d'amour! comme tu es rapide et fraîche,
15371 + Que, malgré ta capacité 10
15372 + Reçoit comme la mer, rien n'y entre,
15373 + De quelle validité et de quelle hauteur soe'er,
15374 + Mais tombe dans l'abattement et le prix bas,
15375 + Même en une minute: si plein de formes est fantaisie
15376 + Que cela seul est fantastique.
15377 +
15378 +
15379 +
15380 + 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)
15381 +
15382 + GRANTS = NULL
15383 + MYFIELD1 = NULL
15384 + MYFIELD2 = NULL
15385 +
15386 + Row No = 2
15387 + TABLEKEY = 2
15388 + F1 = 2
15389 + F2 = 0.314000010490
15390 + F3 = 0.314123456780
15391 + F4 = 101.314
15392 + F5 = 101.99
15393 + F6 = 25/12/2007
15394 + F7 = 25/12/2007 12:30:29.130
15395 + F8 = XX (Charset = UTF8 Codepage = 65001)
15396 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15397 + F10 = NULL
15398 + F11 = 9223372036854775807
15399 + F12 = 65566
15400 + F13 = 12:30:45.000
15401 + F14 = NULL
15402 + 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)
15403 +
15404 + GRANTS = NULL
15405 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15406 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15407 +
15408 + Row No = 3
15409 + TABLEKEY = 3
15410 + F1 = 2
15411 + F2 = 0.314000010490
15412 + F3 = 0.314123456780
15413 + F4 = 101.314
15414 + F5 = 101.99
15415 + F6 = 25/12/2007
15416 + F7 = 25/12/2007 12:30:29.130
15417 + F8 = XX (Charset = UTF8 Codepage = 65001)
15418 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15419 + F10 = (blob), Length = 100
15420 + F11 = 9223372036854775807
15421 + F12 = 65566
15422 + F13 = 12:30:45.000
15423 + F14 (Charset  = UTF8 Codepage = 65001)
15424 +
15425 + If music be the food of love, play on;
15426 + Give me excess of it, that, surfeiting,
15427 + The appetite may sicken, and so die.
15428 + That strain again! it had a dying fall:
15429 + O, it came o'er my ear like the sweet south,
15430 + That breathes upon a bank of violets,
15431 + Stealing and giving odour! Enough; no more:
15432 + 'Tis not so sweet now as it was before.
15433 + O spirit of love! how quick and fresh art thou,
15434 + That, notwithstanding thy capacity      10
15435 + Receiveth as the sea, nought enters there,
15436 + Of what validity and pitch soe'er,
15437 + But falls into abatement and low price,
15438 + Even in a minute: so full of shapes is fancy
15439 + That it alone is high fantastical.
15440 +
15441 + Si la musique est la nourriture de l'amour, continuez à jouer;
15442 + Donnez-m'en un excès, que, surexcité,
15443 + L'appétit peut devenir malade et ainsi mourir.
15444 + Cette souche encore! il a eu une chute mourante:
15445 + Oh, ça m'est venu à l'oreille comme le doux sud,
15446 + Qui souffle sur une banque de violettes,
15447 + Voler et donner de l'odeur! Assez; Pas plus:
15448 + «Ce n'est pas si doux maintenant qu'avant.
15449 + O esprit d'amour! comme tu es rapide et fraîche,
15450 + Que, malgré ta capacité 10
15451 + Reçoit comme la mer, rien n'y entre,
15452 + De quelle validité et de quelle hauteur soe'er,
15453 + Mais tombe dans l'abattement et le prix bas,
15454 + Même en une minute: si plein de formes est fantaisie
15455 + Que cela seul est fantastique.
15456 +
15457 +
15458 +
15459 + 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)
15460 +
15461 + GRANTS = NULL
15462 + MYFIELD1 = NULL
15463 + MYFIELD2 = NULL
15464 +
15465 + Rows printed = 3
15466 +
15467 + Commit
15468 + Row No = 1
15469 + TABLEKEY = 1
15470 + F1 = 2
15471 + F2 = 0.314000010490
15472 + F3 = 0.314123456780
15473 + F4 = 101.314
15474 + F5 = 101.99
15475 + F6 = 25/12/2007
15476 + F7 = 25/12/2007 12:30:29.130
15477 + F8 = XX (Charset = UTF8 Codepage = 65001)
15478 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15479 + F10 = (blob), Length = 100
15480 + F11 = 9223372036854775807
15481 + F12 = 65566
15482 + F13 = 12:30:45.000
15483 + F14 (Charset  = UTF8 Codepage = 65001)
15484 +
15485 + If music be the food of love, play on;
15486 + Give me excess of it, that, surfeiting,
15487 + The appetite may sicken, and so die.
15488 + That strain again! it had a dying fall:
15489 + O, it came o'er my ear like the sweet south,
15490 + That breathes upon a bank of violets,
15491 + Stealing and giving odour! Enough; no more:
15492 + 'Tis not so sweet now as it was before.
15493 + O spirit of love! how quick and fresh art thou,
15494 + That, notwithstanding thy capacity      10
15495 + Receiveth as the sea, nought enters there,
15496 + Of what validity and pitch soe'er,
15497 + But falls into abatement and low price,
15498 + Even in a minute: so full of shapes is fancy
15499 + That it alone is high fantastical.
15500 +
15501 + Si la musique est la nourriture de l'amour, continuez à jouer;
15502 + Donnez-m'en un excès, que, surexcité,
15503 + L'appétit peut devenir malade et ainsi mourir.
15504 + Cette souche encore! il a eu une chute mourante:
15505 + Oh, ça m'est venu à l'oreille comme le doux sud,
15506 + Qui souffle sur une banque de violettes,
15507 + Voler et donner de l'odeur! Assez; Pas plus:
15508 + «Ce n'est pas si doux maintenant qu'avant.
15509 + O esprit d'amour! comme tu es rapide et fraîche,
15510 + Que, malgré ta capacité 10
15511 + Reçoit comme la mer, rien n'y entre,
15512 + De quelle validité et de quelle hauteur soe'er,
15513 + Mais tombe dans l'abattement et le prix bas,
15514 + Même en une minute: si plein de formes est fantaisie
15515 + Que cela seul est fantastique.
15516 +
15517 +
15518 +
15519 + 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)
15520 +
15521 + GRANTS = NULL
15522 + MYFIELD1 = NULL
15523 + MYFIELD2 = NULL
15524 +
15525 + Row No = 2
15526 + TABLEKEY = 2
15527 + F1 = 2
15528 + F2 = 0.314000010490
15529 + F3 = 0.314123456780
15530 + F4 = 101.314
15531 + F5 = 101.99
15532 + F6 = 25/12/2007
15533 + F7 = 25/12/2007 12:30:29.130
15534 + F8 = XX (Charset = UTF8 Codepage = 65001)
15535 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15536 + F10 = NULL
15537 + F11 = 9223372036854775807
15538 + F12 = 65566
15539 + F13 = 12:30:45.000
15540 + F14 = NULL
15541 + 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)
15542 +
15543 + GRANTS = NULL
15544 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
15545 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
15546 +
15547 + Row No = 3
15548 + TABLEKEY = 3
15549 + F1 = 2
15550 + F2 = 0.314000010490
15551 + F3 = 0.314123456780
15552 + F4 = 101.314
15553 + F5 = 101.99
15554 + F6 = 25/12/2007
15555 + F7 = 25/12/2007 12:30:29.130
15556 + F8 = XX (Charset = UTF8 Codepage = 65001)
15557 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
15558 + F10 = (blob), Length = 100
15559 + F11 = 9223372036854775807
15560 + F12 = 65566
15561 + F13 = 12:30:45.000
15562 + F14 (Charset  = UTF8 Codepage = 65001)
15563 +
15564 + If music be the food of love, play on;
15565 + Give me excess of it, that, surfeiting,
15566 + The appetite may sicken, and so die.
15567 + That strain again! it had a dying fall:
15568 + O, it came o'er my ear like the sweet south,
15569 + That breathes upon a bank of violets,
15570 + Stealing and giving odour! Enough; no more:
15571 + 'Tis not so sweet now as it was before.
15572 + O spirit of love! how quick and fresh art thou,
15573 + That, notwithstanding thy capacity      10
15574 + Receiveth as the sea, nought enters there,
15575 + Of what validity and pitch soe'er,
15576 + But falls into abatement and low price,
15577 + Even in a minute: so full of shapes is fancy
15578 + That it alone is high fantastical.
15579 +
15580 + Si la musique est la nourriture de l'amour, continuez à jouer;
15581 + Donnez-m'en un excès, que, surexcité,
15582 + L'appétit peut devenir malade et ainsi mourir.
15583 + Cette souche encore! il a eu une chute mourante:
15584 + Oh, ça m'est venu à l'oreille comme le doux sud,
15585 + Qui souffle sur une banque de violettes,
15586 + Voler et donner de l'odeur! Assez; Pas plus:
15587 + «Ce n'est pas si doux maintenant qu'avant.
15588 + O esprit d'amour! comme tu es rapide et fraîche,
15589 + Que, malgré ta capacité 10
15590 + Reçoit comme la mer, rien n'y entre,
15591 + De quelle validité et de quelle hauteur soe'er,
15592 + Mais tombe dans l'abattement et le prix bas,
15593 + Même en une minute: si plein de formes est fantaisie
15594 + Que cela seul est fantastique.
15595 +
15596 +
15597 +
15598 + 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)
15599 +
15600 + GRANTS = NULL
15601 + MYFIELD1 = NULL
15602 + MYFIELD2 = NULL
15603 +
15604 + Rows printed = 3
15605 +
15606 + Journal Table
15607 + IBX$SESSIONID = 1
15608 + IBX$TRANSACTIONID = 9
15609 + IBX$OLDTRANSACTIONID = NULL
15610 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
15611 + IBX$CREATED = 2021/12/07 10:56:15.3090
15612 + IBX$SESSIONID = 1
15613 + IBX$TRANSACTIONID = 14
15614 + IBX$OLDTRANSACTIONID = NULL
15615 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
15616 + IBX$CREATED = 2021/12/07 10:56:16.4750
15617 + IBX$SESSIONID = 1
15618 + IBX$TRANSACTIONID = 16
15619 + IBX$OLDTRANSACTIONID = 14
15620 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
15621 + IBX$CREATED = 2021/12/07 10:56:16.8800
15622 + Journal Entries
15623 + Journal Entry = jeTransStart(Transaction Start)
15624 + Timestamp = 2021/12/07 10:56:15.3360
15625 + Session ID = 1
15626 + Transaction ID = 9
15627 + Transaction Name = "{A1789F69-9F0A-4D27-A725-971FFF2303F6}"
15628 + TPB: Item Count = 3
15629 +  isc_tpb_concurrency
15630 +  isc_tpb_wait
15631 +  isc_tpb_write
15632 +
15633 + Default Completion = TACommit
15634 +
15635 + Journal Entry = jeQuery(Query)
15636 + Timestamp = 2021/12/07 10:56:15.5020
15637 + Session ID = 1
15638 + Transaction ID = 9
15639 + Query = Insert Into IBXTEST(TABLEKEY, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, f12, F13, F14, MyArray,  GRANTS) Values(1, 2, 0.314, 0.31412345678, 101.314, 101.99, '25/12/2007 12:30:15.0000', '25/12/2007 12:30:29.1300','XX', 'The Quick Brown Fox jumps over the lazy dog', <blob subtype="0">
15640 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
15641 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
15642 + 01000000010000001A01050001000000DA000000
15643 + </blob>
15644 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
15645 + Give me excess of it, that, surfeiting,
15646 + The appetite may sicken, and so die.
15647 + That strain again! it had a dying fall:
15648 + O, it came o''er my ear like the sweet south,
15649 + That breathes upon a bank of violets,
15650 + Stealing and giving odour! Enough; no more:
15651 + ''Tis not so sweet now as it was before.
15652 + O spirit of love! how quick and fresh art thou,
15653 + That, notwithstanding thy capacity      10
15654 + Receiveth as the sea, nought enters there,
15655 + Of what validity and pitch soe''er,
15656 + But falls into abatement and low price,
15657 + Even in a minute: so full of shapes is fancy
15658 + That it alone is high fantastical.
15659 +
15660 + Si la musique est la nourriture de l''amour, continuez à jouer;
15661 + Donnez-m''en un excès, que, surexcité,
15662 + L''appétit peut devenir malade et ainsi mourir.
15663 + Cette souche encore! il a eu une chute mourante:
15664 + Oh, ça m''est venu à l''oreille comme le doux sud,
15665 + Qui souffle sur une banque de violettes,
15666 + Voler et donner de l''odeur! Assez; Pas plus:
15667 + «Ce n''est pas si doux maintenant qu''avant.
15668 + O esprit d''amour! comme tu es rapide et fraîche,
15669 + Que, malgré ta capacité 10
15670 + Reçoit comme la mer, rien n''y entre,
15671 + De quelle validité et de quelle hauteur soe''er,
15672 + Mais tombe dans l''abattement et le prix bas,
15673 + Même en une minute: si plein de formes est fantaisie
15674 + Que cela seul est fantastique.
15675 +
15676 +
15677 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
15678 + <elt ix="0">100</elt>
15679 + <elt ix="1">99</elt>
15680 + <elt ix="2">98</elt>
15681 + <elt ix="3">97</elt>
15682 + <elt ix="4">96</elt>
15683 + <elt ix="5">95</elt>
15684 + <elt ix="6">94</elt>
15685 + <elt ix="7">93</elt>
15686 + <elt ix="8">92</elt>
15687 + <elt ix="9">91</elt>
15688 + <elt ix="10">90</elt>
15689 + <elt ix="11">89</elt>
15690 + <elt ix="12">88</elt>
15691 + <elt ix="13">87</elt>
15692 + <elt ix="14">86</elt>
15693 + <elt ix="15">85</elt>
15694 + <elt ix="16">84</elt>
15695 + </array>
15696 + , NULL) Returning MyArray
15697 +
15698 + Journal Entry = jeQuery(Query)
15699 + Timestamp = 2021/12/07 10:56:15.5160
15700 + Session ID = 1
15701 + Transaction ID = 9
15702 + Query = Insert Into IBXTEST(TABLEKEY, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, f12, F13, F14, MyArray,  GRANTS) Values(2, 2, 0.314, 0.31412345678, 101.314, 101.99, '25/12/2007 12:30:15.0000', '25/12/2007 12:30:29.1300','XX', 'The Quick Brown Fox jumps over the lazy dog', <blob subtype="0">
15703 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
15704 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
15705 + 01000000010000001A01050001000000DA000000
15706 + </blob>
15707 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
15708 + Give me excess of it, that, surfeiting,
15709 + The appetite may sicken, and so die.
15710 + That strain again! it had a dying fall:
15711 + O, it came o''er my ear like the sweet south,
15712 + That breathes upon a bank of violets,
15713 + Stealing and giving odour! Enough; no more:
15714 + ''Tis not so sweet now as it was before.
15715 + O spirit of love! how quick and fresh art thou,
15716 + That, notwithstanding thy capacity      10
15717 + Receiveth as the sea, nought enters there,
15718 + Of what validity and pitch soe''er,
15719 + But falls into abatement and low price,
15720 + Even in a minute: so full of shapes is fancy
15721 + That it alone is high fantastical.
15722 +
15723 + Si la musique est la nourriture de l''amour, continuez à jouer;
15724 + Donnez-m''en un excès, que, surexcité,
15725 + L''appétit peut devenir malade et ainsi mourir.
15726 + Cette souche encore! il a eu une chute mourante:
15727 + Oh, ça m''est venu à l''oreille comme le doux sud,
15728 + Qui souffle sur une banque de violettes,
15729 + Voler et donner de l''odeur! Assez; Pas plus:
15730 + «Ce n''est pas si doux maintenant qu''avant.
15731 + O esprit d''amour! comme tu es rapide et fraîche,
15732 + Que, malgré ta capacité 10
15733 + Reçoit comme la mer, rien n''y entre,
15734 + De quelle validité et de quelle hauteur soe''er,
15735 + Mais tombe dans l''abattement et le prix bas,
15736 + Même en une minute: si plein de formes est fantaisie
15737 + Que cela seul est fantastique.
15738 +
15739 +
15740 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
15741 + <elt ix="0">100</elt>
15742 + <elt ix="1">99</elt>
15743 + <elt ix="2">98</elt>
15744 + <elt ix="3">97</elt>
15745 + <elt ix="4">96</elt>
15746 + <elt ix="5">95</elt>
15747 + <elt ix="6">94</elt>
15748 + <elt ix="7">93</elt>
15749 + <elt ix="8">92</elt>
15750 + <elt ix="9">91</elt>
15751 + <elt ix="10">90</elt>
15752 + <elt ix="11">89</elt>
15753 + <elt ix="12">88</elt>
15754 + <elt ix="13">87</elt>
15755 + <elt ix="14">86</elt>
15756 + <elt ix="15">85</elt>
15757 + <elt ix="16">84</elt>
15758 + </array>
15759 + , NULL) Returning MyArray
15760 +
15761 + Journal Entry = jeQuery(Query)
15762 + Timestamp = 2021/12/07 10:56:15.5220
15763 + Session ID = 1
15764 + Transaction ID = 9
15765 + Query = Update IBXTEST A Set   A.F1 = 2,  A.F2 = 0.314,  A.F3 = 0.31412345678,  A.F4 = 101.314,  A.F5 = 101.99,  A.F6 = '25/12/2007 12:30:15.0000',  A.F7 = '25/12/2007 12:30:29.1300',  A.F8 = 'XX',  A.F9 = 'The Quick Brown Fox jumps over the lazy dog',  A.F10 = NULL,  A.F11 = 9223372036854775807,  A.f12 = 65566,  A.F13 = '26/12/2007 12:30:45.0000',  A.F14 = NULL,  A.MyArray = <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
15766 + <elt ix="0">100</elt>
15767 + <elt ix="1">99</elt>
15768 + <elt ix="2">98</elt>
15769 + <elt ix="3">97</elt>
15770 + <elt ix="4">96</elt>
15771 + <elt ix="5">95</elt>
15772 + <elt ix="6">94</elt>
15773 + <elt ix="7">93</elt>
15774 + <elt ix="8">92</elt>
15775 + <elt ix="9">91</elt>
15776 + <elt ix="10">90</elt>
15777 + <elt ix="11">89</elt>
15778 + <elt ix="12">88</elt>
15779 + <elt ix="13">87</elt>
15780 + <elt ix="14">86</elt>
15781 + <elt ix="15">85</elt>
15782 + <elt ix="16">84</elt>
15783 + </array>
15784 + ,   A.My Field  = 'My Field',  A.MY Field = 'MY Field',  A.GRANTS = NULL Where A.TABLEKEY = 2 RETURNING A.MyArray
15785 +
15786 + Journal Entry = jeTransCommit(Commit)
15787 + Timestamp = 2021/12/07 10:56:15.5920
15788 + Session ID = 1
15789 + Transaction ID = 9
15790 +
15791 + Journal Entry = jeTransStart(Transaction Start)
15792 + Timestamp = 2021/12/07 10:56:15.6010
15793 + Session ID = 1
15794 + Transaction ID = 11
15795 + Transaction Name = "{A1789F69-9F0A-4D27-A725-971FFF2303F6}"
15796 + TPB: Item Count = 3
15797 +  isc_tpb_concurrency
15798 +  isc_tpb_wait
15799 +  isc_tpb_write
15800 +
15801 + Default Completion = TACommit
15802 +
15803 + Journal Entry = jeQuery(Query)
15804 + Timestamp = 2021/12/07 10:56:15.8730
15805 + Session ID = 1
15806 + Transaction ID = 11
15807 + Query = Delete From IBXTEST A Where A.TABLEKEY = 1
15808 +
15809 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
15810 + Timestamp = 2021/12/07 10:56:16.0400
15811 + Session ID = 1
15812 + Transaction ID = 13
15813 + Old TransactionID = 11
15814 +
15815 + Journal Entry = jeQuery(Query)
15816 + Timestamp = 2021/12/07 10:56:16.2670
15817 + Session ID = 1
15818 + Transaction ID = 13
15819 + Query = Delete From IBXTEST A Where A.TABLEKEY = 1
15820 +
15821 + Journal Entry = jeTransRollback(Rollback)
15822 + Timestamp = 2021/12/07 10:56:16.4340
15823 + Session ID = 1
15824 + Transaction ID = 13
15825 +
15826 + Journal Entry = jeTransStart(Transaction Start)
15827 + Timestamp = 2021/12/07 10:56:16.4760
15828 + Session ID = 1
15829 + Transaction ID = 14
15830 + Transaction Name = "{A1789F69-9F0A-4D27-A725-971FFF2303F6}"
15831 + TPB: Item Count = 3
15832 +  isc_tpb_concurrency
15833 +  isc_tpb_wait
15834 +  isc_tpb_write
15835 +
15836 + Default Completion = TACommit
15837 +
15838 + Journal Entry = jeQuery(Query)
15839 + Timestamp = 2021/12/07 10:56:16.7700
15840 + Session ID = 1
15841 + Transaction ID = 14
15842 + Query = Insert Into IBXTEST(TABLEKEY, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, f12, F13, F14, MyArray,  GRANTS) Values(3, 2, 0.314, 0.31412345678, 101.314, 101.99, '25/12/2007 12:30:15.0000', '25/12/2007 12:30:29.1300','XX', 'The Quick Brown Fox jumps over the lazy dog', <blob subtype="0">
15843 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
15844 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
15845 + 01000000010000001A01050001000000DA000000
15846 + </blob>
15847 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
15848 + Give me excess of it, that, surfeiting,
15849 + The appetite may sicken, and so die.
15850 + That strain again! it had a dying fall:
15851 + O, it came o''er my ear like the sweet south,
15852 + That breathes upon a bank of violets,
15853 + Stealing and giving odour! Enough; no more:
15854 + ''Tis not so sweet now as it was before.
15855 + O spirit of love! how quick and fresh art thou,
15856 + That, notwithstanding thy capacity      10
15857 + Receiveth as the sea, nought enters there,
15858 + Of what validity and pitch soe''er,
15859 + But falls into abatement and low price,
15860 + Even in a minute: so full of shapes is fancy
15861 + That it alone is high fantastical.
15862 +
15863 + Si la musique est la nourriture de l''amour, continuez à jouer;
15864 + Donnez-m''en un excès, que, surexcité,
15865 + L''appétit peut devenir malade et ainsi mourir.
15866 + Cette souche encore! il a eu une chute mourante:
15867 + Oh, ça m''est venu à l''oreille comme le doux sud,
15868 + Qui souffle sur une banque de violettes,
15869 + Voler et donner de l''odeur! Assez; Pas plus:
15870 + «Ce n''est pas si doux maintenant qu''avant.
15871 + O esprit d''amour! comme tu es rapide et fraîche,
15872 + Que, malgré ta capacité 10
15873 + Reçoit comme la mer, rien n''y entre,
15874 + De quelle validité et de quelle hauteur soe''er,
15875 + Mais tombe dans l''abattement et le prix bas,
15876 + Même en une minute: si plein de formes est fantaisie
15877 + Que cela seul est fantastique.
15878 +
15879 +
15880 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
15881 + <elt ix="0">100</elt>
15882 + <elt ix="1">99</elt>
15883 + <elt ix="2">98</elt>
15884 + <elt ix="3">97</elt>
15885 + <elt ix="4">96</elt>
15886 + <elt ix="5">95</elt>
15887 + <elt ix="6">94</elt>
15888 + <elt ix="7">93</elt>
15889 + <elt ix="8">92</elt>
15890 + <elt ix="9">91</elt>
15891 + <elt ix="10">90</elt>
15892 + <elt ix="11">89</elt>
15893 + <elt ix="12">88</elt>
15894 + <elt ix="13">87</elt>
15895 + <elt ix="14">86</elt>
15896 + <elt ix="15">85</elt>
15897 + <elt ix="16">84</elt>
15898 + </array>
15899 + , NULL) Returning MyArray
15900 +
15901 + Journal Entry = jeTransCommitRet(Commit Retaining)
15902 + Timestamp = 2021/12/07 10:56:16.8760
15903 + Session ID = 1
15904 + Transaction ID = 16
15905 + Old TransactionID = 14
15906 +
15907 + Journal Entry = jeTransCommit(Commit)
15908 + Timestamp = 2021/12/07 10:56:17.2500
15909 + Session ID = 1
15910 + Transaction ID = 16
15911 +
15912 + Journal Entry = jeTransStart(Transaction Start)
15913 + Timestamp = 2021/12/07 10:56:17.2830
15914 + Session ID = 1
15915 + Transaction ID = 17
15916 + Transaction Name = "{A1789F69-9F0A-4D27-A725-971FFF2303F6}"
15917 + TPB: Item Count = 3
15918 +  isc_tpb_concurrency
15919 +  isc_tpb_wait
15920 +  isc_tpb_write
15921 +
15922 + Default Completion = TACommit
15923 +
15924 + Journal Entry = jeTransRollback(Rollback)
15925 + Timestamp = 2021/12/07 10:56:17.7250
15926 + Session ID = 1
15927 + Transaction ID = 17
15928 +
15929 +
15930 +
15931   ------------------------------------------------------
15932   Test Suite Ends

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines