ViewVC Help

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

root/public/ibx/trunk/fbintf/testsuite/FB3reference.log

Comparing ibx/trunk/fbintf/testsuite/FB3reference.log (file contents):
Revision 345 by tony, Mon Aug 23 14:22:29 2021 UTC vs.
Revision 353 by tony, Sat Oct 23 14:11:37 2021 UTC

#	Line 76 | Line 76 | Dropping Database
76
77		------------------------------------------------------
78		Running Test 2: Open the employee database and run a query
79	+	Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
80		Opening inet://localhost/employee
81		Database Open, SQL Dialect = 3
82		TPB: Item Count = 3
#	Line 292 | Line 293 | Not Null
293		Size = 2
294		Value = 0
295
296	+	Results for Cursor: Test Cursor
297		EMP_NO = 8
298		FIRST_NAME = Leslie
299		LAST_NAME = Johnson
#	Line 519 | Line 521 | Not Null
521		Size = 2
522		Value = 0
523
524	+	Results for Cursor: Test Cursor
525		EMP_NO = 8
526		FIRST_NAME = Leslie
527		LAST_NAME = Johnson
#	Line 531 | Line 534 | JOB_COUNTRY = USA
534		SALARY = 64,635.00
535		FULL_NAME = Johnson, Leslie
536
537	+	Scollable Cursors
538	+	DB Connect String = employee
539	+	DB Charset ID = 4
540	+	DB SQL Dialect = 3
541	+	DB Remote Protocol =
542	+	DB ODS Major Version = 12
543	+	DB ODS Minor Version = 0
544	+	User Authentication Method = User name in DPB
545	+	Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
546	+	DB Client Implementation Version = 3.0
547	+	Do Fetch Next:
548	+	EMP_NO = 2
549	+	FIRST_NAME = Robert
550	+	LAST_NAME = Nelson
551	+	PHONE_EXT = 250
552	+	HIRE_DATE = 1988/12/28 00:00:00.0000
553	+	DEPT_NO = 600
554	+	JOB_CODE = VP
555	+	JOB_GRADE = 2
556	+	JOB_COUNTRY = USA
557	+	SALARY = 105,900.00
558	+	FULL_NAME = Nelson, Robert
559	+	Do Fetch Last:
560	+	EMP_NO = 145
561	+	FIRST_NAME = Mark
562	+	LAST_NAME = Guckenheimer
563	+	PHONE_EXT = 221
564	+	HIRE_DATE = 1994/05/02 00:00:00.0000
565	+	DEPT_NO = 622
566	+	JOB_CODE = Eng
567	+	JOB_GRADE = 5
568	+	JOB_COUNTRY = USA
569	+	SALARY = 32,000.00
570	+	FULL_NAME = Guckenheimer, Mark
571	+	Do Fetch Prior:
572	+	EMP_NO = 144
573	+	FIRST_NAME = John
574	+	LAST_NAME = Montgomery
575	+	PHONE_EXT = 820
576	+	HIRE_DATE = 1994/03/30 00:00:00.0000
577	+	DEPT_NO = 672
578	+	JOB_CODE = Eng
579	+	JOB_GRADE = 5
580	+	JOB_COUNTRY = USA
581	+	SALARY = 35,000.00
582	+	FULL_NAME = Montgomery, John
583	+	Do Fetch First:
584	+	EMP_NO = 2
585	+	FIRST_NAME = Robert
586	+	LAST_NAME = Nelson
587	+	PHONE_EXT = 250
588	+	HIRE_DATE = 1988/12/28 00:00:00.0000
589	+	DEPT_NO = 600
590	+	JOB_CODE = VP
591	+	JOB_GRADE = 2
592	+	JOB_COUNTRY = USA
593	+	SALARY = 105,900.00
594	+	FULL_NAME = Nelson, Robert
595	+	Do Fetch Abs 8 :
596	+	EMP_NO = 14
597	+	FIRST_NAME = Stewart
598	+	LAST_NAME = Hall
599	+	PHONE_EXT = 227
600	+	HIRE_DATE = 1990/06/04 00:00:00.0000
601	+	DEPT_NO = 900
602	+	JOB_CODE = Finan
603	+	JOB_GRADE = 3
604	+	JOB_COUNTRY = USA
605	+	SALARY = 69,482.63
606	+	FULL_NAME = Hall, Stewart
607	+	Do Fetch Relative -2 :
608	+	EMP_NO = 11
609	+	FIRST_NAME = K. J.
610	+	LAST_NAME = Weston
611	+	PHONE_EXT = 34
612	+	HIRE_DATE = 1990/01/17 00:00:00.0000
613	+	DEPT_NO = 130
614	+	JOB_CODE = SRep
615	+	JOB_GRADE = 4
616	+	JOB_COUNTRY = USA
617	+	SALARY = 86,292.94
618	+	FULL_NAME = Weston, K. J.
619	+	Do Fetch beyond EOF :
620	+	Fetch returned false
621
622
623		------------------------------------------------------
#	Line 568 | Line 655 | JOB_COUNTRY = USA
655		SALARY = 64,635.00
656		FULL_NAME = Johnson, Leslie
657
658	<	Current memory = 19,693,312
658	>	Current memory = 19,694,032
659		Delta memory = 4,480
660	<	Max memory = 19,755,424
661	<	Elapsed time= 0.001 sec
660	>	Max memory = 19,755,888
661	>	Elapsed time= 0.002 sec
662		Cpu = 0.000 sec
663		Buffers = 2048
664		Reads = 0
#	Line 2609 | Line 2696 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2696
2697		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)
2698
2699	<	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: 14.69) (15: 15.75) (16: 16.79)
2699	>	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)
2700
2701
2702		Shrink to 2:10
#	Line 2625 | Line 2712 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2712
2713		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)
2714
2715	<	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: 14.69) (15: 15.75) (16: 16.79)
2715	>	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)
2716
2717
2718
#	Line 2722 | Line 2809 | Database is Read/Write
2809		Database Created: 09/1/2020 13:13:45
2810		Pages Used = 297
2811		Pages Free = 10
2812	<	Server Memory = 19195664
2812	>	Server Memory = 19196128
2813		Forced Writes  = 1
2814	<	Max Memory  = 19316176
2814	>	Max Memory  = 19316896
2815		Num Buffers  = 2048
2816		Sweep Interval  = 20000
2817		Logged in Users: SYSDBA,
#	Line 2841 | Line 2928 | Local Backup
2928
2929
2930
2931	+
2932		Local Backup Complete
2933
2934		Local Restore
#	Line 3139 | Line 3227 | Invalid Param SQL Type Test
3227		Error Handled: Field "EMP_NO" not found
3228		Case sensitive Param SQL  Test
3229		Error Handled: Field "EMP_NO" not found
3230	+	Stale Reference Check
3231	+	First test correct usage
3232	+	COUNTER = 42
3233	+
3234	+	New Transaction before param set
3235	+	Error Handled: This interface is no longer up-to-date
3236	+	New Transaction before Open Cursor
3237	+	Error Handled: This interface is no longer up-to-date
3238	+	Stop Stale Reference Checks
3239	+	New Transaction before param set
3240	+	COUNTER = 42
3241	+
3242	+	New Transaction before Open Cursor
3243	+	COUNTER = 42
3244	+
3245		Invalid Server Name Test
3246		Error Handled: Unable to complete network request to host "unknown".
3247		-Failed to locate host machine.
#	Line 3252 | Line 3355 | Skipping test for Firebird 4 and later
3355
3356
3357		------------------------------------------------------
3358	+	Running Test 21: Exercise setting and getting of numeric data types
3359	+	SQL Params
3360	+	SQLType =SQL_LONG
3361	+	sub type = 0
3362	+	Field Name =
3363	+	Scale = 0
3364	+	Charset id = 0
3365	+	Not Null
3366	+	Size = 4
3367	+	Value = 0
3368	+
3369	+	SQLType =SQL_LONG
3370	+	sub type = 0
3371	+	Field Name =
3372	+	Scale = 0
3373	+	Charset id = 0
3374	+	Nullable
3375	+	Size = 4
3376	+
3377	+	SQLType =SQL_INT64
3378	+	sub type = 0
3379	+	Field Name =
3380	+	Scale = 0
3381	+	Charset id = 0
3382	+	Nullable
3383	+	Size = 8
3384	+
3385	+	SQLType =SQL_INT64
3386	+	sub type = 0
3387	+	Field Name =
3388	+	Scale = -4
3389	+	Charset id = 0
3390	+	Nullable
3391	+	Size = 8
3392	+
3393	+	SQLType =SQL_DOUBLE
3394	+	sub type = 0
3395	+	Field Name =
3396	+	Scale = 0
3397	+	Charset id = 0
3398	+	Nullable
3399	+	Size = 8
3400	+
3401	+	SQLType =SQL_INT64
3402	+	sub type = 0
3403	+	Field Name =
3404	+	Scale = -6
3405	+	Charset id = 0
3406	+	Nullable
3407	+	Size = 8
3408	+
3409	+	Expected Error - Dynamic SQL Error
3410	+	-SQL error code = -303
3411	+	-conversion error from string "1,000"
3412	+	Expected Error - Dynamic SQL Error
3413	+	-SQL error code = -303
3414	+	-conversion error from string "10.0.0"
3415	+	ROWID = 1
3416	+	ITYPE = 101
3417	+	I64TYPE = 9223372036854775807
3418	+	CURRTYPE = 10,000.12340000
3419	+	DTYPE = 9,999.12345678
3420	+	FIXEDPOINT = 1,234,567,890.12345700
3421	+	ROWID = 2
3422	+	ITYPE = -32457
3423	+	I64TYPE = -9223372036854775808
3424	+	CURRTYPE = 1,000,001.12000000
3425	+	DTYPE = 1.7E308
3426	+	FIXEDPOINT = -1,234,567,890.12345700
3427	+	ROWID = 3
3428	+	ITYPE = 0
3429	+	I64TYPE = 0
3430	+	CURRTYPE = .00000000
3431	+	DTYPE = .00000000
3432	+	FIXEDPOINT = .00000000
3433	+	ROWID = 4
3434	+	ITYPE = 1
3435	+	I64TYPE = 10
3436	+	CURRTYPE = .02300000
3437	+	DTYPE = .00110000
3438	+	FIXEDPOINT = 233.45600000
3439	+
3440	+
3441	+
3442	+	------------------------------------------------------
3443		Test Suite Ends

Diff Legend

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