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

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

# Line 644 | Line 644 | Rows printed = 42
644   Current memory = 19,651,872
645   Delta memory = 13,040
646   Max memory = 19,780,144
647 < Elapsed time= 0.026 sec
647 > Elapsed time= 0.019 sec
648   Cpu = 0.010 sec
649   Buffers = 2048
650   Reads = 2
# Line 1445 | Line 1445 | DPB: Item Count = 3
1445    isc_dpb_lc_ctype = UTF8
1446  
1447   Before Disconnect
1448 < inet://localhost/employee Disconnected after 19 ms
1448 > inet://localhost/employee Disconnected after 23 ms
1449   Before Connect
1450   Connected to inet://localhost/employee
1451   DPB: Item Count = 3
# Line 1454 | Line 1454 | DPB: Item Count = 3
1454    isc_dpb_lc_ctype = UTF8
1455  
1456   Before Disconnect
1457 < inet://localhost/employee Disconnected after 4018 ms
1457 > inet://localhost/employee Disconnected after 3967 ms
1458   Idle Timer Expired for Test_Database_02
1459   Database Closed
1460   Transaction Events
# Line 1506 | Line 1506 | DPB: Item Count = 4
1506  
1507   inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created
1508   Before Disconnect
1509 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 15 ms
1509 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 14 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 | DPB: Item Count = 3
1516    isc_dpb_lc_ctype = UTF8
1517  
1518   Before Disconnect
1519 < inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms
1519 > inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 23 ms
1520  
1521  
1522   ------------------------------------------------------
# Line 3171 | Line 3171 | DEPT_KEY_PATH = 000;600;620;622 (Charset
3171   Current memory = 19,654,224
3172   Delta memory = 13,072
3173   Max memory = 19,730,048
3174 < Elapsed time= 0.023 sec
3174 > Elapsed time= 0.027 sec
3175   Cpu = 0.020 sec
3176   Buffers = 2048
3177   Reads = 2
# Line 3428 | Line 3428 | JOB_COUNTRY = USA
3428   SALARY = 105,900.00
3429   FULL_NAME = Nelson, Robert
3430   Do Fetch Last:
3431 < EMP_NO = 145
3432 < FIRST_NAME = Mark
3433 < LAST_NAME = Guckenheimer
3434 < PHONE_EXT = 221
3435 < HIRE_DATE = 1994/05/02 00:00:00.0000
3436 < DEPT_NO = 622
3437 < JOB_CODE = Eng
3438 < JOB_GRADE = 5
3439 < JOB_COUNTRY = USA
3440 < SALARY = 32,000.00
3441 < FULL_NAME = Guckenheimer, Mark
3442 < Do Fetch Prior:
3443 < EMP_NO = 144
3444 < FIRST_NAME = John
3445 < LAST_NAME = Montgomery
3446 < PHONE_EXT = 820
3447 < HIRE_DATE = 1994/03/30 00:00:00.0000
3448 < DEPT_NO = 672
3449 < JOB_CODE = Eng
3450 < JOB_GRADE = 5
3451 < JOB_COUNTRY = USA
3452 < SALARY = 35,000.00
3453 < FULL_NAME = Montgomery, John
3454 < Do Fetch First:
3455 < EMP_NO = 2
3456 < FIRST_NAME = Robert
3457 < LAST_NAME = Nelson
3458 < PHONE_EXT = 250
3459 < HIRE_DATE = 1988/12/28 00:00:00.0000
3460 < DEPT_NO = 600
3461 < JOB_CODE = VP
3462 < JOB_GRADE = 2
3463 < JOB_COUNTRY = USA
3464 < SALARY = 105,900.00
3465 < FULL_NAME = Nelson, Robert
3466 < Do Fetch Abs 8 :
3467 < EMP_NO = 14
3468 < FIRST_NAME = Stewart
3469 < LAST_NAME = Hall
3470 < PHONE_EXT = 227
3471 < HIRE_DATE = 1990/06/04 00:00:00.0000
3472 < DEPT_NO = 900
3473 < JOB_CODE = Finan
3474 < JOB_GRADE = 3
3475 < JOB_COUNTRY = USA
3476 < SALARY = 69,482.63
3477 < FULL_NAME = Hall, Stewart
3478 < Do Fetch Relative -2 :
3479 < EMP_NO = 11
3480 < FIRST_NAME = K. J.
3481 < LAST_NAME = Weston
3482 < PHONE_EXT = 34
3483 < HIRE_DATE = 1990/01/17 00:00:00.0000
3484 < DEPT_NO = 130
3485 < JOB_CODE = SRep
3486 < JOB_GRADE = 4
3487 < JOB_COUNTRY = USA
3488 < SALARY = 86,292.94
3489 < FULL_NAME = Weston, K. J.
3490 < Do Fetch beyond EOF :
3491 < Fetch returned false
3492 <
3493 <
3431 > Test Completed with Error: feature is not supported
3432   ------------------------------------------------------
3433   Running Test 08: TIBDataset: Locate, Bookmark and Lookup
3434   Field No 1 Name = EMP_NO DataType = ftSmallint
# Line 11989 | Line 11927 | Message File Location = /opt/firebird3.0
11927   Database Statistics for employee
11928  
11929   Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb"
11930 < Gstat execution time Sat Oct 23 13:38:43 2021
11930 > Gstat execution time Tue Dec  7 10:59:34 2021
11931  
11932   Database header page information:
11933   Flags                   0
11934 < Generation              4226
11934 > Generation              4544
11935   System Change Number    0
11936   Page size               8192
11937   ODS version             12.0
11938 < Oldest transaction      4708
11939 < Oldest active           4709
11940 < Oldest snapshot         4709
11941 < Next transaction        4709
11938 > Oldest transaction      5073
11939 > Oldest active           5074
11940 > Oldest snapshot         5074
11941 > Next transaction        5074
11942   Sequence number         0
11943 < Next attachment ID      4314
11943 > Next attachment ID      4601
11944   Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
11945   Shadow count            0
11946   Page buffers            0
# Line 12149 | Line 12087 | Fill distribution:
12087   60 - 79% = 0
12088   80 - 99% = 0
12089  
12090 < Gstat completion time Sat Oct 23 13:38:43 2021
12090 > Gstat completion time Tue Dec  7 10:59:34 2021
12091  
12092  
12093  
# Line 12159 | Line 12097 | zeus   Tue Jun  9 15:11:28 2020
12097   bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird
12098  
12099   Online Validation
12100 < 13:38:44.65 Validation started
12100 > 10:59:35.29 Validation started
12101  
12102 < 13:38:44.65 Relation 128 (COUNTRY)
12103 < 13:38:44.65   process pointer page    0 of    1
12104 < 13:38:44.65 Index 1 (RDB$PRIMARY1)
12105 < 13:38:44.65 Relation 128 (COUNTRY) is ok
12106 <
12107 < 13:38:44.65 Relation 129 (JOB)
12108 < 13:38:44.65   process pointer page    0 of    1
12109 < 13:38:44.65 Index 1 (RDB$PRIMARY2)
12110 < 13:38:44.65 Index 2 (RDB$FOREIGN3)
12111 < 13:38:44.65 Index 3 (MAXSALX)
12112 < 13:38:44.67 Index 4 (MINSALX)
12113 < 13:38:44.68 Relation 129 (JOB) is ok
12114 <
12115 < 13:38:44.68 Relation 130 (DEPARTMENT)
12116 < 13:38:44.68   process pointer page    0 of    1
12117 < 13:38:44.68 Index 1 (RDB$4)
12118 < 13:38:44.68 Index 2 (RDB$PRIMARY5)
12119 < 13:38:44.68 Index 3 (RDB$FOREIGN6)
12120 < 13:38:44.68 Index 4 (BUDGETX)
12121 < 13:38:44.68 Index 5 (RDB$FOREIGN10)
12122 < 13:38:44.68 Relation 130 (DEPARTMENT) is ok
12123 <
12124 < 13:38:44.68 Relation 131 (EMPLOYEE)
12125 < 13:38:44.68   process pointer page    0 of    1
12126 < 13:38:44.68 Index 1 (RDB$PRIMARY7)
12127 < 13:38:44.68 Index 2 (RDB$FOREIGN8)
12128 < 13:38:44.68 Index 3 (RDB$FOREIGN9)
12129 < 13:38:44.68 Index 4 (NAMEX)
12130 < 13:38:44.68 Relation 131 (EMPLOYEE) is ok
12131 <
12132 < 13:38:44.68 Relation 133 (PROJECT)
12133 < 13:38:44.68   process pointer page    0 of    1
12134 < 13:38:44.68 Index 1 (RDB$11)
12135 < 13:38:44.68 Index 2 (RDB$PRIMARY12)
12136 < 13:38:44.68 Index 3 (RDB$FOREIGN13)
12137 < 13:38:44.68 Index 4 (PRODTYPEX)
12138 < 13:38:44.69 Relation 133 (PROJECT) is ok
12139 <
12140 < 13:38:44.69 Relation 134 (EMPLOYEE_PROJECT)
12141 < 13:38:44.69   process pointer page    0 of    1
12142 < 13:38:44.69 Index 1 (RDB$PRIMARY14)
12143 < 13:38:44.69 Index 2 (RDB$FOREIGN15)
12144 < 13:38:44.69 Index 3 (RDB$FOREIGN16)
12145 < 13:38:44.69 Relation 134 (EMPLOYEE_PROJECT) is ok
12146 <
12147 < 13:38:44.69 Relation 135 (PROJ_DEPT_BUDGET)
12148 < 13:38:44.69   process pointer page    0 of    1
12149 < 13:38:44.70 Index 1 (RDB$PRIMARY17)
12150 < 13:38:44.70 Index 2 (RDB$FOREIGN18)
12151 < 13:38:44.70 Index 3 (RDB$FOREIGN19)
12152 < 13:38:44.70 Relation 135 (PROJ_DEPT_BUDGET) is ok
12153 <
12154 < 13:38:44.70 Relation 136 (SALARY_HISTORY)
12155 < 13:38:44.70   process pointer page    0 of    1
12156 < 13:38:44.70 Index 1 (RDB$PRIMARY20)
12157 < 13:38:44.70 Index 2 (RDB$FOREIGN21)
12158 < 13:38:44.70 Index 3 (CHANGEX)
12159 < 13:38:44.70 Index 4 (UPDATERX)
12160 < 13:38:44.70 Relation 136 (SALARY_HISTORY) is ok
12161 <
12162 < 13:38:44.70 Relation 137 (CUSTOMER)
12163 < 13:38:44.70   process pointer page    0 of    1
12164 < 13:38:44.70 Index 1 (RDB$PRIMARY22)
12165 < 13:38:44.70 Index 2 (RDB$FOREIGN23)
12166 < 13:38:44.70 Index 3 (CUSTNAMEX)
12167 < 13:38:44.70 Index 4 (CUSTREGION)
12168 < 13:38:44.70 Relation 137 (CUSTOMER) is ok
12169 <
12170 < 13:38:44.70 Relation 138 (SALES)
12171 < 13:38:44.70   process pointer page    0 of    1
12172 < 13:38:44.70 Index 1 (RDB$PRIMARY24)
12173 < 13:38:44.70 Index 2 (RDB$FOREIGN25)
12174 < 13:38:44.70 Index 3 (RDB$FOREIGN26)
12175 < 13:38:44.70 Index 4 (NEEDX)
12176 < 13:38:44.70 Index 5 (QTYX)
12177 < 13:38:44.70 Index 6 (SALESTATX)
12178 < 13:38:44.70 Relation 138 (SALES) is ok
12102 > 10:59:35.29 Relation 128 (COUNTRY)
12103 > 10:59:35.29   process pointer page    0 of    1
12104 > 10:59:35.29 Index 1 (RDB$PRIMARY1)
12105 > 10:59:35.29 Relation 128 (COUNTRY) is ok
12106 >
12107 > 10:59:35.29 Relation 129 (JOB)
12108 > 10:59:35.29   process pointer page    0 of    1
12109 > 10:59:35.29 Index 1 (RDB$PRIMARY2)
12110 > 10:59:35.29 Index 2 (RDB$FOREIGN3)
12111 > 10:59:35.29 Index 3 (MAXSALX)
12112 > 10:59:35.31 Index 4 (MINSALX)
12113 > 10:59:35.31 Relation 129 (JOB) is ok
12114 >
12115 > 10:59:35.31 Relation 130 (DEPARTMENT)
12116 > 10:59:35.31   process pointer page    0 of    1
12117 > 10:59:35.31 Index 1 (RDB$4)
12118 > 10:59:35.31 Index 2 (RDB$PRIMARY5)
12119 > 10:59:35.31 Index 3 (RDB$FOREIGN6)
12120 > 10:59:35.31 Index 4 (BUDGETX)
12121 > 10:59:35.31 Index 5 (RDB$FOREIGN10)
12122 > 10:59:35.31 Relation 130 (DEPARTMENT) is ok
12123 >
12124 > 10:59:35.31 Relation 131 (EMPLOYEE)
12125 > 10:59:35.32   process pointer page    0 of    1
12126 > 10:59:35.32 Index 1 (RDB$PRIMARY7)
12127 > 10:59:35.32 Index 2 (RDB$FOREIGN8)
12128 > 10:59:35.32 Index 3 (RDB$FOREIGN9)
12129 > 10:59:35.32 Index 4 (NAMEX)
12130 > 10:59:35.32 Relation 131 (EMPLOYEE) is ok
12131 >
12132 > 10:59:35.32 Relation 133 (PROJECT)
12133 > 10:59:35.32   process pointer page    0 of    1
12134 > 10:59:35.32 Index 1 (RDB$11)
12135 > 10:59:35.32 Index 2 (RDB$PRIMARY12)
12136 > 10:59:35.32 Index 3 (RDB$FOREIGN13)
12137 > 10:59:35.32 Index 4 (PRODTYPEX)
12138 > 10:59:35.32 Relation 133 (PROJECT) is ok
12139 >
12140 > 10:59:35.32 Relation 134 (EMPLOYEE_PROJECT)
12141 > 10:59:35.32   process pointer page    0 of    1
12142 > 10:59:35.32 Index 1 (RDB$PRIMARY14)
12143 > 10:59:35.32 Index 2 (RDB$FOREIGN15)
12144 > 10:59:35.32 Index 3 (RDB$FOREIGN16)
12145 > 10:59:35.32 Relation 134 (EMPLOYEE_PROJECT) is ok
12146 >
12147 > 10:59:35.32 Relation 135 (PROJ_DEPT_BUDGET)
12148 > 10:59:35.32   process pointer page    0 of    1
12149 > 10:59:35.33 Index 1 (RDB$PRIMARY17)
12150 > 10:59:35.33 Index 2 (RDB$FOREIGN18)
12151 > 10:59:35.33 Index 3 (RDB$FOREIGN19)
12152 > 10:59:35.33 Relation 135 (PROJ_DEPT_BUDGET) is ok
12153 >
12154 > 10:59:35.33 Relation 136 (SALARY_HISTORY)
12155 > 10:59:35.33   process pointer page    0 of    1
12156 > 10:59:35.33 Index 1 (RDB$PRIMARY20)
12157 > 10:59:35.33 Index 2 (RDB$FOREIGN21)
12158 > 10:59:35.33 Index 3 (CHANGEX)
12159 > 10:59:35.33 Index 4 (UPDATERX)
12160 > 10:59:35.33 Relation 136 (SALARY_HISTORY) is ok
12161 >
12162 > 10:59:35.33 Relation 137 (CUSTOMER)
12163 > 10:59:35.33   process pointer page    0 of    1
12164 > 10:59:35.33 Index 1 (RDB$PRIMARY22)
12165 > 10:59:35.33 Index 2 (RDB$FOREIGN23)
12166 > 10:59:35.33 Index 3 (CUSTNAMEX)
12167 > 10:59:35.33 Index 4 (CUSTREGION)
12168 > 10:59:35.33 Relation 137 (CUSTOMER) is ok
12169 >
12170 > 10:59:35.33 Relation 138 (SALES)
12171 > 10:59:35.33   process pointer page    0 of    1
12172 > 10:59:35.33 Index 1 (RDB$PRIMARY24)
12173 > 10:59:35.33 Index 2 (RDB$FOREIGN25)
12174 > 10:59:35.33 Index 3 (RDB$FOREIGN26)
12175 > 10:59:35.33 Index 4 (NEEDX)
12176 > 10:59:35.33 Index 5 (QTYX)
12177 > 10:59:35.33 Index 6 (SALESTATX)
12178 > 10:59:35.33 Relation 138 (SALES) is ok
12179  
12180 < 13:38:44.70 Validation finished
12180 > 10:59:35.33 Validation finished
12181  
12182  
12183   Normal Validation
# Line 13795 | Line 13733 | Rows printed = 2
13733   Current memory = 19,652,336
13734   Delta memory = 12,688
13735   Max memory = 19,780,960
13736 < Elapsed time= 0.104 sec
13737 < Cpu = 0.010 sec
13736 > Elapsed time= 0.103 sec
13737 > Cpu = 0.000 sec
13738   Buffers = 2048
13739   Reads = 2
13740   Writes = 0
# Line 15413 | Line 15351 | Create Table LotsOfData (
15351      MyText VarChar(1024),
15352      Primary Key (RowID)
15353    );                
15354 < Loading data into database table. Started at 23/10/2021 13:39:35.904
15355 < Data load completed at 23/10/2021 13:41:21.474 Elapsed Time = 105570 ms, 100000 records loaded
15356 < Message Hash = 74ca9d8999ced80d351dfb9f693ac23e
15357 < Database Read started at 23/10/2021 13:41:21.484
15358 < Read Dataset completed at 23/10/2021 13:41:51.025 Elapsed Time = 29541 ms, 100000 records read
15359 < Message Hash = 74ca9d8999ced80d351dfb9f693ac23e
15354 > Loading data into database table. Started at 07/12/2021 11:00:25.567
15355 > Data load completed at 07/12/2021 11:02:25.474 Elapsed Time = 119907 ms, 100000 records loaded
15356 > Message Hash = 977f458d39d2649ac5fb981ea5986e56
15357 > Database Read started at 07/12/2021 11:02:25.483
15358 > Read Dataset completed at 07/12/2021 11:02:55.671 Elapsed Time = 30188 ms, 100000 records read
15359 > Message Hash = 977f458d39d2649ac5fb981ea5986e56
15360   Test Completed successfully
15361 < 23/10/2021 13:41:51.026 Test 21 passes as long as the checksums are identical
15361 > 07/12/2021 11:02:55.671 Test 21 passes as long as the checksums are identical
15362  
15363  
15364   ------------------------------------------------------
# Line 15455 | Line 15393 | SEC$MIDDLE_NAME = NULL
15393   SEC$LAST_NAME = Tester (Charset = UTF8 Codepage = 65001)
15394   SEC$PASSWORD = NULL
15395   LOGGEDIN = False
15396 < DBCREATOR = True
15396 > DBCREATOR = False
15397  
15398   Row No = 2
15399   SEC$DESCRIPTION = NULL
# Line 17498 | Line 17436 | SET TERM ;^
17436  
17437  
17438  
17439 + ------------------------------------------------------
17440 + Running Test 29: Test 29: IBJournal Tests
17441 + Creating Database from resources/Test29.sql
17442 +
17443 + Create Table IBXTest (
17444 + TableKey Integer not null,
17445 + F1 Smallint,
17446 + F2 Float,
17447 + F3 Double Precision,
17448 + F4 Decimal(9,3),
17449 + F5 Decimal(18,4),
17450 + F6 Date,
17451 + F7 Timestamp,
17452 + F8 Char (2),
17453 + F9 VarChar(256),
17454 + F10 Blob,
17455 + F11 BigInt,
17456 + "f12" Integer,
17457 + F13 Time,
17458 + F14 Blob sub_type text,
17459 + MyArray Integer [0:16],
17460 + "GRANTS" VarChar(20),
17461 + "My Field" VarChar(32),
17462 + "MY Field" VarChar(32),
17463 + Primary Key(TableKey)
17464 + );
17465 +
17466 + Create Generator IBXGen;
17467 + Add a record
17468 + Add and edit a record
17469 + Row No = 1
17470 + TABLEKEY = 1
17471 + F1 = 2
17472 + F2 = 0.314000010490
17473 + F3 = 0.314123456780
17474 + F4 = 101.314
17475 + F5 = 101.99
17476 + F6 = 25/12/2007
17477 + F7 = 25/12/2007 12:30:29.130
17478 + F8 = XX (Charset = UTF8 Codepage = 65001)
17479 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17480 + F10 = (blob), Length = 100
17481 + F11 = 9223372036854775807
17482 + F12 = 65566
17483 + F13 = 12:30:45.000
17484 + F14 (Charset  = UTF8 Codepage = 65001)
17485 +
17486 + If music be the food of love, play on;
17487 + Give me excess of it, that, surfeiting,
17488 + The appetite may sicken, and so die.
17489 + That strain again! it had a dying fall:
17490 + O, it came o'er my ear like the sweet south,
17491 + That breathes upon a bank of violets,
17492 + Stealing and giving odour! Enough; no more:
17493 + 'Tis not so sweet now as it was before.
17494 + O spirit of love! how quick and fresh art thou,
17495 + That, notwithstanding thy capacity      10
17496 + Receiveth as the sea, nought enters there,
17497 + Of what validity and pitch soe'er,
17498 + But falls into abatement and low price,
17499 + Even in a minute: so full of shapes is fancy
17500 + That it alone is high fantastical.
17501 +
17502 + Si la musique est la nourriture de l'amour, continuez à jouer;
17503 + Donnez-m'en un excès, que, surexcité,
17504 + L'appétit peut devenir malade et ainsi mourir.
17505 + Cette souche encore! il a eu une chute mourante:
17506 + Oh, ça m'est venu à l'oreille comme le doux sud,
17507 + Qui souffle sur une banque de violettes,
17508 + Voler et donner de l'odeur! Assez; Pas plus:
17509 + «Ce n'est pas si doux maintenant qu'avant.
17510 + O esprit d'amour! comme tu es rapide et fraîche,
17511 + Que, malgré ta capacité 10
17512 + Reçoit comme la mer, rien n'y entre,
17513 + De quelle validité et de quelle hauteur soe'er,
17514 + Mais tombe dans l'abattement et le prix bas,
17515 + Même en une minute: si plein de formes est fantaisie
17516 + Que cela seul est fantastique.
17517 +
17518 +
17519 +
17520 + 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)
17521 +
17522 + GRANTS = NULL
17523 + MYFIELD1 = NULL
17524 + MYFIELD2 = NULL
17525 +
17526 + Row No = 2
17527 + TABLEKEY = 2
17528 + F1 = 2
17529 + F2 = 0.314000010490
17530 + F3 = 0.314123456780
17531 + F4 = 101.314
17532 + F5 = 101.99
17533 + F6 = 25/12/2007
17534 + F7 = 25/12/2007 12:30:29.130
17535 + F8 = XX (Charset = UTF8 Codepage = 65001)
17536 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17537 + F10 = NULL
17538 + F11 = 9223372036854775807
17539 + F12 = 65566
17540 + F13 = 12:30:45.000
17541 + F14 = NULL
17542 + 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)
17543 +
17544 + GRANTS = NULL
17545 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17546 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17547 +
17548 + Rows printed = 2
17549 +
17550 + Delete a record
17551 + Row No = 1
17552 + TABLEKEY = 2
17553 + F1 = 2
17554 + F2 = 0.314000010490
17555 + F3 = 0.314123456780
17556 + F4 = 101.314
17557 + F5 = 101.99
17558 + F6 = 25/12/2007
17559 + F7 = 25/12/2007 12:30:29.130
17560 + F8 = XX (Charset = UTF8 Codepage = 65001)
17561 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17562 + F10 = NULL
17563 + F11 = 9223372036854775807
17564 + F12 = 65566
17565 + F13 = 12:30:45.000
17566 + F14 = NULL
17567 + 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)
17568 +
17569 + GRANTS = NULL
17570 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17571 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17572 +
17573 + Rows printed = 1
17574 +
17575 + Rollback Retaining
17576 + Row No = 1
17577 + TABLEKEY = 1
17578 + F1 = 2
17579 + F2 = 0.314000010490
17580 + F3 = 0.314123456780
17581 + F4 = 101.314
17582 + F5 = 101.99
17583 + F6 = 25/12/2007
17584 + F7 = 25/12/2007 12:30:29.130
17585 + F8 = XX (Charset = UTF8 Codepage = 65001)
17586 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17587 + F10 = (blob), Length = 100
17588 + F11 = 9223372036854775807
17589 + F12 = 65566
17590 + F13 = 12:30:45.000
17591 + F14 (Charset  = UTF8 Codepage = 65001)
17592 +
17593 + If music be the food of love, play on;
17594 + Give me excess of it, that, surfeiting,
17595 + The appetite may sicken, and so die.
17596 + That strain again! it had a dying fall:
17597 + O, it came o'er my ear like the sweet south,
17598 + That breathes upon a bank of violets,
17599 + Stealing and giving odour! Enough; no more:
17600 + 'Tis not so sweet now as it was before.
17601 + O spirit of love! how quick and fresh art thou,
17602 + That, notwithstanding thy capacity      10
17603 + Receiveth as the sea, nought enters there,
17604 + Of what validity and pitch soe'er,
17605 + But falls into abatement and low price,
17606 + Even in a minute: so full of shapes is fancy
17607 + That it alone is high fantastical.
17608 +
17609 + Si la musique est la nourriture de l'amour, continuez à jouer;
17610 + Donnez-m'en un excès, que, surexcité,
17611 + L'appétit peut devenir malade et ainsi mourir.
17612 + Cette souche encore! il a eu une chute mourante:
17613 + Oh, ça m'est venu à l'oreille comme le doux sud,
17614 + Qui souffle sur une banque de violettes,
17615 + Voler et donner de l'odeur! Assez; Pas plus:
17616 + «Ce n'est pas si doux maintenant qu'avant.
17617 + O esprit d'amour! comme tu es rapide et fraîche,
17618 + Que, malgré ta capacité 10
17619 + Reçoit comme la mer, rien n'y entre,
17620 + De quelle validité et de quelle hauteur soe'er,
17621 + Mais tombe dans l'abattement et le prix bas,
17622 + Même en une minute: si plein de formes est fantaisie
17623 + Que cela seul est fantastique.
17624 +
17625 +
17626 +
17627 + 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)
17628 +
17629 + GRANTS = NULL
17630 + MYFIELD1 = NULL
17631 + MYFIELD2 = NULL
17632 +
17633 + Row No = 2
17634 + TABLEKEY = 2
17635 + F1 = 2
17636 + F2 = 0.314000010490
17637 + F3 = 0.314123456780
17638 + F4 = 101.314
17639 + F5 = 101.99
17640 + F6 = 25/12/2007
17641 + F7 = 25/12/2007 12:30:29.130
17642 + F8 = XX (Charset = UTF8 Codepage = 65001)
17643 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17644 + F10 = NULL
17645 + F11 = 9223372036854775807
17646 + F12 = 65566
17647 + F13 = 12:30:45.000
17648 + F14 = NULL
17649 + 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)
17650 +
17651 + GRANTS = NULL
17652 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17653 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17654 +
17655 + Rows printed = 2
17656 +
17657 + Delete a record
17658 + Row No = 1
17659 + TABLEKEY = 2
17660 + F1 = 2
17661 + F2 = 0.314000010490
17662 + F3 = 0.314123456780
17663 + F4 = 101.314
17664 + F5 = 101.99
17665 + F6 = 25/12/2007
17666 + F7 = 25/12/2007 12:30:29.130
17667 + F8 = XX (Charset = UTF8 Codepage = 65001)
17668 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17669 + F10 = NULL
17670 + F11 = 9223372036854775807
17671 + F12 = 65566
17672 + F13 = 12:30:45.000
17673 + F14 = NULL
17674 + 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)
17675 +
17676 + GRANTS = NULL
17677 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17678 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17679 +
17680 + Rows printed = 1
17681 +
17682 + Rollback
17683 + Row No = 1
17684 + TABLEKEY = 1
17685 + F1 = 2
17686 + F2 = 0.314000010490
17687 + F3 = 0.314123456780
17688 + F4 = 101.314
17689 + F5 = 101.99
17690 + F6 = 25/12/2007
17691 + F7 = 25/12/2007 12:30:29.130
17692 + F8 = XX (Charset = UTF8 Codepage = 65001)
17693 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17694 + F10 = (blob), Length = 100
17695 + F11 = 9223372036854775807
17696 + F12 = 65566
17697 + F13 = 12:30:45.000
17698 + F14 (Charset  = UTF8 Codepage = 65001)
17699 +
17700 + If music be the food of love, play on;
17701 + Give me excess of it, that, surfeiting,
17702 + The appetite may sicken, and so die.
17703 + That strain again! it had a dying fall:
17704 + O, it came o'er my ear like the sweet south,
17705 + That breathes upon a bank of violets,
17706 + Stealing and giving odour! Enough; no more:
17707 + 'Tis not so sweet now as it was before.
17708 + O spirit of love! how quick and fresh art thou,
17709 + That, notwithstanding thy capacity      10
17710 + Receiveth as the sea, nought enters there,
17711 + Of what validity and pitch soe'er,
17712 + But falls into abatement and low price,
17713 + Even in a minute: so full of shapes is fancy
17714 + That it alone is high fantastical.
17715 +
17716 + Si la musique est la nourriture de l'amour, continuez à jouer;
17717 + Donnez-m'en un excès, que, surexcité,
17718 + L'appétit peut devenir malade et ainsi mourir.
17719 + Cette souche encore! il a eu une chute mourante:
17720 + Oh, ça m'est venu à l'oreille comme le doux sud,
17721 + Qui souffle sur une banque de violettes,
17722 + Voler et donner de l'odeur! Assez; Pas plus:
17723 + «Ce n'est pas si doux maintenant qu'avant.
17724 + O esprit d'amour! comme tu es rapide et fraîche,
17725 + Que, malgré ta capacité 10
17726 + Reçoit comme la mer, rien n'y entre,
17727 + De quelle validité et de quelle hauteur soe'er,
17728 + Mais tombe dans l'abattement et le prix bas,
17729 + Même en une minute: si plein de formes est fantaisie
17730 + Que cela seul est fantastique.
17731 +
17732 +
17733 +
17734 + 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)
17735 +
17736 + GRANTS = NULL
17737 + MYFIELD1 = NULL
17738 + MYFIELD2 = NULL
17739 +
17740 + Row No = 2
17741 + TABLEKEY = 2
17742 + F1 = 2
17743 + F2 = 0.314000010490
17744 + F3 = 0.314123456780
17745 + F4 = 101.314
17746 + F5 = 101.99
17747 + F6 = 25/12/2007
17748 + F7 = 25/12/2007 12:30:29.130
17749 + F8 = XX (Charset = UTF8 Codepage = 65001)
17750 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17751 + F10 = NULL
17752 + F11 = 9223372036854775807
17753 + F12 = 65566
17754 + F13 = 12:30:45.000
17755 + F14 = NULL
17756 + 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)
17757 +
17758 + GRANTS = NULL
17759 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17760 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17761 +
17762 + Rows printed = 2
17763 +
17764 + Commit Retaining
17765 + Row No = 1
17766 + TABLEKEY = 1
17767 + F1 = 2
17768 + F2 = 0.314000010490
17769 + F3 = 0.314123456780
17770 + F4 = 101.314
17771 + F5 = 101.99
17772 + F6 = 25/12/2007
17773 + F7 = 25/12/2007 12:30:29.130
17774 + F8 = XX (Charset = UTF8 Codepage = 65001)
17775 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17776 + F10 = (blob), Length = 100
17777 + F11 = 9223372036854775807
17778 + F12 = 65566
17779 + F13 = 12:30:45.000
17780 + F14 (Charset  = UTF8 Codepage = 65001)
17781 +
17782 + If music be the food of love, play on;
17783 + Give me excess of it, that, surfeiting,
17784 + The appetite may sicken, and so die.
17785 + That strain again! it had a dying fall:
17786 + O, it came o'er my ear like the sweet south,
17787 + That breathes upon a bank of violets,
17788 + Stealing and giving odour! Enough; no more:
17789 + 'Tis not so sweet now as it was before.
17790 + O spirit of love! how quick and fresh art thou,
17791 + That, notwithstanding thy capacity      10
17792 + Receiveth as the sea, nought enters there,
17793 + Of what validity and pitch soe'er,
17794 + But falls into abatement and low price,
17795 + Even in a minute: so full of shapes is fancy
17796 + That it alone is high fantastical.
17797 +
17798 + Si la musique est la nourriture de l'amour, continuez à jouer;
17799 + Donnez-m'en un excès, que, surexcité,
17800 + L'appétit peut devenir malade et ainsi mourir.
17801 + Cette souche encore! il a eu une chute mourante:
17802 + Oh, ça m'est venu à l'oreille comme le doux sud,
17803 + Qui souffle sur une banque de violettes,
17804 + Voler et donner de l'odeur! Assez; Pas plus:
17805 + «Ce n'est pas si doux maintenant qu'avant.
17806 + O esprit d'amour! comme tu es rapide et fraîche,
17807 + Que, malgré ta capacité 10
17808 + Reçoit comme la mer, rien n'y entre,
17809 + De quelle validité et de quelle hauteur soe'er,
17810 + Mais tombe dans l'abattement et le prix bas,
17811 + Même en une minute: si plein de formes est fantaisie
17812 + Que cela seul est fantastique.
17813 +
17814 +
17815 +
17816 + 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)
17817 +
17818 + GRANTS = NULL
17819 + MYFIELD1 = NULL
17820 + MYFIELD2 = NULL
17821 +
17822 + Row No = 2
17823 + TABLEKEY = 2
17824 + F1 = 2
17825 + F2 = 0.314000010490
17826 + F3 = 0.314123456780
17827 + F4 = 101.314
17828 + F5 = 101.99
17829 + F6 = 25/12/2007
17830 + F7 = 25/12/2007 12:30:29.130
17831 + F8 = XX (Charset = UTF8 Codepage = 65001)
17832 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17833 + F10 = NULL
17834 + F11 = 9223372036854775807
17835 + F12 = 65566
17836 + F13 = 12:30:45.000
17837 + F14 = NULL
17838 + 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)
17839 +
17840 + GRANTS = NULL
17841 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17842 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17843 +
17844 + Row No = 3
17845 + TABLEKEY = 3
17846 + F1 = 2
17847 + F2 = 0.314000010490
17848 + F3 = 0.314123456780
17849 + F4 = 101.314
17850 + F5 = 101.99
17851 + F6 = 25/12/2007
17852 + F7 = 25/12/2007 12:30:29.130
17853 + F8 = XX (Charset = UTF8 Codepage = 65001)
17854 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17855 + F10 = (blob), Length = 100
17856 + F11 = 9223372036854775807
17857 + F12 = 65566
17858 + F13 = 12:30:45.000
17859 + F14 (Charset  = UTF8 Codepage = 65001)
17860 +
17861 + If music be the food of love, play on;
17862 + Give me excess of it, that, surfeiting,
17863 + The appetite may sicken, and so die.
17864 + That strain again! it had a dying fall:
17865 + O, it came o'er my ear like the sweet south,
17866 + That breathes upon a bank of violets,
17867 + Stealing and giving odour! Enough; no more:
17868 + 'Tis not so sweet now as it was before.
17869 + O spirit of love! how quick and fresh art thou,
17870 + That, notwithstanding thy capacity      10
17871 + Receiveth as the sea, nought enters there,
17872 + Of what validity and pitch soe'er,
17873 + But falls into abatement and low price,
17874 + Even in a minute: so full of shapes is fancy
17875 + That it alone is high fantastical.
17876 +
17877 + Si la musique est la nourriture de l'amour, continuez à jouer;
17878 + Donnez-m'en un excès, que, surexcité,
17879 + L'appétit peut devenir malade et ainsi mourir.
17880 + Cette souche encore! il a eu une chute mourante:
17881 + Oh, ça m'est venu à l'oreille comme le doux sud,
17882 + Qui souffle sur une banque de violettes,
17883 + Voler et donner de l'odeur! Assez; Pas plus:
17884 + «Ce n'est pas si doux maintenant qu'avant.
17885 + O esprit d'amour! comme tu es rapide et fraîche,
17886 + Que, malgré ta capacité 10
17887 + Reçoit comme la mer, rien n'y entre,
17888 + De quelle validité et de quelle hauteur soe'er,
17889 + Mais tombe dans l'abattement et le prix bas,
17890 + Même en une minute: si plein de formes est fantaisie
17891 + Que cela seul est fantastique.
17892 +
17893 +
17894 +
17895 + 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)
17896 +
17897 + GRANTS = NULL
17898 + MYFIELD1 = NULL
17899 + MYFIELD2 = NULL
17900 +
17901 + Rows printed = 3
17902 +
17903 + Commit
17904 + Row No = 1
17905 + TABLEKEY = 1
17906 + F1 = 2
17907 + F2 = 0.314000010490
17908 + F3 = 0.314123456780
17909 + F4 = 101.314
17910 + F5 = 101.99
17911 + F6 = 25/12/2007
17912 + F7 = 25/12/2007 12:30:29.130
17913 + F8 = XX (Charset = UTF8 Codepage = 65001)
17914 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17915 + F10 = (blob), Length = 100
17916 + F11 = 9223372036854775807
17917 + F12 = 65566
17918 + F13 = 12:30:45.000
17919 + F14 (Charset  = UTF8 Codepage = 65001)
17920 +
17921 + If music be the food of love, play on;
17922 + Give me excess of it, that, surfeiting,
17923 + The appetite may sicken, and so die.
17924 + That strain again! it had a dying fall:
17925 + O, it came o'er my ear like the sweet south,
17926 + That breathes upon a bank of violets,
17927 + Stealing and giving odour! Enough; no more:
17928 + 'Tis not so sweet now as it was before.
17929 + O spirit of love! how quick and fresh art thou,
17930 + That, notwithstanding thy capacity      10
17931 + Receiveth as the sea, nought enters there,
17932 + Of what validity and pitch soe'er,
17933 + But falls into abatement and low price,
17934 + Even in a minute: so full of shapes is fancy
17935 + That it alone is high fantastical.
17936 +
17937 + Si la musique est la nourriture de l'amour, continuez à jouer;
17938 + Donnez-m'en un excès, que, surexcité,
17939 + L'appétit peut devenir malade et ainsi mourir.
17940 + Cette souche encore! il a eu une chute mourante:
17941 + Oh, ça m'est venu à l'oreille comme le doux sud,
17942 + Qui souffle sur une banque de violettes,
17943 + Voler et donner de l'odeur! Assez; Pas plus:
17944 + «Ce n'est pas si doux maintenant qu'avant.
17945 + O esprit d'amour! comme tu es rapide et fraîche,
17946 + Que, malgré ta capacité 10
17947 + Reçoit comme la mer, rien n'y entre,
17948 + De quelle validité et de quelle hauteur soe'er,
17949 + Mais tombe dans l'abattement et le prix bas,
17950 + Même en une minute: si plein de formes est fantaisie
17951 + Que cela seul est fantastique.
17952 +
17953 +
17954 +
17955 + 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)
17956 +
17957 + GRANTS = NULL
17958 + MYFIELD1 = NULL
17959 + MYFIELD2 = NULL
17960 +
17961 + Row No = 2
17962 + TABLEKEY = 2
17963 + F1 = 2
17964 + F2 = 0.314000010490
17965 + F3 = 0.314123456780
17966 + F4 = 101.314
17967 + F5 = 101.99
17968 + F6 = 25/12/2007
17969 + F7 = 25/12/2007 12:30:29.130
17970 + F8 = XX (Charset = UTF8 Codepage = 65001)
17971 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17972 + F10 = NULL
17973 + F11 = 9223372036854775807
17974 + F12 = 65566
17975 + F13 = 12:30:45.000
17976 + F14 = NULL
17977 + 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)
17978 +
17979 + GRANTS = NULL
17980 + MYFIELD1 = My Field (Charset = UTF8 Codepage = 65001)
17981 + MYFIELD2 = MY Field (Charset = UTF8 Codepage = 65001)
17982 +
17983 + Row No = 3
17984 + TABLEKEY = 3
17985 + F1 = 2
17986 + F2 = 0.314000010490
17987 + F3 = 0.314123456780
17988 + F4 = 101.314
17989 + F5 = 101.99
17990 + F6 = 25/12/2007
17991 + F7 = 25/12/2007 12:30:29.130
17992 + F8 = XX (Charset = UTF8 Codepage = 65001)
17993 + F9 = The Quick Brown Fox jumps over the lazy dog (Charset = UTF8 Codepage = 65001)
17994 + F10 = (blob), Length = 100
17995 + F11 = 9223372036854775807
17996 + F12 = 65566
17997 + F13 = 12:30:45.000
17998 + F14 (Charset  = UTF8 Codepage = 65001)
17999 +
18000 + If music be the food of love, play on;
18001 + Give me excess of it, that, surfeiting,
18002 + The appetite may sicken, and so die.
18003 + That strain again! it had a dying fall:
18004 + O, it came o'er my ear like the sweet south,
18005 + That breathes upon a bank of violets,
18006 + Stealing and giving odour! Enough; no more:
18007 + 'Tis not so sweet now as it was before.
18008 + O spirit of love! how quick and fresh art thou,
18009 + That, notwithstanding thy capacity      10
18010 + Receiveth as the sea, nought enters there,
18011 + Of what validity and pitch soe'er,
18012 + But falls into abatement and low price,
18013 + Even in a minute: so full of shapes is fancy
18014 + That it alone is high fantastical.
18015 +
18016 + Si la musique est la nourriture de l'amour, continuez à jouer;
18017 + Donnez-m'en un excès, que, surexcité,
18018 + L'appétit peut devenir malade et ainsi mourir.
18019 + Cette souche encore! il a eu une chute mourante:
18020 + Oh, ça m'est venu à l'oreille comme le doux sud,
18021 + Qui souffle sur une banque de violettes,
18022 + Voler et donner de l'odeur! Assez; Pas plus:
18023 + «Ce n'est pas si doux maintenant qu'avant.
18024 + O esprit d'amour! comme tu es rapide et fraîche,
18025 + Que, malgré ta capacité 10
18026 + Reçoit comme la mer, rien n'y entre,
18027 + De quelle validité et de quelle hauteur soe'er,
18028 + Mais tombe dans l'abattement et le prix bas,
18029 + Même en une minute: si plein de formes est fantaisie
18030 + Que cela seul est fantastique.
18031 +
18032 +
18033 +
18034 + 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)
18035 +
18036 + GRANTS = NULL
18037 + MYFIELD1 = NULL
18038 + MYFIELD2 = NULL
18039 +
18040 + Rows printed = 3
18041 +
18042 + Journal Table
18043 + IBX$SESSIONID = 1
18044 + IBX$TRANSACTIONID = 10
18045 + IBX$OLDTRANSACTIONID = NULL
18046 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
18047 + IBX$CREATED = 2021/12/07 11:03:25.0870
18048 + IBX$SESSIONID = 1
18049 + IBX$TRANSACTIONID = 15
18050 + IBX$OLDTRANSACTIONID = NULL
18051 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
18052 + IBX$CREATED = 2021/12/07 11:03:26.2430
18053 + IBX$SESSIONID = 1
18054 + IBX$TRANSACTIONID = 17
18055 + IBX$OLDTRANSACTIONID = 15
18056 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
18057 + IBX$CREATED = 2021/12/07 11:03:26.6180
18058 + Journal Entries
18059 + Journal Entry = jeTransStart(Transaction Start)
18060 + Timestamp = 2021/12/07 11:03:25.0880
18061 + Session ID = 1
18062 + Transaction ID = 10
18063 + Transaction Name = "{DA7F1B4D-F444-4B74-9A76-CA37E24363F4}"
18064 + TPB: Item Count = 3
18065 +  isc_tpb_concurrency
18066 +  isc_tpb_wait
18067 +  isc_tpb_write
18068 +
18069 + Default Completion = TACommit
18070 +
18071 + Journal Entry = jeQuery(Query)
18072 + Timestamp = 2021/12/07 11:03:25.1560
18073 + Session ID = 1
18074 + Transaction ID = 10
18075 + 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">
18076 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
18077 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
18078 + 01000000010000001A01050001000000DA000000
18079 + </blob>
18080 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
18081 + Give me excess of it, that, surfeiting,
18082 + The appetite may sicken, and so die.
18083 + That strain again! it had a dying fall:
18084 + O, it came o''er my ear like the sweet south,
18085 + That breathes upon a bank of violets,
18086 + Stealing and giving odour! Enough; no more:
18087 + ''Tis not so sweet now as it was before.
18088 + O spirit of love! how quick and fresh art thou,
18089 + That, notwithstanding thy capacity      10
18090 + Receiveth as the sea, nought enters there,
18091 + Of what validity and pitch soe''er,
18092 + But falls into abatement and low price,
18093 + Even in a minute: so full of shapes is fancy
18094 + That it alone is high fantastical.
18095 +
18096 + Si la musique est la nourriture de l''amour, continuez à jouer;
18097 + Donnez-m''en un excès, que, surexcité,
18098 + L''appétit peut devenir malade et ainsi mourir.
18099 + Cette souche encore! il a eu une chute mourante:
18100 + Oh, ça m''est venu à l''oreille comme le doux sud,
18101 + Qui souffle sur une banque de violettes,
18102 + Voler et donner de l''odeur! Assez; Pas plus:
18103 + «Ce n''est pas si doux maintenant qu''avant.
18104 + O esprit d''amour! comme tu es rapide et fraîche,
18105 + Que, malgré ta capacité 10
18106 + Reçoit comme la mer, rien n''y entre,
18107 + De quelle validité et de quelle hauteur soe''er,
18108 + Mais tombe dans l''abattement et le prix bas,
18109 + Même en une minute: si plein de formes est fantaisie
18110 + Que cela seul est fantastique.
18111 +
18112 +
18113 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
18114 + <elt ix="0">100</elt>
18115 + <elt ix="1">99</elt>
18116 + <elt ix="2">98</elt>
18117 + <elt ix="3">97</elt>
18118 + <elt ix="4">96</elt>
18119 + <elt ix="5">95</elt>
18120 + <elt ix="6">94</elt>
18121 + <elt ix="7">93</elt>
18122 + <elt ix="8">92</elt>
18123 + <elt ix="9">91</elt>
18124 + <elt ix="10">90</elt>
18125 + <elt ix="11">89</elt>
18126 + <elt ix="12">88</elt>
18127 + <elt ix="13">87</elt>
18128 + <elt ix="14">86</elt>
18129 + <elt ix="15">85</elt>
18130 + <elt ix="16">84</elt>
18131 + </array>
18132 + , NULL) Returning MyArray
18133 +
18134 + Journal Entry = jeQuery(Query)
18135 + Timestamp = 2021/12/07 11:03:25.1680
18136 + Session ID = 1
18137 + Transaction ID = 10
18138 + 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">
18139 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
18140 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
18141 + 01000000010000001A01050001000000DA000000
18142 + </blob>
18143 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
18144 + Give me excess of it, that, surfeiting,
18145 + The appetite may sicken, and so die.
18146 + That strain again! it had a dying fall:
18147 + O, it came o''er my ear like the sweet south,
18148 + That breathes upon a bank of violets,
18149 + Stealing and giving odour! Enough; no more:
18150 + ''Tis not so sweet now as it was before.
18151 + O spirit of love! how quick and fresh art thou,
18152 + That, notwithstanding thy capacity      10
18153 + Receiveth as the sea, nought enters there,
18154 + Of what validity and pitch soe''er,
18155 + But falls into abatement and low price,
18156 + Even in a minute: so full of shapes is fancy
18157 + That it alone is high fantastical.
18158 +
18159 + Si la musique est la nourriture de l''amour, continuez à jouer;
18160 + Donnez-m''en un excès, que, surexcité,
18161 + L''appétit peut devenir malade et ainsi mourir.
18162 + Cette souche encore! il a eu une chute mourante:
18163 + Oh, ça m''est venu à l''oreille comme le doux sud,
18164 + Qui souffle sur une banque de violettes,
18165 + Voler et donner de l''odeur! Assez; Pas plus:
18166 + «Ce n''est pas si doux maintenant qu''avant.
18167 + O esprit d''amour! comme tu es rapide et fraîche,
18168 + Que, malgré ta capacité 10
18169 + Reçoit comme la mer, rien n''y entre,
18170 + De quelle validité et de quelle hauteur soe''er,
18171 + Mais tombe dans l''abattement et le prix bas,
18172 + Même en une minute: si plein de formes est fantaisie
18173 + Que cela seul est fantastique.
18174 +
18175 +
18176 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
18177 + <elt ix="0">100</elt>
18178 + <elt ix="1">99</elt>
18179 + <elt ix="2">98</elt>
18180 + <elt ix="3">97</elt>
18181 + <elt ix="4">96</elt>
18182 + <elt ix="5">95</elt>
18183 + <elt ix="6">94</elt>
18184 + <elt ix="7">93</elt>
18185 + <elt ix="8">92</elt>
18186 + <elt ix="9">91</elt>
18187 + <elt ix="10">90</elt>
18188 + <elt ix="11">89</elt>
18189 + <elt ix="12">88</elt>
18190 + <elt ix="13">87</elt>
18191 + <elt ix="14">86</elt>
18192 + <elt ix="15">85</elt>
18193 + <elt ix="16">84</elt>
18194 + </array>
18195 + , NULL) Returning MyArray
18196 +
18197 + Journal Entry = jeQuery(Query)
18198 + Timestamp = 2021/12/07 11:03:25.1990
18199 + Session ID = 1
18200 + Transaction ID = 10
18201 + 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">
18202 + <elt ix="0">100</elt>
18203 + <elt ix="1">99</elt>
18204 + <elt ix="2">98</elt>
18205 + <elt ix="3">97</elt>
18206 + <elt ix="4">96</elt>
18207 + <elt ix="5">95</elt>
18208 + <elt ix="6">94</elt>
18209 + <elt ix="7">93</elt>
18210 + <elt ix="8">92</elt>
18211 + <elt ix="9">91</elt>
18212 + <elt ix="10">90</elt>
18213 + <elt ix="11">89</elt>
18214 + <elt ix="12">88</elt>
18215 + <elt ix="13">87</elt>
18216 + <elt ix="14">86</elt>
18217 + <elt ix="15">85</elt>
18218 + <elt ix="16">84</elt>
18219 + </array>
18220 + ,   A.My Field  = 'My Field',  A.MY Field = 'MY Field',  A.GRANTS = NULL Where A.TABLEKEY = 2 RETURNING A.MyArray
18221 +
18222 + Journal Entry = jeTransCommit(Commit)
18223 + Timestamp = 2021/12/07 11:03:25.3020
18224 + Session ID = 1
18225 + Transaction ID = 10
18226 +
18227 + Journal Entry = jeTransStart(Transaction Start)
18228 + Timestamp = 2021/12/07 11:03:25.3280
18229 + Session ID = 1
18230 + Transaction ID = 12
18231 + Transaction Name = "{DA7F1B4D-F444-4B74-9A76-CA37E24363F4}"
18232 + TPB: Item Count = 3
18233 +  isc_tpb_concurrency
18234 +  isc_tpb_wait
18235 +  isc_tpb_write
18236 +
18237 + Default Completion = TACommit
18238 +
18239 + Journal Entry = jeQuery(Query)
18240 + Timestamp = 2021/12/07 11:03:25.5960
18241 + Session ID = 1
18242 + Transaction ID = 12
18243 + Query = Delete From IBXTEST A Where A.TABLEKEY = 1
18244 +
18245 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
18246 + Timestamp = 2021/12/07 11:03:25.7980
18247 + Session ID = 1
18248 + Transaction ID = 14
18249 + Old TransactionID = 12
18250 +
18251 + Journal Entry = jeQuery(Query)
18252 + Timestamp = 2021/12/07 11:03:26.0330
18253 + Session ID = 1
18254 + Transaction ID = 14
18255 + Query = Delete From IBXTEST A Where A.TABLEKEY = 1
18256 +
18257 + Journal Entry = jeTransRollback(Rollback)
18258 + Timestamp = 2021/12/07 11:03:26.2140
18259 + Session ID = 1
18260 + Transaction ID = 14
18261 +
18262 + Journal Entry = jeTransStart(Transaction Start)
18263 + Timestamp = 2021/12/07 11:03:26.2450
18264 + Session ID = 1
18265 + Transaction ID = 15
18266 + Transaction Name = "{DA7F1B4D-F444-4B74-9A76-CA37E24363F4}"
18267 + TPB: Item Count = 3
18268 +  isc_tpb_concurrency
18269 +  isc_tpb_wait
18270 +  isc_tpb_write
18271 +
18272 + Default Completion = TACommit
18273 +
18274 + Journal Entry = jeQuery(Query)
18275 + Timestamp = 2021/12/07 11:03:26.5300
18276 + Session ID = 1
18277 + Transaction ID = 15
18278 + 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">
18279 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
18280 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
18281 + 01000000010000001A01050001000000DA000000
18282 + </blob>
18283 + , 9223372036854775807, 65566, '26/12/2007 12:30:45.0000', 'If music be the food of love, play on;
18284 + Give me excess of it, that, surfeiting,
18285 + The appetite may sicken, and so die.
18286 + That strain again! it had a dying fall:
18287 + O, it came o''er my ear like the sweet south,
18288 + That breathes upon a bank of violets,
18289 + Stealing and giving odour! Enough; no more:
18290 + ''Tis not so sweet now as it was before.
18291 + O spirit of love! how quick and fresh art thou,
18292 + That, notwithstanding thy capacity      10
18293 + Receiveth as the sea, nought enters there,
18294 + Of what validity and pitch soe''er,
18295 + But falls into abatement and low price,
18296 + Even in a minute: so full of shapes is fancy
18297 + That it alone is high fantastical.
18298 +
18299 + Si la musique est la nourriture de l''amour, continuez à jouer;
18300 + Donnez-m''en un excès, que, surexcité,
18301 + L''appétit peut devenir malade et ainsi mourir.
18302 + Cette souche encore! il a eu une chute mourante:
18303 + Oh, ça m''est venu à l''oreille comme le doux sud,
18304 + Qui souffle sur une banque de violettes,
18305 + Voler et donner de l''odeur! Assez; Pas plus:
18306 + «Ce n''est pas si doux maintenant qu''avant.
18307 + O esprit d''amour! comme tu es rapide et fraîche,
18308 + Que, malgré ta capacité 10
18309 + Reçoit comme la mer, rien n''y entre,
18310 + De quelle validité et de quelle hauteur soe''er,
18311 + Mais tombe dans l''abattement et le prix bas,
18312 + Même en une minute: si plein de formes est fantaisie
18313 + Que cela seul est fantastique.
18314 +
18315 +
18316 + ', <array dim = "1" sqltype = "496" length = "4" relation_name = "IBXTEST" column_name = "MYARRAY" scale = "0" bounds="0:16">
18317 + <elt ix="0">100</elt>
18318 + <elt ix="1">99</elt>
18319 + <elt ix="2">98</elt>
18320 + <elt ix="3">97</elt>
18321 + <elt ix="4">96</elt>
18322 + <elt ix="5">95</elt>
18323 + <elt ix="6">94</elt>
18324 + <elt ix="7">93</elt>
18325 + <elt ix="8">92</elt>
18326 + <elt ix="9">91</elt>
18327 + <elt ix="10">90</elt>
18328 + <elt ix="11">89</elt>
18329 + <elt ix="12">88</elt>
18330 + <elt ix="13">87</elt>
18331 + <elt ix="14">86</elt>
18332 + <elt ix="15">85</elt>
18333 + <elt ix="16">84</elt>
18334 + </array>
18335 + , NULL) Returning MyArray
18336 +
18337 + Journal Entry = jeTransCommitRet(Commit Retaining)
18338 + Timestamp = 2021/12/07 11:03:26.6140
18339 + Session ID = 1
18340 + Transaction ID = 17
18341 + Old TransactionID = 15
18342 +
18343 + Journal Entry = jeTransCommit(Commit)
18344 + Timestamp = 2021/12/07 11:03:26.9970
18345 + Session ID = 1
18346 + Transaction ID = 17
18347 +
18348 + Journal Entry = jeTransStart(Transaction Start)
18349 + Timestamp = 2021/12/07 11:03:27.0120
18350 + Session ID = 1
18351 + Transaction ID = 18
18352 + Transaction Name = "{DA7F1B4D-F444-4B74-9A76-CA37E24363F4}"
18353 + TPB: Item Count = 3
18354 +  isc_tpb_concurrency
18355 +  isc_tpb_wait
18356 +  isc_tpb_write
18357 +
18358 + Default Completion = TACommit
18359 +
18360 + Journal Entry = jeTransRollback(Rollback)
18361 + Timestamp = 2021/12/07 11:03:27.4600
18362 + Session ID = 1
18363 + Transaction ID = 18
18364 +
18365 +
18366 +
18367   ------------------------------------------------------
18368   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines