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 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
Revision 350 by tony, Wed Oct 20 14:58:56 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 267 | Line 267 | Scale = 0
267		Charset id = 0
268		Not Null
269		Size = 2
270	+	Value = 0
271
272		EMP_NO = 8
273		FIRST_NAME = Leslie
#	Line 290 | Line 291 | Scale = 0
291		Charset id = 0
292		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 492 | Line 495 | Scale = 0
495		Charset id = 0
496		Not Null
497		Size = 2
498	+	Value = 0
499
500		EMP_NO = 8
501		FIRST_NAME = Leslie
#	Line 515 | Line 519 | Scale = 0
519		Charset id = 0
520		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 528 | Line 534 | JOB_COUNTRY = USA
534		SALARY = 64,635.00
535		FULL_NAME = Johnson, Leslie
536
537	+	Scollable Cursors
538	+	Do Fetch Next:
539	+	EMP_NO = 2
540	+	FIRST_NAME = Robert
541	+	LAST_NAME = Nelson
542	+	PHONE_EXT = 250
543	+	HIRE_DATE = 1988/12/28 00:00:00.0000
544	+	DEPT_NO = 600
545	+	JOB_CODE = VP
546	+	JOB_GRADE = 2
547	+	JOB_COUNTRY = USA
548	+	SALARY = 105,900.00
549	+	FULL_NAME = Nelson, Robert
550	+	Do Fetch Last:
551	+	EMP_NO = 145
552	+	FIRST_NAME = Mark
553	+	LAST_NAME = Guckenheimer
554	+	PHONE_EXT = 221
555	+	HIRE_DATE = 1994/05/02 00:00:00.0000
556	+	DEPT_NO = 622
557	+	JOB_CODE = Eng
558	+	JOB_GRADE = 5
559	+	JOB_COUNTRY = USA
560	+	SALARY = 32,000.00
561	+	FULL_NAME = Guckenheimer, Mark
562	+	Do Fetch Prior:
563	+	EMP_NO = 144
564	+	FIRST_NAME = John
565	+	LAST_NAME = Montgomery
566	+	PHONE_EXT = 820
567	+	HIRE_DATE = 1994/03/30 00:00:00.0000
568	+	DEPT_NO = 672
569	+	JOB_CODE = Eng
570	+	JOB_GRADE = 5
571	+	JOB_COUNTRY = USA
572	+	SALARY = 35,000.00
573	+	FULL_NAME = Montgomery, John
574	+	Do Fetch First:
575	+	EMP_NO = 2
576	+	FIRST_NAME = Robert
577	+	LAST_NAME = Nelson
578	+	PHONE_EXT = 250
579	+	HIRE_DATE = 1988/12/28 00:00:00.0000
580	+	DEPT_NO = 600
581	+	JOB_CODE = VP
582	+	JOB_GRADE = 2
583	+	JOB_COUNTRY = USA
584	+	SALARY = 105,900.00
585	+	FULL_NAME = Nelson, Robert
586	+	Do Fetch Abs 8 :
587	+	EMP_NO = 14
588	+	FIRST_NAME = Stewart
589	+	LAST_NAME = Hall
590	+	PHONE_EXT = 227
591	+	HIRE_DATE = 1990/06/04 00:00:00.0000
592	+	DEPT_NO = 900
593	+	JOB_CODE = Finan
594	+	JOB_GRADE = 3
595	+	JOB_COUNTRY = USA
596	+	SALARY = 69,482.63
597	+	FULL_NAME = Hall, Stewart
598	+	Do Fetch Relative -2 :
599	+	EMP_NO = 11
600	+	FIRST_NAME = K. J.
601	+	LAST_NAME = Weston
602	+	PHONE_EXT = 34
603	+	HIRE_DATE = 1990/01/17 00:00:00.0000
604	+	DEPT_NO = 130
605	+	JOB_CODE = SRep
606	+	JOB_GRADE = 4
607	+	JOB_COUNTRY = USA
608	+	SALARY = 86,292.94
609	+	FULL_NAME = Weston, K. J.
610	+	Do Fetch beyond EOF :
611	+	Fetch returned false
612
613
614		------------------------------------------------------
#	Line 548 | Line 629 | Constrained Employee Count = 3
629		Running Test 4: Update, Insert and Delete Queries
630		Opening inet://localhost/employee
631		Database Open
632	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
633	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
634	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
632	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
633	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
634	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
635		on disk structure version 13.0
636		Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
637		EMP_NO = 8
#	Line 565 | Line 646 | JOB_COUNTRY = USA
646		SALARY = 64,635.00
647		FULL_NAME = Johnson, Leslie
648
649	<	Current memory = 19,747,376
649	>	Current memory = 19,767,952
650		Delta memory = 4,464
651	<	Max memory = 19,793,248
652	<	Elapsed time= 0.002 sec
651	>	Max memory = 19,813,568
652	>	Elapsed time= 0.000 sec
653		Cpu = 0.000 sec
654		Buffers = 2048
655		Reads = 0
#	Line 1067 | Line 1148 | Scale = 0
1148		Charset id = 0
1149		Not Null
1150		Size = 4
1151	+	Value = 0
1152
1153		SQLType =SQL_VARYING
1154		sub type = 0
#	Line 1114 | Line 1196 | Scale = 0
1196		Charset id = 0
1197		Not Null
1198		Size = 4
1199	+	Value = 0
1200
1201		ROWID = 1
1202		FIXEDPOINT = 20.28
#	Line 1166 | Line 1249 | Scale = 0
1249		Charset id = 0
1250		Not Null
1251		Size = 4
1252	+	Value = 0
1253
1254		SQLType =SQL_VARYING
1255		sub type = 0
#	Line 1543 | Line 1627 | Scale = 0
1627		Charset id = 0
1628		Not Null
1629		Size = 4
1630	+	Value = 0
1631
1632		SQLType =SQL_VARYING
1633		sub type = 0
#	Line 1590 | Line 1675 | Scale = 0
1675		Charset id = 0
1676		Not Null
1677		Size = 4
1678	+	Value = 0
1679
1680		ROWID = 1
1681		FIXEDPOINT = 20.28
#	Line 1642 | Line 1728 | Scale = 0
1728		Charset id = 0
1729		Not Null
1730		Size = 4
1731	+	Value = 0
1732
1733		SQLType =SQL_VARYING
1734		sub type = 0
#	Line 2019 | Line 2106 | Scale = 0
2106		Charset id = 0
2107		Not Null
2108		Size = 4
2109	+	Value = 0
2110
2111		SQLType =SQL_VARYING
2112		sub type = 0
#	Line 2066 | Line 2154 | Scale = 0
2154		Charset id = 0
2155		Not Null
2156		Size = 4
2157	+	Value = 0
2158
2159		ROWID = 1
2160		FIXEDPOINT = 20.28
#	Line 2118 | Line 2207 | Scale = 0
2207		Charset id = 0
2208		Not Null
2209		Size = 4
2210	+	Value = 0
2211
2212		SQLType =SQL_VARYING
2213		sub type = 0
#	Line 2412 | Line 2502 | Scale = 0
2502		Charset id = 0
2503		Not Null
2504		Size = 4
2505	+	Value = 0
2506
2507		SQLType =SQL_VARYING
2508		sub type = 0
#	Line 2673 | Line 2764 | Scale = 0
2764		Charset id = 0
2765		Not Null
2766		Size = 4
2767	+	Value = 0
2768
2769		SQLType =SQL_VARYING
2770		sub type = 0
#	Line 2695 | Line 2787 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2787
2788		------------------------------------------------------
2789		Running Test 9: Database Information tests
2790	<	Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus
2791	<	Pages =346
2790	>	Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2791	>	Pages =1075
2792		Base Level = 13,4,0,3,
2793		Implementation = 11,7,0,3,66,1,66,
2794		Reserved = 0
2795		ODS minor = 0
2796		ODS major = 13
2797		Page Size = 8192
2798	<	Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1
2798	>	Version = 1: LI-V6.3.0.2496 Firebird 4.0
2799		Database is Read/Write
2800	<	Database Created: 01/2/2021 14:57:08
2801	<	Pages Used = 310
2802	<	Pages Free = 36
2803	<	Server Memory = 19466032
2800	>	Database Created: 29/5/2021 16:47:30
2801	>	Pages Used = 313
2802	>	Pages Free = 762
2803	>	Server Memory = 19484112
2804		Forced Writes  = 1
2805	<	Max Memory  = 19612048
2805	>	Max Memory  = 19630384
2806		Num Buffers  = 2048
2807		Sweep Interval  = 20000
2808		Logged in Users: SYSDBA,
2809		Active Transaction Count = 0
2810	<	Fetches  = 1634
2810	>	Fetches  = 1648
2811		Writes  = 8
2812	<	Reads  = 91
2812	>	Reads  = 92
2813		Page Writes  = 4
2814		Record Version Removals Operation Counts
2815
#	Line 2741 | Line 2833 | Count = 2
2833		Table ID = 12
2834		Count = 24
2835		Table ID = 18
2836	<	Count = 805
2836	>	Count = 816
2837		Table ID = 20
2838		Count = 5
2839		Table ID = 28
#	Line 2753 | Line 2845 | Count = 1
2845
2846		Sequential Table Scans Operation Counts
2847		Table ID = 0
2848	<	Count = 98
2848	>	Count = 100
2849		Table ID = 1
2850		Count = 24
2851
#	Line 2796 | Line 2888 | SPB: Item Count = 2
2888		password = masterkey
2889
2890		Service Manager Version = 2
2891	<	Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1
2891	>	Server Version = LI-V4.0.0.2496 Firebird 4.0
2892		Implementation = Firebird/Linux/AMD/Intel/x64
2893
2894		Lock Directory = /tmp/firebird/
2895	<	Message File = /opt/firebird4rc1/
2896	<	Security File = /opt/firebird4rc1/security4.fdb
2895	>	Message File = /opt/firebird4.0.0/
2896	>	Security File = /opt/firebird4.0.0/security4.fdb
2897
2898		DB Attachments
2899		No. of Attachments = 0
#	Line 2859 | Line 2951 | Scale = 0
2951		Charset id = 0
2952		Not Null
2953		Size = 4
2954	+	Value = 0
2955
2956		SQLType =SQL_VARYING
2957		sub type = 0
#	Line 2908 | Line 3001 | Charset id = 4
3001		Nullable
3002		Size = 16
3003
3004	+	Show Param Values
3005	+	SQL Params
3006	+	SQLType =SQL_LONG
3007	+	sub type = 0
3008	+	Field Name = ROWID
3009	+	Scale = 0
3010	+	Charset id = 0
3011	+	Not Null
3012	+	Size = 4
3013	+	Value = 1
3014	+
3015	+	SQLType =SQL_VARYING
3016	+	sub type = 0
3017	+	Field Name = TITLE
3018	+	Scale = 0
3019	+	Charset id = 4
3020	+	Nullable
3021	+	Size = 128
3022	+	Value = Blob Test ©€
3023	+
3024	+	SQLType =SQL_VARYING
3025	+	sub type = 0
3026	+	Field Name = NOTES
3027	+	Scale = 0
3028	+	Charset id = 4
3029	+	Nullable
3030	+	Size = 256
3031	+	Value = Écoute moi
3032	+
3033	+	SQLType =SQL_VARYING
3034	+	sub type = 1
3035	+	Field Name = BLOBDATA
3036	+	Scale = 0
3037	+	Charset id = 4
3038	+	Nullable
3039	+	Size = 8192
3040	+	Value = Some German Special Characters like ÖÄÜöäüß
3041	+
3042	+	SQLType =SQL_BLOB
3043	+	sub type = 1
3044	+	Field Name = BLOBDATA2
3045	+	Scale = 0
3046	+	Charset id = 4
3047	+	Nullable
3048	+	Size = 8
3049	+	Value = Some German Special Characters like ÖÄÜöäüß
3050	+
3051	+	SQLType =SQL_VARYING
3052	+	sub type = 0
3053	+	Field Name = INCLEAR
3054	+	Scale = 0
3055	+	Charset id = 1
3056	+	Nullable
3057	+	Size = 16
3058	+	Value = &Test
3059
3060	+
3061	+	SQLType =SQL_VARYING
3062	+	sub type = 0
3063	+	Field Name = FIXEDWIDTH
3064	+	Scale = 0
3065	+	Charset id = 4
3066	+	Nullable
3067	+	Size = 16
3068	+	Value = É
3069	+
3070		Connection Character Set UTF8
3071		ROWID = 1
3072		TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
#	Line 3022 | Line 3180 | ROWID = 1
3180		TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3181		BLOBDATA = (blob), Length = 92514
3182
3183	+	ROWID = 2
3184	+	TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3185	+	BLOBDATA = (blob), Length = 13
3186	+	0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3187
3188		Testdata 2
3189
#	Line 3061 | Line 3223 | Invalid Param SQL Type Test
3223		Error Handled: Field "EMP_NO" not found
3224		Case sensitive Param SQL  Test
3225		Error Handled: Field "EMP_NO" not found
3226	+	Stale Reference Check
3227	+	First test correct usage
3228	+	COUNTER = 42
3229	+
3230	+	New Transaction before param set
3231	+	Error Handled: This interface is no longer up-to-date
3232	+	New Transaction before Open Cursor
3233	+	Error Handled: This interface is no longer up-to-date
3234	+	Stop Stale Reference Checks
3235	+	New Transaction before param set
3236	+	COUNTER = 42
3237	+
3238	+	New Transaction before Open Cursor
3239	+	COUNTER = 42
3240	+
3241		Invalid Server Name Test
3242		Error Handled: Unable to complete network request to host "unknown".
3243		-Failed to locate host machine.
#	Line 3073 | Line 3250 | Error Handled: Your user name and passwo
3250
3251		------------------------------------------------------
3252		Running Test 17: Date/Time tests and Firebird 4 extensions
3253	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3253	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3254		Has Local TZ DB = TRUE
3255
3256		Testdata
#	Line 3835 | Line 4012 | TZ_MINUTE = 0
4012
4013		------------------------------------------------------
4014		Running Test 18: Firebird 4 Decfloat extensions
4015	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
4015	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4016
4017		FB4 Testdata_DECFloat
4018
#	Line 3937 | Line 4114 | BigInteger = 123456789123456789
4114		Special = 0
4115		Places = 0
4116		Digits = 12 34 56 78 91 23 45 67 89
4117	+
4118		RowID = 2
4119		Float16 = -64000000000.01
4120		Precision = 13
#	Line 3957 | Line 4135 | BigNumber = -123456123456.123456
4135		Places = 6
4136		Digits = 12 34 56 12 34 56 12 34 56
4137		BigInteger = Null
4138	+
4139		RowID = 3
4140		Float16 = 64100000000.011
4141		Precision = 14
#	Line 3983 | Line 4162 | BiggerNumber = 1112345612345612345612345
4162		Places = 4
4163		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4164		BigInteger = Null
4165	+
4166		RowID = 4
4167		Float16 = 0
4168		Precision = 0
#	Line 4009 | Line 4189 | BiggerNumber = 0.0000
4189		Places = 0
4190		Digits =
4191		BigInteger = Null
4192	+
4193		Metadata
4194		SQLType =SQL_LONG
4195		sub type = 0
#	Line 4096 | Line 4277 | BigNumber Array: (0: 123456123400.123456
4277
4278
4279
4280	+	------------------------------------------------------
4281	+	Running Test 19: Batch Update and Insert Queries
4282	+	Opening inet://localhost/employee
4283	+	Database Open
4284	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4285	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4286	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4287	+	on disk structure version 13.0
4288	+	Rows before update
4289	+	EMP_NO = 2
4290	+	FIRST_NAME = Robert
4291	+	LAST_NAME = Nelson
4292	+	PHONE_EXT = 250
4293	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4294	+	DEPT_NO = 600
4295	+	JOB_CODE = VP
4296	+	JOB_GRADE = 2
4297	+	JOB_COUNTRY = USA
4298	+	SALARY = 105,900.00
4299	+	FULL_NAME = Nelson, Robert
4300	+	EMP_NO = 8
4301	+	FIRST_NAME = Leslie
4302	+	LAST_NAME = Johnson
4303	+	PHONE_EXT = 410
4304	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4305	+	DEPT_NO = 180
4306	+	JOB_CODE = Mktg
4307	+	JOB_GRADE = 3
4308	+	JOB_COUNTRY = USA
4309	+	SALARY = 64,635.00
4310	+	FULL_NAME = Johnson, Leslie
4311	+
4312	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4313	+	Batch Completion Info
4314	+	Total rows processed = 2
4315	+	Updated Records = 2
4316	+	Row 1 State = bcNoMoreErrors Msg =
4317	+	Row 2 State = bcNoMoreErrors Msg =
4318	+	Rows after update
4319	+	EMP_NO = 2
4320	+	FIRST_NAME = Robert
4321	+	LAST_NAME = Nelson
4322	+	PHONE_EXT = 250
4323	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4324	+	DEPT_NO = 600
4325	+	JOB_CODE = VP
4326	+	JOB_GRADE = 2
4327	+	JOB_COUNTRY = USA
4328	+	SALARY = 105,900.00
4329	+	FULL_NAME = Nelson, Robert
4330	+	EMP_NO = 8
4331	+	FIRST_NAME = Leslie
4332	+	LAST_NAME = Johnson
4333	+	PHONE_EXT = 410
4334	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4335	+	DEPT_NO = 180
4336	+	JOB_CODE = Mktg
4337	+	JOB_GRADE = 3
4338	+	JOB_COUNTRY = USA
4339	+	SALARY = 64,635.00
4340	+	FULL_NAME = Johnson, Leslie
4341	+
4342	+
4343	+	Repeat but with a last dummy row that is ignored
4344	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4345	+	Batch Completion Info
4346	+	Total rows processed = 2
4347	+	Updated Records = 2
4348	+	Row 1 State = bcNoMoreErrors Msg =
4349	+	Row 2 State = bcNoMoreErrors Msg =
4350	+	Rows after update
4351	+	EMP_NO = 2
4352	+	FIRST_NAME = Robert
4353	+	LAST_NAME = Nelson
4354	+	PHONE_EXT = 250
4355	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4356	+	DEPT_NO = 600
4357	+	JOB_CODE = VP
4358	+	JOB_GRADE = 2
4359	+	JOB_COUNTRY = USA
4360	+	SALARY = 105,900.00
4361	+	FULL_NAME = Nelson, Robert
4362	+	EMP_NO = 8
4363	+	FIRST_NAME = Leslie
4364	+	LAST_NAME = Johnson
4365	+	PHONE_EXT = 410
4366	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4367	+	DEPT_NO = 180
4368	+	JOB_CODE = Mktg
4369	+	JOB_GRADE = 3
4370	+	JOB_COUNTRY = USA
4371	+	SALARY = 64,635.00
4372	+	FULL_NAME = Johnson, Leslie
4373	+
4374	+
4375	+	Insert rows
4376	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4377	+	Batch Completion Info
4378	+	Total rows processed = 3
4379	+	Updated Records = 3
4380	+	Row 1 State = bcNoMoreErrors Msg =
4381	+	Row 2 State = bcNoMoreErrors Msg =
4382	+	Row 3 State = bcNoMoreErrors Msg =
4383	+	Rows after insert
4384	+	EMP_NO = 150
4385	+	FIRST_NAME = John
4386	+	LAST_NAME = Doe
4387	+	PHONE_EXT =
4388	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4389	+	DEPT_NO = 600
4390	+	JOB_CODE = Eng
4391	+	JOB_GRADE = 4
4392	+	JOB_COUNTRY = England
4393	+	SALARY = 41,000.89
4394	+	FULL_NAME = Doe, John
4395	+	EMP_NO = 151
4396	+	FIRST_NAME = Jane
4397	+	LAST_NAME = Doe
4398	+	PHONE_EXT =
4399	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4400	+	DEPT_NO = 600
4401	+	JOB_CODE = Eng
4402	+	JOB_GRADE = 4
4403	+	JOB_COUNTRY = England
4404	+	SALARY = 42,000.89
4405	+	FULL_NAME = Doe, Jane
4406	+	EMP_NO = 152
4407	+	FIRST_NAME = John
4408	+	LAST_NAME = SmithAndJonesFamily1
4409	+	PHONE_EXT =
4410	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4411	+	DEPT_NO = 600
4412	+	JOB_CODE = Eng
4413	+	JOB_GRADE = 4
4414	+	JOB_COUNTRY = England
4415	+	SALARY = 41,000.99
4416	+	FULL_NAME = SmithAndJonesFamily1, John
4417	+
4418	+
4419	+	Insert rows - and then cancel
4420	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4421	+
4422	+	Insert rows - ignore last row
4423	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4424	+	Batch Completion Info
4425	+	Total rows processed = 2
4426	+	Updated Records = 2
4427	+	Row 1 State = bcNoMoreErrors Msg =
4428	+	Row 2 State = bcNoMoreErrors Msg =
4429	+	Rows after insert
4430	+	EMP_NO = 150
4431	+	FIRST_NAME = John
4432	+	LAST_NAME = Doe
4433	+	PHONE_EXT =
4434	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4435	+	DEPT_NO = 600
4436	+	JOB_CODE = Eng
4437	+	JOB_GRADE = 4
4438	+	JOB_COUNTRY = England
4439	+	SALARY = 41,000.89
4440	+	FULL_NAME = Doe, John
4441	+	EMP_NO = 151
4442	+	FIRST_NAME = Jane
4443	+	LAST_NAME = Doe
4444	+	PHONE_EXT =
4445	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4446	+	DEPT_NO = 600
4447	+	JOB_CODE = Eng
4448	+	JOB_GRADE = 4
4449	+	JOB_COUNTRY = England
4450	+	SALARY = 42,000.89
4451	+	FULL_NAME = Doe, Jane
4452	+
4453	+	Insert with inline blob
4454	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4455	+	Batch Completion Info
4456	+	Total rows processed = 2
4457	+	Updated Records = 2
4458	+	Row 1 State = bcNoMoreErrors Msg =
4459	+	Row 2 State = bcNoMoreErrors Msg =
4460	+	Rows after insert
4461	+	JOB_CODE = ABC
4462	+	JOB_GRADE = 3
4463	+	JOB_COUNTRY = England
4464	+	JOB_TITLE = Chief Tester
4465	+	MIN_SALARY = 21,000.00
4466	+	MAX_SALARY = 24,000.99
4467	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4468	+
4469	+	The quick brown fox jumped over the lazy dog
4470	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4471	+
4472	+	JOB_CODE = DEF
4473	+	JOB_GRADE = 3
4474	+	JOB_COUNTRY = England
4475	+	JOB_TITLE = Deputy Tester
4476	+	MIN_SALARY = 21,000.00
4477	+	MAX_SALARY = 24,000.99
4478	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4479	+
4480	+	The quick brown fox jumped over the running dog
4481	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4482	+
4483	+
4484	+
4485	+	Insert with explicit blob
4486	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4487	+	Batch Completion Info
4488	+	Total rows processed = 2
4489	+	Updated Records = 2
4490	+	Row 1 State = bcNoMoreErrors Msg =
4491	+	Row 2 State = bcNoMoreErrors Msg =
4492	+	Rows after insert
4493	+	JOB_CODE = ABC
4494	+	JOB_GRADE = 3
4495	+	JOB_COUNTRY = England
4496	+	JOB_TITLE = Chief Tester
4497	+	MIN_SALARY = 21,000.00
4498	+	MAX_SALARY = 24,000.99
4499	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4500	+
4501	+	The quick brown fox jumped over the lazy dog
4502	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4503	+
4504	+	JOB_CODE = DEF
4505	+	JOB_GRADE = 3
4506	+	JOB_COUNTRY = England
4507	+	JOB_TITLE = Deputy Tester
4508	+	MIN_SALARY = 21,000.00
4509	+	MAX_SALARY = 24,000.99
4510	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4511	+
4512	+	The quick brown fox jumped over the running dog
4513	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4514	+
4515	+
4516	+	Test Error Handling
4517	+	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4518	+	Test Error Handling - Update returning should fail
4519	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4520	+	Error handling when Insert rows - duplicate key
4521	+	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"
4522	+	-Problematic key value is ("EMP_NO" = 150)
4523	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4524	+	Batch Completion Info
4525	+	Total rows processed = 2
4526	+	Updated Records = 1
4527	+	Row 1 State = bcNoMoreErrors Msg =
4528	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4529	+	-Problematic key value is ("EMP_NO" = 150)
4530	+
4531	+
4532	+	------------------------------------------------------
4533	+	Running Test 20: Stress Test IBatch interface
4534	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4535	+	10000 rows added
4536	+	20000 rows added
4537	+	30000 rows added
4538	+	40000 rows added
4539	+	50000 rows added
4540	+	Batch Execute
4541	+	Intermediate Apply Batch on row 50001
4542	+	Batch Completion Info
4543	+	Total rows processed = 50000
4544	+	Updated Rows = 50000
4545	+	Row 50000 State = bcNoMoreErrors Msg =
4546	+	60000 rows added
4547	+	70000 rows added
4548	+	80000 rows added
4549	+	90000 rows added
4550	+	100000 rows added
4551	+	Batch Execute
4552	+	Batch Completion Info
4553	+	Total rows processed = 50000
4554	+	Updated Rows = 50000
4555	+	Row 50000 State = bcNoMoreErrors Msg =
4556	+	Rows in Dataset = 100000
4557	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4558	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4559	+	Test Completed Successfully
4560	+
4561	+
4562	+	------------------------------------------------------
4563	+	Running Test 21: Exercise setting and getting of numeric data types
4564	+	SQL Params
4565	+	SQLType =SQL_LONG
4566	+	sub type = 0
4567	+	Field Name =
4568	+	Scale = 0
4569	+	Charset id = 0
4570	+	Not Null
4571	+	Size = 4
4572	+	Value = 0
4573	+
4574	+	SQLType =SQL_LONG
4575	+	sub type = 0
4576	+	Field Name =
4577	+	Scale = 0
4578	+	Charset id = 0
4579	+	Nullable
4580	+	Size = 4
4581	+
4582	+	SQLType =SQL_INT64
4583	+	sub type = 0
4584	+	Field Name =
4585	+	Scale = 0
4586	+	Charset id = 0
4587	+	Nullable
4588	+	Size = 8
4589	+
4590	+	SQLType =SQL_INT64
4591	+	sub type = 0
4592	+	Field Name =
4593	+	Scale = -4
4594	+	Charset id = 0
4595	+	Nullable
4596	+	Size = 8
4597	+
4598	+	SQLType =SQL_DOUBLE
4599	+	sub type = 0
4600	+	Field Name =
4601	+	Scale = 0
4602	+	Charset id = 0
4603	+	Nullable
4604	+	Size = 8
4605	+
4606	+	SQLType =SQL_INT64
4607	+	sub type = 0
4608	+	Field Name =
4609	+	Scale = -6
4610	+	Charset id = 0
4611	+	Nullable
4612	+	Size = 8
4613	+
4614	+	Expected Error - SQLCODE: -303
4615	+	Engine Code: 335544569 Incompatible column/host variable data type
4616	+	Dynamic SQL Error
4617	+	-SQL error code = -303
4618	+	-conversion error from string "1,000"
4619	+	Expected Error - SQLCODE: -303
4620	+	Engine Code: 335544569 Incompatible column/host variable data type
4621	+	Dynamic SQL Error
4622	+	-SQL error code = -303
4623	+	-conversion error from string "10.0.0"
4624	+	ROWID = 1
4625	+	ITYPE = 101
4626	+	I64TYPE = 9223372036854775807
4627	+	CURRTYPE = 10,000.12340000
4628	+	DTYPE = 9,999.12345678
4629	+	FIXEDPOINT = 1,234,567,890.12345700
4630	+	ROWID = 2
4631	+	ITYPE = -32457
4632	+	I64TYPE = -9223372036854775808
4633	+	CURRTYPE = 1,000,001.12000000
4634	+	DTYPE = 1.7E308
4635	+	FIXEDPOINT = -1,234,567,890.12345700
4636	+	ROWID = 3
4637	+	ITYPE = 0
4638	+	I64TYPE = 0
4639	+	CURRTYPE = .00000000
4640	+	DTYPE = .00000000
4641	+	FIXEDPOINT = .00000000
4642	+	ROWID = 4
4643	+	ITYPE = 1
4644	+	I64TYPE = 10
4645	+	CURRTYPE = .02300000
4646	+	DTYPE = .00000000
4647	+	FIXEDPOINT = 233.45600000
4648	+
4649	+
4650	+
4651		------------------------------------------------------
4652		Test Suite Ends

Diff Legend

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