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

Comparing ibx/branches/udr/testsuite/FB4reference.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 651 | Line 651 | Running Test 3: ad hoc queries
651   Opening inet://localhost/employee
652   Database Open
653   Employee Count = 42
654 < Transaction ID = 5281
654 > Transaction ID = 8337
655   Transaction is Read/Write
656   Transaction Database Path = inet://localhost/employee
657 < Transaction ID = 5281
658 < Oldest Interesting = 1895
659 < Oldest Action = 5280
660 < Oldest Snapshot = 5280
657 > Transaction ID = 8337
658 > Oldest Interesting = 8335
659 > Oldest Action = 8336
660 > Oldest Snapshot = 8336
661   Oldest Snapshot Number = 1
662   Lock Timeout = 0
663   Transaction Access = isc_info_tra_readwrite
# Line 692 | Line 692 | JOB_COUNTRY = USA
692   SALARY = 64,635.00
693   FULL_NAME = Johnson, Leslie
694  
695 < Current memory = 19,762,192
695 > Current memory = 19,762,400
696   Delta memory = 4,464
697 < Max memory = 19,807,520
698 < Elapsed time= 0.002 sec
697 > Max memory = 19,807,728
698 > Elapsed time= 0.003 sec
699   Cpu = 0.000 sec
700   Buffers = 2048
701   Reads = 0
702 < Writes = 0
702 > Writes = 1
703   Fetches = 3
704   Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
705   Relation Name = EMPLOYEE
# Line 2733 | Line 2733 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2733  
2734   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)
2735  
2736 < 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)
2736 > 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)
2737  
2738  
2739   Shrink to 2:10
# Line 2749 | Line 2749 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2749  
2750   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)
2751  
2752 < 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)
2752 > 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)
2753  
2754  
2755  
# Line 2844 | Line 2844 | Page Size = 8192
2844   Version = 1: LI-V6.3.1.2692 Firebird 4.0
2845   Database is Read/Write
2846   Database Created: 21/12/2021 10:52:59
2847 < Pages Used = 351
2848 < Pages Free = 62
2847 > Pages Used = 352
2848 > Pages Free = 61
2849   Server Memory = 19476112
2850   Forced Writes  = 1
2851   Max Memory  = 19506944
# Line 2853 | Line 2853 | Num Buffers  = 2048
2853   Sweep Interval  = 20000
2854   Logged in Users: SYSDBA,
2855   Active Transaction Count = 0
2856 < Fetches  = 1683
2856 > Fetches  = 1698
2857   Writes  = 6
2858   Reads  = 97
2859   Page Writes  = 3
# Line 2879 | Line 2879 | Count = 2
2879   Table ID = 12
2880   Count = 24
2881   Table ID = 18
2882 < Count = 940
2882 > Count = 952
2883   Table ID = 20
2884   Count = 5
2885   Table ID = 28
# Line 2907 | Line 2907 | Async Wait Called
2907   Event Signalled
2908   First Event - usually ignored
2909   Signal Event
2910 + Event Signalled
2911   Event Counts: TESTEVENT, Count = 1
2912   Two more events
2913   Call Async Wait
2914   Async Wait Called
2915   Event Signalled
2915 Event Signalled
2916   Deferred Events Caught
2917   Event Counts: TESTEVENT, Count = 2
2918   Signal Event
# Line 2971 | Line 2971 | Local Backup
2971  
2972  
2973  
2974
2974   Local Backup Complete
2975  
2976   Local Restore
# Line 4669 | Line 4668 | Value from BCD = 9999.12345678
4668   Raw Value = 999912345678 Scale = -8
4669   Value from Raw Data = 9999123.456780
4670   Raw Value = 9999123456780 Scale = -6
4671 + Numeric Operations
4672 + Add 2.23 + 24.12345 = 26.35345
4673 + Add Double 2.23 + 24.12645 = 26.35645
4674 + Add integer 2.23 + 2412345 = 2412347.23
4675 + Subtract 2.23 - 24.12345 = -21.89345
4676 + Subtract Double 24.12645 - 2.23 = -21.89645
4677 + Subtract integer 24123.45 - 223 = -23900.45
4678 + Multiply 2.23 * 24.12345 = 53.7952935
4679 + Multiply Double 24.12645 * 2.23 = 53.8019835
4680 + Multiply integer 241.2345 * 223 = 53795.2935
4681 + Divide 24.12345 / 2.23 = 10.81769
4682 + Divide Double 2.23 / 24.12645 = 0.09
4683 + Divide integer 241.2345 / 223 = 1.0818
4684 + Compare 2.23, -24.12345 = 1
4685 + Compare integer 2.23, 3 = -1
4686 + Compare Double 2.23, 2.23 = 0
4687 + Negate 24.12345 = -24.12345
4688   SQL Params
4689   SQLType =SQL_LONG
4690   sub type = 0
# Line 4926 | Line 4942 | IBX$SESSIONID = 1
4942   IBX$TRANSACTIONID = 8
4943   IBX$OLDTRANSACTIONID = NULL
4944   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4945 < IBX$CREATED = 2022/01/09 15:24:09.1790
4945 > IBX$CREATED = 2022/01/14 22:58:12.7560
4946   IBX$SESSIONID = 1
4947   IBX$TRANSACTIONID = 10
4948   IBX$OLDTRANSACTIONID = 9
4949   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4950 < IBX$CREATED = 2022/01/09 15:24:09.5040
4950 > IBX$CREATED = 2022/01/14 22:58:13.0520
4951  
4952   Journal Entries
4953   Journal Entry = jeTransStart(Transaction Start)

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines