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

Comparing:
ibx/branches/journaling/fbintf/testsuite/FB3reference.log (file contents), Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC vs.
ibx/branches/udr/testsuite/FB3reference.log (file contents), Revision 375 by tony, Sun Jan 9 23:42:58 2022 UTC

# Line 9 | Line 9 | Firebird Conf Directory = /opt/firebird3
9   Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so
10   Running Test 1: Create and Drop a Database
11   Creating a Database with empty parameters
12 < Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
12 > Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file ""
13   -Error while trying to create file
14   -No such file or directory
15   Creating a Database using an SQL Statement
# Line 77 | Line 77 | Dropping Database
77  
78   ------------------------------------------------------
79   Running Test 2: Open the employee database and run a query
80 < Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
80 > Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
81   Opening inet://localhost/employee
82   Database Open, SQL Dialect = 3
83   TPB: Item Count = 3
# Line 330 | Line 330 | 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
333 > Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported
334   Now open the employee database as a local database
335   TPB: Item Count = 3
336    isc_tpb_read
# 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 = 5005
653 > Transaction ID = 5734
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
656 > Transaction ID = 5734
657 > Oldest Interesting = 5732
658 > Oldest Action = 5733
659 > Oldest Snapshot = 5733
660   Oldest Interesting = 0
661   Employee Count = 41
662   Employee Count = 42
# Line 688 | Line 688 | JOB_COUNTRY = USA
688   SALARY = 64,635.00
689   FULL_NAME = Johnson, Leslie
690  
691 < Current memory = 19,694,032
691 > Current memory = 19,689,792
692   Delta memory = 4,480
693 < Max memory = 19,755,888
694 < Elapsed time= 0.002 sec
693 > Max memory = 19,751,184
694 > Elapsed time= 0.003 sec
695   Cpu = 0.010 sec
696   Buffers = 2048
697   Reads = 0
698 < Writes = 0
698 > Writes = 1
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.45) (16: 4269)
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)
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.45) (16: 4269)
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)
2749  
2750  
2751  
# Line 2842 | Line 2842 | Database is Read/Write
2842   Database Created: 09/1/2020 13:13:45
2843   Pages Used = 297
2844   Pages Free = 10
2845 < Server Memory = 19196128
2845 > Server Memory = 18985136
2846   Forced Writes  = 1
2847 < Max Memory  = 19316896
2847 > Max Memory  = 19022320
2848   Num Buffers  = 2048
2849   Sweep Interval  = 20000
2850   Logged in Users: SYSDBA,
2851   Active Transaction Count = 0
2852 < Fetches  = 452
2853 < Writes  = 8
2854 < Reads  = 57
2855 < Page Writes  = 4
2852 > Fetches  = 407
2853 > Writes  = 6
2854 > Reads  = 55
2855 > Page Writes  = 3
2856   Record Version Removals Operation Counts
2857  
2858   Deletes Operation Counts
# Line 2867 | Line 2867 | Indexed Reads Count Operation Counts
2867   Table ID = 4
2868   Count = 28
2869   Table ID = 6
2870 < Count = 15
2870 > Count = 5
2871   Table ID = 9
2872 < Count = 3
2872 > Count = 1
2873   Table ID = 11
2874   Count = 1
2875   Table ID = 12
# Line 2944 | Line 2944 | User ID = 0
2944   Group ID = 0
2945  
2946  
2947 < Licence Info: feature is not supported
2947 > Licence Info: Engine Code: 335544378 feature is not supported
2948   -feature is not supported
2949  
2950 < Licence Mask Info: feature is not supported
2950 > Licence Mask Info: Engine Code: 335544378 feature is not supported
2951  
2952   Capabilities = 6
2953  
# Line 2961 | Line 2961 | Local Backup
2961  
2962  
2963  
2964 +
2965   Local Backup Complete
2966  
2967   Local Restore
# Line 3234 | Line 3235 | Écoute moi
3235   ------------------------------------------------------
3236   Running Test 16: Error handling
3237   Invalid Database Name Test
3238 < Error Handled: I/O error during "open" operation for file "Malformed Name"
3238 > Error Handled: SQLCODE: -902
3239 > Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3240 > I/O error during "open" operation for file "Malformed Name"
3241   -Error while trying to open file
3242   -No such file or directory
3243   Invalid User Name Test
3244 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3244 > Error Handled: SQLCODE: -902
3245 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3246 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3247   Invalid password Test
3248 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3248 > Error Handled: SQLCODE: -902
3249 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3250 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3251   Invalid Prepare SQL Test
3252 < Error Handled: Dynamic SQL Error
3252 > Error Handled: SQLCODE: -206
3253 > Engine Code: 335544569 Column does not belong to referenced table
3254 > Dynamic SQL Error
3255   -SQL error code = -206
3256   -Column unknown
3257   -UNKNOWN_DATE
3258   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3259   Invalid Open Cursor SQL Test
3260 < Error Handled: Dynamic SQL Error
3260 > Error Handled: SQLCODE: -206
3261 > Engine Code: 335544569 Column does not belong to referenced table
3262 > Dynamic SQL Error
3263   -SQL error code = -206
3264   -Column unknown
3265   -X
# Line 3275 | Line 3286 | New Transaction before Open Cursor
3286   COUNTER = 42
3287  
3288   Invalid Server Name Test
3289 < Error Handled: Unable to complete network request to host "unknown".
3289 > Error Handled: SQLCODE: -902
3290 > Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3291 > Unable to complete network request to host "unknown".
3292   -Failed to locate host machine.
3293   -The specified name was not found in the hosts file or Domain Name Services
3294   Invalid User Name Test
3295 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3295 > Error Handled: SQLCODE: -902
3296 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3297 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3298   Invalid password Test
3299 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3299 > Error Handled: SQLCODE: -902
3300 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3301 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3302  
3303  
3304   ------------------------------------------------------
# Line 3412 | Line 3429 | Parsing of 1.2E1.2 failed
3429   Parsing of 1,000 failed
3430   Parsing of 1e1e1 failed
3431   Parsing of 1.2+3 failed
3432 + Validating Numeric Interface - IFBNumeric
3433 + Value from Currency = 9999.1235
3434 + Raw Value = 99991235 Scale = -4
3435 + Value from Currency(rescaled) = 9999.12
3436 + Raw Value = 999912 Scale = -2
3437 + Value from Double = 9999.12345678
3438 + Raw Value = 999912345678 Scale = -8
3439 + Value from Integer = 9223372036854775807
3440 + Raw Value = 9223372036854775807 Scale = 0
3441 + Value from string = 9223372036854775807
3442 + Raw Value = 9223372036854775807 Scale = 0
3443 + Value from string = 9999.12345678
3444 + Raw Value = 999912345678 Scale = -8
3445 + Value from string = -0.12
3446 + Raw Value = -12 Scale = -3
3447 + Value from BCD = 9999.12345678
3448 + Raw Value = 999912345678 Scale = -8
3449 + Value from Raw Data = 9999123.456780
3450 + Raw Value = 9999123456780 Scale = -6
3451   SQL Params
3452   SQLType =SQL_LONG
3453   sub type = 0
# Line 3462 | Line 3498 | Charset id = 0
3498   Nullable
3499   Size = 8
3500  
3501 < Expected Error - Dynamic SQL Error
3501 > Expected Error - SQLCODE: -303
3502 > Engine Code: 335544569 Incompatible column/host variable data type
3503 > Dynamic SQL Error
3504   -SQL error code = -303
3505   -conversion error from string "1,000"
3506 < Expected Error - Dynamic SQL Error
3506 > Expected Error - SQLCODE: -303
3507 > Engine Code: 335544569 Incompatible column/host variable data type
3508 > Dynamic SQL Error
3509   -SQL error code = -303
3510   -conversion error from string "10.0.0"
3511 + Test Numeric Type
3512   ROWID = 1
3513   ITYPE = 101
3514   I64TYPE = 9223372036854775807
# Line 3492 | Line 3533 | I64TYPE = 10
3533   CURRTYPE = .02300000
3534   DTYPE = .00110000
3535   FIXEDPOINT = 233.45600000
3536 + ROWID = 7
3537 + ITYPE = 1
3538 + I64TYPE = 1234567
3539 + CURRTYPE = .02300000
3540 + DTYPE = .00110000
3541 + FIXEDPOINT = 1,234.25000000
3542  
3543  
3544  
3545   ------------------------------------------------------
3546   Running Test 22: Journalling
3547 < Start Journaling. Session ID = 1
3547 > Start Journaling. Session ID = 0
3548   1234.567 parsed to 1234567 scale = -3
3549   As Float =  1.2345670000000000E+003
3550   -765.4321 parsed to -7654321 scale = -4
# Line 3655 | Line 3702 | MYARRAY = NULL
3702  
3703   Journal Table
3704   IBX$SESSIONID = 1
3705 < IBX$TRANSACTIONID = 9
3705 > IBX$TRANSACTIONID = 8
3706   IBX$OLDTRANSACTIONID = NULL
3707   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3708 < IBX$CREATED = 2021/12/07 09:58:40.6960
3708 > IBX$CREATED = 2022/01/09 15:31:44.1510
3709   IBX$SESSIONID = 1
3710 < IBX$TRANSACTIONID = 11
3711 < IBX$OLDTRANSACTIONID = 10
3710 > IBX$TRANSACTIONID = 10
3711 > IBX$OLDTRANSACTIONID = 9
3712   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3713 < IBX$CREATED = 2021/12/07 09:58:41.0190
3713 > IBX$CREATED = 2022/01/09 15:31:44.8740
3714  
3715   Journal Entries
3716   Journal Entry = jeTransStart(Transaction Start)
3717 < Timestamp = 2021/12/07 09:58:40.7300
3717 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3718 > Attachment ID = 6
3719   Session ID = 1
3720 < Transaction ID = 9
3720 > Transaction ID = 8
3721   Transaction Name = "Transaction_29_1"
3722   TPB: Item Count = 3
3723    isc_tpb_write
# Line 3679 | Line 3727 | TPB: Item Count = 3
3727   Default Completion = TACommit
3728  
3729   Journal Entry = jeQuery(Query)
3730 < Timestamp = 2021/12/07 09:58:40.7970
3730 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3731 > Attachment ID = 6
3732   Session ID = 1
3733 < Transaction ID = 9
3733 > Transaction ID = 8
3734   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3735  
3736   Journal Entry = jeQuery(Query)
3737 < Timestamp = 2021/12/07 09:58:40.8130
3737 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3738 > Attachment ID = 6
3739   Session ID = 1
3740 < Transaction ID = 9
3740 > Transaction ID = 8
3741   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3742  
3743   Journal Entry = jeTransCommitRet(Commit Retaining)
3744 < Timestamp = 2021/12/07 09:58:40.8900
3744 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3745 > Attachment ID = 6
3746   Session ID = 1
3747 < Transaction ID = 10
3748 < Old TransactionID = 9
3747 > Transaction ID = 9
3748 > Old TransactionID = 8
3749  
3750   Journal Entry = jeQuery(Query)
3751 < Timestamp = 2021/12/07 09:58:40.9150
3751 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3752 > Attachment ID = 6
3753   Session ID = 1
3754 < Transaction ID = 10
3754 > Transaction ID = 9
3755   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3756  
3757   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3758 < Timestamp = 2021/12/07 09:58:41.0150
3758 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3759 > Attachment ID = 6
3760   Session ID = 1
3761 < Transaction ID = 11
3762 < Old TransactionID = 10
3761 > Transaction ID = 10
3762 > Old TransactionID = 9
3763  
3764   Journal Entry = jeQuery(Query)
3765 < Timestamp = 2021/12/07 09:58:41.0390
3765 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3766 > Attachment ID = 6
3767   Session ID = 1
3768 < Transaction ID = 11
3768 > Transaction ID = 10
3769   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3770  
3771   Journal Entry = jeTransStart(Transaction Start)
3772 < Timestamp = 2021/12/07 09:58:41.0610
3772 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3773 > Attachment ID = 6
3774   Session ID = 1
3775 < Transaction ID = 12
3775 > Transaction ID = 11
3776   Transaction Name = "Transaction_29_2"
3777   TPB: Item Count = 3
3778    isc_tpb_write
# Line 3727 | Line 3782 | TPB: Item Count = 3
3782   Default Completion = TARollback
3783  
3784   Journal Entry = jeTransCommit(Commit)
3785 < Timestamp = 2021/12/07 09:58:41.1310
3785 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3786 > Attachment ID = 6
3787   Session ID = 1
3788 < Transaction ID = 11
3788 > Transaction ID = 10
3789  
3790   Journal Entry = jeQuery(Query)
3791 < Timestamp = 2021/12/07 09:58:41.1910
3791 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3792 > Attachment ID = 6
3793   Session ID = 1
3794 < Transaction ID = 12
3794 > Transaction ID = 11
3795   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:
3796   Whether ''tis nobler in the mind to suffer
3797   The slings and arrows of outrageous fortune,
# Line 3773 | Line 3830 | Be all my sins remembered
3830   ')
3831  
3832   Journal Entry = jeQuery(Query)
3833 < Timestamp = 2021/12/07 09:58:41.2100
3833 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3834 > Attachment ID = 6
3835   Session ID = 1
3836 < Transaction ID = 12
3836 > Transaction ID = 11
3837   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3838   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3839   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3784 | Line 3842 | FFD8FFE000104A46494600010101004800480000
3842   )
3843  
3844   Journal Entry = jeQuery(Query)
3845 < Timestamp = 2021/12/07 09:58:41.2330
3845 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3846 > Attachment ID = 6
3847   Session ID = 1
3848 < Transaction ID = 12
3848 > Transaction ID = 11
3849   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">
3850   <elt ix="0">100</elt>
3851   <elt ix="1">99</elt>
# Line 3809 | Line 3868 | Query = Insert into TestData(RowID,MyArr
3868   )
3869  
3870   Journal Entry = jeTransRollback(Rollback)
3871 < Timestamp = 2021/12/07 09:58:41.3650
3871 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3872 > Attachment ID = 6
3873   Session ID = 1
3874 < Transaction ID = 12
3874 > Transaction ID = 11
3875  
3876  
3877  

Diff Legend

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