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