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 349 by tony, Mon Oct 18 08:39:40 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		EMP_NO = 8
297		FIRST_NAME = Leslie
#	Line 492 | Line 494 | Scale = 0
494		Charset id = 0
495		Not Null
496		Size = 2
497	+	Value = 0
498
499		EMP_NO = 8
500		FIRST_NAME = Leslie
#	Line 515 | Line 518 | Scale = 0
518		Charset id = 0
519		Not Null
520		Size = 2
521	+	Value = 0
522
523		EMP_NO = 8
524		FIRST_NAME = Leslie
#	Line 548 | Line 552 | Constrained Employee Count = 3
552		Running Test 4: Update, Insert and Delete Queries
553		Opening inet://localhost/employee
554		Database Open
555	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
556	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
557	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
555	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
556	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
557	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
558		on disk structure version 13.0
559		Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
560		EMP_NO = 8
#	Line 565 | Line 569 | JOB_COUNTRY = USA
569		SALARY = 64,635.00
570		FULL_NAME = Johnson, Leslie
571
572	<	Current memory = 19,747,376
572	>	Current memory = 19,767,232
573		Delta memory = 4,464
574	<	Max memory = 19,793,248
575	<	Elapsed time= 0.002 sec
574	>	Max memory = 19,813,104
575	>	Elapsed time= 0.001 sec
576		Cpu = 0.000 sec
577		Buffers = 2048
578		Reads = 0
#	Line 731 | Line 735 | DEPT_NO = 600
735		JOB_CODE = Eng
736		JOB_GRADE = 4
737		JOB_COUNTRY = England
738	<	SALARY = 40,000.59
738	>	SALARY = 40,000.58
739		FULL_NAME = Major, Major
740
741		Now Delete the rows
#	Line 1067 | Line 1071 | Scale = 0
1071		Charset id = 0
1072		Not Null
1073		Size = 4
1074	+	Value = 0
1075
1076		SQLType =SQL_VARYING
1077		sub type = 0
#	Line 1114 | Line 1119 | Scale = 0
1119		Charset id = 0
1120		Not Null
1121		Size = 4
1122	+	Value = 0
1123
1124		ROWID = 1
1125		FIXEDPOINT = 20.28
#	Line 1166 | Line 1172 | Scale = 0
1172		Charset id = 0
1173		Not Null
1174		Size = 4
1175	+	Value = 0
1176
1177		SQLType =SQL_VARYING
1178		sub type = 0
#	Line 1543 | Line 1550 | Scale = 0
1550		Charset id = 0
1551		Not Null
1552		Size = 4
1553	+	Value = 0
1554
1555		SQLType =SQL_VARYING
1556		sub type = 0
#	Line 1590 | Line 1598 | Scale = 0
1598		Charset id = 0
1599		Not Null
1600		Size = 4
1601	+	Value = 0
1602
1603		ROWID = 1
1604		FIXEDPOINT = 20.28
#	Line 1642 | Line 1651 | Scale = 0
1651		Charset id = 0
1652		Not Null
1653		Size = 4
1654	+	Value = 0
1655
1656		SQLType =SQL_VARYING
1657		sub type = 0
#	Line 2019 | Line 2029 | Scale = 0
2029		Charset id = 0
2030		Not Null
2031		Size = 4
2032	+	Value = 0
2033
2034		SQLType =SQL_VARYING
2035		sub type = 0
#	Line 2066 | Line 2077 | Scale = 0
2077		Charset id = 0
2078		Not Null
2079		Size = 4
2080	+	Value = 0
2081
2082		ROWID = 1
2083		FIXEDPOINT = 20.28
#	Line 2118 | Line 2130 | Scale = 0
2130		Charset id = 0
2131		Not Null
2132		Size = 4
2133	+	Value = 0
2134
2135		SQLType =SQL_VARYING
2136		sub type = 0
#	Line 2412 | Line 2425 | Scale = 0
2425		Charset id = 0
2426		Not Null
2427		Size = 4
2428	+	Value = 0
2429
2430		SQLType =SQL_VARYING
2431		sub type = 0
#	Line 2673 | Line 2687 | Scale = 0
2687		Charset id = 0
2688		Not Null
2689		Size = 4
2690	+	Value = 0
2691
2692		SQLType =SQL_VARYING
2693		sub type = 0
#	Line 2695 | Line 2710 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2710
2711		------------------------------------------------------
2712		Running Test 9: Database Information tests
2713	<	Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus
2714	<	Pages =346
2713	>	Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2714	>	Pages =1075
2715		Base Level = 13,4,0,3,
2716		Implementation = 11,7,0,3,66,1,66,
2717		Reserved = 0
2718		ODS minor = 0
2719		ODS major = 13
2720		Page Size = 8192
2721	<	Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1
2721	>	Version = 1: LI-V6.3.0.2496 Firebird 4.0
2722		Database is Read/Write
2723	<	Database Created: 01/2/2021 14:57:08
2724	<	Pages Used = 310
2725	<	Pages Free = 36
2726	<	Server Memory = 19466032
2723	>	Database Created: 29/5/2021 16:47:30
2724	>	Pages Used = 313
2725	>	Pages Free = 762
2726	>	Server Memory = 19483648
2727		Forced Writes  = 1
2728	<	Max Memory  = 19612048
2728	>	Max Memory  = 19629664
2729		Num Buffers  = 2048
2730		Sweep Interval  = 20000
2731		Logged in Users: SYSDBA,
2732		Active Transaction Count = 0
2733	<	Fetches  = 1634
2733	>	Fetches  = 1648
2734		Writes  = 8
2735	<	Reads  = 91
2735	>	Reads  = 92
2736		Page Writes  = 4
2737		Record Version Removals Operation Counts
2738
#	Line 2741 | Line 2756 | Count = 2
2756		Table ID = 12
2757		Count = 24
2758		Table ID = 18
2759	<	Count = 805
2759	>	Count = 816
2760		Table ID = 20
2761		Count = 5
2762		Table ID = 28
#	Line 2753 | Line 2768 | Count = 1
2768
2769		Sequential Table Scans Operation Counts
2770		Table ID = 0
2771	<	Count = 98
2771	>	Count = 100
2772		Table ID = 1
2773		Count = 24
2774
#	Line 2796 | Line 2811 | SPB: Item Count = 2
2811		password = masterkey
2812
2813		Service Manager Version = 2
2814	<	Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1
2814	>	Server Version = LI-V4.0.0.2496 Firebird 4.0
2815		Implementation = Firebird/Linux/AMD/Intel/x64
2816
2817		Lock Directory = /tmp/firebird/
2818	<	Message File = /opt/firebird4rc1/
2819	<	Security File = /opt/firebird4rc1/security4.fdb
2818	>	Message File = /opt/firebird4.0.0/
2819	>	Security File = /opt/firebird4.0.0/security4.fdb
2820
2821		DB Attachments
2822		No. of Attachments = 0
#	Line 2859 | Line 2874 | Scale = 0
2874		Charset id = 0
2875		Not Null
2876		Size = 4
2877	+	Value = 0
2878
2879		SQLType =SQL_VARYING
2880		sub type = 0
#	Line 2908 | Line 2924 | Charset id = 4
2924		Nullable
2925		Size = 16
2926
2927	+	Show Param Values
2928	+	SQL Params
2929	+	SQLType =SQL_LONG
2930	+	sub type = 0
2931	+	Field Name = ROWID
2932	+	Scale = 0
2933	+	Charset id = 0
2934	+	Not Null
2935	+	Size = 4
2936	+	Value = 1
2937	+
2938	+	SQLType =SQL_VARYING
2939	+	sub type = 0
2940	+	Field Name = TITLE
2941	+	Scale = 0
2942	+	Charset id = 4
2943	+	Nullable
2944	+	Size = 128
2945	+	Value = Blob Test ©€
2946	+
2947	+	SQLType =SQL_VARYING
2948	+	sub type = 0
2949	+	Field Name = NOTES
2950	+	Scale = 0
2951	+	Charset id = 4
2952	+	Nullable
2953	+	Size = 256
2954	+	Value = Écoute moi
2955	+
2956	+	SQLType =SQL_VARYING
2957	+	sub type = 1
2958	+	Field Name = BLOBDATA
2959	+	Scale = 0
2960	+	Charset id = 4
2961	+	Nullable
2962	+	Size = 8192
2963	+	Value = Some German Special Characters like ÖÄÜöäüß
2964	+
2965	+	SQLType =SQL_BLOB
2966	+	sub type = 1
2967	+	Field Name = BLOBDATA2
2968	+	Scale = 0
2969	+	Charset id = 4
2970	+	Nullable
2971	+	Size = 8
2972	+	Value = Some German Special Characters like ÖÄÜöäüß
2973	+
2974	+	SQLType =SQL_VARYING
2975	+	sub type = 0
2976	+	Field Name = INCLEAR
2977	+	Scale = 0
2978	+	Charset id = 1
2979	+	Nullable
2980	+	Size = 16
2981	+	Value = &Test
2982
2983	+
2984	+	SQLType =SQL_VARYING
2985	+	sub type = 0
2986	+	Field Name = FIXEDWIDTH
2987	+	Scale = 0
2988	+	Charset id = 4
2989	+	Nullable
2990	+	Size = 16
2991	+	Value = É
2992	+
2993		Connection Character Set UTF8
2994		ROWID = 1
2995		TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
#	Line 3022 | Line 3103 | ROWID = 1
3103		TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3104		BLOBDATA = (blob), Length = 92514
3105
3106	+	ROWID = 2
3107	+	TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3108	+	BLOBDATA = (blob), Length = 13
3109	+	0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3110
3111		Testdata 2
3112
#	Line 3061 | Line 3146 | Invalid Param SQL Type Test
3146		Error Handled: Field "EMP_NO" not found
3147		Case sensitive Param SQL  Test
3148		Error Handled: Field "EMP_NO" not found
3149	+	Stale Reference Check
3150	+	First test correct usage
3151	+	COUNTER = 42
3152	+
3153	+	New Transaction before param set
3154	+	Error Handled: This interface is no longer up-to-date
3155	+	New Transaction before Open Cursor
3156	+	Error Handled: This interface is no longer up-to-date
3157	+	Stop Stale Reference Checks
3158	+	New Transaction before param set
3159	+	COUNTER = 42
3160	+
3161	+	New Transaction before Open Cursor
3162	+	COUNTER = 42
3163	+
3164		Invalid Server Name Test
3165		Error Handled: Unable to complete network request to host "unknown".
3166		-Failed to locate host machine.
#	Line 3073 | Line 3173 | Error Handled: Your user name and passwo
3173
3174		------------------------------------------------------
3175		Running Test 17: Date/Time tests and Firebird 4 extensions
3176	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3176	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3177		Has Local TZ DB = TRUE
3178
3179		Testdata
#	Line 3835 | Line 3935 | TZ_MINUTE = 0
3935
3936		------------------------------------------------------
3937		Running Test 18: Firebird 4 Decfloat extensions
3938	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3938	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3939
3940		FB4 Testdata_DECFloat
3941
#	Line 3937 | Line 4037 | BigInteger = 123456789123456789
4037		Special = 0
4038		Places = 0
4039		Digits = 12 34 56 78 91 23 45 67 89
4040	+
4041		RowID = 2
4042		Float16 = -64000000000.01
4043		Precision = 13
#	Line 3957 | Line 4058 | BigNumber = -123456123456.123456
4058		Places = 6
4059		Digits = 12 34 56 12 34 56 12 34 56
4060		BigInteger = Null
4061	+
4062		RowID = 3
4063		Float16 = 64100000000.011
4064		Precision = 14
#	Line 3983 | Line 4085 | BiggerNumber = 1112345612345612345612345
4085		Places = 4
4086		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4087		BigInteger = Null
4088	+
4089		RowID = 4
4090		Float16 = 0
4091		Precision = 0
#	Line 4009 | Line 4112 | BiggerNumber = 0.0000
4112		Places = 0
4113		Digits =
4114		BigInteger = Null
4115	+
4116		Metadata
4117		SQLType =SQL_LONG
4118		sub type = 0
#	Line 4096 | Line 4200 | BigNumber Array: (0: 123456123400.123456
4200
4201
4202
4203	+	------------------------------------------------------
4204	+	Running Test 19: Batch Update and Insert Queries
4205	+	Opening inet://localhost/employee
4206	+	Database Open
4207	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4208	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4209	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4210	+	on disk structure version 13.0
4211	+	Rows before update
4212	+	EMP_NO = 2
4213	+	FIRST_NAME = Robert
4214	+	LAST_NAME = Nelson
4215	+	PHONE_EXT = 250
4216	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4217	+	DEPT_NO = 600
4218	+	JOB_CODE = VP
4219	+	JOB_GRADE = 2
4220	+	JOB_COUNTRY = USA
4221	+	SALARY = 105,900.00
4222	+	FULL_NAME = Nelson, Robert
4223	+	EMP_NO = 8
4224	+	FIRST_NAME = Leslie
4225	+	LAST_NAME = Johnson
4226	+	PHONE_EXT = 410
4227	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4228	+	DEPT_NO = 180
4229	+	JOB_CODE = Mktg
4230	+	JOB_GRADE = 3
4231	+	JOB_COUNTRY = USA
4232	+	SALARY = 64,635.00
4233	+	FULL_NAME = Johnson, Leslie
4234	+
4235	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4236	+	Batch Completion Info
4237	+	Total rows processed = 2
4238	+	Updated Records = 2
4239	+	Row 1 State = bcNoMoreErrors Msg =
4240	+	Row 2 State = bcNoMoreErrors Msg =
4241	+	Rows after update
4242	+	EMP_NO = 2
4243	+	FIRST_NAME = Robert
4244	+	LAST_NAME = Nelson
4245	+	PHONE_EXT = 250
4246	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4247	+	DEPT_NO = 600
4248	+	JOB_CODE = VP
4249	+	JOB_GRADE = 2
4250	+	JOB_COUNTRY = USA
4251	+	SALARY = 105,900.00
4252	+	FULL_NAME = Nelson, Robert
4253	+	EMP_NO = 8
4254	+	FIRST_NAME = Leslie
4255	+	LAST_NAME = Johnson
4256	+	PHONE_EXT = 410
4257	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4258	+	DEPT_NO = 180
4259	+	JOB_CODE = Mktg
4260	+	JOB_GRADE = 3
4261	+	JOB_COUNTRY = USA
4262	+	SALARY = 64,635.00
4263	+	FULL_NAME = Johnson, Leslie
4264	+
4265	+
4266	+	Repeat but with a last dummy row that is ignored
4267	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4268	+	Batch Completion Info
4269	+	Total rows processed = 2
4270	+	Updated Records = 2
4271	+	Row 1 State = bcNoMoreErrors Msg =
4272	+	Row 2 State = bcNoMoreErrors Msg =
4273	+	Rows after update
4274	+	EMP_NO = 2
4275	+	FIRST_NAME = Robert
4276	+	LAST_NAME = Nelson
4277	+	PHONE_EXT = 250
4278	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4279	+	DEPT_NO = 600
4280	+	JOB_CODE = VP
4281	+	JOB_GRADE = 2
4282	+	JOB_COUNTRY = USA
4283	+	SALARY = 105,900.00
4284	+	FULL_NAME = Nelson, Robert
4285	+	EMP_NO = 8
4286	+	FIRST_NAME = Leslie
4287	+	LAST_NAME = Johnson
4288	+	PHONE_EXT = 410
4289	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4290	+	DEPT_NO = 180
4291	+	JOB_CODE = Mktg
4292	+	JOB_GRADE = 3
4293	+	JOB_COUNTRY = USA
4294	+	SALARY = 64,635.00
4295	+	FULL_NAME = Johnson, Leslie
4296	+
4297	+
4298	+	Insert rows
4299	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4300	+	Batch Completion Info
4301	+	Total rows processed = 3
4302	+	Updated Records = 3
4303	+	Row 1 State = bcNoMoreErrors Msg =
4304	+	Row 2 State = bcNoMoreErrors Msg =
4305	+	Row 3 State = bcNoMoreErrors Msg =
4306	+	Rows after insert
4307	+	EMP_NO = 150
4308	+	FIRST_NAME = John
4309	+	LAST_NAME = Doe
4310	+	PHONE_EXT =
4311	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4312	+	DEPT_NO = 600
4313	+	JOB_CODE = Eng
4314	+	JOB_GRADE = 4
4315	+	JOB_COUNTRY = England
4316	+	SALARY = 41,000.89
4317	+	FULL_NAME = Doe, John
4318	+	EMP_NO = 151
4319	+	FIRST_NAME = Jane
4320	+	LAST_NAME = Doe
4321	+	PHONE_EXT =
4322	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4323	+	DEPT_NO = 600
4324	+	JOB_CODE = Eng
4325	+	JOB_GRADE = 4
4326	+	JOB_COUNTRY = England
4327	+	SALARY = 42,000.89
4328	+	FULL_NAME = Doe, Jane
4329	+	EMP_NO = 152
4330	+	FIRST_NAME = John
4331	+	LAST_NAME = SmithAndJonesFamily1
4332	+	PHONE_EXT =
4333	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4334	+	DEPT_NO = 600
4335	+	JOB_CODE = Eng
4336	+	JOB_GRADE = 4
4337	+	JOB_COUNTRY = England
4338	+	SALARY = 41,000.99
4339	+	FULL_NAME = SmithAndJonesFamily1, John
4340	+
4341	+
4342	+	Insert rows - and then cancel
4343	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4344	+
4345	+	Insert rows - ignore last row
4346	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4347	+	Batch Completion Info
4348	+	Total rows processed = 2
4349	+	Updated Records = 2
4350	+	Row 1 State = bcNoMoreErrors Msg =
4351	+	Row 2 State = bcNoMoreErrors Msg =
4352	+	Rows after insert
4353	+	EMP_NO = 150
4354	+	FIRST_NAME = John
4355	+	LAST_NAME = Doe
4356	+	PHONE_EXT =
4357	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4358	+	DEPT_NO = 600
4359	+	JOB_CODE = Eng
4360	+	JOB_GRADE = 4
4361	+	JOB_COUNTRY = England
4362	+	SALARY = 41,000.89
4363	+	FULL_NAME = Doe, John
4364	+	EMP_NO = 151
4365	+	FIRST_NAME = Jane
4366	+	LAST_NAME = Doe
4367	+	PHONE_EXT =
4368	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4369	+	DEPT_NO = 600
4370	+	JOB_CODE = Eng
4371	+	JOB_GRADE = 4
4372	+	JOB_COUNTRY = England
4373	+	SALARY = 42,000.89
4374	+	FULL_NAME = Doe, Jane
4375	+
4376	+	Insert with inline blob
4377	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4378	+	Batch Completion Info
4379	+	Total rows processed = 2
4380	+	Updated Records = 2
4381	+	Row 1 State = bcNoMoreErrors Msg =
4382	+	Row 2 State = bcNoMoreErrors Msg =
4383	+	Rows after insert
4384	+	JOB_CODE = ABC
4385	+	JOB_GRADE = 3
4386	+	JOB_COUNTRY = England
4387	+	JOB_TITLE = Chief Tester
4388	+	MIN_SALARY = 21,000.00
4389	+	MAX_SALARY = 24,000.99
4390	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4391	+
4392	+	The quick brown fox jumped over the lazy dog
4393	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4394	+
4395	+	JOB_CODE = DEF
4396	+	JOB_GRADE = 3
4397	+	JOB_COUNTRY = England
4398	+	JOB_TITLE = Deputy Tester
4399	+	MIN_SALARY = 21,000.00
4400	+	MAX_SALARY = 24,000.99
4401	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4402	+
4403	+	The quick brown fox jumped over the running dog
4404	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4405	+
4406	+
4407	+
4408	+	Insert with explicit blob
4409	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4410	+	Batch Completion Info
4411	+	Total rows processed = 2
4412	+	Updated Records = 2
4413	+	Row 1 State = bcNoMoreErrors Msg =
4414	+	Row 2 State = bcNoMoreErrors Msg =
4415	+	Rows after insert
4416	+	JOB_CODE = ABC
4417	+	JOB_GRADE = 3
4418	+	JOB_COUNTRY = England
4419	+	JOB_TITLE = Chief Tester
4420	+	MIN_SALARY = 21,000.00
4421	+	MAX_SALARY = 24,000.99
4422	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4423	+
4424	+	The quick brown fox jumped over the lazy dog
4425	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4426	+
4427	+	JOB_CODE = DEF
4428	+	JOB_GRADE = 3
4429	+	JOB_COUNTRY = England
4430	+	JOB_TITLE = Deputy Tester
4431	+	MIN_SALARY = 21,000.00
4432	+	MAX_SALARY = 24,000.99
4433	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4434	+
4435	+	The quick brown fox jumped over the running dog
4436	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4437	+
4438	+
4439	+	Test Error Handling
4440	+	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4441	+	Test Error Handling - Update returning should fail
4442	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4443	+	Error handling when Insert rows - duplicate key
4444	+	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"
4445	+	-Problematic key value is ("EMP_NO" = 150)
4446	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4447	+	Batch Completion Info
4448	+	Total rows processed = 2
4449	+	Updated Records = 1
4450	+	Row 1 State = bcNoMoreErrors Msg =
4451	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4452	+	-Problematic key value is ("EMP_NO" = 150)
4453	+
4454	+
4455	+	------------------------------------------------------
4456	+	Running Test 20: Stress Test IBatch interface
4457	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4458	+	10000 rows added
4459	+	20000 rows added
4460	+	30000 rows added
4461	+	40000 rows added
4462	+	50000 rows added
4463	+	Batch Execute
4464	+	Intermediate Apply Batch on row 50001
4465	+	Batch Completion Info
4466	+	Total rows processed = 50000
4467	+	Updated Rows = 50000
4468	+	Row 50000 State = bcNoMoreErrors Msg =
4469	+	60000 rows added
4470	+	70000 rows added
4471	+	80000 rows added
4472	+	90000 rows added
4473	+	100000 rows added
4474	+	Batch Execute
4475	+	Batch Completion Info
4476	+	Total rows processed = 50000
4477	+	Updated Rows = 50000
4478	+	Row 50000 State = bcNoMoreErrors Msg =
4479	+	Rows in Dataset = 100000
4480	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4481	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4482	+	Test Completed Successfully
4483	+
4484	+
4485	+	------------------------------------------------------
4486	+	Running Test 21: Exercise setting and getting of numeric data types
4487	+	SQL Params
4488	+	SQLType =SQL_LONG
4489	+	sub type = 0
4490	+	Field Name =
4491	+	Scale = 0
4492	+	Charset id = 0
4493	+	Not Null
4494	+	Size = 4
4495	+	Value = 0
4496	+
4497	+	SQLType =SQL_LONG
4498	+	sub type = 0
4499	+	Field Name =
4500	+	Scale = 0
4501	+	Charset id = 0
4502	+	Nullable
4503	+	Size = 4
4504	+
4505	+	SQLType =SQL_INT64
4506	+	sub type = 0
4507	+	Field Name =
4508	+	Scale = 0
4509	+	Charset id = 0
4510	+	Nullable
4511	+	Size = 8
4512	+
4513	+	SQLType =SQL_INT64
4514	+	sub type = 0
4515	+	Field Name =
4516	+	Scale = -4
4517	+	Charset id = 0
4518	+	Nullable
4519	+	Size = 8
4520	+
4521	+	SQLType =SQL_DOUBLE
4522	+	sub type = 0
4523	+	Field Name =
4524	+	Scale = 0
4525	+	Charset id = 0
4526	+	Nullable
4527	+	Size = 8
4528	+
4529	+	SQLType =SQL_INT64
4530	+	sub type = 0
4531	+	Field Name =
4532	+	Scale = -6
4533	+	Charset id = 0
4534	+	Nullable
4535	+	Size = 8
4536	+
4537	+	ROWID = 1
4538	+	ITYPE = 101
4539	+	I64TYPE = 9223372036854775807
4540	+	CURRTYPE = 10,000.12340000
4541	+	DTYPE = 9,999.12345678
4542	+	FIXEDPOINT = 1,234,567,890.12345600
4543	+	ROWID = 2
4544	+	ITYPE = -32457
4545	+	I64TYPE = -9223372036854775808
4546	+	CURRTYPE = 1,000,001.12000000
4547	+	DTYPE = 1.7E308
4548	+	FIXEDPOINT = -1,234,567,890.12345600
4549	+	ROWID = 3
4550	+	ITYPE = 0
4551	+	I64TYPE = 0
4552	+	CURRTYPE = .00000000
4553	+	DTYPE = .00000000
4554	+	FIXEDPOINT = .00000000
4555	+
4556	+
4557	+
4558		------------------------------------------------------
4559		Test Suite Ends

Diff Legend

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