ViewVC Help

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

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

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

#	Line 533 | Line 533 | Running Test 3: ad hoc queries
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
#	Line 570 | Line 570 | JOB_COUNTRY = USA
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
#	Line 2611 | Line 2611 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
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
#	Line 2627 | Line 2627 | MYARRAY = Array: (0: 100) (1: 99) (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
#	Line 3309 | Line 3309 | Value from BCD = 9999.12345678
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
#	Line 3562 | Line 3579 | IBX$SESSIONID = 1
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)

Diff Legend

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