ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/branches/udr/testsuite/FB3reference.log

Comparing ibx/branches/udr/testsuite/FB3reference.log (file contents):
Revision 375 by tony, Sun Jan 9 23:42:58 2022 UTC vs.
Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

#	Line 650 | Line 650 | Running Test 3: ad hoc queries
650		Opening inet://localhost/employee
651		Database Open
652		Employee Count = 42
653	<	Transaction ID = 5734
653	>	Transaction ID = 6142
654		Transaction is Read/Write
655		Transaction Database Path = inet://localhost/employee
656	<	Transaction ID = 5734
657	<	Oldest Interesting = 5732
658	<	Oldest Action = 5733
659	<	Oldest Snapshot = 5733
656	>	Transaction ID = 6142
657	>	Oldest Interesting = 6140
658	>	Oldest Action = 6141
659	>	Oldest Snapshot = 6141
660		Oldest Interesting = 0
661		Employee Count = 41
662		Employee Count = 42
#	Line 691 | Line 691 | FULL_NAME = Johnson, Leslie
691		Current memory = 19,689,792
692		Delta memory = 4,480
693		Max memory = 19,751,184
694	<	Elapsed time= 0.003 sec
695	<	Cpu = 0.010 sec
694	>	Elapsed time= 0.001 sec
695	>	Cpu = 0.000 sec
696		Buffers = 2048
697		Reads = 0
698	<	Writes = 1
698	>	Writes = 0
699		Fetches = 3
700		Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
701		Relation Name = EMPLOYEE
#	Line 2729 | Line 2729 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2729
2730		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)
2731
2732	<	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)
2732	>	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)
2733
2734
2735		Shrink to 2:10
#	Line 2745 | Line 2745 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2745
2746		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)
2747
2748	<	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)
2748	>	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)
2749
2750
2751
#	Line 2897 | Line 2897 | Async Wait Called
2897		Event Signalled
2898		First Event - usually ignored
2899		Signal Event
2900	+	Event Signalled
2901		Event Counts: TESTEVENT, Count = 1
2902		Two more events
2903		Call Async Wait
2904		Async Wait Called
2905		Event Signalled
2905	–	Event Signalled
2906		Deferred Events Caught
2907		Event Counts: TESTEVENT, Count = 2
2908		Signal Event
#	Line 2914 | Line 2914 | Event Cancelled
2914		Time Out - Cancel Worked!
2915		Sync wait
2916		Event Signalled
2917	<	Event Counts: TESTEVENT, Count = 1
2917	>	Event Counts: TESTEVENT, Count = 0
2918
2919
2920		------------------------------------------------------
#	Line 2961 | Line 2961 | Local Backup
2961
2962
2963
2964	–
2964		Local Backup Complete
2965
2966		Local Restore
#	Line 3448 | Line 3447 | Value from BCD = 9999.12345678
3447		Raw Value = 999912345678 Scale = -8
3448		Value from Raw Data = 9999123.456780
3449		Raw Value = 9999123456780 Scale = -6
3450	+	Numeric Operations
3451	+	Add 2.23 + 24.12345 = 26.35345
3452	+	Add Double 2.23 + 24.12645 = 26.35645
3453	+	Add integer 2.23 + 2412345 = 2412347.23
3454	+	Subtract 2.23 - 24.12345 = -21.89345
3455	+	Subtract Double 24.12645 - 2.23 = -21.89645
3456	+	Subtract integer 24123.45 - 223 = -23900.45
3457	+	Multiply 2.23 * 24.12345 = 53.7952935
3458	+	Multiply Double 24.12645 * 2.23 = 53.8019835
3459	+	Multiply integer 241.2345 * 223 = 53795.2935
3460	+	Divide 24.12345 / 2.23 = 10.81769
3461	+	Divide Double 2.23 / 24.12645 = 0.09
3462	+	Divide integer 241.2345 / 223 = 1.0818
3463	+	Compare 2.23, -24.12345 = 1
3464	+	Compare integer 2.23, 3 = -1
3465	+	Compare Double 2.23, 2.23 = 0
3466	+	Negate 24.12345 = -24.12345
3467		SQL Params
3468		SQLType =SQL_LONG
3469		sub type = 0
#	Line 3705 | Line 3721 | IBX$SESSIONID = 1
3721		IBX$TRANSACTIONID = 8
3722		IBX$OLDTRANSACTIONID = NULL
3723		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3724	<	IBX$CREATED = 2022/01/09 15:31:44.1510
3724	>	IBX$CREATED = 2022/01/14 23:02:04.2320
3725		IBX$SESSIONID = 1
3726		IBX$TRANSACTIONID = 10
3727		IBX$OLDTRANSACTIONID = 9
3728		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3729	<	IBX$CREATED = 2022/01/09 15:31:44.8740
3729	>	IBX$CREATED = 2022/01/14 23:02:04.6690
3730
3731		Journal Entries
3732		Journal Entry = jeTransStart(Transaction Start)

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines