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 338 by tony, Wed Jun 9 12:07:56 2021 UTC vs.
Revision 353 by tony, Sat Oct 23 14:11:37 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 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 565 | Line 656 | JOB_COUNTRY = USA
656		SALARY = 64,635.00
657		FULL_NAME = Johnson, Leslie
658
659	<	Current memory = 19,763,536
659	>	Current memory = 19,764,272
660		Delta memory = 4,464
661	<	Max memory = 19,809,408
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 2696 | Line 2798 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2798		------------------------------------------------------
2799		Running Test 9: Database Information tests
2800		Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2801	<	Pages =346
2801	>	Pages =1075
2802		Base Level = 13,4,0,3,
2803		Implementation = 11,7,0,3,66,1,66,
2804		Reserved = 0
#	Line 2707 | Line 2809 | 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 = 310
2812	<	Pages Free = 36
2813	<	Server Memory = 19481792
2812	>	Pages Free = 765
2813	>	Server Memory = 19482272
2814		Forced Writes  = 1
2815	<	Max Memory  = 19627808
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 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 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	+	SQL Params
4575	+	SQLType =SQL_LONG
4576	+	sub type = 0
4577	+	Field Name =
4578	+	Scale = 0
4579	+	Charset id = 0
4580	+	Not Null
4581	+	Size = 4
4582	+	Value = 0
4583	+
4584	+	SQLType =SQL_LONG
4585	+	sub type = 0
4586	+	Field Name =
4587	+	Scale = 0
4588	+	Charset id = 0
4589	+	Nullable
4590	+	Size = 4
4591	+
4592	+	SQLType =SQL_INT64
4593	+	sub type = 0
4594	+	Field Name =
4595	+	Scale = 0
4596	+	Charset id = 0
4597	+	Nullable
4598	+	Size = 8
4599	+
4600	+	SQLType =SQL_INT64
4601	+	sub type = 0
4602	+	Field Name =
4603	+	Scale = -4
4604	+	Charset id = 0
4605	+	Nullable
4606	+	Size = 8
4607	+
4608	+	SQLType =SQL_DOUBLE
4609	+	sub type = 0
4610	+	Field Name =
4611	+	Scale = 0
4612	+	Charset id = 0
4613	+	Nullable
4614	+	Size = 8
4615	+
4616	+	SQLType =SQL_INT64
4617	+	sub type = 0
4618	+	Field Name =
4619	+	Scale = -6
4620	+	Charset id = 0
4621	+	Nullable
4622	+	Size = 8
4623	+
4624	+	Expected Error - SQLCODE: -303
4625	+	Engine Code: 335544569 Incompatible column/host variable data type
4626	+	Dynamic SQL Error
4627	+	-SQL error code = -303
4628	+	-conversion error from string "1,000"
4629	+	Expected Error - SQLCODE: -303
4630	+	Engine Code: 335544569 Incompatible column/host variable data type
4631	+	Dynamic SQL Error
4632	+	-SQL error code = -303
4633	+	-conversion error from string "10.0.0"
4634	+	ROWID = 1
4635	+	ITYPE = 101
4636	+	I64TYPE = 9223372036854775807
4637	+	CURRTYPE = 10,000.12340000
4638	+	DTYPE = 9,999.12345678
4639	+	FIXEDPOINT = 1,234,567,890.12345700
4640	+	ROWID = 2
4641	+	ITYPE = -32457
4642	+	I64TYPE = -9223372036854775808
4643	+	CURRTYPE = 1,000,001.12000000
4644	+	DTYPE = 1.7E308
4645	+	FIXEDPOINT = -1,234,567,890.12345700
4646	+	ROWID = 3
4647	+	ITYPE = 0
4648	+	I64TYPE = 0
4649	+	CURRTYPE = .00000000
4650	+	DTYPE = .00000000
4651	+	FIXEDPOINT = .00000000
4652	+	ROWID = 4
4653	+	ITYPE = 1
4654	+	I64TYPE = 10
4655	+	CURRTYPE = .02300000
4656	+	DTYPE = .00110000
4657	+	FIXEDPOINT = 233.45600000
4658	+
4659	+
4660	+
4661		------------------------------------------------------
4662		Test Suite Ends

Diff Legend

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