ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/testsuite/FB4reference.log
(Generate patch)
# Line 641 | Line 641
641  
642   Rows printed = 42
643  
644 < Current memory = 19,687,232
644 > Current memory = 19,689,072
645   Delta memory = 16,384
646 < Max memory = 19,781,872
647 < Elapsed time= 0.027 sec
648 < Cpu = 0.020 sec
646 > Max memory = 19,783,712
647 > Elapsed time= 0.021 sec
648 > Cpu = 0.010 sec
649   Buffers = 2048
650   Reads = 2
651   Writes = 0
# Line 1445 | Line 1445
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 34 ms
1448 > inet://localhost/employee Disconnected after 32 ms
1449   Before Connect
1450   Connected to inet://localhost/employee
1451   DPB: Item Count = 3
# Line 1454 | Line 1454
1454    isc_dpb_lc_ctype = UTF8
1455  
1456   Before Disconnect
1457 < inet://localhost/employee Disconnected after 4041 ms
1457 > inet://localhost/employee Disconnected after 4066 ms
1458   Idle Timer Expired for Test_Database_02
1459   Database Closed
1460   Transaction Events
# Line 1491 | Line 1491
1491    isc_tpb_read
1492  
1493   Transaction Ending
1494 < Transaction Ended after 2000 ms
1494 > Transaction Ended after 2001 ms
1495   Idle Timer Expired for Test_Transaction_02
1496   Before Disconnect
1497 < inet://localhost/employee Disconnected after 2047 ms
1497 > inet://localhost/employee Disconnected after 2045 ms
1498   SQL Dialect Downgrade test
1499   Before Connect
1500   Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
# Line 1506 | Line 1506
1506  
1507   inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created
1508   Before Disconnect
1509 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 25 ms
1509 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 20 ms
1510   Before Connect
1511   Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
1512   Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
# Line 1516 | Line 1516
1516    isc_dpb_lc_ctype = UTF8
1517  
1518   Before Disconnect
1519 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 22 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 16 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 1543 | Line 1543
1543   ODS Major Version = 13
1544   Page Size = 8192
1545   Version = LI-V6.3.0.2496 Firebird 4.0
1546 < Current Memory = 19501920
1546 > Current Memory = 19503760
1547   Forced Writes Enabled
1548 < Max Memory = 19628528
1548 > Max Memory = 19630368
1549   Number of Buffers = 2048
1550   Sweep Interval = 20000
1551   User Names: SYSDBA
1552 < Fetches = 1847
1552 > Fetches = 1860
1553   Marks = 8
1554   Reads = 100
1555   Writes = 2
1556 < Pages Free = 310
1557 < Pages Used = 765
1556 > Pages Free = 313
1557 > Pages Used = 762
1558   Transaction Count = 1
1559  
1560   Read Idx Count
# Line 1565 | Line 1565
1565    RDB$SECURITY_CLASSES = 8
1566    RDB$TYPES = 2
1567    RDB$TRIGGERS = 25
1568 <  RDB$USER_PRIVILEGES = 811
1568 >  RDB$USER_PRIVILEGES = 821
1569    RDB$GENERATORS = 5
1570    RDB$CHARACTER_SETS = 2
1571    RDB$COLLATIONS = 2
1572    RDB$ROLES = 1
1573  
1574   Read Seq Count
1575 <  RDB$PAGES = 98
1575 >  RDB$PAGES = 100
1576    RDB$DATABASE = 25
1577 <  RDB$RELATIONS = 65
1577 >  RDB$RELATIONS = 66
1578  
1579   Database is Read/Write
1580   Hex Dump of Database Page 100:
# Line 3297 | Line 3297
3297   FULL_NAME = Guckenheimer, Mark
3298   DEPT_PATH = Corporate Headquarters / Engineering / Software Products Div. / Quality Assurance (Charset Id = 4 Codepage = 65001)
3299   DEPT_KEY_PATH = 000;600;620;622 (Charset Id = 4 Codepage = 65001)
3300 < Current memory = 19,667,952
3300 > Current memory = 19,669,792
3301   Delta memory = 16,416
3302 < Max memory = 19,763,360
3303 < Elapsed time= 0.026 sec
3302 > Max memory = 19,765,200
3303 > Elapsed time= 0.023 sec
3304   Cpu = 0.010 sec
3305   Buffers = 2048
3306   Reads = 2
# Line 3557 | Line 3557
3557   SALARY = 105,900.00
3558   FULL_NAME = Nelson, Robert
3559   Do Fetch Last:
3560 < EMP_NO = 145
3561 < FIRST_NAME = Mark
3562 < LAST_NAME = Guckenheimer
3563 < PHONE_EXT = 221
3564 < HIRE_DATE = 1994/05/02 00:00:00.0000
3565 < DEPT_NO = 622
3566 < JOB_CODE = Eng
3567 < JOB_GRADE = 5
3568 < JOB_COUNTRY = USA
3569 < SALARY = 32,000.00
3570 < FULL_NAME = Guckenheimer, Mark
3571 < Do Fetch Prior:
3572 < EMP_NO = 144
3573 < FIRST_NAME = John
3574 < LAST_NAME = Montgomery
3575 < PHONE_EXT = 820
3576 < HIRE_DATE = 1994/03/30 00:00:00.0000
3577 < DEPT_NO = 672
3578 < JOB_CODE = Eng
3579 < JOB_GRADE = 5
3580 < JOB_COUNTRY = USA
3581 < SALARY = 35,000.00
3582 < FULL_NAME = Montgomery, John
3583 < Do Fetch First:
3584 < EMP_NO = 2
3585 < FIRST_NAME = Robert
3586 < LAST_NAME = Nelson
3587 < PHONE_EXT = 250
3588 < HIRE_DATE = 1988/12/28 00:00:00.0000
3589 < DEPT_NO = 600
3590 < JOB_CODE = VP
3591 < JOB_GRADE = 2
3592 < JOB_COUNTRY = USA
3593 < SALARY = 105,900.00
3594 < FULL_NAME = Nelson, Robert
3595 < Do Fetch Abs 8 :
3596 < EMP_NO = 14
3597 < FIRST_NAME = Stewart
3598 < LAST_NAME = Hall
3599 < PHONE_EXT = 227
3600 < HIRE_DATE = 1990/06/04 00:00:00.0000
3601 < DEPT_NO = 900
3602 < JOB_CODE = Finan
3603 < JOB_GRADE = 3
3604 < JOB_COUNTRY = USA
3605 < SALARY = 69,482.63
3606 < FULL_NAME = Hall, Stewart
3607 < Do Fetch Relative -2 :
3608 < EMP_NO = 11
3609 < FIRST_NAME = K. J.
3610 < LAST_NAME = Weston
3611 < PHONE_EXT = 34
3612 < HIRE_DATE = 1990/01/17 00:00:00.0000
3613 < DEPT_NO = 130
3614 < JOB_CODE = SRep
3615 < JOB_GRADE = 4
3616 < JOB_COUNTRY = USA
3617 < SALARY = 86,292.94
3618 < FULL_NAME = Weston, K. J.
3619 < Do Fetch beyond EOF :
3620 < Fetch returned false
3621 <
3622 <
3560 > Test Completed with Error: feature is not supported
3561   ------------------------------------------------------
3562   Running Test 08: TIBDataset: Locate, Bookmark and Lookup
3563   Field No 1 Name = EMP_NO DataType = ftSmallint
# Line 4066 | Line 4004
4004   PRIMARY KEY (EMP_NO, PROJ_ID)
4005   );
4006  
4007 + /* Table: IBX$JOURNALS, Owner: SYSDBA */
4008 +
4009 + CREATE TABLE IBX$JOURNALS
4010 + (
4011 +        IBX$SESSIONID   INTEGER NOT NULL,
4012 +        IBX$TRANSACTIONID       INTEGER NOT NULL,
4013 +        IBX$USER        VARCHAR(32) Default CURRENT_USER,
4014 +        IBX$TIMESTAMP   TIMESTAMP Default CURRENT_TIMESTAMP,
4015 + PRIMARY KEY (IBX$SESSIONID, IBX$TRANSACTIONID)
4016 + );
4017 +
4018   /* Table: JOB, Owner: SYSDBA */
4019  
4020   CREATE TABLE JOB
# Line 4170 | Line 4119
4119  
4120   CREATE SEQUENCE CUST_NO_GEN;
4121   CREATE SEQUENCE EMP_NO_GEN;
4122 + CREATE SEQUENCE IBX$SESSIONS;
4123  
4124   /* View: PHONE_LIST, Owner: SYSDBA */
4125  
# Line 12103 | Line 12053
12053   Database Statistics for employee
12054  
12055   Database "/opt/firebird4.0.0/examples/empbuild/employee.fdb"
12056 < Gstat execution time Sat Oct 23 14:18:37 2021
12056 > Gstat execution time Tue Dec  7 11:05:53 2021
12057  
12058   Database header page information:
12059   Flags                   0
12060 < Generation              4690
12060 > Generation              5921
12061   System Change Number    0
12062   Page size               8192
12063   ODS version             13.0
12064 < Oldest transaction      5176
12065 < Oldest active           5177
12066 < Oldest snapshot         5177
12067 < Next transaction        5177
12064 > Oldest transaction      6680
12065 > Oldest active           6681
12066 > Oldest snapshot         6681
12067 > Next transaction        6681
12068   Sequence number         0
12069 < Next attachment ID      4103
12069 > Next attachment ID      5102
12070   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
12071   Shadow count            0
12072   Page buffers            0
# Line 12199 | Line 12149
12149   60 - 79% = 0
12150   80 - 99% = 0
12151  
12152 + IBX$JOURNALS (141)
12153 + Primary pointer page: 285, Index root page: 311
12154 + Pointer pages: 1, data page slots: 0
12155 + Data pages: 0, average fill: 0%
12156 + Primary pages: 0, secondary pages: 0, swept pages: 0
12157 + Empty pages: 0, full pages: 0
12158 + Fill distribution:
12159 + 0 - 19% = 0
12160 + 20 - 39% = 0
12161 + 40 - 59% = 0
12162 + 60 - 79% = 0
12163 + 80 - 99% = 0
12164 +
12165   JOB (129)
12166   Primary pointer page: 229, Index root page: 230
12167   Pointer pages: 1, data page slots: 2
# Line 12264 | Line 12227
12227   60 - 79% = 0
12228   80 - 99% = 0
12229  
12230 < Gstat completion time Sat Oct 23 14:18:37 2021
12230 > Gstat completion time Tue Dec  7 11:05:53 2021
12231  
12232  
12233  
# Line 12274 | Line 12237
12237   firebird4/bin/fbguard: guardian starting /opt/firebird4/bin/firebird
12238  
12239   Online Validation
12240 < 14:18:37.67 Validation started
12240 > 11:05:54.35 Validation started
12241  
12242 < 14:18:37.67 Relation 128 (COUNTRY)
12243 < 14:18:37.67   process pointer page    0 of    1
12244 < 14:18:37.67 Index 1 (RDB$PRIMARY1)
12245 < 14:18:37.67 Relation 128 (COUNTRY) is ok
12246 <
12247 < 14:18:37.67 Relation 129 (JOB)
12248 < 14:18:37.67   process pointer page    0 of    1
12249 < 14:18:37.67 Index 1 (RDB$PRIMARY2)
12250 < 14:18:37.67 Index 2 (RDB$FOREIGN3)
12251 < 14:18:37.67 Index 3 (MAXSALX)
12252 < 14:18:37.67 Index 4 (MINSALX)
12253 < 14:18:37.67 Relation 129 (JOB) is ok
12254 <
12255 < 14:18:37.67 Relation 130 (DEPARTMENT)
12256 < 14:18:37.67   process pointer page    0 of    1
12257 < 14:18:37.67 Index 1 (RDB$4)
12258 < 14:18:37.67 Index 2 (RDB$PRIMARY5)
12259 < 14:18:37.67 Index 3 (RDB$FOREIGN6)
12260 < 14:18:37.67 Index 4 (BUDGETX)
12261 < 14:18:37.67 Index 5 (RDB$FOREIGN10)
12262 < 14:18:37.67 Relation 130 (DEPARTMENT) is ok
12263 <
12264 < 14:18:37.67 Relation 131 (EMPLOYEE)
12265 < 14:18:37.67   process pointer page    0 of    1
12266 < 14:18:37.67 Index 1 (RDB$PRIMARY7)
12267 < 14:18:37.67 Index 2 (RDB$FOREIGN8)
12268 < 14:18:37.67 Index 3 (RDB$FOREIGN9)
12269 < 14:18:37.67 Index 4 (NAMEX)
12270 < 14:18:37.67 Relation 131 (EMPLOYEE) is ok
12271 <
12272 < 14:18:37.67 Relation 133 (PROJECT)
12273 < 14:18:37.67   process pointer page    0 of    1
12274 < 14:18:37.67 Index 1 (RDB$11)
12275 < 14:18:37.67 Index 2 (RDB$PRIMARY12)
12276 < 14:18:37.67 Index 3 (RDB$FOREIGN13)
12277 < 14:18:37.68 Index 4 (PRODTYPEX)
12278 < 14:18:37.68 Relation 133 (PROJECT) is ok
12279 <
12280 < 14:18:37.68 Relation 134 (EMPLOYEE_PROJECT)
12281 < 14:18:37.68   process pointer page    0 of    1
12282 < 14:18:37.68 Index 1 (RDB$PRIMARY14)
12283 < 14:18:37.68 Index 2 (RDB$FOREIGN15)
12284 < 14:18:37.68 Index 3 (RDB$FOREIGN16)
12285 < 14:18:37.68 Relation 134 (EMPLOYEE_PROJECT) is ok
12286 <
12287 < 14:18:37.68 Relation 135 (PROJ_DEPT_BUDGET)
12288 < 14:18:37.68   process pointer page    0 of    1
12289 < 14:18:37.68 Index 1 (RDB$PRIMARY17)
12290 < 14:18:37.68 Index 2 (RDB$FOREIGN18)
12291 < 14:18:37.68 Index 3 (RDB$FOREIGN19)
12292 < 14:18:37.68 Relation 135 (PROJ_DEPT_BUDGET) is ok
12293 <
12294 < 14:18:37.68 Relation 136 (SALARY_HISTORY)
12295 < 14:18:37.68   process pointer page    0 of    1
12296 < 14:18:37.68 Index 1 (RDB$PRIMARY20)
12297 < 14:18:37.68 Index 2 (RDB$FOREIGN21)
12298 < 14:18:37.68 Index 3 (CHANGEX)
12299 < 14:18:37.69 Index 4 (UPDATERX)
12300 < 14:18:37.69 Relation 136 (SALARY_HISTORY) is ok
12301 <
12302 < 14:18:37.69 Relation 137 (CUSTOMER)
12303 < 14:18:37.69   process pointer page    0 of    1
12304 < 14:18:37.69 Index 1 (RDB$PRIMARY22)
12305 < 14:18:37.69 Index 2 (RDB$FOREIGN23)
12306 < 14:18:37.69 Index 3 (CUSTNAMEX)
12307 < 14:18:37.69 Index 4 (CUSTREGION)
12308 < 14:18:37.69 Relation 137 (CUSTOMER) is ok
12309 <
12310 < 14:18:37.69 Relation 138 (SALES)
12311 < 14:18:37.69   process pointer page    0 of    1
12312 < 14:18:37.69 Index 1 (RDB$PRIMARY24)
12313 < 14:18:37.69 Index 2 (RDB$FOREIGN25)
12314 < 14:18:37.69 Index 3 (RDB$FOREIGN26)
12315 < 14:18:37.69 Index 4 (NEEDX)
12316 < 14:18:37.69 Index 5 (QTYX)
12317 < 14:18:37.69 Index 6 (SALESTATX)
12318 < 14:18:37.69 Relation 138 (SALES) is ok
12242 > 11:05:54.35 Relation 128 (COUNTRY)
12243 > 11:05:54.35   process pointer page    0 of    1
12244 > 11:05:54.35 Index 1 (RDB$PRIMARY1)
12245 > 11:05:54.35 Relation 128 (COUNTRY) is ok
12246 >
12247 > 11:05:54.35 Relation 129 (JOB)
12248 > 11:05:54.35   process pointer page    0 of    1
12249 > 11:05:54.35 Index 1 (RDB$PRIMARY2)
12250 > 11:05:54.35 Index 2 (RDB$FOREIGN3)
12251 > 11:05:54.35 Index 3 (MAXSALX)
12252 > 11:05:54.35 Index 4 (MINSALX)
12253 > 11:05:54.35 Relation 129 (JOB) is ok
12254 >
12255 > 11:05:54.35 Relation 130 (DEPARTMENT)
12256 > 11:05:54.35   process pointer page    0 of    1
12257 > 11:05:54.35 Index 1 (RDB$4)
12258 > 11:05:54.35 Index 2 (RDB$PRIMARY5)
12259 > 11:05:54.35 Index 3 (RDB$FOREIGN6)
12260 > 11:05:54.35 Index 4 (BUDGETX)
12261 > 11:05:54.35 Index 5 (RDB$FOREIGN10)
12262 > 11:05:54.35 Relation 130 (DEPARTMENT) is ok
12263 >
12264 > 11:05:54.35 Relation 131 (EMPLOYEE)
12265 > 11:05:54.35   process pointer page    0 of    1
12266 > 11:05:54.35 Index 1 (RDB$PRIMARY7)
12267 > 11:05:54.35 Index 2 (RDB$FOREIGN8)
12268 > 11:05:54.35 Index 3 (RDB$FOREIGN9)
12269 > 11:05:54.35 Index 4 (NAMEX)
12270 > 11:05:54.35 Relation 131 (EMPLOYEE) is ok
12271 >
12272 > 11:05:54.35 Relation 133 (PROJECT)
12273 > 11:05:54.35   process pointer page    0 of    1
12274 > 11:05:54.35 Index 1 (RDB$11)
12275 > 11:05:54.35 Index 2 (RDB$PRIMARY12)
12276 > 11:05:54.35 Index 3 (RDB$FOREIGN13)
12277 > 11:05:54.36 Index 4 (PRODTYPEX)
12278 > 11:05:54.36 Relation 133 (PROJECT) is ok
12279 >
12280 > 11:05:54.36 Relation 134 (EMPLOYEE_PROJECT)
12281 > 11:05:54.36   process pointer page    0 of    1
12282 > 11:05:54.36 Index 1 (RDB$PRIMARY14)
12283 > 11:05:54.36 Index 2 (RDB$FOREIGN15)
12284 > 11:05:54.36 Index 3 (RDB$FOREIGN16)
12285 > 11:05:54.36 Relation 134 (EMPLOYEE_PROJECT) is ok
12286 >
12287 > 11:05:54.36 Relation 135 (PROJ_DEPT_BUDGET)
12288 > 11:05:54.36   process pointer page    0 of    1
12289 > 11:05:54.36 Index 1 (RDB$PRIMARY17)
12290 > 11:05:54.36 Index 2 (RDB$FOREIGN18)
12291 > 11:05:54.36 Index 3 (RDB$FOREIGN19)
12292 > 11:05:54.36 Relation 135 (PROJ_DEPT_BUDGET) is ok
12293 >
12294 > 11:05:54.36 Relation 136 (SALARY_HISTORY)
12295 > 11:05:54.36   process pointer page    0 of    1
12296 > 11:05:54.36 Index 1 (RDB$PRIMARY20)
12297 > 11:05:54.36 Index 2 (RDB$FOREIGN21)
12298 > 11:05:54.36 Index 3 (CHANGEX)
12299 > 11:05:54.39 Index 4 (UPDATERX)
12300 > 11:05:54.39 Relation 136 (SALARY_HISTORY) is ok
12301 >
12302 > 11:05:54.39 Relation 137 (CUSTOMER)
12303 > 11:05:54.39   process pointer page    0 of    1
12304 > 11:05:54.39 Index 1 (RDB$PRIMARY22)
12305 > 11:05:54.39 Index 2 (RDB$FOREIGN23)
12306 > 11:05:54.39 Index 3 (CUSTNAMEX)
12307 > 11:05:54.39 Index 4 (CUSTREGION)
12308 > 11:05:54.40 Relation 137 (CUSTOMER) is ok
12309 >
12310 > 11:05:54.40 Relation 138 (SALES)
12311 > 11:05:54.40   process pointer page    0 of    1
12312 > 11:05:54.41 Index 1 (RDB$PRIMARY24)
12313 > 11:05:54.41 Index 2 (RDB$FOREIGN25)
12314 > 11:05:54.41 Index 3 (RDB$FOREIGN26)
12315 > 11:05:54.41 Index 4 (NEEDX)
12316 > 11:05:54.41 Index 5 (QTYX)
12317 > 11:05:54.41 Index 6 (SALESTATX)
12318 > 11:05:54.41 Relation 138 (SALES) is ok
12319 >
12320 > 11:05:54.41 Relation 141 (IBX$JOURNALS)
12321 > 11:05:54.41   process pointer page    0 of    1
12322 > 11:05:54.41 Index 1 (RDB$PRIMARY29)
12323 > 11:05:54.41 Relation 141 (IBX$JOURNALS) is ok
12324  
12325 < 14:18:37.69 Validation finished
12325 > 11:05:54.41 Validation finished
12326  
12327  
12328   Normal Validation
# Line 12490 | Line 12458
12458   Employee Database is Online = TRUE
12459  
12460   Starting Backup
12461 < Backup Completed - File Size = 80384 bytes
12461 > Backup Completed - File Size = 81920 bytes
12462   Restore Started
12463  
12464   Restore Completed
# Line 13639 | Line 13607
13607  
13608   Rows printed = 2
13609  
13610 < Current memory = 19,666,176
13610 > Current memory = 19,668,016
13611   Delta memory = 16,032
13612 < Max memory = 19,761,504
13613 < Elapsed time= 0.002 sec
13614 < Cpu = 0.010 sec
13612 > Max memory = 19,763,344
13613 > Elapsed time= 0.003 sec
13614 > Cpu = 0.000 sec
13615   Buffers = 2048
13616   Reads = 2
13617   Writes = 0
# Line 13907 | Line 13875
13875  
13876   Rows printed = 2
13877  
13878 < Current memory = 19,666,176
13878 > Current memory = 19,668,016
13879   Delta memory = 16,032
13880 < Max memory = 19,761,504
13881 < Elapsed time= 0.102 sec
13882 < Cpu = 0.000 sec
13880 > Max memory = 19,763,344
13881 > Elapsed time= 0.103 sec
13882 > Cpu = 0.010 sec
13883   Buffers = 2048
13884   Reads = 2
13885   Writes = 0
# Line 15528 | Line 15496
15496      MyText VarChar(1024),
15497      Primary Key (RowID)
15498    );                
15499 < Loading data into database table. Started at 23/10/2021 14:19:28.924
15500 < Data load completed at 23/10/2021 14:21:13.893 Elapsed Time = 104969 ms, 100000 records loaded
15501 < Message Hash = 436daf51ddd32626a439935108ea69c8
15502 < Database Read started at 23/10/2021 14:21:13.906
15503 < Read Dataset completed at 23/10/2021 14:21:44.043 Elapsed Time = 30137 ms, 100000 records read
15504 < Message Hash = 436daf51ddd32626a439935108ea69c8
15499 > Loading data into database table. Started at 07/12/2021 11:06:44.478
15500 > Data load completed at 07/12/2021 11:08:48.103 Elapsed Time = 123625 ms, 100000 records loaded
15501 > Message Hash = f284b45f0183162d3078ab502d908ae1
15502 > Database Read started at 07/12/2021 11:08:48.114
15503 > Read Dataset completed at 07/12/2021 11:09:18.751 Elapsed Time = 30637 ms, 100000 records read
15504 > Message Hash = f284b45f0183162d3078ab502d908ae1
15505   Test Completed successfully
15506 < 23/10/2021 14:21:44.043 Test 21 passes as long as the checksums are identical
15506 > 07/12/2021 11:09:18.751 Test 21 passes as long as the checksums are identical
15507  
15508  
15509   ------------------------------------------------------
# Line 15570 | Line 15538
15538   SEC$LAST_NAME = Tester (Charset = UTF8 Codepage = 65001)
15539   SEC$PASSWORD = NULL
15540   LOGGEDIN = False
15541 < DBCREATOR = True
15541 > DBCREATOR = False
15542  
15543   Row No = 2
15544   SEC$DESCRIPTION = NULL
# Line 17615 | Line 17583
17583  
17584  
17585  
17586 + ------------------------------------------------------
17587 + Running Test 29: IBJournal Tests
17588 + Creating Database from resources/Test29.sql
17589 +
17590 + Create Table IBXTest (
17591 + TableKey Integer not null,
17592 + F1 Smallint,
17593 + F2 Float,
17594 + F3 Double Precision,
17595 + F4 Decimal(9,3),
17596 + F5 Decimal(18,4),
17597 + F6 Date,
17598 + F7 Timestamp,
17599 + F8 Char (2),
17600 + F9 VarChar(256),
17601 + F10 Blob,
17602 + F11 BigInt,
17603 + "f12" Integer,
17604 + F13 Time,
17605 + F14 Blob sub_type text,
17606 + MyArray Integer [0:16],
17607 + "GRANTS" VarChar(20),
17608 + "My Field" VarChar(32),
17609 + "MY Field" VarChar(32),
17610 + Primary Key(TableKey)
17611 + );
17612 +
17613 + Create Generator IBXGen;
17614 + Add a record
17615 + Add and edit a record
17616 + Row No = 1
17617 + TABLEKEY = 1
17618 + F1 = 2
17619 + F2 = 0.314000010490
17620 + F3 = 0.314123456780
17621 + F4 = 101.314
17622 + F5 = 101.99
17623 + F6 = 25/12/2007
17624 + F7 = 25/12/2007 12:30:29.130
17625 + F8 = XX (Charset = UTF8 Codepage = 65001)
17626 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17627 + F10 = (blob), Length = 100
17628 + F11 = 9223372036854775807
17629 + F12 = 65566
17630 + F13 = 12:30:45.000
17631 + F14 (Charset  = UTF8 Codepage = 65001)
17632 +
17633 + If music be the food of love, play on;
17634 + Give me excess of it, that, surfeiting,
17635 + The appetite may sicken, and so die.
17636 + That strain again! it had a dying fall:
17637 + O, it came o'er my ear like the sweet south,
17638 + That breathes upon a bank of violets,
17639 + Stealing and giving odour! Enough; no more:
17640 + 'Tis not so sweet now as it was before.
17641 + O spirit of love! how quick and fresh art thou,
17642 + That, notwithstanding thy capacity      10
17643 + Receiveth as the sea, nought enters there,
17644 + Of what validity and pitch soe'er,
17645 + But falls into abatement and low price,
17646 + Even in a minute: so full of shapes is fancy
17647 + That it alone is high fantastical.
17648 +
17649 + Si la musique est la nourriture de l'amour, continuez à jouer;
17650 + Donnez-m'en un excès, que, surexcité,
17651 + L'appétit peut devenir malade et ainsi mourir.
17652 + Cette souche encore! il a eu une chute mourante:
17653 + Oh, ça m'est venu à l'oreille comme le doux sud,
17654 + Qui souffle sur une banque de violettes,
17655 + Voler et donner de l'odeur! Assez; Pas plus:
17656 + «Ce n'est pas si doux maintenant qu'avant.
17657 + O esprit d'amour! comme tu es rapide et fraîche,
17658 + Que, malgré ta capacité 10
17659 + Reçoit comme la mer, rien n'y entre,
17660 + De quelle validité et de quelle hauteur soe'er,
17661 + Mais tombe dans l'abattement et le prix bas,
17662 + Même en une minute: si plein de formes est fantaisie
17663 + Que cela seul est fantastique.
17664 +
17665 +
17666 +
17667 + 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)
17668 +
17669 + GRANTS = NULL
17670 + MYFIELD1 = NULL
17671 + MYFIELD2 = NULL
17672 +
17673 + Row No = 2
17674 + TABLEKEY = 2
17675 + F1 = 2
17676 + F2 = 0.314000010490
17677 + F3 = 0.314123456780
17678 + F4 = 101.314
17679 + F5 = 101.99
17680 + F6 = 25/12/2007
17681 + F7 = 25/12/2007 12:30:29.130
17682 + F8 = XX (Charset = UTF8 Codepage = 65001)
17683 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17684 + F10 = NULL
17685 + F11 = 9223372036854775807
17686 + F12 = 65566
17687 + F13 = 12:30:45.000
17688 + F14 = NULL
17689 + 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)
17690 +
17691 + GRANTS = NULL
17692 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17693 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17694 +
17695 + Rows printed = 2
17696 +
17697 + Delete a record
17698 + Row No = 1
17699 + TABLEKEY = 2
17700 + F1 = 2
17701 + F2 = 0.314000010490
17702 + F3 = 0.314123456780
17703 + F4 = 101.314
17704 + F5 = 101.99
17705 + F6 = 25/12/2007
17706 + F7 = 25/12/2007 12:30:29.130
17707 + F8 = XX (Charset = UTF8 Codepage = 65001)
17708 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17709 + F10 = NULL
17710 + F11 = 9223372036854775807
17711 + F12 = 65566
17712 + F13 = 12:30:45.000
17713 + F14 = NULL
17714 + 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)
17715 +
17716 + GRANTS = NULL
17717 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17718 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17719 +
17720 + Rows printed = 1
17721 +
17722 + Rollback Retaining
17723 + Row No = 1
17724 + TABLEKEY = 1
17725 + F1 = 2
17726 + F2 = 0.314000010490
17727 + F3 = 0.314123456780
17728 + F4 = 101.314
17729 + F5 = 101.99
17730 + F6 = 25/12/2007
17731 + F7 = 25/12/2007 12:30:29.130
17732 + F8 = XX (Charset = UTF8 Codepage = 65001)
17733 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17734 + F10 = (blob), Length = 100
17735 + F11 = 9223372036854775807
17736 + F12 = 65566
17737 + F13 = 12:30:45.000
17738 + F14 (Charset  = UTF8 Codepage = 65001)
17739 +
17740 + If music be the food of love, play on;
17741 + Give me excess of it, that, surfeiting,
17742 + The appetite may sicken, and so die.
17743 + That strain again! it had a dying fall:
17744 + O, it came o'er my ear like the sweet south,
17745 + That breathes upon a bank of violets,
17746 + Stealing and giving odour! Enough; no more:
17747 + 'Tis not so sweet now as it was before.
17748 + O spirit of love! how quick and fresh art thou,
17749 + That, notwithstanding thy capacity      10
17750 + Receiveth as the sea, nought enters there,
17751 + Of what validity and pitch soe'er,
17752 + But falls into abatement and low price,
17753 + Even in a minute: so full of shapes is fancy
17754 + That it alone is high fantastical.
17755 +
17756 + Si la musique est la nourriture de l'amour, continuez à jouer;
17757 + Donnez-m'en un excès, que, surexcité,
17758 + L'appétit peut devenir malade et ainsi mourir.
17759 + Cette souche encore! il a eu une chute mourante:
17760 + Oh, ça m'est venu à l'oreille comme le doux sud,
17761 + Qui souffle sur une banque de violettes,
17762 + Voler et donner de l'odeur! Assez; Pas plus:
17763 + «Ce n'est pas si doux maintenant qu'avant.
17764 + O esprit d'amour! comme tu es rapide et fraîche,
17765 + Que, malgré ta capacité 10
17766 + Reçoit comme la mer, rien n'y entre,
17767 + De quelle validité et de quelle hauteur soe'er,
17768 + Mais tombe dans l'abattement et le prix bas,
17769 + Même en une minute: si plein de formes est fantaisie
17770 + Que cela seul est fantastique.
17771 +
17772 +
17773 +
17774 + 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)
17775 +
17776 + GRANTS = NULL
17777 + MYFIELD1 = NULL
17778 + MYFIELD2 = NULL
17779 +
17780 + Row No = 2
17781 + TABLEKEY = 2
17782 + F1 = 2
17783 + F2 = 0.314000010490
17784 + F3 = 0.314123456780
17785 + F4 = 101.314
17786 + F5 = 101.99
17787 + F6 = 25/12/2007
17788 + F7 = 25/12/2007 12:30:29.130
17789 + F8 = XX (Charset = UTF8 Codepage = 65001)
17790 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17791 + F10 = NULL
17792 + F11 = 9223372036854775807
17793 + F12 = 65566
17794 + F13 = 12:30:45.000
17795 + F14 = NULL
17796 + 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)
17797 +
17798 + GRANTS = NULL
17799 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17800 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17801 +
17802 + Rows printed = 2
17803 +
17804 + Delete a record
17805 + Row No = 1
17806 + TABLEKEY = 2
17807 + F1 = 2
17808 + F2 = 0.314000010490
17809 + F3 = 0.314123456780
17810 + F4 = 101.314
17811 + F5 = 101.99
17812 + F6 = 25/12/2007
17813 + F7 = 25/12/2007 12:30:29.130
17814 + F8 = XX (Charset = UTF8 Codepage = 65001)
17815 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17816 + F10 = NULL
17817 + F11 = 9223372036854775807
17818 + F12 = 65566
17819 + F13 = 12:30:45.000
17820 + F14 = NULL
17821 + 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)
17822 +
17823 + GRANTS = NULL
17824 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17825 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17826 +
17827 + Rows printed = 1
17828 +
17829 + Rollback
17830 + Row No = 1
17831 + TABLEKEY = 1
17832 + F1 = 2
17833 + F2 = 0.314000010490
17834 + F3 = 0.314123456780
17835 + F4 = 101.314
17836 + F5 = 101.99
17837 + F6 = 25/12/2007
17838 + F7 = 25/12/2007 12:30:29.130
17839 + F8 = XX (Charset = UTF8 Codepage = 65001)
17840 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17841 + F10 = (blob), Length = 100
17842 + F11 = 9223372036854775807
17843 + F12 = 65566
17844 + F13 = 12:30:45.000
17845 + F14 (Charset  = UTF8 Codepage = 65001)
17846 +
17847 + If music be the food of love, play on;
17848 + Give me excess of it, that, surfeiting,
17849 + The appetite may sicken, and so die.
17850 + That strain again! it had a dying fall:
17851 + O, it came o'er my ear like the sweet south,
17852 + That breathes upon a bank of violets,
17853 + Stealing and giving odour! Enough; no more:
17854 + 'Tis not so sweet now as it was before.
17855 + O spirit of love! how quick and fresh art thou,
17856 + That, notwithstanding thy capacity      10
17857 + Receiveth as the sea, nought enters there,
17858 + Of what validity and pitch soe'er,
17859 + But falls into abatement and low price,
17860 + Even in a minute: so full of shapes is fancy
17861 + That it alone is high fantastical.
17862 +
17863 + Si la musique est la nourriture de l'amour, continuez à jouer;
17864 + Donnez-m'en un excès, que, surexcité,
17865 + L'appétit peut devenir malade et ainsi mourir.
17866 + Cette souche encore! il a eu une chute mourante:
17867 + Oh, ça m'est venu à l'oreille comme le doux sud,
17868 + Qui souffle sur une banque de violettes,
17869 + Voler et donner de l'odeur! Assez; Pas plus:
17870 + «Ce n'est pas si doux maintenant qu'avant.
17871 + O esprit d'amour! comme tu es rapide et fraîche,
17872 + Que, malgré ta capacité 10
17873 + Reçoit comme la mer, rien n'y entre,
17874 + De quelle validité et de quelle hauteur soe'er,
17875 + Mais tombe dans l'abattement et le prix bas,
17876 + Même en une minute: si plein de formes est fantaisie
17877 + Que cela seul est fantastique.
17878 +
17879 +
17880 +
17881 + 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)
17882 +
17883 + GRANTS = NULL
17884 + MYFIELD1 = NULL
17885 + MYFIELD2 = NULL
17886 +
17887 + Row No = 2
17888 + TABLEKEY = 2
17889 + F1 = 2
17890 + F2 = 0.314000010490
17891 + F3 = 0.314123456780
17892 + F4 = 101.314
17893 + F5 = 101.99
17894 + F6 = 25/12/2007
17895 + F7 = 25/12/2007 12:30:29.130
17896 + F8 = XX (Charset = UTF8 Codepage = 65001)
17897 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17898 + F10 = NULL
17899 + F11 = 9223372036854775807
17900 + F12 = 65566
17901 + F13 = 12:30:45.000
17902 + F14 = NULL
17903 + 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)
17904 +
17905 + GRANTS = NULL
17906 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17907 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17908 +
17909 + Rows printed = 2
17910 +
17911 + Commit Retaining
17912 + Row No = 1
17913 + TABLEKEY = 1
17914 + F1 = 2
17915 + F2 = 0.314000010490
17916 + F3 = 0.314123456780
17917 + F4 = 101.314
17918 + F5 = 101.99
17919 + F6 = 25/12/2007
17920 + F7 = 25/12/2007 12:30:29.130
17921 + F8 = XX (Charset = UTF8 Codepage = 65001)
17922 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17923 + F10 = (blob), Length = 100
17924 + F11 = 9223372036854775807
17925 + F12 = 65566
17926 + F13 = 12:30:45.000
17927 + F14 (Charset  = UTF8 Codepage = 65001)
17928 +
17929 + If music be the food of love, play on;
17930 + Give me excess of it, that, surfeiting,
17931 + The appetite may sicken, and so die.
17932 + That strain again! it had a dying fall:
17933 + O, it came o'er my ear like the sweet south,
17934 + That breathes upon a bank of violets,
17935 + Stealing and giving odour! Enough; no more:
17936 + 'Tis not so sweet now as it was before.
17937 + O spirit of love! how quick and fresh art thou,
17938 + That, notwithstanding thy capacity      10
17939 + Receiveth as the sea, nought enters there,
17940 + Of what validity and pitch soe'er,
17941 + But falls into abatement and low price,
17942 + Even in a minute: so full of shapes is fancy
17943 + That it alone is high fantastical.
17944 +
17945 + Si la musique est la nourriture de l'amour, continuez à jouer;
17946 + Donnez-m'en un excès, que, surexcité,
17947 + L'appétit peut devenir malade et ainsi mourir.
17948 + Cette souche encore! il a eu une chute mourante:
17949 + Oh, ça m'est venu à l'oreille comme le doux sud,
17950 + Qui souffle sur une banque de violettes,
17951 + Voler et donner de l'odeur! Assez; Pas plus:
17952 + «Ce n'est pas si doux maintenant qu'avant.
17953 + O esprit d'amour! comme tu es rapide et fraîche,
17954 + Que, malgré ta capacité 10
17955 + Reçoit comme la mer, rien n'y entre,
17956 + De quelle validité et de quelle hauteur soe'er,
17957 + Mais tombe dans l'abattement et le prix bas,
17958 + Même en une minute: si plein de formes est fantaisie
17959 + Que cela seul est fantastique.
17960 +
17961 +
17962 +
17963 + 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)
17964 +
17965 + GRANTS = NULL
17966 + MYFIELD1 = NULL
17967 + MYFIELD2 = NULL
17968 +
17969 + Row No = 2
17970 + TABLEKEY = 2
17971 + F1 = 2
17972 + F2 = 0.314000010490
17973 + F3 = 0.314123456780
17974 + F4 = 101.314
17975 + F5 = 101.99
17976 + F6 = 25/12/2007
17977 + F7 = 25/12/2007 12:30:29.130
17978 + F8 = XX (Charset = UTF8 Codepage = 65001)
17979 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17980 + F10 = NULL
17981 + F11 = 9223372036854775807
17982 + F12 = 65566
17983 + F13 = 12:30:45.000
17984 + F14 = NULL
17985 + 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)
17986 +
17987 + GRANTS = NULL
17988 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17989 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17990 +
17991 + Row No = 3
17992 + TABLEKEY = 3
17993 + F1 = 2
17994 + F2 = 0.314000010490
17995 + F3 = 0.314123456780
17996 + F4 = 101.314
17997 + F5 = 101.99
17998 + F6 = 25/12/2007
17999 + F7 = 25/12/2007 12:30:29.130
18000 + F8 = XX (Charset = UTF8 Codepage = 65001)
18001 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
18002 + F10 = (blob), Length = 100
18003 + F11 = 9223372036854775807
18004 + F12 = 65566
18005 + F13 = 12:30:45.000
18006 + F14 (Charset  = UTF8 Codepage = 65001)
18007 +
18008 + If music be the food of love, play on;
18009 + Give me excess of it, that, surfeiting,
18010 + The appetite may sicken, and so die.
18011 + That strain again! it had a dying fall:
18012 + O, it came o'er my ear like the sweet south,
18013 + That breathes upon a bank of violets,
18014 + Stealing and giving odour! Enough; no more:
18015 + 'Tis not so sweet now as it was before.
18016 + O spirit of love! how quick and fresh art thou,
18017 + That, notwithstanding thy capacity      10
18018 + Receiveth as the sea, nought enters there,
18019 + Of what validity and pitch soe'er,
18020 + But falls into abatement and low price,
18021 + Even in a minute: so full of shapes is fancy
18022 + That it alone is high fantastical.
18023 +
18024 + Si la musique est la nourriture de l'amour, continuez à jouer;
18025 + Donnez-m'en un excès, que, surexcité,
18026 + L'appétit peut devenir malade et ainsi mourir.
18027 + Cette souche encore! il a eu une chute mourante:
18028 + Oh, ça m'est venu à l'oreille comme le doux sud,
18029 + Qui souffle sur une banque de violettes,
18030 + Voler et donner de l'odeur! Assez; Pas plus:
18031 + «Ce n'est pas si doux maintenant qu'avant.
18032 + O esprit d'amour! comme tu es rapide et fraîche,
18033 + Que, malgré ta capacité 10
18034 + Reçoit comme la mer, rien n'y entre,
18035 + De quelle validité et de quelle hauteur soe'er,
18036 + Mais tombe dans l'abattement et le prix bas,
18037 + Même en une minute: si plein de formes est fantaisie
18038 + Que cela seul est fantastique.
18039 +
18040 +
18041 +
18042 + 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)
18043 +
18044 + GRANTS = NULL
18045 + MYFIELD1 = NULL
18046 + MYFIELD2 = NULL
18047 +
18048 + Rows printed = 3
18049 +
18050 + Commit
18051 + Row No = 1
18052 + TABLEKEY = 1
18053 + F1 = 2
18054 + F2 = 0.314000010490
18055 + F3 = 0.314123456780
18056 + F4 = 101.314
18057 + F5 = 101.99
18058 + F6 = 25/12/2007
18059 + F7 = 25/12/2007 12:30:29.130
18060 + F8 = XX (Charset = UTF8 Codepage = 65001)
18061 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
18062 + F10 = (blob), Length = 100
18063 + F11 = 9223372036854775807
18064 + F12 = 65566
18065 + F13 = 12:30:45.000
18066 + F14 (Charset  = UTF8 Codepage = 65001)
18067 +
18068 + If music be the food of love, play on;
18069 + Give me excess of it, that, surfeiting,
18070 + The appetite may sicken, and so die.
18071 + That strain again! it had a dying fall:
18072 + O, it came o'er my ear like the sweet south,
18073 + That breathes upon a bank of violets,
18074 + Stealing and giving odour! Enough; no more:
18075 + 'Tis not so sweet now as it was before.
18076 + O spirit of love! how quick and fresh art thou,
18077 + That, notwithstanding thy capacity      10
18078 + Receiveth as the sea, nought enters there,
18079 + Of what validity and pitch soe'er,
18080 + But falls into abatement and low price,
18081 + Even in a minute: so full of shapes is fancy
18082 + That it alone is high fantastical.
18083 +
18084 + Si la musique est la nourriture de l'amour, continuez à jouer;
18085 + Donnez-m'en un excès, que, surexcité,
18086 + L'appétit peut devenir malade et ainsi mourir.
18087 + Cette souche encore! il a eu une chute mourante:
18088 + Oh, ça m'est venu à l'oreille comme le doux sud,
18089 + Qui souffle sur une banque de violettes,
18090 + Voler et donner de l'odeur! Assez; Pas plus:
18091 + «Ce n'est pas si doux maintenant qu'avant.
18092 + O esprit d'amour! comme tu es rapide et fraîche,
18093 + Que, malgré ta capacité 10
18094 + Reçoit comme la mer, rien n'y entre,
18095 + De quelle validité et de quelle hauteur soe'er,
18096 + Mais tombe dans l'abattement et le prix bas,
18097 + Même en une minute: si plein de formes est fantaisie
18098 + Que cela seul est fantastique.
18099 +
18100 +
18101 +
18102 + 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)
18103 +
18104 + GRANTS = NULL
18105 + MYFIELD1 = NULL
18106 + MYFIELD2 = NULL
18107 +
18108 + Row No = 2
18109 + TABLEKEY = 2
18110 + F1 = 2
18111 + F2 = 0.314000010490
18112 + F3 = 0.314123456780
18113 + F4 = 101.314
18114 + F5 = 101.99
18115 + F6 = 25/12/2007
18116 + F7 = 25/12/2007 12:30:29.130
18117 + F8 = XX (Charset = UTF8 Codepage = 65001)
18118 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
18119 + F10 = NULL
18120 + F11 = 9223372036854775807
18121 + F12 = 65566
18122 + F13 = 12:30:45.000
18123 + F14 = NULL
18124 + 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)
18125 +
18126 + GRANTS = NULL
18127 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
18128 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
18129 +
18130 + Row No = 3
18131 + TABLEKEY = 3
18132 + F1 = 2
18133 + F2 = 0.314000010490
18134 + F3 = 0.314123456780
18135 + F4 = 101.314
18136 + F5 = 101.99
18137 + F6 = 25/12/2007
18138 + F7 = 25/12/2007 12:30:29.130
18139 + F8 = XX (Charset = UTF8 Codepage = 65001)
18140 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
18141 + F10 = (blob), Length = 100
18142 + F11 = 9223372036854775807
18143 + F12 = 65566
18144 + F13 = 12:30:45.000
18145 + F14 (Charset  = UTF8 Codepage = 65001)
18146 +
18147 + If music be the food of love, play on;
18148 + Give me excess of it, that, surfeiting,
18149 + The appetite may sicken, and so die.
18150 + That strain again! it had a dying fall:
18151 + O, it came o'er my ear like the sweet south,
18152 + That breathes upon a bank of violets,
18153 + Stealing and giving odour! Enough; no more:
18154 + 'Tis not so sweet now as it was before.
18155 + O spirit of love! how quick and fresh art thou,
18156 + That, notwithstanding thy capacity      10
18157 + Receiveth as the sea, nought enters there,
18158 + Of what validity and pitch soe'er,
18159 + But falls into abatement and low price,
18160 + Even in a minute: so full of shapes is fancy
18161 + That it alone is high fantastical.
18162 +
18163 + Si la musique est la nourriture de l'amour, continuez à jouer;
18164 + Donnez-m'en un excès, que, surexcité,
18165 + L'appétit peut devenir malade et ainsi mourir.
18166 + Cette souche encore! il a eu une chute mourante:
18167 + Oh, ça m'est venu à l'oreille comme le doux sud,
18168 + Qui souffle sur une banque de violettes,
18169 + Voler et donner de l'odeur! Assez; Pas plus:
18170 + «Ce n'est pas si doux maintenant qu'avant.
18171 + O esprit d'amour! comme tu es rapide et fraîche,
18172 + Que, malgré ta capacité 10
18173 + Reçoit comme la mer, rien n'y entre,
18174 + De quelle validité et de quelle hauteur soe'er,
18175 + Mais tombe dans l'abattement et le prix bas,
18176 + Même en une minute: si plein de formes est fantaisie
18177 + Que cela seul est fantastique.
18178 +
18179 +
18180 +
18181 + 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)
18182 +
18183 + GRANTS = NULL
18184 + MYFIELD1 = NULL
18185 + MYFIELD2 = NULL
18186 +
18187 + Rows printed = 3
18188 +
18189 + Journal Table
18190 + IBX$SESSIONID = 1
18191 + IBX$TRANSACTIONID = 10
18192 + IBX$OLDTRANSACTIONID = NULL
18193 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
18194 + IBX$CREATED = 2021/12/07 11:09:47.8910
18195 + IBX$SESSIONID = 1
18196 + IBX$TRANSACTIONID = 15
18197 + IBX$OLDTRANSACTIONID = NULL
18198 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
18199 + IBX$CREATED = 2021/12/07 11:09:49.1300
18200 + IBX$SESSIONID = 1
18201 + IBX$TRANSACTIONID = 17
18202 + IBX$OLDTRANSACTIONID = 15
18203 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
18204 + IBX$CREATED = 2021/12/07 11:09:49.6100
18205 + Journal Entries
18206 + Journal Entry = jeTransStart(Transaction Start)
18207 + Timestamp = 2021/12/07 11:09:47.9210
18208 + Session ID = 1
18209 + Transaction ID = 10
18210 + Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
18211 + TPB: Item Count = 3
18212 +  isc_tpb_concurrency
18213 +  isc_tpb_wait
18214 +  isc_tpb_write
18215 +
18216 + Default Completion = TACommit
18217 +
18218 + Journal Entry = jeQuery(Query)
18219 + Timestamp = 2021/12/07 11:09:48.0720
18220 + Session ID = 1
18221 + Transaction ID = 10
18222 + 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">
18223 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
18224 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
18225 + 01000000010000001A01050001000000DA000000
18226 + </blob>
18227 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
18228 + Give me excess of it, that, surfeiting,
18229 + The appetite may sicken, and so die.
18230 + That strain again! it had a dying fall:
18231 + O, it came o''er my ear like the sweet south,
18232 + That breathes upon a bank of violets,
18233 + Stealing and giving odour! Enough; no more:
18234 + ''Tis not so sweet now as it was before.
18235 + O spirit of love! how quick and fresh art thou,
18236 + That, notwithstanding thy capacity      10
18237 + Receiveth as the sea, nought enters there,
18238 + Of what validity and pitch soe''er,
18239 + But falls into abatement and low price,
18240 + Even in a minute: so full of shapes is fancy
18241 + That it alone is high fantastical.
18242 +
18243 + Si la musique est la nourriture de l''amour, continuez à jouer;
18244 + Donnez-m''en un excès, que, surexcité,
18245 + L''appétit peut devenir malade et ainsi mourir.
18246 + Cette souche encore! il a eu une chute mourante:
18247 + Oh, ça m''est venu à l''oreille comme le doux sud,
18248 + Qui souffle sur une banque de violettes,
18249 + Voler et donner de l''odeur! Assez; Pas plus:
18250 + «Ce n''est pas si doux maintenant qu''avant.
18251 + O esprit d''amour! comme tu es rapide et fraîche,
18252 + Que, malgré ta capacité 10
18253 + Reçoit comme la mer, rien n''y entre,
18254 + De quelle validité et de quelle hauteur soe''er,
18255 + Mais tombe dans l''abattement et le prix bas,
18256 + Même en une minute: si plein de formes est fantaisie
18257 + Que cela seul est fantastique.
18258 +
18259 +
18260 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
18261 + <elt ix="0">100</elt>
18262 + <elt ix="1">99</elt>
18263 + <elt ix="2">98</elt>
18264 + <elt ix="3">97</elt>
18265 + <elt ix="4">96</elt>
18266 + <elt ix="5">95</elt>
18267 + <elt ix="6">94</elt>
18268 + <elt ix="7">93</elt>
18269 + <elt ix="8">92</elt>
18270 + <elt ix="9">91</elt>
18271 + <elt ix="10">90</elt>
18272 + <elt ix="11">89</elt>
18273 + <elt ix="12">88</elt>
18274 + <elt ix="13">87</elt>
18275 + <elt ix="14">86</elt>
18276 + <elt ix="15">85</elt>
18277 + <elt ix="16">84</elt>
18278 + </array>
18279 + , NULL) Returning MyArray
18280 +
18281 + Journal Entry = jeQuery(Query)
18282 + Timestamp = 2021/12/07 11:09:48.0840
18283 + Session ID = 1
18284 + Transaction ID = 10
18285 + 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">
18286 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
18287 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
18288 + 01000000010000001A01050001000000DA000000
18289 + </blob>
18290 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
18291 + Give me excess of it, that, surfeiting,
18292 + The appetite may sicken, and so die.
18293 + That strain again! it had a dying fall:
18294 + O, it came o''er my ear like the sweet south,
18295 + That breathes upon a bank of violets,
18296 + Stealing and giving odour! Enough; no more:
18297 + ''Tis not so sweet now as it was before.
18298 + O spirit of love! how quick and fresh art thou,
18299 + That, notwithstanding thy capacity      10
18300 + Receiveth as the sea, nought enters there,
18301 + Of what validity and pitch soe''er,
18302 + But falls into abatement and low price,
18303 + Even in a minute: so full of shapes is fancy
18304 + That it alone is high fantastical.
18305 +
18306 + Si la musique est la nourriture de l''amour, continuez à jouer;
18307 + Donnez-m''en un excès, que, surexcité,
18308 + L''appétit peut devenir malade et ainsi mourir.
18309 + Cette souche encore! il a eu une chute mourante:
18310 + Oh, ça m''est venu à l''oreille comme le doux sud,
18311 + Qui souffle sur une banque de violettes,
18312 + Voler et donner de l''odeur! Assez; Pas plus:
18313 + «Ce n''est pas si doux maintenant qu''avant.
18314 + O esprit d''amour! comme tu es rapide et fraîche,
18315 + Que, malgré ta capacité 10
18316 + Reçoit comme la mer, rien n''y entre,
18317 + De quelle validité et de quelle hauteur soe''er,
18318 + Mais tombe dans l''abattement et le prix bas,
18319 + Même en une minute: si plein de formes est fantaisie
18320 + Que cela seul est fantastique.
18321 +
18322 +
18323 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
18324 + <elt ix="0">100</elt>
18325 + <elt ix="1">99</elt>
18326 + <elt ix="2">98</elt>
18327 + <elt ix="3">97</elt>
18328 + <elt ix="4">96</elt>
18329 + <elt ix="5">95</elt>
18330 + <elt ix="6">94</elt>
18331 + <elt ix="7">93</elt>
18332 + <elt ix="8">92</elt>
18333 + <elt ix="9">91</elt>
18334 + <elt ix="10">90</elt>
18335 + <elt ix="11">89</elt>
18336 + <elt ix="12">88</elt>
18337 + <elt ix="13">87</elt>
18338 + <elt ix="14">86</elt>
18339 + <elt ix="15">85</elt>
18340 + <elt ix="16">84</elt>
18341 + </array>
18342 + , NULL) Returning MyArray
18343 +
18344 + Journal Entry = jeQuery(Query)
18345 + Timestamp = 2021/12/07 11:09:48.1180
18346 + Session ID = 1
18347 + Transaction ID = 10
18348 + 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">
18349 + <elt ix="0">100</elt>
18350 + <elt ix="1">99</elt>
18351 + <elt ix="2">98</elt>
18352 + <elt ix="3">97</elt>
18353 + <elt ix="4">96</elt>
18354 + <elt ix="5">95</elt>
18355 + <elt ix="6">94</elt>
18356 + <elt ix="7">93</elt>
18357 + <elt ix="8">92</elt>
18358 + <elt ix="9">91</elt>
18359 + <elt ix="10">90</elt>
18360 + <elt ix="11">89</elt>
18361 + <elt ix="12">88</elt>
18362 + <elt ix="13">87</elt>
18363 + <elt ix="14">86</elt>
18364 + <elt ix="15">85</elt>
18365 + <elt ix="16">84</elt>
18366 + </array>
18367 + ,   A.My Field  = 'My Field',  A.MY Field = 'MY Field',  A.GRANTS = NULL Where A.TABLEKEY = 2 RETURNING A.MyArray
18368 +
18369 + Journal Entry = jeTransCommit(Commit)
18370 + Timestamp = 2021/12/07 11:09:48.2130
18371 + Session ID = 1
18372 + Transaction ID = 10
18373 +
18374 + Journal Entry = jeTransStart(Transaction Start)
18375 + Timestamp = 2021/12/07 11:09:48.2260
18376 + Session ID = 1
18377 + Transaction ID = 12
18378 + Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
18379 + TPB: Item Count = 3
18380 +  isc_tpb_concurrency
18381 +  isc_tpb_wait
18382 +  isc_tpb_write
18383 +
18384 + Default Completion = TACommit
18385 +
18386 + Journal Entry = jeQuery(Query)
18387 + Timestamp = 2021/12/07 11:09:48.4910
18388 + Session ID = 1
18389 + Transaction ID = 12
18390 + Query = Delete From IBXTEST A Where A.TABLEKEY = 1
18391 +
18392 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
18393 + Timestamp = 2021/12/07 11:09:48.6890
18394 + Session ID = 1
18395 + Transaction ID = 14
18396 + Old TransactionID = 12
18397 +
18398 + Journal Entry = jeQuery(Query)
18399 + Timestamp = 2021/12/07 11:09:48.9240
18400 + Session ID = 1
18401 + Transaction ID = 14
18402 + Query = Delete From IBXTEST A Where A.TABLEKEY = 1
18403 +
18404 + Journal Entry = jeTransRollback(Rollback)
18405 + Timestamp = 2021/12/07 11:09:49.1130
18406 + Session ID = 1
18407 + Transaction ID = 14
18408 +
18409 + Journal Entry = jeTransStart(Transaction Start)
18410 + Timestamp = 2021/12/07 11:09:49.1320
18411 + Session ID = 1
18412 + Transaction ID = 15
18413 + Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
18414 + TPB: Item Count = 3
18415 +  isc_tpb_concurrency
18416 +  isc_tpb_wait
18417 +  isc_tpb_write
18418 +
18419 + Default Completion = TACommit
18420 +
18421 + Journal Entry = jeQuery(Query)
18422 + Timestamp = 2021/12/07 11:09:49.4250
18423 + Session ID = 1
18424 + Transaction ID = 15
18425 + 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">
18426 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
18427 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
18428 + 01000000010000001A01050001000000DA000000
18429 + </blob>
18430 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
18431 + Give me excess of it, that, surfeiting,
18432 + The appetite may sicken, and so die.
18433 + That strain again! it had a dying fall:
18434 + O, it came o''er my ear like the sweet south,
18435 + That breathes upon a bank of violets,
18436 + Stealing and giving odour! Enough; no more:
18437 + ''Tis not so sweet now as it was before.
18438 + O spirit of love! how quick and fresh art thou,
18439 + That, notwithstanding thy capacity      10
18440 + Receiveth as the sea, nought enters there,
18441 + Of what validity and pitch soe''er,
18442 + But falls into abatement and low price,
18443 + Even in a minute: so full of shapes is fancy
18444 + That it alone is high fantastical.
18445 +
18446 + Si la musique est la nourriture de l''amour, continuez à jouer;
18447 + Donnez-m''en un excès, que, surexcité,
18448 + L''appétit peut devenir malade et ainsi mourir.
18449 + Cette souche encore! il a eu une chute mourante:
18450 + Oh, ça m''est venu à l''oreille comme le doux sud,
18451 + Qui souffle sur une banque de violettes,
18452 + Voler et donner de l''odeur! Assez; Pas plus:
18453 + «Ce n''est pas si doux maintenant qu''avant.
18454 + O esprit d''amour! comme tu es rapide et fraîche,
18455 + Que, malgré ta capacité 10
18456 + Reçoit comme la mer, rien n''y entre,
18457 + De quelle validité et de quelle hauteur soe''er,
18458 + Mais tombe dans l''abattement et le prix bas,
18459 + Même en une minute: si plein de formes est fantaisie
18460 + Que cela seul est fantastique.
18461 +
18462 +
18463 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
18464 + <elt ix="0">100</elt>
18465 + <elt ix="1">99</elt>
18466 + <elt ix="2">98</elt>
18467 + <elt ix="3">97</elt>
18468 + <elt ix="4">96</elt>
18469 + <elt ix="5">95</elt>
18470 + <elt ix="6">94</elt>
18471 + <elt ix="7">93</elt>
18472 + <elt ix="8">92</elt>
18473 + <elt ix="9">91</elt>
18474 + <elt ix="10">90</elt>
18475 + <elt ix="11">89</elt>
18476 + <elt ix="12">88</elt>
18477 + <elt ix="13">87</elt>
18478 + <elt ix="14">86</elt>
18479 + <elt ix="15">85</elt>
18480 + <elt ix="16">84</elt>
18481 + </array>
18482 + , NULL) Returning MyArray
18483 +
18484 + Journal Entry = jeTransCommitRet(Commit Retaining)
18485 + Timestamp = 2021/12/07 11:09:49.6060
18486 + Session ID = 1
18487 + Transaction ID = 17
18488 + Old TransactionID = 15
18489 +
18490 + Journal Entry = jeTransCommit(Commit)
18491 + Timestamp = 2021/12/07 11:09:49.9880
18492 + Session ID = 1
18493 + Transaction ID = 17
18494 +
18495 + Journal Entry = jeTransStart(Transaction Start)
18496 + Timestamp = 2021/12/07 11:09:50.0030
18497 + Session ID = 1
18498 + Transaction ID = 18
18499 + Transaction Name = "{20003B11-428F-4AE2-BD86-F56556AE7032}"
18500 + TPB: Item Count = 3
18501 +  isc_tpb_concurrency
18502 +  isc_tpb_wait
18503 +  isc_tpb_write
18504 +
18505 + Default Completion = TACommit
18506 +
18507 + Journal Entry = jeTransRollback(Rollback)
18508 + Timestamp = 2021/12/07 11:09:50.4720
18509 + Session ID = 1
18510 + Transaction ID = 18
18511 +
18512 +
18513 +
18514   ------------------------------------------------------
18515   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines