ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/fbintf/testsuite/FB4reference.log
(Generate patch)
# Line 57 | Line 57
57   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58   ODS major = 13
59   ODS minor = 0
60 + Attachment ID = 4
61   DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
62   DB Charset ID = 4
63   DB SQL Dialect = 3
# Line 307 | Line 308
308   SALARY = 64,635.00
309   FULL_NAME = Johnson, Leslie
310  
311 + Scollable Cursors
312 + DB Connect String = inet://localhost/employee
313 + DB Charset ID = 4
314 + DB SQL Dialect = 3
315 + DB Remote Protocol = TCPv4
316 + DB ODS Major Version = 13
317 + DB ODS Minor Version = 0
318 + User Authentication Method = Srp256
319 + Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
320 + DB Client Implementation Version = 4.0
321 + Do Fetch Next:
322 + EMP_NO = 2
323 + FIRST_NAME = Robert
324 + LAST_NAME = Nelson
325 + PHONE_EXT = 250
326 + HIRE_DATE = 1988/12/28 00:00:00.0000
327 + DEPT_NO = 600
328 + JOB_CODE = VP
329 + JOB_GRADE = 2
330 + JOB_COUNTRY = USA
331 + SALARY = 105,900.00
332 + FULL_NAME = Nelson, Robert
333 + Do Fetch Last:
334 + Remote Scrollable cursors test fails feature is not supported
335   Now open the employee database as a local database
336   TPB: Item Count = 3
337    isc_tpb_read
# Line 626 | Line 651
651   Opening inet://localhost/employee
652   Database Open
653   Employee Count = 42
654 + Transaction ID = 6547
655 + Transaction is Read/Write
656 + Transaction Database Path = inet://localhost/employee
657 + Transaction ID = 6547
658 + Oldest Interesting = 6545
659 + Oldest Action = 6546
660 + Oldest Snapshot = 6546
661 + Oldest Snapshot Number = 2
662 + Lock Timeout = 0
663 + Transaction Access = isc_info_tra_readwrite
664 + Isolation Type = isc_info_tra_concurrency
665   Employee Count = 41
666   Employee Count = 42
667   Employee Count = 41
# Line 656 | Line 692
692   SALARY = 64,635.00
693   FULL_NAME = Johnson, Leslie
694  
695 < Current memory = 19,764,272
695 > Current memory = 19,767,952
696   Delta memory = 4,464
697 < Max memory = 19,809,888
698 < Elapsed time= 0.002 sec
697 > Max memory = 19,813,568
698 > Elapsed time= 0.001 sec
699   Cpu = 0.000 sec
700   Buffers = 2048
701   Reads = 0
# Line 2808 | Line 2844
2844   Version = 1: LI-V6.3.0.2496 Firebird 4.0
2845   Database is Read/Write
2846   Database Created: 29/5/2021 16:47:30
2847 < Pages Used = 310
2848 < Pages Free = 765
2849 < Server Memory = 19482272
2847 > Pages Used = 313
2848 > Pages Free = 762
2849 > Server Memory = 19484112
2850   Forced Writes  = 1
2851 < Max Memory  = 19628544
2851 > Max Memory  = 19630384
2852   Num Buffers  = 2048
2853   Sweep Interval  = 20000
2854   Logged in Users: SYSDBA,
2855   Active Transaction Count = 0
2856 < Fetches  = 1641
2856 > Fetches  = 1653
2857   Writes  = 8
2858   Reads  = 92
2859   Page Writes  = 4
# Line 2843 | Line 2879
2879   Table ID = 12
2880   Count = 24
2881   Table ID = 18
2882 < Count = 811
2882 > Count = 821
2883   Table ID = 20
2884   Count = 5
2885   Table ID = 28
# Line 2855 | Line 2891
2891  
2892   Sequential Table Scans Operation Counts
2893   Table ID = 0
2894 < Count = 98
2894 > Count = 100
2895   Table ID = 1
2896   Count = 24
2897  
# Line 4682 | Line 4718
4718  
4719  
4720  
4721 + ------------------------------------------------------
4722 + Running Test 22: Journalling
4723 + Start Journaling. Session ID = 1
4724 + 1234.567 parsed to 1234567 scale = -3
4725 + As Float =  1.2345670000000000E+003
4726 + -765.4321 parsed to -7654321 scale = -4
4727 + As Float = -7.6543209999999999E+002
4728 + 0.1 parsed to 1 scale = -1
4729 + As Float =  1.0000000000000001E-001
4730 + 0.01 parsed to 1 scale = -2
4731 + As Float =  1.0000000000000000E-002
4732 + +123 parsed to 123 scale = 0
4733 + As Float =  1.2300000000000000E+002
4734 + 1.23456E308 parsed to 123456 scale = 303
4735 + As Float =  1.2345600000000001E+308
4736 + -1.2e-02 parsed to -12 scale = -3
4737 + As Float = -1.2000000000000000E-002
4738 + 10. parsed to 10 scale = 0
4739 + As Float =  1.0000000000000000E+001
4740 + .12 parsed to 12 scale = -2
4741 + As Float =  1.2000000000000000E-001
4742 + 0.12 parsed to 12 scale = -2
4743 + As Float =  1.2000000000000000E-001
4744 + Parsing of 1.2E1.2 failed
4745 + Parsing of 1,000 failed
4746 + Parsing of 1e1e1 failed
4747 + Parsing of 1.2+3 failed
4748 + SQL Params
4749 + SQLType =SQL_LONG
4750 + sub type = 0
4751 + Field Name =
4752 + Scale = 0
4753 + Charset id = 0
4754 + Not Null
4755 + Size = 4
4756 + Value = 0
4757 +
4758 + SQLType =SQL_LONG
4759 + sub type = 0
4760 + Field Name =
4761 + Scale = 0
4762 + Charset id = 0
4763 + Nullable
4764 + Size = 4
4765 +
4766 + SQLType =SQL_INT64
4767 + sub type = 0
4768 + Field Name =
4769 + Scale = 0
4770 + Charset id = 0
4771 + Nullable
4772 + Size = 8
4773 +
4774 + SQLType =SQL_INT64
4775 + sub type = 0
4776 + Field Name =
4777 + Scale = -4
4778 + Charset id = 0
4779 + Nullable
4780 + Size = 8
4781 +
4782 + SQLType =SQL_DOUBLE
4783 + sub type = 0
4784 + Field Name =
4785 + Scale = 0
4786 + Charset id = 0
4787 + Nullable
4788 + Size = 8
4789 +
4790 + SQLType =SQL_INT64
4791 + sub type = 0
4792 + Field Name =
4793 + Scale = -6
4794 + Charset id = 0
4795 + Nullable
4796 + Size = 8
4797 +
4798 +
4799 + Text Tests
4800 + SQL Params
4801 + SQLType =SQL_LONG
4802 + sub type = 0
4803 + Field Name =
4804 + Scale = 0
4805 + Charset id = 0
4806 + Not Null
4807 + Size = 4
4808 + Value = 0
4809 +
4810 + SQLType =SQL_VARYING
4811 + sub type = 0
4812 + Field Name =
4813 + Scale = 0
4814 + Charset id = 4
4815 + Nullable
4816 + Size = 1024
4817 +
4818 + SQLType =SQL_BLOB
4819 + sub type = 1
4820 + Field Name =
4821 + Scale = 0
4822 + Charset id = 4
4823 + Nullable
4824 + Size = 8
4825 +
4826 +
4827 + Binary Blob Tests
4828 +
4829 + Array Test
4830 + SQL Params
4831 + SQLType =SQL_LONG
4832 + sub type = 0
4833 + Field Name =
4834 + Scale = 0
4835 + Charset id = 0
4836 + Not Null
4837 + Size = 4
4838 + Value = 0
4839 +
4840 + SQLType =SQL_ARRAY
4841 + sub type = 0
4842 + Field Name =
4843 + Scale = 0
4844 + Charset id = 0
4845 + Nullable
4846 + Size = 8
4847 +
4848 + ROWID = 1
4849 + ITYPE = 101
4850 + I64TYPE = 9223372036854775807
4851 + CURRTYPE = 10,000.12340000
4852 + DTYPE = 9,999.12345678
4853 + FIXEDPOINT = 1,234,567,890.12345700
4854 + STR = NULL
4855 + TEXTBLOB = NULL
4856 + OTHERBLOB = NULL
4857 + MYARRAY = NULL
4858 + ROWID = 2
4859 + ITYPE = -32457
4860 + I64TYPE = -9223372036854775808
4861 + CURRTYPE = 1,000,001.12000000
4862 + DTYPE = 1.7E308
4863 + FIXEDPOINT = -1,234,567,890.12345700
4864 + STR = NULL
4865 + TEXTBLOB = NULL
4866 + OTHERBLOB = NULL
4867 + MYARRAY = NULL
4868 + ROWID = 4
4869 + ITYPE = 1
4870 + I64TYPE = 10
4871 + CURRTYPE = .02300000
4872 + DTYPE = .00110000
4873 + FIXEDPOINT = 233.45600000
4874 + STR = NULL
4875 + TEXTBLOB = NULL
4876 + OTHERBLOB = NULL
4877 + MYARRAY = NULL
4878 +
4879 + Journal Table
4880 + IBX$SESSIONID = 1
4881 + IBX$TRANSACTIONID = 9
4882 + IBX$OLDTRANSACTIONID = NULL
4883 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4884 + IBX$CREATED = 2021/12/07 09:50:08.4430
4885 + IBX$SESSIONID = 1
4886 + IBX$TRANSACTIONID = 11
4887 + IBX$OLDTRANSACTIONID = 10
4888 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4889 + IBX$CREATED = 2021/12/07 09:50:08.7940
4890 +
4891 + Journal Entries
4892 + Journal Entry = jeTransStart(Transaction Start)
4893 + Timestamp = 2021/12/07 09:50:08.4700
4894 + Session ID = 1
4895 + Transaction ID = 9
4896 + Transaction Name = "Transaction_29_1"
4897 + TPB: Item Count = 3
4898 +  isc_tpb_write
4899 +  isc_tpb_nowait
4900 +  isc_tpb_concurrency
4901 +
4902 + Default Completion = TACommit
4903 +
4904 + Journal Entry = jeQuery(Query)
4905 + Timestamp = 2021/12/07 09:50:08.5300
4906 + Session ID = 1
4907 + Transaction ID = 9
4908 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4909 +
4910 + Journal Entry = jeQuery(Query)
4911 + Timestamp = 2021/12/07 09:50:08.5510
4912 + Session ID = 1
4913 + Transaction ID = 9
4914 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4915 +
4916 + Journal Entry = jeTransCommitRet(Commit Retaining)
4917 + Timestamp = 2021/12/07 09:50:08.6650
4918 + Session ID = 1
4919 + Transaction ID = 10
4920 + Old TransactionID = 9
4921 +
4922 + Journal Entry = jeQuery(Query)
4923 + Timestamp = 2021/12/07 09:50:08.6870
4924 + Session ID = 1
4925 + Transaction ID = 10
4926 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4927 +
4928 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
4929 + Timestamp = 2021/12/07 09:50:08.7900
4930 + Session ID = 1
4931 + Transaction ID = 11
4932 + Old TransactionID = 10
4933 +
4934 + Journal Entry = jeQuery(Query)
4935 + Timestamp = 2021/12/07 09:50:08.8140
4936 + Session ID = 1
4937 + Transaction ID = 11
4938 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4939 +
4940 + Journal Entry = jeTransStart(Transaction Start)
4941 + Timestamp = 2021/12/07 09:50:08.8260
4942 + Session ID = 1
4943 + Transaction ID = 12
4944 + Transaction Name = "Transaction_29_2"
4945 + TPB: Item Count = 3
4946 +  isc_tpb_write
4947 +  isc_tpb_nowait
4948 +  isc_tpb_concurrency
4949 +
4950 + Default Completion = TARollback
4951 +
4952 + Journal Entry = jeTransCommit(Commit)
4953 + Timestamp = 2021/12/07 09:50:08.8860
4954 + Session ID = 1
4955 + Transaction ID = 11
4956 +
4957 + Journal Entry = jeQuery(Query)
4958 + Timestamp = 2021/12/07 09:50:08.9660
4959 + Session ID = 1
4960 + Transaction ID = 12
4961 + 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:
4962 + Whether ''tis nobler in the mind to suffer
4963 + The slings and arrows of outrageous fortune,
4964 + Or to take arms against a sea of troubles,
4965 + And, by opposing, end them. To die, to sleep-
4966 + No more-and by a sleep to say we end
4967 + The heartache and the thousand natural shocks
4968 + That flesh is heir to-''tis a consummation
4969 + Devoutly to be wished. To die, to sleep-
4970 + To sleep, perchance to dream. Aye, there''s the rub,
4971 + For in that sleep of death what dreams may come,
4972 + When we have shuffled off this mortal coil,
4973 + Must give us pause. There''s the respect
4974 + That makes calamity of so long life.
4975 + For who would bear the whips and scorns of time,
4976 + Th'' oppressor''s wrong, the proud man''s contumely,
4977 + The pangs of despised love, the law’s delay,
4978 + The insolence of office, and the spurns
4979 + That patient merit of the unworthy takes,
4980 + When he himself might his quietus make
4981 + With a bare bodkin? Who would fardels bear,
4982 + To grunt and sweat under a weary life,
4983 + But that the dread of something after death,
4984 + The undiscovered country from whose bourn
4985 + No traveler returns, puzzles the will
4986 + And makes us rather bear those ills we have
4987 + Than fly to others that we know not of?
4988 + Thus conscience does make cowards of us all,
4989 + And thus the native hue of resolution
4990 + Is sicklied o''er with the pale cast of thought,
4991 + And enterprises of great pitch and moment,
4992 + With this regard their currents turn awry,
4993 + And lose the name of action.-Soft you now,
4994 + The fair Ophelia.-Nymph, in thy orisons
4995 + Be all my sins remembered
4996 + ')
4997 +
4998 + Journal Entry = jeQuery(Query)
4999 + Timestamp = 2021/12/07 09:50:09.0130
5000 + Session ID = 1
5001 + Transaction ID = 12
5002 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5003 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5004 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5005 + 01000000010000001A01050001000000DA000000
5006 + </blob>
5007 + )
5008 +
5009 + Journal Entry = jeQuery(Query)
5010 + Timestamp = 2021/12/07 09:50:09.0380
5011 + Session ID = 1
5012 + Transaction ID = 12
5013 + 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">
5014 + <elt ix="0">100</elt>
5015 + <elt ix="1">99</elt>
5016 + <elt ix="2">98</elt>
5017 + <elt ix="3">97</elt>
5018 + <elt ix="4">96</elt>
5019 + <elt ix="5">95</elt>
5020 + <elt ix="6">94</elt>
5021 + <elt ix="7">93</elt>
5022 + <elt ix="8">92</elt>
5023 + <elt ix="9">91</elt>
5024 + <elt ix="10">90</elt>
5025 + <elt ix="11">89</elt>
5026 + <elt ix="12">88</elt>
5027 + <elt ix="13">87</elt>
5028 + <elt ix="14">86</elt>
5029 + <elt ix="15">85</elt>
5030 + <elt ix="16">84</elt>
5031 + </array>
5032 + )
5033 +
5034 + Journal Entry = jeTransRollback(Rollback)
5035 + Timestamp = 2021/12/07 09:50:09.1560
5036 + Session ID = 1
5037 + Transaction ID = 12
5038 +
5039 +
5040 +
5041   ------------------------------------------------------
5042   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines