ViewVC Help

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

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

Comparing ibx/trunk/fbintf/testsuite/FB4reference.log (file contents):
Revision 347 by tony, Mon Sep 20 22:08:20 2021 UTC vs.
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC

#	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
81		Opening inet://localhost/employee
82		Database Open, SQL Dialect = 3
83		TPB: Item Count = 3
#	Line 293 | Line 294 | Not Null
294		Size = 2
295		Value = 0
296
297	+	Results for Cursor: Test Cursor
298		EMP_NO = 8
299		FIRST_NAME = Leslie
300		LAST_NAME = Johnson
#	Line 520 | Line 522 | Not Null
522		Size = 2
523		Value = 0
524
525	+	Results for Cursor: Test Cursor
526		EMP_NO = 8
527		FIRST_NAME = Leslie
528		LAST_NAME = Johnson
#	Line 532 | Line 535 | JOB_COUNTRY = USA
535		SALARY = 64,635.00
536		FULL_NAME = Johnson, Leslie
537
538	+	Scollable Cursors
539	+	DB Connect String = employee
540	+	DB Charset ID = 4
541	+	DB SQL Dialect = 3
542	+	DB Remote Protocol =
543	+	DB ODS Major Version = 13
544	+	DB ODS Minor Version = 0
545	+	User Authentication Method = User name in DPB
546	+	Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
547	+	DB Client Implementation Version = 4.0
548	+	Do Fetch Next:
549	+	EMP_NO = 2
550	+	FIRST_NAME = Robert
551	+	LAST_NAME = Nelson
552	+	PHONE_EXT = 250
553	+	HIRE_DATE = 1988/12/28 00:00:00.0000
554	+	DEPT_NO = 600
555	+	JOB_CODE = VP
556	+	JOB_GRADE = 2
557	+	JOB_COUNTRY = USA
558	+	SALARY = 105,900.00
559	+	FULL_NAME = Nelson, Robert
560	+	Do Fetch Last:
561	+	EMP_NO = 145
562	+	FIRST_NAME = Mark
563	+	LAST_NAME = Guckenheimer
564	+	PHONE_EXT = 221
565	+	HIRE_DATE = 1994/05/02 00:00:00.0000
566	+	DEPT_NO = 622
567	+	JOB_CODE = Eng
568	+	JOB_GRADE = 5
569	+	JOB_COUNTRY = USA
570	+	SALARY = 32,000.00
571	+	FULL_NAME = Guckenheimer, Mark
572	+	Do Fetch Prior:
573	+	EMP_NO = 144
574	+	FIRST_NAME = John
575	+	LAST_NAME = Montgomery
576	+	PHONE_EXT = 820
577	+	HIRE_DATE = 1994/03/30 00:00:00.0000
578	+	DEPT_NO = 672
579	+	JOB_CODE = Eng
580	+	JOB_GRADE = 5
581	+	JOB_COUNTRY = USA
582	+	SALARY = 35,000.00
583	+	FULL_NAME = Montgomery, John
584	+	Do Fetch First:
585	+	EMP_NO = 2
586	+	FIRST_NAME = Robert
587	+	LAST_NAME = Nelson
588	+	PHONE_EXT = 250
589	+	HIRE_DATE = 1988/12/28 00:00:00.0000
590	+	DEPT_NO = 600
591	+	JOB_CODE = VP
592	+	JOB_GRADE = 2
593	+	JOB_COUNTRY = USA
594	+	SALARY = 105,900.00
595	+	FULL_NAME = Nelson, Robert
596	+	Do Fetch Abs 8 :
597	+	EMP_NO = 14
598	+	FIRST_NAME = Stewart
599	+	LAST_NAME = Hall
600	+	PHONE_EXT = 227
601	+	HIRE_DATE = 1990/06/04 00:00:00.0000
602	+	DEPT_NO = 900
603	+	JOB_CODE = Finan
604	+	JOB_GRADE = 3
605	+	JOB_COUNTRY = USA
606	+	SALARY = 69,482.63
607	+	FULL_NAME = Hall, Stewart
608	+	Do Fetch Relative -2 :
609	+	EMP_NO = 11
610	+	FIRST_NAME = K. J.
611	+	LAST_NAME = Weston
612	+	PHONE_EXT = 34
613	+	HIRE_DATE = 1990/01/17 00:00:00.0000
614	+	DEPT_NO = 130
615	+	JOB_CODE = SRep
616	+	JOB_GRADE = 4
617	+	JOB_COUNTRY = USA
618	+	SALARY = 86,292.94
619	+	FULL_NAME = Weston, K. J.
620	+	Do Fetch beyond EOF :
621	+	Fetch returned false
622
623
624		------------------------------------------------------
#	Line 569 | Line 656 | JOB_COUNTRY = USA
656		SALARY = 64,635.00
657		FULL_NAME = Johnson, Leslie
658
659	<	Current memory = 19,767,232
659	>	Current memory = 19,764,272
660		Delta memory = 4,464
661	<	Max memory = 19,813,104
661	>	Max memory = 19,809,888
662		Elapsed time= 0.002 sec
663	<	Cpu = 0.010 sec
663	>	Cpu = 0.000 sec
664		Buffers = 2048
665		Reads = 0
666		Writes = 0
#	Line 2610 | Line 2697 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2697
2698		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)
2699
2700	<	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)
2700	>	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)
2701
2702
2703		Shrink to 2:10
#	Line 2626 | Line 2713 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2713
2714		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)
2715
2716	<	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)
2716	>	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)
2717
2718
2719
#	Line 2721 | Line 2808 | Page Size = 8192
2808		Version = 1: LI-V6.3.0.2496 Firebird 4.0
2809		Database is Read/Write
2810		Database Created: 29/5/2021 16:47:30
2811	<	Pages Used = 313
2812	<	Pages Free = 762
2813	<	Server Memory = 19483648
2811	>	Pages Used = 310
2812	>	Pages Free = 765
2813	>	Server Memory = 19482272
2814		Forced Writes  = 1
2815	<	Max Memory  = 19629664
2815	>	Max Memory  = 19628544
2816		Num Buffers  = 2048
2817		Sweep Interval  = 20000
2818		Logged in Users: SYSDBA,
2819		Active Transaction Count = 0
2820	<	Fetches  = 1648
2820	>	Fetches  = 1641
2821		Writes  = 8
2822		Reads  = 92
2823		Page Writes  = 4
#	Line 2756 | Line 2843 | Count = 2
2843		Table ID = 12
2844		Count = 24
2845		Table ID = 18
2846	<	Count = 816
2846	>	Count = 811
2847		Table ID = 20
2848		Count = 5
2849		Table ID = 28
#	Line 2768 | Line 2855 | Count = 1
2855
2856		Sequential Table Scans Operation Counts
2857		Table ID = 0
2858	<	Count = 100
2858	>	Count = 98
2859		Table ID = 1
2860		Count = 24
2861
#	Line 4483 | Line 4570 | Test Completed Successfully
4570
4571
4572		------------------------------------------------------
4573	+	Running Test 21: Exercise setting and getting of numeric data types
4574	+	1234.567 parsed to 1234567 scale = -3
4575	+	As Float =  1.2345670000000000E+003
4576	+	-765.4321 parsed to -7654321 scale = -4
4577	+	As Float = -7.6543209999999999E+002
4578	+	0.1 parsed to 1 scale = -1
4579	+	As Float =  1.0000000000000001E-001
4580	+	0.01 parsed to 1 scale = -2
4581	+	As Float =  1.0000000000000000E-002
4582	+	+123 parsed to 123 scale = 0
4583	+	As Float =  1.2300000000000000E+002
4584	+	1.23456E308 parsed to 123456 scale = 303
4585	+	As Float =  1.2345600000000001E+308
4586	+	-1.2e-02 parsed to -12 scale = -3
4587	+	As Float = -1.2000000000000000E-002
4588	+	10. parsed to 10 scale = 0
4589	+	As Float =  1.0000000000000000E+001
4590	+	.12 parsed to 12 scale = -2
4591	+	As Float =  1.2000000000000000E-001
4592	+	0.12 parsed to 12 scale = -2
4593	+	As Float =  1.2000000000000000E-001
4594	+	Parsing of 1.2E1.2 failed
4595	+	Parsing of 1,000 failed
4596	+	Parsing of 1e1e1 failed
4597	+	Parsing of 1.2+3 failed
4598	+	SQL Params
4599	+	SQLType =SQL_LONG
4600	+	sub type = 0
4601	+	Field Name =
4602	+	Scale = 0
4603	+	Charset id = 0
4604	+	Not Null
4605	+	Size = 4
4606	+	Value = 0
4607	+
4608	+	SQLType =SQL_LONG
4609	+	sub type = 0
4610	+	Field Name =
4611	+	Scale = 0
4612	+	Charset id = 0
4613	+	Nullable
4614	+	Size = 4
4615	+
4616	+	SQLType =SQL_INT64
4617	+	sub type = 0
4618	+	Field Name =
4619	+	Scale = 0
4620	+	Charset id = 0
4621	+	Nullable
4622	+	Size = 8
4623	+
4624	+	SQLType =SQL_INT64
4625	+	sub type = 0
4626	+	Field Name =
4627	+	Scale = -4
4628	+	Charset id = 0
4629	+	Nullable
4630	+	Size = 8
4631	+
4632	+	SQLType =SQL_DOUBLE
4633	+	sub type = 0
4634	+	Field Name =
4635	+	Scale = 0
4636	+	Charset id = 0
4637	+	Nullable
4638	+	Size = 8
4639	+
4640	+	SQLType =SQL_INT64
4641	+	sub type = 0
4642	+	Field Name =
4643	+	Scale = -6
4644	+	Charset id = 0
4645	+	Nullable
4646	+	Size = 8
4647	+
4648	+	Expected Error - SQLCODE: -303
4649	+	Engine Code: 335544569 Incompatible column/host variable data type
4650	+	Dynamic SQL Error
4651	+	-SQL error code = -303
4652	+	-conversion error from string "1,000"
4653	+	Expected Error - SQLCODE: -303
4654	+	Engine Code: 335544569 Incompatible column/host variable data type
4655	+	Dynamic SQL Error
4656	+	-SQL error code = -303
4657	+	-conversion error from string "10.0.0"
4658	+	ROWID = 1
4659	+	ITYPE = 101
4660	+	I64TYPE = 9223372036854775807
4661	+	CURRTYPE = 10,000.12340000
4662	+	DTYPE = 9,999.12345678
4663	+	FIXEDPOINT = 1,234,567,890.12345700
4664	+	ROWID = 2
4665	+	ITYPE = -32457
4666	+	I64TYPE = -9223372036854775808
4667	+	CURRTYPE = 1,000,001.12000000
4668	+	DTYPE = 1.7E308
4669	+	FIXEDPOINT = -1,234,567,890.12345700
4670	+	ROWID = 3
4671	+	ITYPE = 0
4672	+	I64TYPE = 0
4673	+	CURRTYPE = .00000000
4674	+	DTYPE = .00000000
4675	+	FIXEDPOINT = .00000000
4676	+	ROWID = 4
4677	+	ITYPE = 1
4678	+	I64TYPE = 10
4679	+	CURRTYPE = .02300000
4680	+	DTYPE = .00110000
4681	+	FIXEDPOINT = 233.45600000
4682	+
4683	+
4684	+
4685	+	------------------------------------------------------
4686		Test Suite Ends

Diff Legend

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