ViewVC Help

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

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

Comparing ibx/branches/udr/testsuite/FB3reference.log (file contents):
Revision 370 by tony, Wed Jan 5 14:59:15 2022 UTC vs.
Revision 371 by tony, Wed Jan 5 15:21: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 = 5588
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 = 5588
657	>	Oldest Interesting = 5586
658	>	Oldest Action = 5587
659	>	Oldest Snapshot = 5587
660		Oldest Interesting = 0
661		Employee Count = 41
662		Employee Count = 42
#	Line 692 | Line 692 | Current memory = 19,694,032
692		Delta memory = 4,480
693		Max memory = 19,755,888
694		Elapsed time= 0.002 sec
695	<	Cpu = 0.010 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.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 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		SQL Params
3451		SQLType =SQL_LONG
3452		sub type = 0
#	Line 3462 | Line 3497 | Charset id = 0
3497		Nullable
3498		Size = 8
3499
3500	<	Expected Error - Dynamic SQL Error
3500	>	Expected Error - SQLCODE: -303
3501	>	Engine Code: 335544569 Incompatible column/host variable data type
3502	>	Dynamic SQL Error
3503		-SQL error code = -303
3504		-conversion error from string "1,000"
3505	<	Expected Error - Dynamic SQL Error
3505	>	Expected Error - SQLCODE: -303
3506	>	Engine Code: 335544569 Incompatible column/host variable data type
3507	>	Dynamic SQL Error
3508		-SQL error code = -303
3509		-conversion error from string "10.0.0"
3510	+	Test Numeric Type
3511		ROWID = 1
3512		ITYPE = 101
3513		I64TYPE = 9223372036854775807
#	Line 3492 | Line 3532 | I64TYPE = 10
3532		CURRTYPE = .02300000
3533		DTYPE = .00110000
3534		FIXEDPOINT = 233.45600000
3535	+	ROWID = 7
3536	+	ITYPE = 1
3537	+	I64TYPE = 1234567
3538	+	CURRTYPE = .02300000
3539	+	DTYPE = .00110000
3540	+	FIXEDPOINT = 1,234.25000000
3541
3542
3543
3544		------------------------------------------------------
3545		Running Test 22: Journalling
3546	<	Start Journaling. Session ID = 1
3546	>	Start Journaling. Session ID = 0
3547		1234.567 parsed to 1234567 scale = -3
3548		As Float =  1.2345670000000000E+003
3549		-765.4321 parsed to -7654321 scale = -4
#	Line 3658 | Line 3704 | IBX$SESSIONID = 1
3704		IBX$TRANSACTIONID = 9
3705		IBX$OLDTRANSACTIONID = NULL
3706		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3707	<	IBX$CREATED = 2021/12/07 09:58:40.6960
3707	>	IBX$CREATED = 2022/01/02 13:51:28.9780
3708		IBX$SESSIONID = 1
3709		IBX$TRANSACTIONID = 11
3710		IBX$OLDTRANSACTIONID = 10
3711		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3712	<	IBX$CREATED = 2021/12/07 09:58:41.0190
3712	>	IBX$CREATED = 2022/01/02 13:51:29.3510
3713
3714		Journal Entries
3715		Journal Entry = jeTransStart(Transaction Start)
3716	<	Timestamp = 2021/12/07 09:58:40.7300
3716	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3717	>	Attachment ID = 6
3718		Session ID = 1
3719		Transaction ID = 9
3720		Transaction Name = "Transaction_29_1"
#	Line 3679 | Line 3726 | TPB: Item Count = 3
3726		Default Completion = TACommit
3727
3728		Journal Entry = jeQuery(Query)
3729	<	Timestamp = 2021/12/07 09:58:40.7970
3729	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3730	>	Attachment ID = 6
3731		Session ID = 1
3732		Transaction ID = 9
3733		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3734
3735		Journal Entry = jeQuery(Query)
3736	<	Timestamp = 2021/12/07 09:58:40.8130
3736	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3737	>	Attachment ID = 6
3738		Session ID = 1
3739		Transaction ID = 9
3740		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3741
3742		Journal Entry = jeTransCommitRet(Commit Retaining)
3743	<	Timestamp = 2021/12/07 09:58:40.8900
3743	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3744	>	Attachment ID = 6
3745		Session ID = 1
3746		Transaction ID = 10
3747		Old TransactionID = 9
3748
3749		Journal Entry = jeQuery(Query)
3750	<	Timestamp = 2021/12/07 09:58:40.9150
3750	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3751	>	Attachment ID = 6
3752		Session ID = 1
3753		Transaction ID = 10
3754		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3755
3756		Journal Entry = jeTransRollbackRet(Rollback Retaining)
3757	<	Timestamp = 2021/12/07 09:58:41.0150
3757	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3758	>	Attachment ID = 6
3759		Session ID = 1
3760		Transaction ID = 11
3761		Old TransactionID = 10
3762
3763		Journal Entry = jeQuery(Query)
3764	<	Timestamp = 2021/12/07 09:58:41.0390
3764	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3765	>	Attachment ID = 6
3766		Session ID = 1
3767		Transaction ID = 11
3768		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3769
3770		Journal Entry = jeTransStart(Transaction Start)
3771	<	Timestamp = 2021/12/07 09:58:41.0610
3771	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3772	>	Attachment ID = 6
3773		Session ID = 1
3774		Transaction ID = 12
3775		Transaction Name = "Transaction_29_2"
#	Line 3727 | Line 3781 | TPB: Item Count = 3
3781		Default Completion = TARollback
3782
3783		Journal Entry = jeTransCommit(Commit)
3784	<	Timestamp = 2021/12/07 09:58:41.1310
3784	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3785	>	Attachment ID = 6
3786		Session ID = 1
3787		Transaction ID = 11
3788
3789		Journal Entry = jeQuery(Query)
3790	<	Timestamp = 2021/12/07 09:58:41.1910
3790	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3791	>	Attachment ID = 6
3792		Session ID = 1
3793		Transaction ID = 12
3794		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:
#	Line 3773 | Line 3829 | Be all my sins remembered
3829		')
3830
3831		Journal Entry = jeQuery(Query)
3832	<	Timestamp = 2021/12/07 09:58:41.2100
3832	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3833	>	Attachment ID = 6
3834		Session ID = 1
3835		Transaction ID = 12
3836		Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
#	Line 3784 | Line 3841 | FFD8FFE000104A46494600010101004800480000
3841		)
3842
3843		Journal Entry = jeQuery(Query)
3844	<	Timestamp = 2021/12/07 09:58:41.2330
3844	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3845	>	Attachment ID = 6
3846		Session ID = 1
3847		Transaction ID = 12
3848		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">
#	Line 3809 | Line 3867 | Query = Insert into TestData(RowID,MyArr
3867		)
3868
3869		Journal Entry = jeTransRollback(Rollback)
3870	<	Timestamp = 2021/12/07 09:58:41.3650
3870	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3871	>	Attachment ID = 6
3872		Session ID = 1
3873		Transaction ID = 12
3874

Diff Legend

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