533 |
|
Opening localhost:employee |
534 |
|
Database Open |
535 |
|
Employee Count = 42 |
536 |
< |
Transaction ID = 6014 |
536 |
> |
Transaction ID = 6359 |
537 |
|
Transaction is Read/Write |
538 |
< |
Transaction ID = 6014 |
539 |
< |
Oldest Interesting = 5461 |
540 |
< |
Oldest Action = 6013 |
541 |
< |
Oldest Snapshot = 6013 |
538 |
> |
Transaction ID = 6359 |
539 |
> |
Oldest Interesting = 6318 |
540 |
> |
Oldest Action = 6358 |
541 |
> |
Oldest Snapshot = 6358 |
542 |
|
Oldest Interesting = 0 |
543 |
|
Employee Count = 41 |
544 |
|
Employee Count = 42 |
570 |
|
SALARY = 64,635.00 |
571 |
|
FULL_NAME = Johnson, Leslie |
572 |
|
|
573 |
< |
Current memory = 937,656 |
574 |
< |
Delta memory = 1,296 |
575 |
< |
Max memory = 965,720 |
576 |
< |
Elapsed time= 0.003 sec |
577 |
< |
Cpu = 0.001 sec |
573 |
> |
Current memory = 937,536 |
574 |
> |
Delta memory = 1,288 |
575 |
> |
Max memory = 965,600 |
576 |
> |
Elapsed time= 0.000 sec |
577 |
> |
Cpu = 0.000 sec |
578 |
|
Buffers = 75 |
579 |
|
Reads = 0 |
580 |
|
Writes = 0 |
2611 |
|
|
2612 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2613 |
|
|
2614 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.46) (16: 4269) |
2614 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2615 |
|
|
2616 |
|
|
2617 |
|
Shrink to 2:10 |
2627 |
|
|
2628 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2629 |
|
|
2630 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.46) (16: 4269) |
2630 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2631 |
|
|
2632 |
|
|
2633 |
|
|
3309 |
|
Raw Value = 999912345678 Scale = -8 |
3310 |
|
Value from Raw Data = 9999123.456780 |
3311 |
|
Raw Value = 9999123456780 Scale = -6 |
3312 |
+ |
Numeric Operations |
3313 |
+ |
Add 2.23 + 24.12345 = 26.35345 |
3314 |
+ |
Add Double 2.23 + 24.12645 = 26.35645 |
3315 |
+ |
Add integer 2.23 + 2412345 = 2412347.23 |
3316 |
+ |
Subtract 2.23 - 24.12345 = -21.89345 |
3317 |
+ |
Subtract Double 24.12645 - 2.23 = -21.89645 |
3318 |
+ |
Subtract integer 24123.45 - 223 = -23900.45 |
3319 |
+ |
Multiply 2.23 * 24.12345 = 53.7952935 |
3320 |
+ |
Multiply Double 24.12645 * 2.23 = 53.8019835 |
3321 |
+ |
Multiply integer 241.2345 * 223 = 53795.2935 |
3322 |
+ |
Divide 24.12345 / 2.23 = 10.81769 |
3323 |
+ |
Divide Double 2.23 / 24.12645 = 0.09 |
3324 |
+ |
Divide integer 241.2345 / 223 = 1.0818 |
3325 |
+ |
Compare 2.23, -24.12345 = 1 |
3326 |
+ |
Compare integer 2.23, 3 = -1 |
3327 |
+ |
Compare Double 2.23, 2.23 = 0 |
3328 |
+ |
Negate 24.12345 = -24.12345 |
3329 |
|
SQL Params |
3330 |
|
SQLType =SQL_LONG |
3331 |
|
sub type = 0 |
3579 |
|
IBX$TRANSACTIONID = 7 |
3580 |
|
IBX$OLDTRANSACTIONID = NULL |
3581 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3582 |
< |
IBX$CREATED = 2022/01/09 15:33:11.5220 |
3582 |
> |
IBX$CREATED = 2022/01/14 23:03:42.7720 |
3583 |
|
IBX$SESSIONID = 1 |
3584 |
|
IBX$TRANSACTIONID = 9 |
3585 |
|
IBX$OLDTRANSACTIONID = 8 |
3586 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3587 |
< |
IBX$CREATED = 2022/01/09 15:33:11.8430 |
3587 |
> |
IBX$CREATED = 2022/01/14 23:03:43.1080 |
3588 |
|
|
3589 |
|
Journal Entries |
3590 |
|
Journal Entry = jeTransStart(Transaction Start) |