57 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
58 |
|
ODS major = 12 |
59 |
|
ODS minor = 0 |
60 |
+ |
Attachment ID = 6 |
61 |
|
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
62 |
|
DB Charset ID = 4 |
63 |
|
DB SQL Dialect = 3 |
307 |
|
SALARY = 64,635.00 |
308 |
|
FULL_NAME = Johnson, Leslie |
309 |
|
|
310 |
+ |
Scollable Cursors |
311 |
+ |
DB Connect String = inet://localhost/employee |
312 |
+ |
DB Charset ID = 4 |
313 |
+ |
DB SQL Dialect = 3 |
314 |
+ |
DB Remote Protocol = TCPv4 |
315 |
+ |
DB ODS Major Version = 12 |
316 |
+ |
DB ODS Minor Version = 0 |
317 |
+ |
User Authentication Method = Srp |
318 |
+ |
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
319 |
+ |
DB Client Implementation Version = 3.0 |
320 |
+ |
Do Fetch Next: |
321 |
+ |
EMP_NO = 2 |
322 |
+ |
FIRST_NAME = Robert |
323 |
+ |
LAST_NAME = Nelson |
324 |
+ |
PHONE_EXT = 250 |
325 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
326 |
+ |
DEPT_NO = 600 |
327 |
+ |
JOB_CODE = VP |
328 |
+ |
JOB_GRADE = 2 |
329 |
+ |
JOB_COUNTRY = USA |
330 |
+ |
SALARY = 105,900.00 |
331 |
+ |
FULL_NAME = Nelson, Robert |
332 |
+ |
Do Fetch Last: |
333 |
+ |
Remote Scrollable cursors test fails feature is not supported |
334 |
|
Now open the employee database as a local database |
335 |
|
TPB: Item Count = 3 |
336 |
|
isc_tpb_read |
650 |
|
Opening inet://localhost/employee |
651 |
|
Database Open |
652 |
|
Employee Count = 42 |
653 |
+ |
Transaction ID = 5005 |
654 |
+ |
Transaction is Read/Write |
655 |
+ |
Transaction Database Path = inet://localhost/employee |
656 |
+ |
Transaction ID = 5005 |
657 |
+ |
Oldest Interesting = 5003 |
658 |
+ |
Oldest Action = 5004 |
659 |
+ |
Oldest Snapshot = 5004 |
660 |
+ |
Oldest Interesting = 0 |
661 |
|
Employee Count = 41 |
662 |
|
Employee Count = 42 |
663 |
|
Employee Count = 41 |
692 |
|
Delta memory = 4,480 |
693 |
|
Max memory = 19,755,888 |
694 |
|
Elapsed time= 0.002 sec |
695 |
< |
Cpu = 0.000 sec |
695 |
> |
Cpu = 0.010 sec |
696 |
|
Buffers = 2048 |
697 |
|
Reads = 0 |
698 |
|
Writes = 0 |
3495 |
|
|
3496 |
|
|
3497 |
|
|
3498 |
+ |
------------------------------------------------------ |
3499 |
+ |
Running Test 22: Journalling |
3500 |
+ |
Start Journaling. Session ID = 1 |
3501 |
+ |
1234.567 parsed to 1234567 scale = -3 |
3502 |
+ |
As Float = 1.2345670000000000E+003 |
3503 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
3504 |
+ |
As Float = -7.6543209999999999E+002 |
3505 |
+ |
0.1 parsed to 1 scale = -1 |
3506 |
+ |
As Float = 1.0000000000000001E-001 |
3507 |
+ |
0.01 parsed to 1 scale = -2 |
3508 |
+ |
As Float = 1.0000000000000000E-002 |
3509 |
+ |
+123 parsed to 123 scale = 0 |
3510 |
+ |
As Float = 1.2300000000000000E+002 |
3511 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
3512 |
+ |
As Float = 1.2345600000000001E+308 |
3513 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
3514 |
+ |
As Float = -1.2000000000000000E-002 |
3515 |
+ |
10. parsed to 10 scale = 0 |
3516 |
+ |
As Float = 1.0000000000000000E+001 |
3517 |
+ |
.12 parsed to 12 scale = -2 |
3518 |
+ |
As Float = 1.2000000000000000E-001 |
3519 |
+ |
0.12 parsed to 12 scale = -2 |
3520 |
+ |
As Float = 1.2000000000000000E-001 |
3521 |
+ |
Parsing of 1.2E1.2 failed |
3522 |
+ |
Parsing of 1,000 failed |
3523 |
+ |
Parsing of 1e1e1 failed |
3524 |
+ |
Parsing of 1.2+3 failed |
3525 |
+ |
SQL Params |
3526 |
+ |
SQLType =SQL_LONG |
3527 |
+ |
sub type = 0 |
3528 |
+ |
Field Name = |
3529 |
+ |
Scale = 0 |
3530 |
+ |
Charset id = 0 |
3531 |
+ |
Not Null |
3532 |
+ |
Size = 4 |
3533 |
+ |
Value = 0 |
3534 |
+ |
|
3535 |
+ |
SQLType =SQL_LONG |
3536 |
+ |
sub type = 0 |
3537 |
+ |
Field Name = |
3538 |
+ |
Scale = 0 |
3539 |
+ |
Charset id = 0 |
3540 |
+ |
Nullable |
3541 |
+ |
Size = 4 |
3542 |
+ |
|
3543 |
+ |
SQLType =SQL_INT64 |
3544 |
+ |
sub type = 0 |
3545 |
+ |
Field Name = |
3546 |
+ |
Scale = 0 |
3547 |
+ |
Charset id = 0 |
3548 |
+ |
Nullable |
3549 |
+ |
Size = 8 |
3550 |
+ |
|
3551 |
+ |
SQLType =SQL_INT64 |
3552 |
+ |
sub type = 0 |
3553 |
+ |
Field Name = |
3554 |
+ |
Scale = -4 |
3555 |
+ |
Charset id = 0 |
3556 |
+ |
Nullable |
3557 |
+ |
Size = 8 |
3558 |
+ |
|
3559 |
+ |
SQLType =SQL_DOUBLE |
3560 |
+ |
sub type = 0 |
3561 |
+ |
Field Name = |
3562 |
+ |
Scale = 0 |
3563 |
+ |
Charset id = 0 |
3564 |
+ |
Nullable |
3565 |
+ |
Size = 8 |
3566 |
+ |
|
3567 |
+ |
SQLType =SQL_INT64 |
3568 |
+ |
sub type = 0 |
3569 |
+ |
Field Name = |
3570 |
+ |
Scale = -6 |
3571 |
+ |
Charset id = 0 |
3572 |
+ |
Nullable |
3573 |
+ |
Size = 8 |
3574 |
+ |
|
3575 |
+ |
|
3576 |
+ |
Text Tests |
3577 |
+ |
SQL Params |
3578 |
+ |
SQLType =SQL_LONG |
3579 |
+ |
sub type = 0 |
3580 |
+ |
Field Name = |
3581 |
+ |
Scale = 0 |
3582 |
+ |
Charset id = 0 |
3583 |
+ |
Not Null |
3584 |
+ |
Size = 4 |
3585 |
+ |
Value = 0 |
3586 |
+ |
|
3587 |
+ |
SQLType =SQL_VARYING |
3588 |
+ |
sub type = 0 |
3589 |
+ |
Field Name = |
3590 |
+ |
Scale = 0 |
3591 |
+ |
Charset id = 4 |
3592 |
+ |
Nullable |
3593 |
+ |
Size = 1024 |
3594 |
+ |
|
3595 |
+ |
SQLType =SQL_BLOB |
3596 |
+ |
sub type = 1 |
3597 |
+ |
Field Name = |
3598 |
+ |
Scale = 0 |
3599 |
+ |
Charset id = 4 |
3600 |
+ |
Nullable |
3601 |
+ |
Size = 8 |
3602 |
+ |
|
3603 |
+ |
|
3604 |
+ |
Binary Blob Tests |
3605 |
+ |
|
3606 |
+ |
Array Test |
3607 |
+ |
SQL Params |
3608 |
+ |
SQLType =SQL_LONG |
3609 |
+ |
sub type = 0 |
3610 |
+ |
Field Name = |
3611 |
+ |
Scale = 0 |
3612 |
+ |
Charset id = 0 |
3613 |
+ |
Not Null |
3614 |
+ |
Size = 4 |
3615 |
+ |
Value = 0 |
3616 |
+ |
|
3617 |
+ |
SQLType =SQL_ARRAY |
3618 |
+ |
sub type = 0 |
3619 |
+ |
Field Name = |
3620 |
+ |
Scale = 0 |
3621 |
+ |
Charset id = 0 |
3622 |
+ |
Nullable |
3623 |
+ |
Size = 8 |
3624 |
+ |
|
3625 |
+ |
ROWID = 1 |
3626 |
+ |
ITYPE = 101 |
3627 |
+ |
I64TYPE = 9223372036854775807 |
3628 |
+ |
CURRTYPE = 10,000.12340000 |
3629 |
+ |
DTYPE = 9,999.12345678 |
3630 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
3631 |
+ |
STR = NULL |
3632 |
+ |
TEXTBLOB = NULL |
3633 |
+ |
OTHERBLOB = NULL |
3634 |
+ |
MYARRAY = NULL |
3635 |
+ |
ROWID = 2 |
3636 |
+ |
ITYPE = -32457 |
3637 |
+ |
I64TYPE = -9223372036854775808 |
3638 |
+ |
CURRTYPE = 1,000,001.12000000 |
3639 |
+ |
DTYPE = 1.7E308 |
3640 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
3641 |
+ |
STR = NULL |
3642 |
+ |
TEXTBLOB = NULL |
3643 |
+ |
OTHERBLOB = NULL |
3644 |
+ |
MYARRAY = NULL |
3645 |
+ |
ROWID = 4 |
3646 |
+ |
ITYPE = 1 |
3647 |
+ |
I64TYPE = 10 |
3648 |
+ |
CURRTYPE = .02300000 |
3649 |
+ |
DTYPE = .00110000 |
3650 |
+ |
FIXEDPOINT = 233.45600000 |
3651 |
+ |
STR = NULL |
3652 |
+ |
TEXTBLOB = NULL |
3653 |
+ |
OTHERBLOB = NULL |
3654 |
+ |
MYARRAY = NULL |
3655 |
+ |
|
3656 |
+ |
Journal Table |
3657 |
+ |
IBX$SESSIONID = 1 |
3658 |
+ |
IBX$TRANSACTIONID = 9 |
3659 |
+ |
IBX$OLDTRANSACTIONID = NULL |
3660 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3661 |
+ |
IBX$CREATED = 2021/12/07 09:58:40.6960 |
3662 |
+ |
IBX$SESSIONID = 1 |
3663 |
+ |
IBX$TRANSACTIONID = 11 |
3664 |
+ |
IBX$OLDTRANSACTIONID = 10 |
3665 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3666 |
+ |
IBX$CREATED = 2021/12/07 09:58:41.0190 |
3667 |
+ |
|
3668 |
+ |
Journal Entries |
3669 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
3670 |
+ |
Timestamp = 2021/12/07 09:58:40.7300 |
3671 |
+ |
Session ID = 1 |
3672 |
+ |
Transaction ID = 9 |
3673 |
+ |
Transaction Name = "Transaction_29_1" |
3674 |
+ |
TPB: Item Count = 3 |
3675 |
+ |
isc_tpb_write |
3676 |
+ |
isc_tpb_nowait |
3677 |
+ |
isc_tpb_concurrency |
3678 |
+ |
|
3679 |
+ |
Default Completion = TACommit |
3680 |
+ |
|
3681 |
+ |
Journal Entry = jeQuery(Query) |
3682 |
+ |
Timestamp = 2021/12/07 09:58:40.7970 |
3683 |
+ |
Session ID = 1 |
3684 |
+ |
Transaction ID = 9 |
3685 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
3686 |
+ |
|
3687 |
+ |
Journal Entry = jeQuery(Query) |
3688 |
+ |
Timestamp = 2021/12/07 09:58:40.8130 |
3689 |
+ |
Session ID = 1 |
3690 |
+ |
Transaction ID = 9 |
3691 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
3692 |
+ |
|
3693 |
+ |
Journal Entry = jeTransCommitRet(Commit Retaining) |
3694 |
+ |
Timestamp = 2021/12/07 09:58:40.8900 |
3695 |
+ |
Session ID = 1 |
3696 |
+ |
Transaction ID = 10 |
3697 |
+ |
Old TransactionID = 9 |
3698 |
+ |
|
3699 |
+ |
Journal Entry = jeQuery(Query) |
3700 |
+ |
Timestamp = 2021/12/07 09:58:40.9150 |
3701 |
+ |
Session ID = 1 |
3702 |
+ |
Transaction ID = 10 |
3703 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
3704 |
+ |
|
3705 |
+ |
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
3706 |
+ |
Timestamp = 2021/12/07 09:58:41.0150 |
3707 |
+ |
Session ID = 1 |
3708 |
+ |
Transaction ID = 11 |
3709 |
+ |
Old TransactionID = 10 |
3710 |
+ |
|
3711 |
+ |
Journal Entry = jeQuery(Query) |
3712 |
+ |
Timestamp = 2021/12/07 09:58:41.0390 |
3713 |
+ |
Session ID = 1 |
3714 |
+ |
Transaction ID = 11 |
3715 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
3716 |
+ |
|
3717 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
3718 |
+ |
Timestamp = 2021/12/07 09:58:41.0610 |
3719 |
+ |
Session ID = 1 |
3720 |
+ |
Transaction ID = 12 |
3721 |
+ |
Transaction Name = "Transaction_29_2" |
3722 |
+ |
TPB: Item Count = 3 |
3723 |
+ |
isc_tpb_write |
3724 |
+ |
isc_tpb_nowait |
3725 |
+ |
isc_tpb_concurrency |
3726 |
+ |
|
3727 |
+ |
Default Completion = TARollback |
3728 |
+ |
|
3729 |
+ |
Journal Entry = jeTransCommit(Commit) |
3730 |
+ |
Timestamp = 2021/12/07 09:58:41.1310 |
3731 |
+ |
Session ID = 1 |
3732 |
+ |
Transaction ID = 11 |
3733 |
+ |
|
3734 |
+ |
Journal Entry = jeQuery(Query) |
3735 |
+ |
Timestamp = 2021/12/07 09:58:41.1910 |
3736 |
+ |
Session ID = 1 |
3737 |
+ |
Transaction ID = 12 |
3738 |
+ |
Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question: |
3739 |
+ |
Whether ''tis nobler in the mind to suffer |
3740 |
+ |
The slings and arrows of outrageous fortune, |
3741 |
+ |
Or to take arms against a sea of troubles, |
3742 |
+ |
And, by opposing, end them. To die, to sleep- |
3743 |
+ |
No more-and by a sleep to say we end |
3744 |
+ |
The heartache and the thousand natural shocks |
3745 |
+ |
That flesh is heir to-''tis a consummation |
3746 |
+ |
Devoutly to be wished. To die, to sleep- |
3747 |
+ |
To sleep, perchance to dream. Aye, there''s the rub, |
3748 |
+ |
For in that sleep of death what dreams may come, |
3749 |
+ |
When we have shuffled off this mortal coil, |
3750 |
+ |
Must give us pause. There''s the respect |
3751 |
+ |
That makes calamity of so long life. |
3752 |
+ |
For who would bear the whips and scorns of time, |
3753 |
+ |
Th'' oppressor''s wrong, the proud man''s contumely, |
3754 |
+ |
The pangs of despised love, the law’s delay, |
3755 |
+ |
The insolence of office, and the spurns |
3756 |
+ |
That patient merit of the unworthy takes, |
3757 |
+ |
When he himself might his quietus make |
3758 |
+ |
With a bare bodkin? Who would fardels bear, |
3759 |
+ |
To grunt and sweat under a weary life, |
3760 |
+ |
But that the dread of something after death, |
3761 |
+ |
The undiscovered country from whose bourn |
3762 |
+ |
No traveler returns, puzzles the will |
3763 |
+ |
And makes us rather bear those ills we have |
3764 |
+ |
Than fly to others that we know not of? |
3765 |
+ |
Thus conscience does make cowards of us all, |
3766 |
+ |
And thus the native hue of resolution |
3767 |
+ |
Is sicklied o''er with the pale cast of thought, |
3768 |
+ |
And enterprises of great pitch and moment, |
3769 |
+ |
With this regard their currents turn awry, |
3770 |
+ |
And lose the name of action.-Soft you now, |
3771 |
+ |
The fair Ophelia.-Nymph, in thy orisons |
3772 |
+ |
Be all my sins remembered |
3773 |
+ |
') |
3774 |
+ |
|
3775 |
+ |
Journal Entry = jeQuery(Query) |
3776 |
+ |
Timestamp = 2021/12/07 09:58:41.2100 |
3777 |
+ |
Session ID = 1 |
3778 |
+ |
Transaction ID = 12 |
3779 |
+ |
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
3780 |
+ |
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
3781 |
+ |
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
3782 |
+ |
01000000010000001A01050001000000DA000000 |
3783 |
+ |
</blob> |
3784 |
+ |
) |
3785 |
+ |
|
3786 |
+ |
Journal Entry = jeQuery(Query) |
3787 |
+ |
Timestamp = 2021/12/07 09:58:41.2330 |
3788 |
+ |
Session ID = 1 |
3789 |
+ |
Transaction ID = 12 |
3790 |
+ |
Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16"> |
3791 |
+ |
<elt ix="0">100</elt> |
3792 |
+ |
<elt ix="1">99</elt> |
3793 |
+ |
<elt ix="2">98</elt> |
3794 |
+ |
<elt ix="3">97</elt> |
3795 |
+ |
<elt ix="4">96</elt> |
3796 |
+ |
<elt ix="5">95</elt> |
3797 |
+ |
<elt ix="6">94</elt> |
3798 |
+ |
<elt ix="7">93</elt> |
3799 |
+ |
<elt ix="8">92</elt> |
3800 |
+ |
<elt ix="9">91</elt> |
3801 |
+ |
<elt ix="10">90</elt> |
3802 |
+ |
<elt ix="11">89</elt> |
3803 |
+ |
<elt ix="12">88</elt> |
3804 |
+ |
<elt ix="13">87</elt> |
3805 |
+ |
<elt ix="14">86</elt> |
3806 |
+ |
<elt ix="15">85</elt> |
3807 |
+ |
<elt ix="16">84</elt> |
3808 |
+ |
</array> |
3809 |
+ |
) |
3810 |
+ |
|
3811 |
+ |
Journal Entry = jeTransRollback(Rollback) |
3812 |
+ |
Timestamp = 2021/12/07 09:58:41.3650 |
3813 |
+ |
Session ID = 1 |
3814 |
+ |
Transaction ID = 12 |
3815 |
+ |
|
3816 |
+ |
|
3817 |
+ |
|
3818 |
|
------------------------------------------------------ |
3819 |
|
Test Suite Ends |