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 |
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 |
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 |
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 |
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 |
|
------------------------------------------------------ |
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 |
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 |
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 |
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 |
|
|
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 |
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 |
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 |
|
------------------------------------------------------ |
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 |
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 |