ViewVC Help

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

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

Comparing ibx/trunk/fbintf/testsuite/FB4reference.log (file contents):
Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC

#	Line 3 | Line 3 | Copyright MWA Software 2016-2021
3
4		Starting Tests
5		Client API Version = 4.0
6	<	Firebird Environment Variable = /opt/firebird4rc1
7	<	Firebird Bin Directory = /opt/firebird4rc1/bin
8	<	Firebird Conf Directory = /opt/firebird4rc1/
9	<	Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so
6	>	Firebird Environment Variable = /opt/firebird4.0.0
7	>	Firebird Bin Directory = /opt/firebird4.0.0/bin
8	>	Firebird Conf Directory = /opt/firebird4.0.0/
9	>	Firebird Client Library Path = /opt/firebird4.0.0/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 ""
#	Line 22 | Line 22 | DB Remote Protocol = TCPv4
22		DB ODS Major Version = 13
23		DB ODS Minor Version = 0
24		User Authentication Method = Srp256
25	<	Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
25	>	Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
26		DB Client Implementation Version = 4.0
27		DPB: Item Count = 3
28		isc_dpb_user_name = SYSDBA
#	Line 30 | Line 30 | DPB: Item Count = 3
30		isc_dpb_set_db_sql_dialect = 3
31
32		Firebird Server Version Info
33	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
34	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C"
35	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C"
33	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
34	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
35	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
36		on disk structure version 13.0
37
38		Dropping Database
#	Line 44 | Line 44 | DB Remote Protocol = TCPv4
44		DB ODS Major Version = 13
45		DB ODS Minor Version = 0
46		User Authentication Method = Srp256
47	<	Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
47	>	Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
48		DB Client Implementation Version = 4.0
49		Dropping Database
50		DPB: Item Count = 4
#	Line 64 | Line 64 | DB Remote Protocol = TCPv4
64		DB ODS Major Version = 13
65		DB ODS Minor Version = 0
66		User Authentication Method = Srp256
67	<	Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
67	>	Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
68		DB Client Implementation Version = 4.0
69		RDB$DESCRIPTION =
70		RDB$RELATION_ID = 128
71	<	RDB$SECURITY_CLASS = SQL$384
71	>	RDB$SECURITY_CLASS = SQL$385
72		RDB$CHARACTER_SET_NAME = UTF8
73		RDB$LINGER =
74		RDB$SQL_SECURITY =
#	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 267 | Line 268 | Scale = 0
268		Charset id = 0
269		Not Null
270		Size = 2
271	+	Value = 0
272
273		EMP_NO = 8
274		FIRST_NAME = Leslie
#	Line 290 | Line 292 | Scale = 0
292		Charset id = 0
293		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 492 | Line 496 | Scale = 0
496		Charset id = 0
497		Not Null
498		Size = 2
499	+	Value = 0
500
501		EMP_NO = 8
502		FIRST_NAME = Leslie
#	Line 515 | Line 520 | Scale = 0
520		Charset id = 0
521		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 528 | 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 548 | Line 639 | Constrained Employee Count = 3
639		Running Test 4: Update, Insert and Delete Queries
640		Opening inet://localhost/employee
641		Database Open
642	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
643	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
644	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
642	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
643	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
644	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
645		on disk structure version 13.0
646		Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
647		EMP_NO = 8
#	Line 565 | Line 656 | JOB_COUNTRY = USA
656		SALARY = 64,635.00
657		FULL_NAME = Johnson, Leslie
658
659	<	Current memory = 19,747,376
659	>	Current memory = 19,764,272
660		Delta memory = 4,464
661	<	Max memory = 19,793,248
661	>	Max memory = 19,809,888
662		Elapsed time= 0.002 sec
663		Cpu = 0.000 sec
664		Buffers = 2048
#	Line 1067 | Line 1158 | Scale = 0
1158		Charset id = 0
1159		Not Null
1160		Size = 4
1161	+	Value = 0
1162
1163		SQLType =SQL_VARYING
1164		sub type = 0
#	Line 1114 | Line 1206 | Scale = 0
1206		Charset id = 0
1207		Not Null
1208		Size = 4
1209	+	Value = 0
1210
1211		ROWID = 1
1212		FIXEDPOINT = 20.28
#	Line 1166 | Line 1259 | Scale = 0
1259		Charset id = 0
1260		Not Null
1261		Size = 4
1262	+	Value = 0
1263
1264		SQLType =SQL_VARYING
1265		sub type = 0
#	Line 1543 | Line 1637 | Scale = 0
1637		Charset id = 0
1638		Not Null
1639		Size = 4
1640	+	Value = 0
1641
1642		SQLType =SQL_VARYING
1643		sub type = 0
#	Line 1590 | Line 1685 | Scale = 0
1685		Charset id = 0
1686		Not Null
1687		Size = 4
1688	+	Value = 0
1689
1690		ROWID = 1
1691		FIXEDPOINT = 20.28
#	Line 1642 | Line 1738 | Scale = 0
1738		Charset id = 0
1739		Not Null
1740		Size = 4
1741	+	Value = 0
1742
1743		SQLType =SQL_VARYING
1744		sub type = 0
#	Line 2019 | Line 2116 | Scale = 0
2116		Charset id = 0
2117		Not Null
2118		Size = 4
2119	+	Value = 0
2120
2121		SQLType =SQL_VARYING
2122		sub type = 0
#	Line 2066 | Line 2164 | Scale = 0
2164		Charset id = 0
2165		Not Null
2166		Size = 4
2167	+	Value = 0
2168
2169		ROWID = 1
2170		FIXEDPOINT = 20.28
#	Line 2118 | Line 2217 | Scale = 0
2217		Charset id = 0
2218		Not Null
2219		Size = 4
2220	+	Value = 0
2221
2222		SQLType =SQL_VARYING
2223		sub type = 0
#	Line 2412 | Line 2512 | Scale = 0
2512		Charset id = 0
2513		Not Null
2514		Size = 4
2515	+	Value = 0
2516
2517		SQLType =SQL_VARYING
2518		sub type = 0
#	Line 2596 | 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 2612 | 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 2673 | Line 2774 | Scale = 0
2774		Charset id = 0
2775		Not Null
2776		Size = 4
2777	+	Value = 0
2778
2779		SQLType =SQL_VARYING
2780		sub type = 0
#	Line 2695 | Line 2797 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2797
2798		------------------------------------------------------
2799		Running Test 9: Database Information tests
2800	<	Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus
2801	<	Pages =346
2800	>	Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2801	>	Pages =1075
2802		Base Level = 13,4,0,3,
2803		Implementation = 11,7,0,3,66,1,66,
2804		Reserved = 0
2805		ODS minor = 0
2806		ODS major = 13
2807		Page Size = 8192
2808	<	Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1
2808	>	Version = 1: LI-V6.3.0.2496 Firebird 4.0
2809		Database is Read/Write
2810	<	Database Created: 01/2/2021 14:57:08
2810	>	Database Created: 29/5/2021 16:47:30
2811		Pages Used = 310
2812	<	Pages Free = 36
2813	<	Server Memory = 19466032
2812	>	Pages Free = 765
2813	>	Server Memory = 19482272
2814		Forced Writes  = 1
2815	<	Max Memory  = 19612048
2815	>	Max Memory  = 19628544
2816		Num Buffers  = 2048
2817		Sweep Interval  = 20000
2818		Logged in Users: SYSDBA,
2819		Active Transaction Count = 0
2820	<	Fetches  = 1634
2820	>	Fetches  = 1641
2821		Writes  = 8
2822	<	Reads  = 91
2822	>	Reads  = 92
2823		Page Writes  = 4
2824		Record Version Removals Operation Counts
2825
#	Line 2741 | Line 2843 | Count = 2
2843		Table ID = 12
2844		Count = 24
2845		Table ID = 18
2846	<	Count = 805
2846	>	Count = 811
2847		Table ID = 20
2848		Count = 5
2849		Table ID = 28
#	Line 2796 | Line 2898 | SPB: Item Count = 2
2898		password = masterkey
2899
2900		Service Manager Version = 2
2901	<	Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1
2901	>	Server Version = LI-V4.0.0.2496 Firebird 4.0
2902		Implementation = Firebird/Linux/AMD/Intel/x64
2903
2904		Lock Directory = /tmp/firebird/
2905	<	Message File = /opt/firebird4rc1/
2906	<	Security File = /opt/firebird4rc1/security4.fdb
2905	>	Message File = /opt/firebird4.0.0/
2906	>	Security File = /opt/firebird4.0.0/security4.fdb
2907
2908		DB Attachments
2909		No. of Attachments = 0
#	Line 2859 | Line 2961 | Scale = 0
2961		Charset id = 0
2962		Not Null
2963		Size = 4
2964	+	Value = 0
2965
2966		SQLType =SQL_VARYING
2967		sub type = 0
#	Line 2908 | Line 3011 | Charset id = 4
3011		Nullable
3012		Size = 16
3013
3014	+	Show Param Values
3015	+	SQL Params
3016	+	SQLType =SQL_LONG
3017	+	sub type = 0
3018	+	Field Name = ROWID
3019	+	Scale = 0
3020	+	Charset id = 0
3021	+	Not Null
3022	+	Size = 4
3023	+	Value = 1
3024	+
3025	+	SQLType =SQL_VARYING
3026	+	sub type = 0
3027	+	Field Name = TITLE
3028	+	Scale = 0
3029	+	Charset id = 4
3030	+	Nullable
3031	+	Size = 128
3032	+	Value = Blob Test ©€
3033	+
3034	+	SQLType =SQL_VARYING
3035	+	sub type = 0
3036	+	Field Name = NOTES
3037	+	Scale = 0
3038	+	Charset id = 4
3039	+	Nullable
3040	+	Size = 256
3041	+	Value = Écoute moi
3042	+
3043	+	SQLType =SQL_VARYING
3044	+	sub type = 1
3045	+	Field Name = BLOBDATA
3046	+	Scale = 0
3047	+	Charset id = 4
3048	+	Nullable
3049	+	Size = 8192
3050	+	Value = Some German Special Characters like ÖÄÜöäüß
3051	+
3052	+	SQLType =SQL_BLOB
3053	+	sub type = 1
3054	+	Field Name = BLOBDATA2
3055	+	Scale = 0
3056	+	Charset id = 4
3057	+	Nullable
3058	+	Size = 8
3059	+	Value = Some German Special Characters like ÖÄÜöäüß
3060	+
3061	+	SQLType =SQL_VARYING
3062	+	sub type = 0
3063	+	Field Name = INCLEAR
3064	+	Scale = 0
3065	+	Charset id = 1
3066	+	Nullable
3067	+	Size = 16
3068	+	Value = &Test
3069
3070	+
3071	+	SQLType =SQL_VARYING
3072	+	sub type = 0
3073	+	Field Name = FIXEDWIDTH
3074	+	Scale = 0
3075	+	Charset id = 4
3076	+	Nullable
3077	+	Size = 16
3078	+	Value = É
3079	+
3080		Connection Character Set UTF8
3081		ROWID = 1
3082		TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
#	Line 3022 | Line 3190 | ROWID = 1
3190		TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3191		BLOBDATA = (blob), Length = 92514
3192
3193	+	ROWID = 2
3194	+	TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3195	+	BLOBDATA = (blob), Length = 13
3196	+	0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3197
3198		Testdata 2
3199
#	Line 3061 | Line 3233 | Invalid Param SQL Type Test
3233		Error Handled: Field "EMP_NO" not found
3234		Case sensitive Param SQL  Test
3235		Error Handled: Field "EMP_NO" not found
3236	+	Stale Reference Check
3237	+	First test correct usage
3238	+	COUNTER = 42
3239	+
3240	+	New Transaction before param set
3241	+	Error Handled: This interface is no longer up-to-date
3242	+	New Transaction before Open Cursor
3243	+	Error Handled: This interface is no longer up-to-date
3244	+	Stop Stale Reference Checks
3245	+	New Transaction before param set
3246	+	COUNTER = 42
3247	+
3248	+	New Transaction before Open Cursor
3249	+	COUNTER = 42
3250	+
3251		Invalid Server Name Test
3252		Error Handled: Unable to complete network request to host "unknown".
3253		-Failed to locate host machine.
#	Line 3073 | Line 3260 | Error Handled: Your user name and passwo
3260
3261		------------------------------------------------------
3262		Running Test 17: Date/Time tests and Firebird 4 extensions
3263	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3263	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3264		Has Local TZ DB = TRUE
3265
3266		Testdata
#	Line 3835 | Line 4022 | TZ_MINUTE = 0
4022
4023		------------------------------------------------------
4024		Running Test 18: Firebird 4 Decfloat extensions
4025	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
4025	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4026
4027		FB4 Testdata_DECFloat
4028
#	Line 3937 | Line 4124 | BigInteger = 123456789123456789
4124		Special = 0
4125		Places = 0
4126		Digits = 12 34 56 78 91 23 45 67 89
4127	+
4128		RowID = 2
4129		Float16 = -64000000000.01
4130		Precision = 13
#	Line 3957 | Line 4145 | BigNumber = -123456123456.123456
4145		Places = 6
4146		Digits = 12 34 56 12 34 56 12 34 56
4147		BigInteger = Null
4148	+
4149		RowID = 3
4150		Float16 = 64100000000.011
4151		Precision = 14
#	Line 3983 | Line 4172 | BiggerNumber = 1112345612345612345612345
4172		Places = 4
4173		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4174		BigInteger = Null
4175	+
4176		RowID = 4
4177		Float16 = 0
4178		Precision = 0
#	Line 4009 | Line 4199 | BiggerNumber = 0.0000
4199		Places = 0
4200		Digits =
4201		BigInteger = Null
4202	+
4203		Metadata
4204		SQLType =SQL_LONG
4205		sub type = 0
#	Line 4096 | Line 4287 | BigNumber Array: (0: 123456123400.123456
4287
4288
4289
4290	+	------------------------------------------------------
4291	+	Running Test 19: Batch Update and Insert Queries
4292	+	Opening inet://localhost/employee
4293	+	Database Open
4294	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4295	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4296	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4297	+	on disk structure version 13.0
4298	+	Rows before update
4299	+	EMP_NO = 2
4300	+	FIRST_NAME = Robert
4301	+	LAST_NAME = Nelson
4302	+	PHONE_EXT = 250
4303	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4304	+	DEPT_NO = 600
4305	+	JOB_CODE = VP
4306	+	JOB_GRADE = 2
4307	+	JOB_COUNTRY = USA
4308	+	SALARY = 105,900.00
4309	+	FULL_NAME = Nelson, Robert
4310	+	EMP_NO = 8
4311	+	FIRST_NAME = Leslie
4312	+	LAST_NAME = Johnson
4313	+	PHONE_EXT = 410
4314	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4315	+	DEPT_NO = 180
4316	+	JOB_CODE = Mktg
4317	+	JOB_GRADE = 3
4318	+	JOB_COUNTRY = USA
4319	+	SALARY = 64,635.00
4320	+	FULL_NAME = Johnson, Leslie
4321	+
4322	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4323	+	Batch Completion Info
4324	+	Total rows processed = 2
4325	+	Updated Records = 2
4326	+	Row 1 State = bcNoMoreErrors Msg =
4327	+	Row 2 State = bcNoMoreErrors Msg =
4328	+	Rows after update
4329	+	EMP_NO = 2
4330	+	FIRST_NAME = Robert
4331	+	LAST_NAME = Nelson
4332	+	PHONE_EXT = 250
4333	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4334	+	DEPT_NO = 600
4335	+	JOB_CODE = VP
4336	+	JOB_GRADE = 2
4337	+	JOB_COUNTRY = USA
4338	+	SALARY = 105,900.00
4339	+	FULL_NAME = Nelson, Robert
4340	+	EMP_NO = 8
4341	+	FIRST_NAME = Leslie
4342	+	LAST_NAME = Johnson
4343	+	PHONE_EXT = 410
4344	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4345	+	DEPT_NO = 180
4346	+	JOB_CODE = Mktg
4347	+	JOB_GRADE = 3
4348	+	JOB_COUNTRY = USA
4349	+	SALARY = 64,635.00
4350	+	FULL_NAME = Johnson, Leslie
4351	+
4352	+
4353	+	Repeat but with a last dummy row that is ignored
4354	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4355	+	Batch Completion Info
4356	+	Total rows processed = 2
4357	+	Updated Records = 2
4358	+	Row 1 State = bcNoMoreErrors Msg =
4359	+	Row 2 State = bcNoMoreErrors Msg =
4360	+	Rows after update
4361	+	EMP_NO = 2
4362	+	FIRST_NAME = Robert
4363	+	LAST_NAME = Nelson
4364	+	PHONE_EXT = 250
4365	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4366	+	DEPT_NO = 600
4367	+	JOB_CODE = VP
4368	+	JOB_GRADE = 2
4369	+	JOB_COUNTRY = USA
4370	+	SALARY = 105,900.00
4371	+	FULL_NAME = Nelson, Robert
4372	+	EMP_NO = 8
4373	+	FIRST_NAME = Leslie
4374	+	LAST_NAME = Johnson
4375	+	PHONE_EXT = 410
4376	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4377	+	DEPT_NO = 180
4378	+	JOB_CODE = Mktg
4379	+	JOB_GRADE = 3
4380	+	JOB_COUNTRY = USA
4381	+	SALARY = 64,635.00
4382	+	FULL_NAME = Johnson, Leslie
4383	+
4384	+
4385	+	Insert rows
4386	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4387	+	Batch Completion Info
4388	+	Total rows processed = 3
4389	+	Updated Records = 3
4390	+	Row 1 State = bcNoMoreErrors Msg =
4391	+	Row 2 State = bcNoMoreErrors Msg =
4392	+	Row 3 State = bcNoMoreErrors Msg =
4393	+	Rows after insert
4394	+	EMP_NO = 150
4395	+	FIRST_NAME = John
4396	+	LAST_NAME = Doe
4397	+	PHONE_EXT =
4398	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4399	+	DEPT_NO = 600
4400	+	JOB_CODE = Eng
4401	+	JOB_GRADE = 4
4402	+	JOB_COUNTRY = England
4403	+	SALARY = 41,000.89
4404	+	FULL_NAME = Doe, John
4405	+	EMP_NO = 151
4406	+	FIRST_NAME = Jane
4407	+	LAST_NAME = Doe
4408	+	PHONE_EXT =
4409	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4410	+	DEPT_NO = 600
4411	+	JOB_CODE = Eng
4412	+	JOB_GRADE = 4
4413	+	JOB_COUNTRY = England
4414	+	SALARY = 42,000.89
4415	+	FULL_NAME = Doe, Jane
4416	+	EMP_NO = 152
4417	+	FIRST_NAME = John
4418	+	LAST_NAME = SmithAndJonesFamily1
4419	+	PHONE_EXT =
4420	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4421	+	DEPT_NO = 600
4422	+	JOB_CODE = Eng
4423	+	JOB_GRADE = 4
4424	+	JOB_COUNTRY = England
4425	+	SALARY = 41,000.99
4426	+	FULL_NAME = SmithAndJonesFamily1, John
4427	+
4428	+
4429	+	Insert rows - and then cancel
4430	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4431	+
4432	+	Insert rows - ignore last row
4433	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4434	+	Batch Completion Info
4435	+	Total rows processed = 2
4436	+	Updated Records = 2
4437	+	Row 1 State = bcNoMoreErrors Msg =
4438	+	Row 2 State = bcNoMoreErrors Msg =
4439	+	Rows after insert
4440	+	EMP_NO = 150
4441	+	FIRST_NAME = John
4442	+	LAST_NAME = Doe
4443	+	PHONE_EXT =
4444	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4445	+	DEPT_NO = 600
4446	+	JOB_CODE = Eng
4447	+	JOB_GRADE = 4
4448	+	JOB_COUNTRY = England
4449	+	SALARY = 41,000.89
4450	+	FULL_NAME = Doe, John
4451	+	EMP_NO = 151
4452	+	FIRST_NAME = Jane
4453	+	LAST_NAME = Doe
4454	+	PHONE_EXT =
4455	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4456	+	DEPT_NO = 600
4457	+	JOB_CODE = Eng
4458	+	JOB_GRADE = 4
4459	+	JOB_COUNTRY = England
4460	+	SALARY = 42,000.89
4461	+	FULL_NAME = Doe, Jane
4462	+
4463	+	Insert with inline blob
4464	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4465	+	Batch Completion Info
4466	+	Total rows processed = 2
4467	+	Updated Records = 2
4468	+	Row 1 State = bcNoMoreErrors Msg =
4469	+	Row 2 State = bcNoMoreErrors Msg =
4470	+	Rows after insert
4471	+	JOB_CODE = ABC
4472	+	JOB_GRADE = 3
4473	+	JOB_COUNTRY = England
4474	+	JOB_TITLE = Chief Tester
4475	+	MIN_SALARY = 21,000.00
4476	+	MAX_SALARY = 24,000.99
4477	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4478	+
4479	+	The quick brown fox jumped over the lazy dog
4480	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4481	+
4482	+	JOB_CODE = DEF
4483	+	JOB_GRADE = 3
4484	+	JOB_COUNTRY = England
4485	+	JOB_TITLE = Deputy Tester
4486	+	MIN_SALARY = 21,000.00
4487	+	MAX_SALARY = 24,000.99
4488	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4489	+
4490	+	The quick brown fox jumped over the running dog
4491	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4492	+
4493	+
4494	+
4495	+	Insert with explicit blob
4496	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4497	+	Batch Completion Info
4498	+	Total rows processed = 2
4499	+	Updated Records = 2
4500	+	Row 1 State = bcNoMoreErrors Msg =
4501	+	Row 2 State = bcNoMoreErrors Msg =
4502	+	Rows after insert
4503	+	JOB_CODE = ABC
4504	+	JOB_GRADE = 3
4505	+	JOB_COUNTRY = England
4506	+	JOB_TITLE = Chief Tester
4507	+	MIN_SALARY = 21,000.00
4508	+	MAX_SALARY = 24,000.99
4509	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4510	+
4511	+	The quick brown fox jumped over the lazy dog
4512	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4513	+
4514	+	JOB_CODE = DEF
4515	+	JOB_GRADE = 3
4516	+	JOB_COUNTRY = England
4517	+	JOB_TITLE = Deputy Tester
4518	+	MIN_SALARY = 21,000.00
4519	+	MAX_SALARY = 24,000.99
4520	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4521	+
4522	+	The quick brown fox jumped over the running dog
4523	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4524	+
4525	+
4526	+	Test Error Handling
4527	+	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4528	+	Test Error Handling - Update returning should fail
4529	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4530	+	Error handling when Insert rows - duplicate key
4531	+	Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4532	+	-Problematic key value is ("EMP_NO" = 150)
4533	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4534	+	Batch Completion Info
4535	+	Total rows processed = 2
4536	+	Updated Records = 1
4537	+	Row 1 State = bcNoMoreErrors Msg =
4538	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4539	+	-Problematic key value is ("EMP_NO" = 150)
4540	+
4541	+
4542	+	------------------------------------------------------
4543	+	Running Test 20: Stress Test IBatch interface
4544	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4545	+	10000 rows added
4546	+	20000 rows added
4547	+	30000 rows added
4548	+	40000 rows added
4549	+	50000 rows added
4550	+	Batch Execute
4551	+	Intermediate Apply Batch on row 50001
4552	+	Batch Completion Info
4553	+	Total rows processed = 50000
4554	+	Updated Rows = 50000
4555	+	Row 50000 State = bcNoMoreErrors Msg =
4556	+	60000 rows added
4557	+	70000 rows added
4558	+	80000 rows added
4559	+	90000 rows added
4560	+	100000 rows added
4561	+	Batch Execute
4562	+	Batch Completion Info
4563	+	Total rows processed = 50000
4564	+	Updated Rows = 50000
4565	+	Row 50000 State = bcNoMoreErrors Msg =
4566	+	Rows in Dataset = 100000
4567	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4568	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4569	+	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