ViewVC Help

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

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

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 381 by tony, Sat Jan 15 00:06:22 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 = 6359
537		Transaction is Read/Write
538	<	Transaction ID = 5277
539	<	Oldest Interesting = 5275
540	<	Oldest Action = 5276
541	<	Oldest Snapshot = 5276
538	>	Transaction ID = 6359
539	>	Oldest Interesting = 6318
540	>	Oldest Action = 6358
541	>	Oldest Snapshot = 6358
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
573	>	Current memory = 937,536
574		Delta memory = 1,288
575	<	Max memory = 992,448
576	<	Elapsed time= 0.002 sec
575	>	Max memory = 965,600
576	>	Elapsed time= 0.000 sec
577		Cpu = 0.000 sec
578		Buffers = 75
579		Reads = 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.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)
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.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)
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	+	Numeric Operations
3313	+	Add 2.23 + 24.12345 = 26.35345
3314	+	Add Double 2.23 + 24.12645 = 26.35645
3315	+	Add integer 2.23 + 2412345 = 2412347.23
3316	+	Subtract 2.23 - 24.12345 = -21.89345
3317	+	Subtract Double 24.12645 - 2.23 = -21.89645
3318	+	Subtract integer 24123.45 - 223 = -23900.45
3319	+	Multiply 2.23 * 24.12345 = 53.7952935
3320	+	Multiply Double 24.12645 * 2.23 = 53.8019835
3321	+	Multiply integer 241.2345 * 223 = 53795.2935
3322	+	Divide 24.12345 / 2.23 = 10.81769
3323	+	Divide Double 2.23 / 24.12645 = 0.09
3324	+	Divide integer 241.2345 / 223 = 1.0818
3325	+	Compare 2.23, -24.12345 = 1
3326	+	Compare integer 2.23, 3 = -1
3327	+	Compare Double 2.23, 2.23 = 0
3328	+	Negate 24.12345 = -24.12345
3329		SQL Params
3330		SQLType =SQL_LONG
3331		sub type = 0
#	Line 3342 | Line 3376 | Charset id = 0
3376		Nullable
3377		Size = 8
3378
3379	<	Expected Error - Dynamic SQL Error
3380	<	-SQL error code = -303
3381	<	-conversion error from string "1,000"
3382	<	Expected Error - Dynamic SQL Error
3383	<	-SQL error code = -303
3384	<	-conversion error from string "10.0.0"
3379	>	Expected Error - SQLCODE: -303
3380	>	Engine Code: 335544569 Incompatible column/host variable data type
3381	>	Dynamic SQL Error
3382	>	Expected Error - SQLCODE: -303
3383	>	Engine Code: 335544569 Incompatible column/host variable data type
3384	>	Dynamic SQL Error
3385	>	Test Numeric Type
3386		ROWID = 1
3387		ITYPE = 101
3388		I64TYPE = 9223372036854775807
#	Line 3372 | Line 3407 | I64TYPE = 10
3407		CURRTYPE = .02300000
3408		DTYPE = .00110000
3409		FIXEDPOINT = 233.45600000
3410	+	ROWID = 7
3411	+	ITYPE = 1
3412	+	I64TYPE = 1234567
3413	+	CURRTYPE = .02300000
3414	+	DTYPE = .00110000
3415	+	FIXEDPOINT = 1,234.25000000
3416
3417
3418
3419		------------------------------------------------------
3420		Running Test 22: Journalling
3421	<	Start Journaling. Session ID = 1
3421	>	Start Journaling. Session ID = 0
3422		1234.567 parsed to 1234567 scale = -3
3423		As Float =  1.2345670000000000E+003
3424		-765.4321 parsed to -7654321 scale = -4
#	Line 3535 | Line 3576 | MYARRAY = NULL
3576
3577		Journal Table
3578		IBX$SESSIONID = 1
3579	<	IBX$TRANSACTIONID = 8
3579	>	IBX$TRANSACTIONID = 7
3580		IBX$OLDTRANSACTIONID = NULL
3581		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3582	<	IBX$CREATED = 2021/12/07 09:57:12.8450
3582	>	IBX$CREATED = 2022/01/14 23:03:42.7720
3583		IBX$SESSIONID = 1
3584	<	IBX$TRANSACTIONID = 10
3585	<	IBX$OLDTRANSACTIONID = 9
3584	>	IBX$TRANSACTIONID = 9
3585	>	IBX$OLDTRANSACTIONID = 8
3586		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3587	<	IBX$CREATED = 2021/12/07 09:57:13.1650
3587	>	IBX$CREATED = 2022/01/14 23:03:43.1080
3588
3589		Journal Entries
3590		Journal Entry = jeTransStart(Transaction Start)
3591	<	Timestamp = 2021/12/07 09:57:12.8740
3591	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3592	>	Attachment ID = 2
3593		Session ID = 1
3594	<	Transaction ID = 8
3594	>	Transaction ID = 7
3595		Transaction Name = "Transaction_29_1"
3596		TPB: Item Count = 3
3597		isc_tpb_write
#	Line 3559 | Line 3601 | TPB: Item Count = 3
3601		Default Completion = TACommit
3602
3603		Journal Entry = jeQuery(Query)
3604	<	Timestamp = 2021/12/07 09:57:12.9610
3604	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3605	>	Attachment ID = 2
3606		Session ID = 1
3607	<	Transaction ID = 8
3607	>	Transaction ID = 7
3608		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3609
3610		Journal Entry = jeQuery(Query)
3611	<	Timestamp = 2021/12/07 09:57:12.9820
3611	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3612	>	Attachment ID = 2
3613		Session ID = 1
3614	<	Transaction ID = 8
3614	>	Transaction ID = 7
3615		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3616
3617		Journal Entry = jeTransCommitRet(Commit Retaining)
3618	<	Timestamp = 2021/12/07 09:57:13.0450
3618	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3619	>	Attachment ID = 2
3620		Session ID = 1
3621	<	Transaction ID = 9
3622	<	Old TransactionID = 8
3621	>	Transaction ID = 8
3622	>	Old TransactionID = 7
3623
3624		Journal Entry = jeQuery(Query)
3625	<	Timestamp = 2021/12/07 09:57:13.0670
3625	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3626	>	Attachment ID = 2
3627		Session ID = 1
3628	<	Transaction ID = 9
3628	>	Transaction ID = 8
3629		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3630
3631		Journal Entry = jeTransRollbackRet(Rollback Retaining)
3632	<	Timestamp = 2021/12/07 09:57:13.1620
3632	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3633	>	Attachment ID = 2
3634		Session ID = 1
3635	<	Transaction ID = 10
3636	<	Old TransactionID = 9
3635	>	Transaction ID = 9
3636	>	Old TransactionID = 8
3637
3638		Journal Entry = jeQuery(Query)
3639	<	Timestamp = 2021/12/07 09:57:13.1830
3639	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3640	>	Attachment ID = 2
3641		Session ID = 1
3642	<	Transaction ID = 10
3642	>	Transaction ID = 9
3643		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3644
3645		Journal Entry = jeTransStart(Transaction Start)
3646	<	Timestamp = 2021/12/07 09:57:13.1940
3646	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3647	>	Attachment ID = 2
3648		Session ID = 1
3649	<	Transaction ID = 11
3649	>	Transaction ID = 10
3650		Transaction Name = "Transaction_29_2"
3651		TPB: Item Count = 3
3652		isc_tpb_write
#	Line 3607 | Line 3656 | TPB: Item Count = 3
3656		Default Completion = TARollback
3657
3658		Journal Entry = jeTransCommit(Commit)
3659	<	Timestamp = 2021/12/07 09:57:13.2360
3659	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3660	>	Attachment ID = 2
3661		Session ID = 1
3662	<	Transaction ID = 10
3662	>	Transaction ID = 9
3663
3664		Journal Entry = jeQuery(Query)
3665	<	Timestamp = 2021/12/07 09:57:13.2590
3665	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3666	>	Attachment ID = 2
3667		Session ID = 1
3668	<	Transaction ID = 11
3668	>	Transaction ID = 10
3669		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:
3670		Whether ''tis nobler in the mind to suffer
3671		The slings and arrows of outrageous fortune,
#	Line 3653 | Line 3704 | Be all my sins remembered
3704		')
3705
3706		Journal Entry = jeQuery(Query)
3707	<	Timestamp = 2021/12/07 09:57:13.2780
3707	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3708	>	Attachment ID = 2
3709		Session ID = 1
3710	<	Transaction ID = 11
3710	>	Transaction ID = 10
3711		Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3712		FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3713		0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
#	Line 3664 | Line 3716 | FFD8FFE000104A46494600010101004800480000
3716		)
3717
3718		Journal Entry = jeQuery(Query)
3719	<	Timestamp = 2021/12/07 09:57:13.3010
3719	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3720	>	Attachment ID = 2
3721		Session ID = 1
3722	<	Transaction ID = 11
3722	>	Transaction ID = 10
3723		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">
3724		<elt ix="0">100</elt>
3725		<elt ix="1">99</elt>
#	Line 3689 | Line 3742 | Query = Insert into TestData(RowID,MyArr
3742		)
3743
3744		Journal Entry = jeTransRollback(Rollback)
3745	<	Timestamp = 2021/12/07 09:57:13.3610
3745	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3746	>	Attachment ID = 2
3747		Session ID = 1
3748	<	Transaction ID = 11
3748	>	Transaction ID = 10
3749
3750
3751

Diff Legend

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