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 345 by tony, Mon Aug 23 14:22:29 2021 UTC

#	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 565 | Line 569 | JOB_COUNTRY = USA
569		SALARY = 64,635.00
570		FULL_NAME = Johnson, Leslie
571
572	<	Current memory = 19,763,536
572	>	Current memory = 19,767,232
573		Delta memory = 4,464
574	<	Max memory = 19,809,408
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 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 2696 | Line 2711 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2711		------------------------------------------------------
2712		Running Test 9: Database Information tests
2713		Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2714	<	Pages =346
2714	>	Pages =1075
2715		Base Level = 13,4,0,3,
2716		Implementation = 11,7,0,3,66,1,66,
2717		Reserved = 0
#	Line 2706 | Line 2721 | Page Size = 8192
2721		Version = 1: LI-V6.3.0.2496 Firebird 4.0
2722		Database is Read/Write
2723		Database Created: 29/5/2021 16:47:30
2724	<	Pages Used = 310
2725	<	Pages Free = 36
2726	<	Server Memory = 19481792
2724	>	Pages Used = 313
2725	>	Pages Free = 762
2726	>	Server Memory = 19483648
2727		Forced Writes  = 1
2728	<	Max Memory  = 19627808
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 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 3937 | Line 4022 | BigInteger = 123456789123456789
4022		Special = 0
4023		Places = 0
4024		Digits = 12 34 56 78 91 23 45 67 89
4025	+
4026		RowID = 2
4027		Float16 = -64000000000.01
4028		Precision = 13
#	Line 3957 | Line 4043 | BigNumber = -123456123456.123456
4043		Places = 6
4044		Digits = 12 34 56 12 34 56 12 34 56
4045		BigInteger = Null
4046	+
4047		RowID = 3
4048		Float16 = 64100000000.011
4049		Precision = 14
#	Line 3983 | Line 4070 | BiggerNumber = 1112345612345612345612345
4070		Places = 4
4071		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4072		BigInteger = Null
4073	+
4074		RowID = 4
4075		Float16 = 0
4076		Precision = 0
#	Line 4009 | Line 4097 | BiggerNumber = 0.0000
4097		Places = 0
4098		Digits =
4099		BigInteger = Null
4100	+
4101		Metadata
4102		SQLType =SQL_LONG
4103		sub type = 0
#	Line 4097 | Line 4186 | BigNumber Array: (0: 123456123400.123456
4186
4187
4188		------------------------------------------------------
4189	+	Running Test 19: Batch Update and Insert Queries
4190	+	Opening inet://localhost/employee
4191	+	Database Open
4192	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4193	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4194	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4195	+	on disk structure version 13.0
4196	+	Rows before update
4197	+	EMP_NO = 2
4198	+	FIRST_NAME = Robert
4199	+	LAST_NAME = Nelson
4200	+	PHONE_EXT = 250
4201	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4202	+	DEPT_NO = 600
4203	+	JOB_CODE = VP
4204	+	JOB_GRADE = 2
4205	+	JOB_COUNTRY = USA
4206	+	SALARY = 105,900.00
4207	+	FULL_NAME = Nelson, Robert
4208	+	EMP_NO = 8
4209	+	FIRST_NAME = Leslie
4210	+	LAST_NAME = Johnson
4211	+	PHONE_EXT = 410
4212	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4213	+	DEPT_NO = 180
4214	+	JOB_CODE = Mktg
4215	+	JOB_GRADE = 3
4216	+	JOB_COUNTRY = USA
4217	+	SALARY = 64,635.00
4218	+	FULL_NAME = Johnson, Leslie
4219	+
4220	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4221	+	Batch Completion Info
4222	+	Total rows processed = 2
4223	+	Updated Records = 2
4224	+	Row 1 State = bcNoMoreErrors Msg =
4225	+	Row 2 State = bcNoMoreErrors Msg =
4226	+	Rows after update
4227	+	EMP_NO = 2
4228	+	FIRST_NAME = Robert
4229	+	LAST_NAME = Nelson
4230	+	PHONE_EXT = 250
4231	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4232	+	DEPT_NO = 600
4233	+	JOB_CODE = VP
4234	+	JOB_GRADE = 2
4235	+	JOB_COUNTRY = USA
4236	+	SALARY = 105,900.00
4237	+	FULL_NAME = Nelson, Robert
4238	+	EMP_NO = 8
4239	+	FIRST_NAME = Leslie
4240	+	LAST_NAME = Johnson
4241	+	PHONE_EXT = 410
4242	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4243	+	DEPT_NO = 180
4244	+	JOB_CODE = Mktg
4245	+	JOB_GRADE = 3
4246	+	JOB_COUNTRY = USA
4247	+	SALARY = 64,635.00
4248	+	FULL_NAME = Johnson, Leslie
4249	+
4250	+
4251	+	Repeat but with a last dummy row that is ignored
4252	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4253	+	Batch Completion Info
4254	+	Total rows processed = 2
4255	+	Updated Records = 2
4256	+	Row 1 State = bcNoMoreErrors Msg =
4257	+	Row 2 State = bcNoMoreErrors Msg =
4258	+	Rows after update
4259	+	EMP_NO = 2
4260	+	FIRST_NAME = Robert
4261	+	LAST_NAME = Nelson
4262	+	PHONE_EXT = 250
4263	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4264	+	DEPT_NO = 600
4265	+	JOB_CODE = VP
4266	+	JOB_GRADE = 2
4267	+	JOB_COUNTRY = USA
4268	+	SALARY = 105,900.00
4269	+	FULL_NAME = Nelson, Robert
4270	+	EMP_NO = 8
4271	+	FIRST_NAME = Leslie
4272	+	LAST_NAME = Johnson
4273	+	PHONE_EXT = 410
4274	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4275	+	DEPT_NO = 180
4276	+	JOB_CODE = Mktg
4277	+	JOB_GRADE = 3
4278	+	JOB_COUNTRY = USA
4279	+	SALARY = 64,635.00
4280	+	FULL_NAME = Johnson, Leslie
4281	+
4282	+
4283	+	Insert rows
4284	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4285	+	Batch Completion Info
4286	+	Total rows processed = 3
4287	+	Updated Records = 3
4288	+	Row 1 State = bcNoMoreErrors Msg =
4289	+	Row 2 State = bcNoMoreErrors Msg =
4290	+	Row 3 State = bcNoMoreErrors Msg =
4291	+	Rows after insert
4292	+	EMP_NO = 150
4293	+	FIRST_NAME = John
4294	+	LAST_NAME = Doe
4295	+	PHONE_EXT =
4296	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4297	+	DEPT_NO = 600
4298	+	JOB_CODE = Eng
4299	+	JOB_GRADE = 4
4300	+	JOB_COUNTRY = England
4301	+	SALARY = 41,000.89
4302	+	FULL_NAME = Doe, John
4303	+	EMP_NO = 151
4304	+	FIRST_NAME = Jane
4305	+	LAST_NAME = Doe
4306	+	PHONE_EXT =
4307	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4308	+	DEPT_NO = 600
4309	+	JOB_CODE = Eng
4310	+	JOB_GRADE = 4
4311	+	JOB_COUNTRY = England
4312	+	SALARY = 42,000.89
4313	+	FULL_NAME = Doe, Jane
4314	+	EMP_NO = 152
4315	+	FIRST_NAME = John
4316	+	LAST_NAME = SmithAndJonesFamily1
4317	+	PHONE_EXT =
4318	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4319	+	DEPT_NO = 600
4320	+	JOB_CODE = Eng
4321	+	JOB_GRADE = 4
4322	+	JOB_COUNTRY = England
4323	+	SALARY = 41,000.99
4324	+	FULL_NAME = SmithAndJonesFamily1, John
4325	+
4326	+
4327	+	Insert rows - and then cancel
4328	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4329	+
4330	+	Insert rows - ignore last row
4331	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4332	+	Batch Completion Info
4333	+	Total rows processed = 2
4334	+	Updated Records = 2
4335	+	Row 1 State = bcNoMoreErrors Msg =
4336	+	Row 2 State = bcNoMoreErrors Msg =
4337	+	Rows after insert
4338	+	EMP_NO = 150
4339	+	FIRST_NAME = John
4340	+	LAST_NAME = Doe
4341	+	PHONE_EXT =
4342	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4343	+	DEPT_NO = 600
4344	+	JOB_CODE = Eng
4345	+	JOB_GRADE = 4
4346	+	JOB_COUNTRY = England
4347	+	SALARY = 41,000.89
4348	+	FULL_NAME = Doe, John
4349	+	EMP_NO = 151
4350	+	FIRST_NAME = Jane
4351	+	LAST_NAME = Doe
4352	+	PHONE_EXT =
4353	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4354	+	DEPT_NO = 600
4355	+	JOB_CODE = Eng
4356	+	JOB_GRADE = 4
4357	+	JOB_COUNTRY = England
4358	+	SALARY = 42,000.89
4359	+	FULL_NAME = Doe, Jane
4360	+
4361	+	Insert with inline blob
4362	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4363	+	Batch Completion Info
4364	+	Total rows processed = 2
4365	+	Updated Records = 2
4366	+	Row 1 State = bcNoMoreErrors Msg =
4367	+	Row 2 State = bcNoMoreErrors Msg =
4368	+	Rows after insert
4369	+	JOB_CODE = ABC
4370	+	JOB_GRADE = 3
4371	+	JOB_COUNTRY = England
4372	+	JOB_TITLE = Chief Tester
4373	+	MIN_SALARY = 21,000.00
4374	+	MAX_SALARY = 24,000.99
4375	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4376	+
4377	+	The quick brown fox jumped over the lazy dog
4378	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4379	+
4380	+	JOB_CODE = DEF
4381	+	JOB_GRADE = 3
4382	+	JOB_COUNTRY = England
4383	+	JOB_TITLE = Deputy Tester
4384	+	MIN_SALARY = 21,000.00
4385	+	MAX_SALARY = 24,000.99
4386	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4387	+
4388	+	The quick brown fox jumped over the running dog
4389	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4390	+
4391	+
4392	+
4393	+	Insert with explicit blob
4394	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4395	+	Batch Completion Info
4396	+	Total rows processed = 2
4397	+	Updated Records = 2
4398	+	Row 1 State = bcNoMoreErrors Msg =
4399	+	Row 2 State = bcNoMoreErrors Msg =
4400	+	Rows after insert
4401	+	JOB_CODE = ABC
4402	+	JOB_GRADE = 3
4403	+	JOB_COUNTRY = England
4404	+	JOB_TITLE = Chief Tester
4405	+	MIN_SALARY = 21,000.00
4406	+	MAX_SALARY = 24,000.99
4407	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4408	+
4409	+	The quick brown fox jumped over the lazy dog
4410	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4411	+
4412	+	JOB_CODE = DEF
4413	+	JOB_GRADE = 3
4414	+	JOB_COUNTRY = England
4415	+	JOB_TITLE = Deputy Tester
4416	+	MIN_SALARY = 21,000.00
4417	+	MAX_SALARY = 24,000.99
4418	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4419	+
4420	+	The quick brown fox jumped over the running dog
4421	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4422	+
4423	+
4424	+	Test Error Handling
4425	+	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4426	+	Test Error Handling - Update returning should fail
4427	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4428	+	Error handling when Insert rows - duplicate key
4429	+	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"
4430	+	-Problematic key value is ("EMP_NO" = 150)
4431	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4432	+	Batch Completion Info
4433	+	Total rows processed = 2
4434	+	Updated Records = 1
4435	+	Row 1 State = bcNoMoreErrors Msg =
4436	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4437	+	-Problematic key value is ("EMP_NO" = 150)
4438	+
4439	+
4440	+	------------------------------------------------------
4441	+	Running Test 20: Stress Test IBatch interface
4442	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4443	+	10000 rows added
4444	+	20000 rows added
4445	+	30000 rows added
4446	+	40000 rows added
4447	+	50000 rows added
4448	+	Batch Execute
4449	+	Intermediate Apply Batch on row 50001
4450	+	Batch Completion Info
4451	+	Total rows processed = 50000
4452	+	Updated Rows = 50000
4453	+	Row 50000 State = bcNoMoreErrors Msg =
4454	+	60000 rows added
4455	+	70000 rows added
4456	+	80000 rows added
4457	+	90000 rows added
4458	+	100000 rows added
4459	+	Batch Execute
4460	+	Batch Completion Info
4461	+	Total rows processed = 50000
4462	+	Updated Rows = 50000
4463	+	Row 50000 State = bcNoMoreErrors Msg =
4464	+	Rows in Dataset = 100000
4465	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4466	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4467	+	Test Completed Successfully
4468	+
4469	+
4470	+	------------------------------------------------------
4471		Test Suite Ends

Diff Legend

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