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

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

# Line 7 | Line 7 | Firebird Environment Variable = /opt/fir
7   Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so
8   Running Test 1: Create and Drop a Database
9   Creating a Database with empty parameters
10 < Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
11 < -Error while trying to create file
12 < -No such file or directory
10 > Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file ""
11   Creating a Database using an SQL Statement
12   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
13   SQL Dialect = 3
# Line 74 | Line 72 | Dropping Database
72  
73   ------------------------------------------------------
74   Running Test 2: Open the employee database and run a query
75 < Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
75 > Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
76   Opening localhost:employee
77   Database Open, SQL Dialect = 3
78   TPB: Item Count = 3
# Line 535 | Line 533 | Running Test 3: ad hoc queries
533   Opening localhost:employee
534   Database Open
535   Employee Count = 42
536 < Transaction ID = 5277
536 > Transaction ID = 6014
537   Transaction is Read/Write
538 < Transaction ID = 5277
539 < Oldest Interesting = 5275
540 < Oldest Action = 5276
541 < Oldest Snapshot = 5276
538 > Transaction ID = 6014
539 > Oldest Interesting = 5461
540 > Oldest Action = 6013
541 > Oldest Snapshot = 6013
542   Oldest Interesting = 0
543   Employee Count = 41
544   Employee Count = 42
# Line 572 | Line 570 | JOB_COUNTRY = USA
570   SALARY = 64,635.00
571   FULL_NAME = Johnson, Leslie
572  
573 < Current memory = 948,496
574 < Delta memory = 1,288
575 < Max memory = 992,448
576 < Elapsed time= 0.002 sec
577 < Cpu = 0.000 sec
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
578   Buffers = 75
579   Reads = 0
580   Writes = 0
# Line 2613 | 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.45) (16: 4269)
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)
2615  
2616  
2617   Shrink to 2:10
# Line 2629 | 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.45) (16: 4269)
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)
2631  
2632  
2633  
# Line 2726 | Line 2724 | Database is Read/Write
2724   Database Created: 17/6/2019 19:37:08
2725   Unknown Response 3
2726   Unknown Response 3
2727 < Server Memory = 841392
2727 > Server Memory = 721912
2728   Forced Writes  = 1
2729 < Max Memory  = 879288
2729 > Max Memory  = 737792
2730   Num Buffers  = 75
2731   Sweep Interval  = 20000
2732   Logged in Users: SYSDBA,
2733   Active Transaction Count = 0
2734 < Fetches  = 1040
2735 < Writes  = 6
2736 < Reads  = 84
2737 < Page Writes  = 6
2734 > Fetches  = 520
2735 > Writes  = 4
2736 > Reads  = 58
2737 > Page Writes  = 4
2738   Record Version Removals Operation Counts
2739  
2740   Deletes Operation Counts
# Line 2748 | Line 2746 | Insert Count Operation Counts
2746   Purge Count Countites Operation Counts
2747  
2748   Indexed Reads Count Operation Counts
2751 – Table ID = 2
2752 – Count = 14
2753 – Table ID = 5
2754 – Count = 28
2749   Table ID = 6
2750 < Count = 58
2750 > Count = 11
2751   Table ID = 11
2752 < Count = 3
2752 > Count = 1
2753   Table ID = 12
2754 < Count = 36
2754 > Count = 24
2755   Table ID = 28
2756 < Count = 9
2756 > Count = 4
2757   Table ID = 29
2758 < Count = 7
2758 > Count = 4
2759  
2760   Sequential Table Scans Operation Counts
2761   Table ID = 0
# Line 2825 | Line 2819 | User ID = 0
2819   Group ID = 0
2820  
2821  
2822 < Licence Info: feature is not supported
2829 < -feature is not supported
2822 > Licence Info: Engine Code: 335544378 feature is not supported
2823  
2824 < Licence Mask Info: feature is not supported
2824 > Licence Mask Info: Engine Code: 335544378 feature is not supported
2825  
2826   Capabilities = 260
2827  
# Line 3115 | Line 3108 | Écoute moi
3108   ------------------------------------------------------
3109   Running Test 16: Error handling
3110   Invalid Database Name Test
3111 < Error Handled: I/O error during "open" operation for file "Malformed Name"
3112 < -Error while trying to open file
3113 < -No such file or directory
3111 > Error Handled: SQLCODE: -902
3112 > Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3113 > I/O error during "open" operation for file "Malformed Name"
3114   Invalid User Name Test
3115 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3115 > Error Handled: SQLCODE: -902
3116 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3117 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3118   Invalid password Test
3119 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3119 > Error Handled: SQLCODE: -902
3120 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3121 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3122   Invalid Prepare SQL Test
3123 < Error Handled: Dynamic SQL Error
3124 < -SQL error code = -206
3125 < -Column unknown
3129 < -UNKNOWN_DATE
3130 < -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3123 > Error Handled: SQLCODE: -206
3124 > Engine Code: 335544569 Column does not belong to referenced table
3125 > Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3126   Invalid Open Cursor SQL Test
3127 < Error Handled: Dynamic SQL Error
3128 < -SQL error code = -206
3129 < -Column unknown
3135 < -X
3136 < -At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
3127 > Error Handled: SQLCODE: -206
3128 > Engine Code: 335544569 Column does not belong to referenced table
3129 > Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE
3130   Transaction not started Test
3131   Error Handled: Transaction is not active
3132   Invalid Param SQL Type Test
# Line 3156 | Line 3149 | New Transaction before Open Cursor
3149   COUNTER = 42
3150  
3151   Invalid Server Name Test
3152 < Error Handled: Unable to complete network request to host "unknown".
3153 < -Failed to locate host machine
3152 > Error Handled: SQLCODE: -902
3153 > Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3154 > Unable to complete network request to host "unknown"
3155   Invalid User Name Test
3156 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3156 > Error Handled: SQLCODE: -902
3157 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3158 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3159   Invalid password Test
3160 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3160 > Error Handled: SQLCODE: -902
3161 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3162 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3163  
3164  
3165   ------------------------------------------------------
# Line 3292 | Line 3290 | Parsing of 1.2E1.2 failed
3290   Parsing of 1,000 failed
3291   Parsing of 1e1e1 failed
3292   Parsing of 1.2+3 failed
3293 + Validating Numeric Interface - IFBNumeric
3294 + Value from Currency = 9999.1235
3295 + Raw Value = 99991235 Scale = -4
3296 + Value from Currency(rescaled) = 9999.12
3297 + Raw Value = 999912 Scale = -2
3298 + Value from Double = 9999.12345678
3299 + Raw Value = 999912345678 Scale = -8
3300 + Value from Integer = 9223372036854775807
3301 + Raw Value = 9223372036854775807 Scale = 0
3302 + Value from string = 9223372036854775807
3303 + Raw Value = 9223372036854775807 Scale = 0
3304 + Value from string = 9999.12345678
3305 + Raw Value = 999912345678 Scale = -8
3306 + Value from string = -0.12
3307 + Raw Value = -12 Scale = -3
3308 + 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   SQL Params
3313   SQLType =SQL_LONG
3314   sub type = 0
# Line 3342 | Line 3359 | Charset id = 0
3359   Nullable
3360   Size = 8
3361  
3362 < Expected Error - Dynamic SQL Error
3363 < -SQL error code = -303
3364 < -conversion error from string "1,000"
3365 < Expected Error - Dynamic SQL Error
3366 < -SQL error code = -303
3367 < -conversion error from string "10.0.0"
3362 > Expected Error - SQLCODE: -303
3363 > Engine Code: 335544569 Incompatible column/host variable data type
3364 > Dynamic SQL Error
3365 > Expected Error - SQLCODE: -303
3366 > Engine Code: 335544569 Incompatible column/host variable data type
3367 > Dynamic SQL Error
3368 > Test Numeric Type
3369   ROWID = 1
3370   ITYPE = 101
3371   I64TYPE = 9223372036854775807
# Line 3372 | Line 3390 | I64TYPE = 10
3390   CURRTYPE = .02300000
3391   DTYPE = .00110000
3392   FIXEDPOINT = 233.45600000
3393 + ROWID = 7
3394 + ITYPE = 1
3395 + I64TYPE = 1234567
3396 + CURRTYPE = .02300000
3397 + DTYPE = .00110000
3398 + FIXEDPOINT = 1,234.25000000
3399  
3400  
3401  
3402   ------------------------------------------------------
3403   Running Test 22: Journalling
3404 < Start Journaling. Session ID = 1
3404 > Start Journaling. Session ID = 0
3405   1234.567 parsed to 1234567 scale = -3
3406   As Float =  1.2345670000000000E+003
3407   -765.4321 parsed to -7654321 scale = -4
# Line 3535 | Line 3559 | MYARRAY = NULL
3559  
3560   Journal Table
3561   IBX$SESSIONID = 1
3562 < IBX$TRANSACTIONID = 8
3562 > IBX$TRANSACTIONID = 7
3563   IBX$OLDTRANSACTIONID = NULL
3564   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3565 < IBX$CREATED = 2021/12/07 09:57:12.8450
3565 > IBX$CREATED = 2022/01/09 15:33:11.5220
3566   IBX$SESSIONID = 1
3567 < IBX$TRANSACTIONID = 10
3568 < IBX$OLDTRANSACTIONID = 9
3567 > IBX$TRANSACTIONID = 9
3568 > IBX$OLDTRANSACTIONID = 8
3569   IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3570 < IBX$CREATED = 2021/12/07 09:57:13.1650
3570 > IBX$CREATED = 2022/01/09 15:33:11.8430
3571  
3572   Journal Entries
3573   Journal Entry = jeTransStart(Transaction Start)
3574 < Timestamp = 2021/12/07 09:57:12.8740
3574 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3575 > Attachment ID = 2
3576   Session ID = 1
3577 < Transaction ID = 8
3577 > Transaction ID = 7
3578   Transaction Name = "Transaction_29_1"
3579   TPB: Item Count = 3
3580    isc_tpb_write
# Line 3559 | Line 3584 | TPB: Item Count = 3
3584   Default Completion = TACommit
3585  
3586   Journal Entry = jeQuery(Query)
3587 < Timestamp = 2021/12/07 09:57:12.9610
3587 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3588 > Attachment ID = 2
3589   Session ID = 1
3590 < Transaction ID = 8
3590 > Transaction ID = 7
3591   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3592  
3593   Journal Entry = jeQuery(Query)
3594 < Timestamp = 2021/12/07 09:57:12.9820
3594 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3595 > Attachment ID = 2
3596   Session ID = 1
3597 < Transaction ID = 8
3597 > Transaction ID = 7
3598   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3599  
3600   Journal Entry = jeTransCommitRet(Commit Retaining)
3601 < Timestamp = 2021/12/07 09:57:13.0450
3601 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3602 > Attachment ID = 2
3603   Session ID = 1
3604 < Transaction ID = 9
3605 < Old TransactionID = 8
3604 > Transaction ID = 8
3605 > Old TransactionID = 7
3606  
3607   Journal Entry = jeQuery(Query)
3608 < Timestamp = 2021/12/07 09:57:13.0670
3608 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3609 > Attachment ID = 2
3610   Session ID = 1
3611 < Transaction ID = 9
3611 > Transaction ID = 8
3612   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3613  
3614   Journal Entry = jeTransRollbackRet(Rollback Retaining)
3615 < Timestamp = 2021/12/07 09:57:13.1620
3615 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3616 > Attachment ID = 2
3617   Session ID = 1
3618 < Transaction ID = 10
3619 < Old TransactionID = 9
3618 > Transaction ID = 9
3619 > Old TransactionID = 8
3620  
3621   Journal Entry = jeQuery(Query)
3622 < Timestamp = 2021/12/07 09:57:13.1830
3622 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3623 > Attachment ID = 2
3624   Session ID = 1
3625 < Transaction ID = 10
3625 > Transaction ID = 9
3626   Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3627  
3628   Journal Entry = jeTransStart(Transaction Start)
3629 < Timestamp = 2021/12/07 09:57:13.1940
3629 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3630 > Attachment ID = 2
3631   Session ID = 1
3632 < Transaction ID = 11
3632 > Transaction ID = 10
3633   Transaction Name = "Transaction_29_2"
3634   TPB: Item Count = 3
3635    isc_tpb_write
# Line 3607 | Line 3639 | TPB: Item Count = 3
3639   Default Completion = TARollback
3640  
3641   Journal Entry = jeTransCommit(Commit)
3642 < Timestamp = 2021/12/07 09:57:13.2360
3642 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3643 > Attachment ID = 2
3644   Session ID = 1
3645 < Transaction ID = 10
3645 > Transaction ID = 9
3646  
3647   Journal Entry = jeQuery(Query)
3648 < Timestamp = 2021/12/07 09:57:13.2590
3648 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3649 > Attachment ID = 2
3650   Session ID = 1
3651 < Transaction ID = 11
3651 > Transaction ID = 10
3652   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:
3653   Whether ''tis nobler in the mind to suffer
3654   The slings and arrows of outrageous fortune,
# Line 3653 | Line 3687 | Be all my sins remembered
3687   ')
3688  
3689   Journal Entry = jeQuery(Query)
3690 < Timestamp = 2021/12/07 09:57:13.2780
3690 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3691 > Attachment ID = 2
3692   Session ID = 1
3693 < Transaction ID = 11
3693 > Transaction ID = 10
3694   Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3695   FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3696   0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
# Line 3664 | Line 3699 | FFD8FFE000104A46494600010101004800480000
3699   )
3700  
3701   Journal Entry = jeQuery(Query)
3702 < Timestamp = 2021/12/07 09:57:13.3010
3702 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3703 > Attachment ID = 2
3704   Session ID = 1
3705 < Transaction ID = 11
3705 > Transaction ID = 10
3706   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">
3707   <elt ix="0">100</elt>
3708   <elt ix="1">99</elt>
# Line 3689 | Line 3725 | Query = Insert into TestData(RowID,MyArr
3725   )
3726  
3727   Journal Entry = jeTransRollback(Rollback)
3728 < Timestamp = 2021/12/07 09:57:13.3610
3728 > Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3729 > Attachment ID = 2
3730   Session ID = 1
3731 < Transaction ID = 11
3731 > Transaction ID = 10
3732  
3733  
3734  

Diff Legend

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