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

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

# Line 57 | Line 57 | Creating a Database with a DPD
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
# Line 306 | Line 307 | JOB_COUNTRY = USA
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
# Line 625 | Line 650 | Running Test 3: ad hoc queries
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
# Line 659 | Line 692 | Current memory = 19,694,032
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
# Line 3462 | Line 3495 | FIXEDPOINT = 233.45600000
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

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines