--- ibx/branches/journaling/testsuite/FB4reference.log 2021/12/07 13:27:39 362
+++ ibx/branches/journaling/testsuite/FB4reference.log 2021/12/07 13:30:05 363
@@ -641,11 +641,11 @@ DEPT_KEY_PATH = 000;900 (Charset = UTF8
Rows printed = 42
-Current memory = 19,687,232
+Current memory = 19,689,072
Delta memory = 16,384
-Max memory = 19,781,872
-Elapsed time= 0.027 sec
-Cpu = 0.020 sec
+Max memory = 19,783,712
+Elapsed time= 0.021 sec
+Cpu = 0.010 sec
Buffers = 2048
Reads = 2
Writes = 0
@@ -1445,7 +1445,7 @@ DPB: Item Count = 3
isc_dpb_lc_ctype = UTF8
Before Disconnect
-inet://localhost/employee Disconnected after 34 ms
+inet://localhost/employee Disconnected after 32 ms
Before Connect
Connected to inet://localhost/employee
DPB: Item Count = 3
@@ -1454,7 +1454,7 @@ DPB: Item Count = 3
isc_dpb_lc_ctype = UTF8
Before Disconnect
-inet://localhost/employee Disconnected after 4041 ms
+inet://localhost/employee Disconnected after 4066 ms
Idle Timer Expired for Test_Database_02
Database Closed
Transaction Events
@@ -1491,10 +1491,10 @@ TPB: Item Count = 3
isc_tpb_read
Transaction Ending
-Transaction Ended after 2000 ms
+Transaction Ended after 2001 ms
Idle Timer Expired for Test_Transaction_02
Before Disconnect
-inet://localhost/employee Disconnected after 2047 ms
+inet://localhost/employee Disconnected after 2045 ms
SQL Dialect Downgrade test
Before Connect
Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
@@ -1506,7 +1506,7 @@ DPB: Item Count = 4
inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created
Before Disconnect
-inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 25 ms
+inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 20 ms
Before Connect
Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
@@ -1516,7 +1516,7 @@ DPB: Item Count = 3
isc_dpb_lc_ctype = UTF8
Before Disconnect
-inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms
+inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 16 ms
------------------------------------------------------
@@ -1543,18 +1543,18 @@ ODS Minor Version = 0
ODS Major Version = 13
Page Size = 8192
Version = LI-V6.3.0.2496 Firebird 4.0
-Current Memory = 19501920
+Current Memory = 19503760
Forced Writes Enabled
-Max Memory = 19628528
+Max Memory = 19630368
Number of Buffers = 2048
Sweep Interval = 20000
User Names: SYSDBA
-Fetches = 1847
+Fetches = 1860
Marks = 8
Reads = 100
Writes = 2
-Pages Free = 310
-Pages Used = 765
+Pages Free = 313
+Pages Used = 762
Transaction Count = 1
Read Idx Count
@@ -1565,16 +1565,16 @@ Read Idx Count
RDB$SECURITY_CLASSES = 8
RDB$TYPES = 2
RDB$TRIGGERS = 25
- RDB$USER_PRIVILEGES = 811
+ RDB$USER_PRIVILEGES = 821
RDB$GENERATORS = 5
RDB$CHARACTER_SETS = 2
RDB$COLLATIONS = 2
RDB$ROLES = 1
Read Seq Count
- RDB$PAGES = 98
+ RDB$PAGES = 100
RDB$DATABASE = 25
- RDB$RELATIONS = 65
+ RDB$RELATIONS = 66
Database is Read/Write
Hex Dump of Database Page 100:
@@ -3297,10 +3297,10 @@ SALARY = 32,000.00
FULL_NAME = Guckenheimer, Mark
DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance (Charset Id = 4 Codepage = 65001)
DEPT_KEY_PATH = 000;600;620;622 (Charset Id = 4 Codepage = 65001)
-Current memory = 19,667,952
+Current memory = 19,669,792
Delta memory = 16,416
-Max memory = 19,763,360
-Elapsed time= 0.026 sec
+Max memory = 19,765,200
+Elapsed time= 0.023 sec
Cpu = 0.010 sec
Buffers = 2048
Reads = 2
@@ -3557,69 +3557,7 @@ JOB_COUNTRY = USA
SALARY = 105,900.00
FULL_NAME = Nelson, Robert
Do Fetch Last:
-EMP_NO = 145
-FIRST_NAME = Mark
-LAST_NAME = Guckenheimer
-PHONE_EXT = 221
-HIRE_DATE = 1994/05/02 00:00:00.0000
-DEPT_NO = 622
-JOB_CODE = Eng
-JOB_GRADE = 5
-JOB_COUNTRY = USA
-SALARY = 32,000.00
-FULL_NAME = Guckenheimer, Mark
-Do Fetch Prior:
-EMP_NO = 144
-FIRST_NAME = John
-LAST_NAME = Montgomery
-PHONE_EXT = 820
-HIRE_DATE = 1994/03/30 00:00:00.0000
-DEPT_NO = 672
-JOB_CODE = Eng
-JOB_GRADE = 5
-JOB_COUNTRY = USA
-SALARY = 35,000.00
-FULL_NAME = Montgomery, John
-Do Fetch First:
-EMP_NO = 2
-FIRST_NAME = Robert
-LAST_NAME = Nelson
-PHONE_EXT = 250
-HIRE_DATE = 1988/12/28 00:00:00.0000
-DEPT_NO = 600
-JOB_CODE = VP
-JOB_GRADE = 2
-JOB_COUNTRY = USA
-SALARY = 105,900.00
-FULL_NAME = Nelson, Robert
-Do Fetch Abs 8 :
-EMP_NO = 14
-FIRST_NAME = Stewart
-LAST_NAME = Hall
-PHONE_EXT = 227
-HIRE_DATE = 1990/06/04 00:00:00.0000
-DEPT_NO = 900
-JOB_CODE = Finan
-JOB_GRADE = 3
-JOB_COUNTRY = USA
-SALARY = 69,482.63
-FULL_NAME = Hall, Stewart
-Do Fetch Relative -2 :
-EMP_NO = 11
-FIRST_NAME = K. J.
-LAST_NAME = Weston
-PHONE_EXT = 34
-HIRE_DATE = 1990/01/17 00:00:00.0000
-DEPT_NO = 130
-JOB_CODE = SRep
-JOB_GRADE = 4
-JOB_COUNTRY = USA
-SALARY = 86,292.94
-FULL_NAME = Weston, K. J.
-Do Fetch beyond EOF :
-Fetch returned false
-
-
+Test Completed with Error: feature is not supported
------------------------------------------------------
Running Test 08: TIBDataset: Locate, Bookmark and Lookup
Field No 1 Name = EMP_NO DataType = ftSmallint
@@ -4066,6 +4004,17 @@ CREATE TABLE EMPLOYEE_PROJECT
PRIMARY KEY (EMP_NO, PROJ_ID)
);
+/* Table: IBX$JOURNALS, Owner: SYSDBA */
+
+CREATE TABLE IBX$JOURNALS
+(
+ IBX$SESSIONID INTEGER NOT NULL,
+ IBX$TRANSACTIONID INTEGER NOT NULL,
+ IBX$USER VARCHAR(32) Default CURRENT_USER,
+ IBX$TIMESTAMP TIMESTAMP Default CURRENT_TIMESTAMP,
+PRIMARY KEY (IBX$SESSIONID, IBX$TRANSACTIONID)
+);
+
/* Table: JOB, Owner: SYSDBA */
CREATE TABLE JOB
@@ -4170,6 +4119,7 @@ ALTER TABLE SALES ADD FOREIGN KEY (SALES
CREATE SEQUENCE CUST_NO_GEN;
CREATE SEQUENCE EMP_NO_GEN;
+CREATE SEQUENCE IBX$SESSIONS;
/* View: PHONE_LIST, Owner: SYSDBA */
@@ -12103,20 +12053,20 @@ Message File Location = /opt/firebird4.0
Database Statistics for employee
Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb"
-Gstat execution time Sat Oct 23 14:18:37 2021
+Gstat execution time Tue Dec 7 11:05:53 2021
Database header page information:
Flags 0
-Generation 4690
+Generation 5921
System Change Number 0
Page size 8192
ODS version 13.0
-Oldest transaction 5176
-Oldest active 5177
-Oldest snapshot 5177
-Next transaction 5177
+Oldest transaction 6680
+Oldest active 6681
+Oldest snapshot 6681
+Next transaction 6681
Sequence number 0
-Next attachment ID 4103
+Next attachment ID 5102
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
@@ -12199,6 +12149,19 @@ Fill distribution:
60 - 79% = 0
80 - 99% = 0
+IBX$JOURNALS (141)
+Primary pointer page: 285, Index root page: 311
+Pointer pages: 1, data page slots: 0
+Data pages: 0, average fill: 0%
+Primary pages: 0, secondary pages: 0, swept pages: 0
+Empty pages: 0, full pages: 0
+Fill distribution:
+0 - 19% = 0
+20 - 39% = 0
+40 - 59% = 0
+60 - 79% = 0
+80 - 99% = 0
+
JOB (129)
Primary pointer page: 229, Index root page: 230
Pointer pages: 1, data page slots: 2
@@ -12264,7 +12227,7 @@ Fill distribution:
60 - 79% = 0
80 - 99% = 0
-Gstat completion time Sat Oct 23 14:18:37 2021
+Gstat completion time Tue Dec 7 11:05:53 2021
@@ -12274,87 +12237,92 @@ zeus Wed Jun 9 10:07:18 2021
firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird
Online Validation
-14:18:37.67 Validation started
+11:05:54.35 Validation started
-14:18:37.67 Relation 128 (COUNTRY)
-14:18:37.67 process pointer page 0 of 1
-14:18:37.67 Index 1 (RDB$PRIMARY1)
-14:18:37.67 Relation 128 (COUNTRY) is ok
-
-14:18:37.67 Relation 129 (JOB)
-14:18:37.67 process pointer page 0 of 1
-14:18:37.67 Index 1 (RDB$PRIMARY2)
-14:18:37.67 Index 2 (RDB$FOREIGN3)
-14:18:37.67 Index 3 (MAXSALX)
-14:18:37.67 Index 4 (MINSALX)
-14:18:37.67 Relation 129 (JOB) is ok
-
-14:18:37.67 Relation 130 (DEPARTMENT)
-14:18:37.67 process pointer page 0 of 1
-14:18:37.67 Index 1 (RDB$4)
-14:18:37.67 Index 2 (RDB$PRIMARY5)
-14:18:37.67 Index 3 (RDB$FOREIGN6)
-14:18:37.67 Index 4 (BUDGETX)
-14:18:37.67 Index 5 (RDB$FOREIGN10)
-14:18:37.67 Relation 130 (DEPARTMENT) is ok
-
-14:18:37.67 Relation 131 (EMPLOYEE)
-14:18:37.67 process pointer page 0 of 1
-14:18:37.67 Index 1 (RDB$PRIMARY7)
-14:18:37.67 Index 2 (RDB$FOREIGN8)
-14:18:37.67 Index 3 (RDB$FOREIGN9)
-14:18:37.67 Index 4 (NAMEX)
-14:18:37.67 Relation 131 (EMPLOYEE) is ok
-
-14:18:37.67 Relation 133 (PROJECT)
-14:18:37.67 process pointer page 0 of 1
-14:18:37.67 Index 1 (RDB$11)
-14:18:37.67 Index 2 (RDB$PRIMARY12)
-14:18:37.67 Index 3 (RDB$FOREIGN13)
-14:18:37.68 Index 4 (PRODTYPEX)
-14:18:37.68 Relation 133 (PROJECT) is ok
-
-14:18:37.68 Relation 134 (EMPLOYEE_PROJECT)
-14:18:37.68 process pointer page 0 of 1
-14:18:37.68 Index 1 (RDB$PRIMARY14)
-14:18:37.68 Index 2 (RDB$FOREIGN15)
-14:18:37.68 Index 3 (RDB$FOREIGN16)
-14:18:37.68 Relation 134 (EMPLOYEE_PROJECT) is ok
-
-14:18:37.68 Relation 135 (PROJ_DEPT_BUDGET)
-14:18:37.68 process pointer page 0 of 1
-14:18:37.68 Index 1 (RDB$PRIMARY17)
-14:18:37.68 Index 2 (RDB$FOREIGN18)
-14:18:37.68 Index 3 (RDB$FOREIGN19)
-14:18:37.68 Relation 135 (PROJ_DEPT_BUDGET) is ok
-
-14:18:37.68 Relation 136 (SALARY_HISTORY)
-14:18:37.68 process pointer page 0 of 1
-14:18:37.68 Index 1 (RDB$PRIMARY20)
-14:18:37.68 Index 2 (RDB$FOREIGN21)
-14:18:37.68 Index 3 (CHANGEX)
-14:18:37.69 Index 4 (UPDATERX)
-14:18:37.69 Relation 136 (SALARY_HISTORY) is ok
-
-14:18:37.69 Relation 137 (CUSTOMER)
-14:18:37.69 process pointer page 0 of 1
-14:18:37.69 Index 1 (RDB$PRIMARY22)
-14:18:37.69 Index 2 (RDB$FOREIGN23)
-14:18:37.69 Index 3 (CUSTNAMEX)
-14:18:37.69 Index 4 (CUSTREGION)
-14:18:37.69 Relation 137 (CUSTOMER) is ok
-
-14:18:37.69 Relation 138 (SALES)
-14:18:37.69 process pointer page 0 of 1
-14:18:37.69 Index 1 (RDB$PRIMARY24)
-14:18:37.69 Index 2 (RDB$FOREIGN25)
-14:18:37.69 Index 3 (RDB$FOREIGN26)
-14:18:37.69 Index 4 (NEEDX)
-14:18:37.69 Index 5 (QTYX)
-14:18:37.69 Index 6 (SALESTATX)
-14:18:37.69 Relation 138 (SALES) is ok
+11:05:54.35 Relation 128 (COUNTRY)
+11:05:54.35 process pointer page 0 of 1
+11:05:54.35 Index 1 (RDB$PRIMARY1)
+11:05:54.35 Relation 128 (COUNTRY) is ok
+
+11:05:54.35 Relation 129 (JOB)
+11:05:54.35 process pointer page 0 of 1
+11:05:54.35 Index 1 (RDB$PRIMARY2)
+11:05:54.35 Index 2 (RDB$FOREIGN3)
+11:05:54.35 Index 3 (MAXSALX)
+11:05:54.35 Index 4 (MINSALX)
+11:05:54.35 Relation 129 (JOB) is ok
+
+11:05:54.35 Relation 130 (DEPARTMENT)
+11:05:54.35 process pointer page 0 of 1
+11:05:54.35 Index 1 (RDB$4)
+11:05:54.35 Index 2 (RDB$PRIMARY5)
+11:05:54.35 Index 3 (RDB$FOREIGN6)
+11:05:54.35 Index 4 (BUDGETX)
+11:05:54.35 Index 5 (RDB$FOREIGN10)
+11:05:54.35 Relation 130 (DEPARTMENT) is ok
+
+11:05:54.35 Relation 131 (EMPLOYEE)
+11:05:54.35 process pointer page 0 of 1
+11:05:54.35 Index 1 (RDB$PRIMARY7)
+11:05:54.35 Index 2 (RDB$FOREIGN8)
+11:05:54.35 Index 3 (RDB$FOREIGN9)
+11:05:54.35 Index 4 (NAMEX)
+11:05:54.35 Relation 131 (EMPLOYEE) is ok
+
+11:05:54.35 Relation 133 (PROJECT)
+11:05:54.35 process pointer page 0 of 1
+11:05:54.35 Index 1 (RDB$11)
+11:05:54.35 Index 2 (RDB$PRIMARY12)
+11:05:54.35 Index 3 (RDB$FOREIGN13)
+11:05:54.36 Index 4 (PRODTYPEX)
+11:05:54.36 Relation 133 (PROJECT) is ok
+
+11:05:54.36 Relation 134 (EMPLOYEE_PROJECT)
+11:05:54.36 process pointer page 0 of 1
+11:05:54.36 Index 1 (RDB$PRIMARY14)
+11:05:54.36 Index 2 (RDB$FOREIGN15)
+11:05:54.36 Index 3 (RDB$FOREIGN16)
+11:05:54.36 Relation 134 (EMPLOYEE_PROJECT) is ok
+
+11:05:54.36 Relation 135 (PROJ_DEPT_BUDGET)
+11:05:54.36 process pointer page 0 of 1
+11:05:54.36 Index 1 (RDB$PRIMARY17)
+11:05:54.36 Index 2 (RDB$FOREIGN18)
+11:05:54.36 Index 3 (RDB$FOREIGN19)
+11:05:54.36 Relation 135 (PROJ_DEPT_BUDGET) is ok
+
+11:05:54.36 Relation 136 (SALARY_HISTORY)
+11:05:54.36 process pointer page 0 of 1
+11:05:54.36 Index 1 (RDB$PRIMARY20)
+11:05:54.36 Index 2 (RDB$FOREIGN21)
+11:05:54.36 Index 3 (CHANGEX)
+11:05:54.39 Index 4 (UPDATERX)
+11:05:54.39 Relation 136 (SALARY_HISTORY) is ok
+
+11:05:54.39 Relation 137 (CUSTOMER)
+11:05:54.39 process pointer page 0 of 1
+11:05:54.39 Index 1 (RDB$PRIMARY22)
+11:05:54.39 Index 2 (RDB$FOREIGN23)
+11:05:54.39 Index 3 (CUSTNAMEX)
+11:05:54.39 Index 4 (CUSTREGION)
+11:05:54.40 Relation 137 (CUSTOMER) is ok
+
+11:05:54.40 Relation 138 (SALES)
+11:05:54.40 process pointer page 0 of 1
+11:05:54.41 Index 1 (RDB$PRIMARY24)
+11:05:54.41 Index 2 (RDB$FOREIGN25)
+11:05:54.41 Index 3 (RDB$FOREIGN26)
+11:05:54.41 Index 4 (NEEDX)
+11:05:54.41 Index 5 (QTYX)
+11:05:54.41 Index 6 (SALESTATX)
+11:05:54.41 Relation 138 (SALES) is ok
+
+11:05:54.41 Relation 141 (IBX$JOURNALS)
+11:05:54.41 process pointer page 0 of 1
+11:05:54.41 Index 1 (RDB$PRIMARY29)
+11:05:54.41 Relation 141 (IBX$JOURNALS) is ok
-14:18:37.69 Validation finished
+11:05:54.41 Validation finished
Normal Validation
@@ -12490,7 +12458,7 @@ Employee Database is Online = FALSE
Employee Database is Online = TRUE
Starting Backup
-Backup Completed - File Size = 80384 bytes
+Backup Completed - File Size = 81920 bytes
Restore Started
Restore Completed
@@ -13639,11 +13607,11 @@ DEPT_KEY_PATH = 000 (Charset = UTF8 Code
Rows printed = 2
-Current memory = 19,666,176
+Current memory = 19,668,016
Delta memory = 16,032
-Max memory = 19,761,504
-Elapsed time= 0.002 sec
-Cpu = 0.010 sec
+Max memory = 19,763,344
+Elapsed time= 0.003 sec
+Cpu = 0.000 sec
Buffers = 2048
Reads = 2
Writes = 0
@@ -13907,11 +13875,11 @@ DEPT_KEY_PATH = 000 (Charset = UTF8 Code
Rows printed = 2
-Current memory = 19,666,176
+Current memory = 19,668,016
Delta memory = 16,032
-Max memory = 19,761,504
-Elapsed time= 0.102 sec
-Cpu = 0.000 sec
+Max memory = 19,763,344
+Elapsed time= 0.103 sec
+Cpu = 0.010 sec
Buffers = 2048
Reads = 2
Writes = 0
@@ -15528,14 +15496,14 @@ Create Table LotsOfData (
MyText VarChar(1024),
Primary Key (RowID)
);
-Loading data into database table. Started at 23/10/2021 14:19:28.924
-Data load completed at 23/10/2021 14:21:13.893 Elapsed Time = 104969 ms, 100000 records loaded
- Message Hash = 436daf51ddd32626a439935108ea69c8
-Database Read started at 23/10/2021 14:21:13.906
-Read Dataset completed at 23/10/2021 14:21:44.043 Elapsed Time = 30137 ms, 100000 records read
- Message Hash = 436daf51ddd32626a439935108ea69c8
+Loading data into database table. Started at 07/12/2021 11:06:44.478
+Data load completed at 07/12/2021 11:08:48.103 Elapsed Time = 123625 ms, 100000 records loaded
+ Message Hash = f284b45f0183162d3078ab502d908ae1
+Database Read started at 07/12/2021 11:08:48.114
+Read Dataset completed at 07/12/2021 11:09:18.751 Elapsed Time = 30637 ms, 100000 records read
+ Message Hash = f284b45f0183162d3078ab502d908ae1
Test Completed successfully
-23/10/2021 14:21:44.043 Test 21 passes as long as the checksums are identical
+07/12/2021 11:09:18.751 Test 21 passes as long as the checksums are identical
------------------------------------------------------
@@ -15570,7 +15538,7 @@ SEC$MIDDLE_NAME = NULL
SEC$LAST_NAME = Tester (Charset = UTF8 Codepage = 65001)
SEC$PASSWORD = NULL
LOGGEDIN = False
-DBCREATOR = True
+DBCREATOR = False
Row No = 2
SEC$DESCRIPTION = NULL
@@ -17615,5 +17583,933 @@ SET TERM ;^
+------------------------------------------------------
+Running Test 29: IBJournal Tests
+Creating Database from resources/Test29.sql
+
+Create Table IBXTest (
+ TableKey Integer not null,
+ F1 Smallint,
+ F2 Float,
+ F3 Double Precision,
+ F4 Decimal(9,3),
+ F5 Decimal(18,4),
+ F6 Date,
+ F7 Timestamp,
+ F8 Char (2),
+ F9 VarChar(256),
+ F10 Blob,
+ F11 BigInt,
+ "f12" Integer,
+ F13 Time,
+ F14 Blob sub_type text,
+ MyArray Integer [0:16],
+ "GRANTS" VarChar(20),
+ "My Field" VarChar(32),
+ "MY Field" VarChar(32),
+ Primary Key(TableKey)
+);
+
+Create Generator IBXGen;
+Add a record
+Add and edit a record
+Row No = 1
+TABLEKEY = 1
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Row No = 2
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Rows printed = 2
+
+Delete a record
+Row No = 1
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Rows printed = 1
+
+Rollback Retaining
+Row No = 1
+TABLEKEY = 1
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Row No = 2
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Rows printed = 2
+
+Delete a record
+Row No = 1
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Rows printed = 1
+
+Rollback
+Row No = 1
+TABLEKEY = 1
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Row No = 2
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Rows printed = 2
+
+Commit Retaining
+Row No = 1
+TABLEKEY = 1
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Row No = 2
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Row No = 3
+TABLEKEY = 3
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Rows printed = 3
+
+Commit
+Row No = 1
+TABLEKEY = 1
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Row No = 2
+TABLEKEY = 2
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = NULL
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 = NULL
+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)
+
+GRANTS = NULL
+MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
+MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
+
+Row No = 3
+TABLEKEY = 3
+F1 = 2
+F2 = 0.314000010490
+F3 = 0.314123456780
+F4 = 101.314
+F5 = 101.99
+F6 = 25/12/2007
+F7 = 25/12/2007 12:30:29.130
+F8 = XX (Charset = UTF8 Codepage = 65001)
+F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
+F10 = (blob), Length = 100
+F11 = 9223372036854775807
+F12 = 65566
+F13 = 12:30:45.000
+F14 (Charset = UTF8 Codepage = 65001)
+
+If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o'er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+'Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe'er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l'amour, continuez à jouer;
+Donnez-m'en un excès, que, surexcité,
+L'appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m'est venu à l'oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l'odeur! Assez; Pas plus:
+«Ce n'est pas si doux maintenant qu'avant.
+O esprit d'amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n'y entre,
+De quelle validité et de quelle hauteur soe'er,
+Mais tombe dans l'abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+
+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)
+
+GRANTS = NULL
+MYFIELD1 = NULL
+MYFIELD2 = NULL
+
+Rows printed = 3
+
+Journal Table
+IBX$SESSIONID = 1
+IBX$TRANSACTIONID = 10
+IBX$OLDTRANSACTIONID = NULL
+IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
+IBX$CREATED = 2021/12/07 11:09:47.8910
+IBX$SESSIONID = 1
+IBX$TRANSACTIONID = 15
+IBX$OLDTRANSACTIONID = NULL
+IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
+IBX$CREATED = 2021/12/07 11:09:49.1300
+IBX$SESSIONID = 1
+IBX$TRANSACTIONID = 17
+IBX$OLDTRANSACTIONID = 15
+IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
+IBX$CREATED = 2021/12/07 11:09:49.6100
+Journal Entries
+Journal Entry = jeTransStart(Transaction Start)
+Timestamp = 2021/12/07 11:09:47.9210
+Session ID = 1
+Transaction ID = 10
+Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
+TPB: Item Count = 3
+ isc_tpb_concurrency
+ isc_tpb_wait
+ isc_tpb_write
+
+Default Completion = TACommit
+
+Journal Entry = jeQuery(Query)
+Timestamp = 2021/12/07 11:09:48.0720
+Session ID = 1
+Transaction ID = 10
+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',
+FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
+0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
+01000000010000001A01050001000000DA000000
+
+, 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o''er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+''Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe''er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l''amour, continuez à jouer;
+Donnez-m''en un excès, que, surexcité,
+L''appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m''est venu à l''oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l''odeur! Assez; Pas plus:
+«Ce n''est pas si doux maintenant qu''avant.
+O esprit d''amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n''y entre,
+De quelle validité et de quelle hauteur soe''er,
+Mais tombe dans l''abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+',
+ 100
+ 99
+ 98
+ 97
+ 96
+ 95
+ 94
+ 93
+ 92
+ 91
+ 90
+ 89
+ 88
+ 87
+ 86
+ 85
+ 84
+
+, NULL) Returning MyArray
+
+Journal Entry = jeQuery(Query)
+Timestamp = 2021/12/07 11:09:48.0840
+Session ID = 1
+Transaction ID = 10
+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',
+FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
+0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
+01000000010000001A01050001000000DA000000
+
+, 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o''er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+''Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe''er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l''amour, continuez à jouer;
+Donnez-m''en un excès, que, surexcité,
+L''appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m''est venu à l''oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l''odeur! Assez; Pas plus:
+«Ce n''est pas si doux maintenant qu''avant.
+O esprit d''amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n''y entre,
+De quelle validité et de quelle hauteur soe''er,
+Mais tombe dans l''abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+',
+ 100
+ 99
+ 98
+ 97
+ 96
+ 95
+ 94
+ 93
+ 92
+ 91
+ 90
+ 89
+ 88
+ 87
+ 86
+ 85
+ 84
+
+, NULL) Returning MyArray
+
+Journal Entry = jeQuery(Query)
+Timestamp = 2021/12/07 11:09:48.1180
+Session ID = 1
+Transaction ID = 10
+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 =
+ 100
+ 99
+ 98
+ 97
+ 96
+ 95
+ 94
+ 93
+ 92
+ 91
+ 90
+ 89
+ 88
+ 87
+ 86
+ 85
+ 84
+
+, A.My Field = 'My Field', A.MY Field = 'MY Field', A.GRANTS = NULL Where A.TABLEKEY = 2 RETURNING A.MyArray
+
+Journal Entry = jeTransCommit(Commit)
+Timestamp = 2021/12/07 11:09:48.2130
+Session ID = 1
+Transaction ID = 10
+
+Journal Entry = jeTransStart(Transaction Start)
+Timestamp = 2021/12/07 11:09:48.2260
+Session ID = 1
+Transaction ID = 12
+Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
+TPB: Item Count = 3
+ isc_tpb_concurrency
+ isc_tpb_wait
+ isc_tpb_write
+
+Default Completion = TACommit
+
+Journal Entry = jeQuery(Query)
+Timestamp = 2021/12/07 11:09:48.4910
+Session ID = 1
+Transaction ID = 12
+Query = Delete From IBXTEST A Where A.TABLEKEY = 1
+
+Journal Entry = jeTransRollbackRet(Rollback Retaining)
+Timestamp = 2021/12/07 11:09:48.6890
+Session ID = 1
+Transaction ID = 14
+Old TransactionID = 12
+
+Journal Entry = jeQuery(Query)
+Timestamp = 2021/12/07 11:09:48.9240
+Session ID = 1
+Transaction ID = 14
+Query = Delete From IBXTEST A Where A.TABLEKEY = 1
+
+Journal Entry = jeTransRollback(Rollback)
+Timestamp = 2021/12/07 11:09:49.1130
+Session ID = 1
+Transaction ID = 14
+
+Journal Entry = jeTransStart(Transaction Start)
+Timestamp = 2021/12/07 11:09:49.1320
+Session ID = 1
+Transaction ID = 15
+Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
+TPB: Item Count = 3
+ isc_tpb_concurrency
+ isc_tpb_wait
+ isc_tpb_write
+
+Default Completion = TACommit
+
+Journal Entry = jeQuery(Query)
+Timestamp = 2021/12/07 11:09:49.4250
+Session ID = 1
+Transaction ID = 15
+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',
+FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
+0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
+01000000010000001A01050001000000DA000000
+
+, 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
+Give me excess of it, that, surfeiting,
+The appetite may sicken, and so die.
+That strain again! it had a dying fall:
+O, it came o''er my ear like the sweet south,
+That breathes upon a bank of violets,
+Stealing and giving odour! Enough; no more:
+''Tis not so sweet now as it was before.
+O spirit of love! how quick and fresh art thou,
+That, notwithstanding thy capacity 10
+Receiveth as the sea, nought enters there,
+Of what validity and pitch soe''er,
+But falls into abatement and low price,
+Even in a minute: so full of shapes is fancy
+That it alone is high fantastical.
+
+Si la musique est la nourriture de l''amour, continuez à jouer;
+Donnez-m''en un excès, que, surexcité,
+L''appétit peut devenir malade et ainsi mourir.
+Cette souche encore! il a eu une chute mourante:
+Oh, ça m''est venu à l''oreille comme le doux sud,
+Qui souffle sur une banque de violettes,
+Voler et donner de l''odeur! Assez; Pas plus:
+«Ce n''est pas si doux maintenant qu''avant.
+O esprit d''amour! comme tu es rapide et fraîche,
+Que, malgré ta capacité 10
+Reçoit comme la mer, rien n''y entre,
+De quelle validité et de quelle hauteur soe''er,
+Mais tombe dans l''abattement et le prix bas,
+Même en une minute: si plein de formes est fantaisie
+Que cela seul est fantastique.
+
+
+',
+ 100
+ 99
+ 98
+ 97
+ 96
+ 95
+ 94
+ 93
+ 92
+ 91
+ 90
+ 89
+ 88
+ 87
+ 86
+ 85
+ 84
+
+, NULL) Returning MyArray
+
+Journal Entry = jeTransCommitRet(Commit Retaining)
+Timestamp = 2021/12/07 11:09:49.6060
+Session ID = 1
+Transaction ID = 17
+Old TransactionID = 15
+
+Journal Entry = jeTransCommit(Commit)
+Timestamp = 2021/12/07 11:09:49.9880
+Session ID = 1
+Transaction ID = 17
+
+Journal Entry = jeTransStart(Transaction Start)
+Timestamp = 2021/12/07 11:09:50.0030
+Session ID = 1
+Transaction ID = 18
+Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
+TPB: Item Count = 3
+ isc_tpb_concurrency
+ isc_tpb_wait
+ isc_tpb_write
+
+Default Completion = TACommit
+
+Journal Entry = jeTransRollback(Rollback)
+Timestamp = 2021/12/07 11:09:50.4720
+Session ID = 1
+Transaction ID = 18
+
+
+
------------------------------------------------------
Test Suite Ends