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 381 by tony, Sat Jan 15 00:06:22 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 = 6142
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 = 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 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
695 < Cpu = 0.010 sec
693 > Max memory = 19,751,184
694 > Elapsed time= 0.001 sec
695 > Cpu = 0.000 sec
696   Buffers = 2048
697   Reads = 0
698   Writes = 0
# 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.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.45) (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 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 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 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 3234 | Line 3234 | Écoute moi
3234   ------------------------------------------------------
3235   Running Test 16: Error handling
3236   Invalid Database Name Test
3237 < Error Handled: I/O error during "open" operation for file "Malformed Name"
3237 > Error Handled: SQLCODE: -902
3238 > Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3239 > I/O error during "open" operation for file "Malformed Name"
3240   -Error while trying to open file
3241   -No such file or directory
3242   Invalid User Name Test
3243 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3243 > Error Handled: SQLCODE: -902
3244 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3245 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3246   Invalid password Test
3247 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3247 > Error Handled: SQLCODE: -902
3248 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3249 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3250   Invalid Prepare SQL Test
3251 < Error Handled: Dynamic SQL Error
3251 > Error Handled: SQLCODE: -206
3252 > Engine Code: 335544569 Column does not belong to referenced table
3253 > Dynamic SQL Error
3254   -SQL error code = -206
3255   -Column unknown
3256   -UNKNOWN_DATE
3257   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3258   Invalid Open Cursor SQL Test
3259 < Error Handled: Dynamic SQL Error
3259 > Error Handled: SQLCODE: -206
3260 > Engine Code: 335544569 Column does not belong to referenced table
3261 > Dynamic SQL Error
3262   -SQL error code = -206
3263   -Column unknown
3264   -X
# Line 3275 | Line 3285 | New Transaction before Open Cursor
3285   COUNTER = 42
3286  
3287   Invalid Server Name Test
3288 < Error Handled: Unable to complete network request to host "unknown".
3288 > Error Handled: SQLCODE: -902
3289 > Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3290 > Unable to complete network request to host "unknown".
3291   -Failed to locate host machine.
3292   -The specified name was not found in the hosts file or Domain Name Services
3293   Invalid User Name Test
3294 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3294 > Error Handled: SQLCODE: -902
3295 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3296 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3297   Invalid password Test
3298 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3298 > Error Handled: SQLCODE: -902
3299 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3300 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3301  
3302  
3303   ------------------------------------------------------
# Line 3412 | Line 3428 | Parsing of 1.2E1.2 failed
3428   Parsing of 1,000 failed
3429   Parsing of 1e1e1 failed
3430   Parsing of 1.2+3 failed
3431 + Validating Numeric Interface - IFBNumeric
3432 + Value from Currency = 9999.1235
3433 + Raw Value = 99991235 Scale = -4
3434 + Value from Currency(rescaled) = 9999.12
3435 + Raw Value = 999912 Scale = -2
3436 + Value from Double = 9999.12345678
3437 + Raw Value = 999912345678 Scale = -8
3438 + Value from Integer = 9223372036854775807
3439 + Raw Value = 9223372036854775807 Scale = 0
3440 + Value from string = 9223372036854775807
3441 + Raw Value = 9223372036854775807 Scale = 0
3442 + Value from string = 9999.12345678
3443 + Raw Value = 999912345678 Scale = -8
3444 + Value from string = -0.12
3445 + Raw Value = -12 Scale = -3
3446 + 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 3462 | Line 3514 | Charset id = 0
3514   Nullable
3515   Size = 8
3516  
3517 < Expected Error - Dynamic SQL Error
3517 > Expected Error - SQLCODE: -303
3518 > Engine Code: 335544569 Incompatible column/host variable data type
3519 > Dynamic SQL Error
3520   -SQL error code = -303
3521   -conversion error from string "1,000"
3522 < Expected Error - Dynamic SQL Error
3522 > Expected Error - SQLCODE: -303
3523 > Engine Code: 335544569 Incompatible column/host variable data type
3524 > Dynamic SQL Error
3525   -SQL error code = -303
3526   -conversion error from string "10.0.0"
3527 + Test Numeric Type
3528   ROWID = 1
3529   ITYPE = 101
3530   I64TYPE = 9223372036854775807
# Line 3492 | Line 3549 | I64TYPE = 10
3549   CURRTYPE = .02300000
3550   DTYPE = .00110000
3551   FIXEDPOINT = 233.45600000
3552 + ROWID = 7
3553 + ITYPE = 1
3554 + I64TYPE = 1234567
3555 + CURRTYPE = .02300000
3556 + DTYPE = .00110000
3557 + FIXEDPOINT = 1,234.25000000
3558  
3559  
3560  
3561   ------------------------------------------------------
3562   Running Test 22: Journalling
3563 < Start Journaling. Session ID = 1
3563 > Start Journaling. Session ID = 0
3564   1234.567 parsed to 1234567 scale = -3
3565   As Float =  1.2345670000000000E+003
3566   -765.4321 parsed to -7654321 scale = -4
# Line 3655 | Line 3718 | MYARRAY = NULL
3718  
3719   Journal Table
3720   IBX$SESSIONID = 1
3721 < IBX$TRANSACTIONID = 9
3721 > IBX$TRANSACTIONID = 8
3722   IBX$OLDTRANSACTIONID = NULL
3723   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3724 < IBX$CREATED = 2021/12/07 09:58:40.6960
3724 > IBX$CREATED = 2022/01/14 23:02:04.2320
3725   IBX$SESSIONID = 1
3726 < IBX$TRANSACTIONID = 11
3727 < IBX$OLDTRANSACTIONID = 10
3726 > IBX$TRANSACTIONID = 10
3727 > IBX$OLDTRANSACTIONID = 9
3728   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3729 < IBX$CREATED = 2021/12/07 09:58:41.0190
3729 > IBX$CREATED = 2022/01/14 23:02:04.6690
3730  
3731   Journal Entries
3732   Journal Entry = jeTransStart(Transaction Start)
3733 < Timestamp = 2021/12/07 09:58:40.7300
3733 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3734 > Attachment ID = 6
3735   Session ID = 1
3736 < Transaction ID = 9
3736 > Transaction ID = 8
3737   Transaction Name = "Transaction_29_1"
3738   TPB: Item Count = 3
3739    isc_tpb_write
# Line 3679 | Line 3743 | TPB: Item Count = 3
3743   Default Completion = TACommit
3744  
3745   Journal Entry = jeQuery(Query)
3746 < Timestamp = 2021/12/07 09:58:40.7970
3746 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3747 > Attachment ID = 6
3748   Session ID = 1
3749 < Transaction ID = 9
3749 > Transaction ID = 8
3750   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3751  
3752   Journal Entry = jeQuery(Query)
3753 < Timestamp = 2021/12/07 09:58:40.8130
3753 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3754 > Attachment ID = 6
3755   Session ID = 1
3756 < Transaction ID = 9
3756 > Transaction ID = 8
3757   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3758  
3759   Journal Entry = jeTransCommitRet(Commit Retaining)
3760 < Timestamp = 2021/12/07 09:58:40.8900
3760 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3761 > Attachment ID = 6
3762   Session ID = 1
3763 < Transaction ID = 10
3764 < Old TransactionID = 9
3763 > Transaction ID = 9
3764 > Old TransactionID = 8
3765  
3766   Journal Entry = jeQuery(Query)
3767 < Timestamp = 2021/12/07 09:58:40.9150
3767 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3768 > Attachment ID = 6
3769   Session ID = 1
3770 < Transaction ID = 10
3770 > Transaction ID = 9
3771   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3772  
3773   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3774 < Timestamp = 2021/12/07 09:58:41.0150
3774 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3775 > Attachment ID = 6
3776   Session ID = 1
3777 < Transaction ID = 11
3778 < Old TransactionID = 10
3777 > Transaction ID = 10
3778 > Old TransactionID = 9
3779  
3780   Journal Entry = jeQuery(Query)
3781 < Timestamp = 2021/12/07 09:58:41.0390
3781 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3782 > Attachment ID = 6
3783   Session ID = 1
3784 < Transaction ID = 11
3784 > Transaction ID = 10
3785   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3786  
3787   Journal Entry = jeTransStart(Transaction Start)
3788 < Timestamp = 2021/12/07 09:58:41.0610
3788 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3789 > Attachment ID = 6
3790   Session ID = 1
3791 < Transaction ID = 12
3791 > Transaction ID = 11
3792   Transaction Name = "Transaction_29_2"
3793   TPB: Item Count = 3
3794    isc_tpb_write
# Line 3727 | Line 3798 | TPB: Item Count = 3
3798   Default Completion = TARollback
3799  
3800   Journal Entry = jeTransCommit(Commit)
3801 < Timestamp = 2021/12/07 09:58:41.1310
3801 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3802 > Attachment ID = 6
3803   Session ID = 1
3804 < Transaction ID = 11
3804 > Transaction ID = 10
3805  
3806   Journal Entry = jeQuery(Query)
3807 < Timestamp = 2021/12/07 09:58:41.1910
3807 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3808 > Attachment ID = 6
3809   Session ID = 1
3810 < Transaction ID = 12
3810 > Transaction ID = 11
3811   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:
3812   Whether ''tis nobler in the mind to suffer
3813   The slings and arrows of outrageous fortune,
# Line 3773 | Line 3846 | Be all my sins remembered
3846   ')
3847  
3848   Journal Entry = jeQuery(Query)
3849 < Timestamp = 2021/12/07 09:58:41.2100
3849 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3850 > Attachment ID = 6
3851   Session ID = 1
3852 < Transaction ID = 12
3852 > Transaction ID = 11
3853   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3854   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3855   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3784 | Line 3858 | FFD8FFE000104A46494600010101004800480000
3858   )
3859  
3860   Journal Entry = jeQuery(Query)
3861 < Timestamp = 2021/12/07 09:58:41.2330
3861 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3862 > Attachment ID = 6
3863   Session ID = 1
3864 < Transaction ID = 12
3864 > Transaction ID = 11
3865   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">
3866   <elt ix="0">100</elt>
3867   <elt ix="1">99</elt>
# Line 3809 | Line 3884 | Query = Insert into TestData(RowID,MyArr
3884   )
3885  
3886   Journal Entry = jeTransRollback(Rollback)
3887 < Timestamp = 2021/12/07 09:58:41.3650
3887 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3888 > Attachment ID = 6
3889   Session ID = 1
3890 < Transaction ID = 12
3890 > Transaction ID = 11
3891  
3892  
3893  

Diff Legend

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